请教:
Goods是一个类,代码如下:
public class Goods implements java.io.Serializable { // Fields private Integer id;
private User userByBuyerId;
private User userBySalerId;
private String goodsName;
private Double goodsPrice;
private String goodsDesc;
private String goodsPic;
private Date beginTime;
private Date endTime;
private Integer goodsStatus;
//略去getter,setter方法
}
下面要实现一个在表中Goods类型的模糊查询,那么应该如何写HQL的like语句?请给出关键代码,运行成功立刻结贴!谢谢大侠!
public List search(Goods condition)
{
}
Goods是一个类,代码如下:
public class Goods implements java.io.Serializable { // Fields private Integer id;
private User userByBuyerId;
private User userBySalerId;
private String goodsName;
private Double goodsPrice;
private String goodsDesc;
private String goodsPic;
private Date beginTime;
private Date endTime;
private Integer goodsStatus;
//略去getter,setter方法
}
下面要实现一个在表中Goods类型的模糊查询,那么应该如何写HQL的like语句?请给出关键代码,运行成功立刻结贴!谢谢大侠!
public List search(Goods condition)
{
}
if (employeeinfo.getEmpId() != -1) {
hql+=" and empId='"+employeeinfo.getEmpId()+"'";
}
if (null !=employeeinfo.getEmpState()) {
hql+=" and empState='1'";
}
if(null !=employeeinfo.getEmpCode() && !("").equals(employeeinfo.getEmpCode())){
hql+=" and empCode like '%"+employeeinfo.getEmpCode()+"%'";
}if(null !=employeeinfo.getEmpName() && !("").equals(employeeinfo.getEmpName())){
if(!("").equals(employeeinfo.getEmpCode())){
hql+=" or empName like '%"+employeeinfo.getEmpName()+"%'";
}else{
hql+=" and empName like '%"+employeeinfo.getEmpName()+"%'";
}
}
Query qu=session.createQuery(hql);希望对你有帮助
英文的直接拼hql,类似sql的%通配符
中文的上面的方法不行,要用参数,session.createQuery(hql,Object[])
当然我开始做的时候也是用的这个方法 拼接SQL