ssh框架分页查询,有分页类并且作为查询的参数,代码该如何去实现,请各位朋友帮忙解决一下,非常感谢
答案:1 悬赏:80
解决时间 2021-03-02 11:24
- 提问者网友:你在我眼中是最帅
- 2021-03-02 06:26
public List<IDCCustomer> findCustomerList(Integer customerid,String customername,String customertype,PageHolder pageHolder) {
String hql="from IDCCustomer ic where 1=1 ";
if(customerid !=0 &&!customerid.equals("")){
hql += " and ic.customerid="+customerid;
}
if(customername !=null && !customername.equals("")){
hql += " and ic.customername like '%"+customername+"%'";
}
if(customertype !=null && !customertype.equals("")){
hql += " and ic.customertype like '%"+customertype+"%'";
}
if(pageHolder !=null){
Query query = this.getSession().createQuery(hql);
query.setFirstResult(pageHolder.getFirstIndex());
query.setMaxResults(pageHolder.getPageSize());
if(pageHolder.isGetCount()){
pageHolder.setResultSize((int)this.getCount2(hql));
}
// Iterator it = query.list().iterator();
// while(it.hasNext()){
// Object[] row = (Object[])it.next();
// IDCCustomer idc=new IDCCustomer();
// }
}
return this.getHibernateTemplate().find(hql);
最佳答案
- 二级知识专家网友:糜废丧逼
- 2021-03-02 07:17
public List<IDCCustomer> findCustomerList(CustomerVo customerVo){
StringBuffer hql=new StringBuffer("rom IDCCustomer ic where 1=1 ");
List list=new ArrayList();
if(customerVo|=null){
if(customerVo.getCustomerid!=null&&"".equals(customerVo.getCustomerid) ){
hql.append(" and ic.customerid=:customerid");
}
if(customerVo.getCustomername !=null&&"".equals(customerVo.getCustomername ) ){
hql.append(" and ic.customername =:customername ");
}
//customerVo.orderByStr 保存内容格式 :"customername desc/customername asc ......"
if(customerVo.getOrderByStr !=null&&"".equals(customerVo.getOrderByStr ) ){
hql.append(" order by :orderByStr customerid desc");
}
}
Query query = this.getSession().createQuery(hql);
query.setFirstResult(pageHolder.getFirstIndex());
query.setMaxResults(pageHolder.getPageSize());
if(customerVo|=null){
if(customerVo.getCustomerid!=null&&"".equals(customerVo.getCustomerid) ){
query.setParamter("customerid",customerid);
}
if(customerVo.getCustomername !=null&&"".equals(customerVo.getCustomername ) ){
query.setParamter("customername",customername);
}
if(customerVo.getOrderByStr !=null&&"".equals(customerVo.getOrderByStr ) ){
query.setParamter("orderByStr",orderByStr);
}
}
}
StringBuffer hql=new StringBuffer("rom IDCCustomer ic where 1=1 ");
List list=new ArrayList();
if(customerVo|=null){
if(customerVo.getCustomerid!=null&&"".equals(customerVo.getCustomerid) ){
hql.append(" and ic.customerid=:customerid");
}
if(customerVo.getCustomername !=null&&"".equals(customerVo.getCustomername ) ){
hql.append(" and ic.customername =:customername ");
}
//customerVo.orderByStr 保存内容格式 :"customername desc/customername asc ......"
if(customerVo.getOrderByStr !=null&&"".equals(customerVo.getOrderByStr ) ){
hql.append(" order by :orderByStr customerid desc");
}
}
Query query = this.getSession().createQuery(hql);
query.setFirstResult(pageHolder.getFirstIndex());
query.setMaxResults(pageHolder.getPageSize());
if(customerVo|=null){
if(customerVo.getCustomerid!=null&&"".equals(customerVo.getCustomerid) ){
query.setParamter("customerid",customerid);
}
if(customerVo.getCustomername !=null&&"".equals(customerVo.getCustomername ) ){
query.setParamter("customername",customername);
}
if(customerVo.getOrderByStr !=null&&"".equals(customerVo.getOrderByStr ) ){
query.setParamter("orderByStr",orderByStr);
}
}
}
我要举报
如以上问答内容为低俗、色情、不良、暴力、侵权、涉及违法等信息,可以点下面链接进行举报!
大家都在看
推荐资讯