Question

jsp 数据库 联合查询

在DAO里 我想把值传到dept里作为限制条件，请问怎么传值？下面SELECT那应该怎么改？

public List findBydp(String dept) {

try {
String queryString = "SELECT c,p from Contract c,PersonalInformation p where p.department=? and c.personalInformation=p";
Query queryObject = getSession().createQuery(queryString);

return queryObject.list();
} catch (RuntimeException re) {
log.error("find by property name failed", re);
throw re;
}
}
谢谢！

Answer 1

用拼接sql的方法来些，StringBuffer sb = new StringBuffer();
sb.append( "SELECT c,p from Contract c,PersonalInformation p where p.department=");
sb.append(dept); sb.append("and c.personalInformation=p"); String querryString = sb.toString()就OK了