public String getList() throws Exception
{
// 分页
Map paraMap = new HashMap();
paraMap.put("startTime", startTime);
paraMap.put("endTime", endTime);
paraMap.put("mc", mc);
super.setPager(paraMap, 0);
testList = dao.getList(startTime, endTime, mc, super.getPager());
return SUCCESS;
}
public List getList(String startTime, String endTime, String mc, Pager pager)
{
String where = " ";
where = where + " and " + TypeChange.DateBetweenSql("a.riQi", startTime, endTime);
if (!TypeChange.toNotNullDao(mc).equals(""))
{
where = where + " and a.mingCheng like '%" + TypeChange.toNotNullDao(mc) + "%'";
}
return this.findAll(where, pager);
}
}
这有啥好说的,就是分页,startTime, endTime就是两个分界点
把参数startTime, endTime, mc存入一个map中,同时设置到Pager
然后把这些数据作为参数传递给where 来拼接查询sql的字符串,各个参数作为查询条件,然后获取到对应的查询结果