hibernate条件删除

Hibernate3中可以直接通过面向对象的形式进行条件删除，或者是直接sql的形式进行批量删除。

Sql代码：

Session session=HibernateUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

String strSQL=" delete  from Classes as a where a.classno like :name";

Query query = session.createQuery(strSQL);

query.setString("name", "%"+OId+"%");

Session session=HibernateUtil.getSessionFactory().getCurrentSession();   

session.beginTransaction();  

String strSQL="from Classes as a where a.classno like :name";   

Query query = session.createQuery(strSQL);  

HQL代码：

Session session = HibernateUtil.getSessionFactory().getCurrentSession();

session.beginTransaction();

List result=session.createQuery("delete from Classes as a where a.classno

like " '%"+OId+"%'").list();

[sql] view plaincopyprint?

Session session = HibernateUtil.getSessionFactory().getCurrentSession();   

session.beginTransaction();  

List result=session.createQuery("from Classes as a where a.classno  like " '%"+OId+"%'").list();  

Session session = HibernateUtil.getSessionFactory().getCurrentSession(); 

session.beginTransaction(); 

String result=session.createQuery("delete from Classes as a where a.classno like " '%"+OId+"%'").list();