使用QueryRunner进行模糊查询参数数量报错问题，Like

今天在测试模糊查询时，sql语句自己测试明明没有错，debug了半天，终于发现问题所在。

原因：模糊查询进行了转义 %'字段'% 的值加上了 '' 导致查询报错

解决办法:String newUsername ="%"+username+"%";  将要传入的参数直接加上%%，作为一个整体参数传入

 @Override
    public List<User> getUserByCondition(String username, String gendar) throws SQLException {
        String sql = "select u_id as uid , u_name as username , u_password as upassword, u_sex as usex , " +
                "u_status as ustatus , u_code as code , u_email as email, u_role as urole from user ";
        if(StringUtils.isEmpty(gendar) &&  !StringUtils.isEmpty(username)){
            sql += " where u_name like ?";
            String newUsername = "%" + username + "%";
            return queryRunner.query(sql,new BeanListHandler<>(User.class),newUsername);
        }else if(!StringUtils.isEmpty(gendar) &&  StringUtils.isEmpty(username)){
            sql += " where u_sex = ?";
            return queryRunner.query(sql,new BeanListHandler<>(User.class),gendar);
        }else if(!StringUtils.isEmpty(gendar) &&  !StringUtils.isEmpty(username)){
            sql += " where u_name like ? and u_sex = ?";
            String newUsername = "%" + username + "%";
            System.out.println(sql);
            System.out.println(sql);
            return queryRunner.query(sql,new BeanListHandler<>(User.class),newUsername,gendar);
        }else{
            return queryRunner.query(sql,new BeanListHandler<>(User.class));
        }