这里是新疆南部

想起两年前刚来到新疆的时候，这个时候的阿克苏黄沙漫天，走在路上身上都是沙子，，

public int findTotalCount(Map<String, String[]> condition) {
    //1.定义模板初始化sql
    String sql = "select count(*) from user where 1 = 1 ";
    StringBuilder sb = new StringBuilder(sql);
    //2.遍历map
    Set<String> keySet = condition.keySet();
    //定义参数的集合
    List<Object> params = new ArrayList<Object>();
    for (String key : keySet) {

        //排除分页条件参数
        if("currentPage".equals(key) || "rows".equals(key)){
            continue;
        }

        //获取value
        String value = condition.get(key)[0];
        //判断value是否有值
        if(value != null && !"".equals(value)){
            //有值
            sb.append(" and "+key+" like ? ");
            params.add("%"+value+"%");//？条件的值
        }
    }
    System.out.println(sb.toString());
    System.out.println(params);

    return template.queryForObject(sb.toString(),Integer.class,params.toArray());
}