读书人

删除操作怎么改用hibernate的hql

发布时间: 2012-11-09 10:18:48 作者: rapoo

删除操作如何改用hibernate的hql?

Java code
            String delStr = "delete from PLM_EDITLOCK where OBJECTID="+caseId+" and USERID='"+userId+"'";            try{                Session session = HibernateUtil.currentSession();                session.connection().createStatement().execute(delStr);            }catch(Exception se){                //throw se;                System.err.println("delete error!");            }


我现在是这样做的,如果改用hibernate的hql要怎么写?

[解决办法]
Java code
public static void UpdateSQL(String SqlStr){        try{            session = HibernateUtil.currentSession();            Transaction tx= session.beginTransaction();            Query query = session.createQuery(SqlStr);            query.setCacheable(false);            query.executeUpdate();            tx.commit();        }        catch (HibernateException e) {            e.printStackTrace();        }        finally{HibernateUtil.closeSession();}    } 

读书人网 >Java Web开发

热点推荐