Question

hibernate中用hql语句判断一个字符串是否为空

public PagingList<Complaint> searchList(Timestamp time1, Timestamp time3,
int departmentid, int userid, int departmentid1,
int questionSortid, int handleSortid, int yesno, String filename2) {
QueryHelper qh=new QueryHelper("select distinct c from Complaint as c,Department as d,QuestionSort as q,HandleSort as h,User as u");
qh.setParam(true, "c.type=3");
qh.setParam(time1==null?false:true, "c.time>=? ",time1);
qh.setParam(time3==null?false:true, "c.time<=?",time3);
qh.setParam(departmentid==-1?false:true,"c.department.id=?",departmentid);
qh.setParam(yesno==-1?false:true,"c.yesno=?",yesno);
qh.setParam(userid==-1?false:true, "u.id in elements(c.users) and u.id=?",userid);
qh.setParam(departmentid1==-1?false:true,"d.id in elements(c.departments) and d.id=?",departmentid1);
qh.setParam(questionSortid==-1?false:true,"q.id in elements(c.questionSorts) and q.id=?",questionSortid);
qh.setParam(handleSortid==-1?false:true,"h.id in elements(c.handleSorts) and h.id=?",handleSortid);
qh.setParam(filename2.equals("-1")?false:true, "c.filename2 is ?",filename2);
return this.entityDAO.getPagingList(qh.getQuerySql(), 10, qh.getParams());
}
重点是qh.setParam(filename2.equals("-1")?false:true, "c.filename2 is ?",filename2);写的对吗？？？为什么就是查不出来

• 你的回答被采纳后将获得：
• 系统奖励15（财富值+成长值）+难题奖励30（财富值+成长值）

Answer 1

为毛是-1啊 又不是用流；

Answer 2

这种写法。。。你是学生么？应该封装一个类

追问

额，封装成一个类？？？要怎么封装啊