高级查询+分页 service部分

public List aqj(Yuangong yuangong,final int pagesize,final int pageno) {
StringBuffer sql=new StringBuffer("select qingjia.id,yuangong.uname,https://www.wendangku.net/doc/b04749073.html,,qingjia.shiyou,qingjia.qi,qingjia.shi,qingjia.bili,qjleibie.bili from Qingjia qingjia,Yuangong yuangong,Qjleibie qjleibie where qingjia.yuangongid=yuangong.id and qingjia.leibie=qjleibie.id");
if(yuangong!=null){
if(yuangong.getBumen()!=0){
sql.append(" and yuangong.bumen ='"+yuangong.getBumen()+"'");
}
if(yuangong.getGonghao()!=null&&!yuangong.getGonghao().trim().equals("")){
sql.append(" and yuangong.gonghao ='"+yuangong.getGonghao()+"'");
}
if(yuangong.getUname()!=null&&!yuangong.getUname().trim().equals("")){
sql.append(" and yuangong.uname ='"+yuangong.getUname()+"'");
}

}
final String sql0=sql.toString();
return template.executeFind(new HibernateCallback() {
public Object doInHibernate(Session arg0) throws HibernateException,
SQLException {
// TODO Auto-generated method stub
Query q =arg0.createQuery(sql0);
q.setFirstResult((pageno-1)*pagesize);
q.setMaxResults(pagesize);
List list=q.list();
return list;
}
});

}
public List aqj1(Yuangong yuangong) {

StringBuffer sql1=new StringBuffer("select count(*) from Qingjia qingjia,Yuangong yuangong,Qjleibie qjleibie where qingjia.yuangongid=yuangong.id and qingjia.leibie=qjleibie.id ");
if(yuangong!=null){
if(yuangong.getBumen()!=0){
sql1.append(" and yuangong.bumen ='"+yuangong.getBumen()+"'");
}
if(yuangong.getGonghao()!=null&&!yuangong.getGonghao().trim().equals("")){
sql1.append(" and yuangong.gonghao ='"+yuangong.getGonghao()+"'");
}
if(yuangong.getUname()!=null&&!yuangong.getUname().trim().equals("")){
sql1.append(" and yuangong.uname ='"+yuangong.getUname()+"'");
}
}
return template.find(sql1.toString());

}
public List aqjxg(String id) {
return template.find("select qingjia.id,yuangong.uname,https://www.wendangku.net/doc/b04749073.html,,qingjia.shiyou,qingjia.qi,qingjia.shi,qingjia.bili,qjleibie.bili from Qingjia qingjia,Yuangong yuangong,Qjleibie qjleibie where qingjia.yuangongid=yuangong.id and qingjia.leibie=qjleibie.id and qingjia.id='"+id+"'");
}