jdbc多条件模糊查询

代码实例

    List<Object> params = new ArrayList<>();
    StringBuffer sql = new StringBuffer("select * from feature_v2 f where 1 = 1 ");

    if (featureVO.getCode() != null && !"".equals(featureVO.getCode())) {
        sql.append("and f.code like ? ");
        params.add("%" + featureVO.getCode() + "%");
    }

注意：%前后没有单引号！