[public List queryColor(String spdm, String ggdm,
String byzd1,int currentPage, int lineSize) throws Exception {
List WghCustomerList = null;
String hql = "FROM SPGG1 AS q where q.spdm LIKE :spdm and q.ggdm LIKE :ggdm and q.byzd1 LIKE :byzd1";
Query q = super.getSession().createQuery(hql);
q.setString("spdm", "%"+spdm+"%");
q.setString("ggdm", "%"+ggdm+"%");
q.setString("byzd1", "%"+byzd1+"%");
q.setFirstResult((currentPage - 1) * lineSize);
q.setMaxResults(lineSize);
WghCustomerList = q.list();
return WghCustomerList;
}
请问我这个代码有错吗
String byzd1,int currentPage, int lineSize) throws Exception {
List WghCustomerList = null;
String hql = "FROM SPGG1 AS q where q.spdm LIKE :spdm and q.ggdm LIKE :ggdm and q.byzd1 LIKE :byzd1";
Query q = super.getSession().createQuery(hql);
q.setString("spdm", "%"+spdm+"%");
q.setString("ggdm", "%"+ggdm+"%");
q.setString("byzd1", "%"+byzd1+"%");
q.setFirstResult((currentPage - 1) * lineSize);
q.setMaxResults(lineSize);
WghCustomerList = q.list();
return WghCustomerList;
}
请问我这个代码有错吗
int lineSize = 8;
建议LZ把hibernate生成的sql加上参数去数据库执行下噢。=。=