一个ssh项目的模糊查询Util
QueryHelper:
package cn.itcast.core.util;
import java.util.ArrayList;
import java.util.List;
public class QueryHelper {
//form
private String formClause="";
//where
private String whereClause="";
//order
private String orderClause="";
//
private List<Object> parameters;
//排序顺序
public static String ORDER_BY_DESC="DESC";//降序
public static String ORDER_BY_ASC="ASC";//升序
/**
* 构造from子句
* clazz 实体类
* alias 实体类对应的别名
* @return
*/
public QueryHelper(Class clazz,String alias) {
formClause="FROM "+clazz.getSimpleName()+" "+alias;
}
/**
* 构造where语句
* condition 查询条件语句 例如i.title like?
* params 查询条件中? 对应的值 %标题%
* @return
*/
public void addCondition(String condition,Object... params){
if (whereClause.length()>1) {//拿第一个查询条件
whereClause+=" and "+condition;
}else{
whereClause+=" where "+condition;
}
//设置查询条件值到查询条件集合
if (parameters==null) {
parameters=new ArrayList<Object>();
}
if (params!=null) {
for(Object param:params){
parameters.add(param);
}
}
}
public void addOrderByProperty(String property,String order){
if (orderClause.length()>1) {
orderClause+=" , "+property+" "+order;
}else{
orderClause+=" order by "+property+" "+order;
}
}
//查询hql语句
public String getQueryListHql(){
return formClause+whereClause+orderClause;
}
//查询hql语句中 ? 对应的查询条件集合
public List<Object> getParameter(){
return parameters;
}
}
Action:
public class InfoAction extends BaseAction {
@Resource
private InfoService infoService;
private List<Info> infoList;
private Info info;
// 列表页
public String listUI() {
//列表上也有分类显示
ActionContext.getContext().getContextMap().put("infoTypeMap", info.INFO_TYPE_MAP);
QueryHelper queryHelper=new QueryHelper(Info.class, "i");
try {
if (info!=null) {
if (StringUtils.isNotBlank(info.getTitle())) {
//如果标题不为空 说明想根据标题查询
queryHelper.addCondition("i.title like ? ","%"+info.getTitle()+"%" );
}
//queryHelper.addCondition("i.state=? ", "1");
}
//根据创建时间排序,新的放前面
queryHelper.addOrderByProperty("i.createTime", QueryHelper.ORDER_BY_DESC);
infoList = infoService.findObjects(queryHelper);
} catch (Exception e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
return "listUI";
}
}