1 private BaseDao baseDao = BaseDao.getInstance();
2 @Override
3 public List getAllUser睿共享(Integer pageNumber, Integer pageSize, String searchId, String searchName) {
4 /*user关联card*/
5 String sql = "select u.*,c.amount from user u,card c where c.userId = u.userId";
6 if (StringUtils.isNotBlank(searchId)){
7 sql += " and u.userId = "+searchId;
8 睿共享 }
9 if (StringUtils.isNotBlank(searchName)) {
10 searchName = "%" + searchName + "%";
11 sql += " and userName like'" + searchName + "'";
12 }
13 sql += " limit ?,?";
14 pageNumber = (pageNumber-1)*pageSize;
15 Object[] params = {pageNumber,pageSize};
16 return baseDao.query(sql,params,User.class);
17 }
18
睿共享19 public static void main(String[] args) {
20 UserDaoImpl userDao = new UserDaoImpl();
21 List user = userDao.g睿共享etAllUser(1, 睿共享23, null, "六");
22 for (User user1 : user) {
23 System.out.println(user1);
24 }
25 }