sql语句:
sql = "SELECT * FROM orders WHERE concat(name,',',id,',',style) LIKE ? LIMIT ?,?";
调用sql语句:
ResultSet rs = helper.executeSql(sql,"%"+value+"%",pager.getBeginRow(), pager.getPageSize());
几个知识点:
1.这里concat(字段一,字段二,…)用于把想要查询的字段拼接起来,由于怕数据拼接的时候可能 出现首尾连接导致查询出错,所以每个字段用‘,’分隔开;
2.使用参数 %关键字% 做模糊查询,但凡查询的那几个字段里有这个关键字就会被挑出来;
3.limit ? ,? 做分页;
总的代码:
public Pager findbyvalue(Pager pager, Object value,Order order ){
List<Object> orders = new ArrayList();//这里
try {
String sql = "SELECT COUNT(*) FROM orders";
int total = helper.count(sql);
pager.setRows(total);
sql = "SELECT * FROM orders WHERE concat(name,',',id,',',style) LIKE ? LIMIT ?,?";
ResultSet rs = helper.executeSql(sql,"%"+value+"%",pager.getBeginRow(), pager.getPageSize());
while (rs.next()) {
orders.add(rsToBeanr(rs));
order = null ;
}
rs.close();
helper.close();
pager.setDatas(orders);
}catch (Exception ex){
}
return pager;
}
!!!!!!!!!!!!!!!!!ヾ(◍°∇°◍)ノ゙!!!!!!!!!!!!!!