直接上代码
daoimpl:
/**
* 开发转让页面展示 ，查询搜索数据，并且分页展示
* @param zrdp 搜索条件封装对象
* @return
*/
@suppresswarnings(unchecked)
public list  showallzrdpxxpageindex(zrdpxx zrdp,int pageindex,string keys) {
stringsql =select * from zrdpxx where dpxx_htaiztai = 2;
if(zrdp!=null){
if(zrdp.getdpxxid()!=null&&!zrdp.getdpxxid().equals()){
sql+= and dpxx_id = +zrdp.getdpxxid();
}
if(zrdp.getdpxxqyu()!=null&&!zrdp.getdpxxqyu().equals(-选择区域-)){
sql+= and dpxx_qyu = '+zrdp.getdpxxqyu()+';
}
if(zrdp.getdpxxpyetai()!=null&&!zrdp.getdpxxpyetai().equals()){
sql+= and dpxx_pyetai = '+zrdp.getdpxxpyetai()+';
}
if(zrdp.getdpxxzyetai()!=null&&!zrdp.getdpxxzyetai().equals(0)&&!zrdp.getdpxxzyetai().equals(null)){
sql+= and dpxx_zyetai = '+zrdp.getdpxxzyetai()+';
}
if(zrdp.getbigmji()!=0&&zrdp.getsmlmj()!=-1){
sql += and dpxx_mji between +zrdp.getsmlmj()+ and +zrdp.getbigmji();
}
//开始时间和结束时间均有值
if(zrdp.getbegintime()!=null&&!zrdp.getbegintime().equals()&&zrdp.getendtimes()!=null&&!zrdp.getendtimes().equals(null)){
sql += and dpxx_fbusjian  between '+zrdp.getbegintime()+' and '+zrdp.getendtimes()+';
}
//只有开始时间
if(zrdp.getbegintime()!=null&&!zrdp.getbegintime().equals()&&zrdp.getendtimes()==null){
sql += and dpxx_fbusjian  between '+zrdp.getbegintime()+' and now();
}
if(!(标题 地址 电话).equals(keys)){
sql += and (dpxx_bti like '%+keys+%' or tel like '%+keys+%' or dpxx_jtidzhi like '%+keys+%');
}
sql += order by dpxx_fbusjian desc;
}
return getsession().createsqlquery(sql).addentity(zrdpxx.class).setfirstresult((pageindex-1)*20).setmaxresults(20).list();
}
//public int getallzrdpcounts() {
//object oo = getsession().createsqlquery(select count(dpxx_id) from zrdpxx where dpxx_htaiztai =2).uniqueresult();
//return integer.parseint(oo.tostring());
/