[align=center][/align][table]
hibernate hql拼接语句几种方式,模糊查询
1: OID is param
Java代码
1. String strSQL="from Classes as a where a.classno like :name";
2. Query query = session.createQuery(strSQL);
3. query.setString("name", "%"+OId+"%");
4. List result=query.list();
String strSQL="from Classes as a where a.classno like :name";
Query query = session.createQuery(strSQL);
query.setString("name", "%"+OId+"%");
List result=query.list();
2: OID is param
Java代码
1. List result=session.createQuery("from Classes as a where a.classno
like '%"+OId+"%'").list();
List result=session.createQuery("from Classes as a where a.classno like '%"+OId+"%'").list();
3: OID is param
Java代码
1. List result=session.createQuery("from Classes as a where a.classno
like :name").setParameter("name",OId).list();
List result=session.createQuery("from Classes as a where a.classno like :name").setParameter("name",OId).list();
4: DetachedCriteria 的使用
Java代码
1. public FunctionEntity getFunctionEntityById(String id){
2. DetachedCriteria criteria = DetachedCriteria.forClass(FunctionEntity.class);
3. criteria.add(Restrictions.eq("id", id));
4. return (FunctionEntity) getHibernateTemplate().findByCriteria(criteria).get(0);
5. }
[align=center][/align][align=center][/align][align=left][/align][table]
||
[/table]