1 private BaseDao baseDao = BaseDao.getInstance(); 2 @Override 3 public ListgetAllUser(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 (StringUti 睿共享 ls.isNotBlank(searchId)){ 7 sql += " and u.userId = "+searchId; 8 } 9 if睿共享 (StringUtils.isNotBlank(searchName)) { 10 sea睿共享 rchNam睿共享 e = "%" + 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[] arg睿共享 s) { 20 UserDaoImpl userDao = new UserDaoImpl(); 21 Listuser = userDao.getAllUser(1, 23, null, "六"); 22 for (User user1 : user) { 23 System.out.println(user1); 24 } 25 }
11行sql += " and userName like'" + searchName + "'";
弄了好久模糊查询 实体类看了看 dao层看了看 后来看完寻思没错误呀
就把like后面的空格删了就查询到了