public List findByMapNameUseLikeAndPage(String name,int pageSize,int pageNumber) {
log.debug("finding Maps instance with property: " + MAP_NAME
+ ", value: " + name);
try {
//不能写成 '%" + clientname+ "%'
String queryString = "from Maps as model where model." + MAP_NAME
+ " LIKE ? " + "order by mapType";
Query queryObject = getSession().createQuery(queryString);
//正确写法
queryObject.setParameter(0, "%" + name + "%");
queryObject.setFirstResult(pageSize*(pageNumber-1));
queryObject.setMaxResults(pageSize);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
log.debug("finding Maps instance with property: " + MAP_NAME
+ ", value: " + name);
try {
//不能写成 '%" + clientname+ "%'
String queryString = "from Maps as model where model." + MAP_NAME
+ " LIKE ? " + "order by mapType";
Query queryObject = getSession().createQuery(queryString);
//正确写法
queryObject.setParameter(0, "%" + name + "%");
queryObject.setFirstResult(pageSize*(pageNumber-1));
queryObject.setMaxResults(pageSize);
return queryObject.list();
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}