三列模糊查询
使用时注意CriterionList()中的内容
Criterion[] c =new Criterion[3];
cq.like("name", request.getParameter("searchfield"));
cq.like("tel", request.getParameter("searchfield"));
cq.like("pinyinName",request.getParameter("searchfield"));
for (int i = 0; i < 3; i++) {
c[i]=cq.getCriterionList().getParas(1);
//CriterionList会自动往前填充
cq.getCriterionList().removePara(1);
}
cq.or(cq.getor(c[0], c[1]), c[2]);