createQuery不是数据库的方法,这是hibernate的sql操作方法。
具体作用,是对查询语句的执行·,像“select * from tb_a...”这样的
sql语句。
可以传参,通用方法有两种:
String hql = "from InventoryTask it where it
.orgId=:orgId";
Session session = getSession();
Query query=session.createQuery(hql);
query.setString("orgId",orgId);
List list = query.list();
if(list!=null&&list.size()!=0){
return (InventoryTask)list.get(0);
}else{
return null;
}String hql = "from InventoryTask it where it.orgId=?,it.orgName"; Session session = getSession(); Query query=session.createQuery(hql); query.setString("0",orgId); query.setString(1,orgName) List list = query.list(); if(list!=null&&list.size()!=0){ return (InventoryTask)list.get(0); }else{ return null; }