public Iterator getName(String abc)throws HibernateException
{
String queryString = "select a from A as a where a.name like :name" ;
beginTransaction();
Query query = session.createQuery(queryString);
query.setString("name", "%"+abc+"%");
Iterator it= query.iterate();
return it;
}
{
String queryString = "select a from A as a where a.name like :name" ;
beginTransaction();
Query query = session.createQuery(queryString);
query.setString("name", "%"+abc+"%");
Iterator it= query.iterate();
return it;
}
比如:
String selName = "%"+Name+"%";//需要进行模糊查询
String selectHQL = "select a from ABC as a where a.Name like ";
StringBuffer buffer = new StringBuffer();
buffer.append(selectHQL);
buffer.append(selName);
return resultList;这样是不是也可以呢?
String selectHql = "select count(u) from UserInfo(A表) as u,GULink(B表) as g where u.userName like ";
StringBuffer buffer = new StringBuffer();
buffer.append(selectHql);
buffer.append("%"+userName+"%");
buffer.append(" and g.groupId = ");
buffer.append(groupSelId);
请高手看看问题在哪好吗?谢谢。
UserInfo和GULink是类明吗?
这个buffer.append("%"+userName+"%");是不是以应该这样buffer.append("'%"+userName+"%'");
StringBuffer buffer = new StringBuffer();
buffer.append(selectHql);
buffer.append("%"+userName+"%");
buffer.append(" and g.groupId =: ");
buffer.append(groupSelId);
Query query = session.createQuery(buffer.toString());
query.setString("userName", abc);
query.setString("groupSelId",123);
.add( Expression.like("name", "Fritz%") )
.add( Expression.between("weight", minWeight, maxWeight) )
.list();