//针对某个字段更新 逻辑删除
public void updateState(String sql) {
    Session session = this.getHibernateTemplate().getSessionFactory()
            .openSession();
    Transaction tx = session.beginTransaction();
    Query query = session.createQuery(sql);
    query.executeUpdate();
    tx.commit();
    session.close();
}