java

javaweb的Like查询不到的问题

rzk · 4月21日 · 2020年本文共827个字 · 预计阅读3分钟122次已读
 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     }
11行sql += " and userName like'" + searchName + "'";
弄了好久模糊查询 实体类看了看 dao层看了看 后来看完寻思没错误呀
就把like后面的空格删了就查询到了

javaweb的Like查询不到的问题

javaweb的Like查询不到的问题

0 条回应