mybatsis@Select in参数处理

1、

@Select(“select distinct a.matnr,a.maktx\n” +
" from bs_materiel_data a, bs_bom_data b,domestic_produce_plan t\n" +
" where t.complete_machine_code=b.matnr\n" +
" and t.bom_code=to_number(b.bombj)\n" +
" and b.idnrk=a.matnr\n" +
" and t.version in (${version})\n" +
" and b.maktx like ‘%’||#{maktx}||’%’\n" +
" and a.ekgrp=#{ekgrp}\n"+
" order by a.matnr desc")
List getEkgrpAndMaktx(@Param(“version”) String version,@Param(“maktx”) String maktx,@Param(“ekgrp”) String ekgrp);

2、 version="’" + version+ “’” + “,”+"’" + lastVersion + “’”;