HQL

[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]