jdbcTemplate执行查询语句，动态传参写法

weixin_45907672

已于 2022-10-21 11:48:00 修改

阅读量1.3k

点赞数

文章标签： sql 数据库 mybatis java

于 2022-10-21 11:46:15 首次发布

本文链接：https://blog.csdn.net/weixin_45907672/article/details/127443376

版权

    public List<PsDisciplineInfoEntity> getXkList(String year,String xkmc){
        //创建Object对象数组
        Object[] obj = new Object[]{};
        //Object对象数组转换为list
        ArrayList<Object> newObj = new ArrayList<Object>(Arrays.asList(obj));
        String sql = " SELECT id,year,level,discipline,create_time,data_audit_people,data_audit_people_code,review_expert,review_expert_code,secretary,secretary_code,qualification_examiner,qualification_examiner_code  FROM ps_discipline_info where 1=1 ";
        if(StringUtils.isNotEmpty(year)){
            sql += " and year=?";
            newObj.add(year);
        }
        if(StringUtils.isNotEmpty(xkmc)){
            sql += " and discipline  like ?";
            newObj.add( "%"+xkmc+"%");
        }
        sql += " order by create_time ";
        return jdbcTemplate.query(sql,newObj.toArray(),new BeanPropertyRowMapper<PsDisciplineInfoEntity>(PsDisciplineInfoEntity.class));
    }