分页模糊查询

Dao：

 @Override
    public List<Teacher> getTeacherList(int start, int pageSize, Map<String, String[]> map) {
        /*String sql = "select * from athlete limit ? , ?";
        List<Teacher> list = jt.query(sql, new BeanPropertyRowMapper<Teacher>(Teacher.class), start, pageSize );*/
        String sql = "select * from teacher where 1 = 1";
        StringBuilder sb = new StringBuilder(sql);
        Set<String> set = map.keySet();
        List<Object> list = new ArrayList<>();

        for (String key : set) {
            if ("currentPage".equals(key) || "pageSize".equals(key)) {
                continue;
            }
            String value = map.get(key)[0];
            if (value != null && !"".equals(value)) {
                sb.append(" and " + key + " like ? ");
                list.add("%" + value + "%");
            }
        }
        sb.append(" limit ? , ?");
        list.add(start);
        list.add(pageSize);
        sql = sb.toString();
        System.out.println(sql);
        System.out.println(list);
        return jt.query(sql, new BeanPropertyRowMapper<Teacher>(Teacher.class), list.toArray());
    }
     @Override
    public int getToatalCount(Map<String, String[]> map) {
        String sql = "select count(*) from teacher