例子:
@Select("<script>" +
"select nvl(gr.xingming,'') xingming,gr.zjhm zjhm,yh.id userid,gr.grbh grbh from pt_js js " +
"inner join pt_yh_js yhjs on yhjs.jsid=js.id " +
"inner join pt_yh yh on yhjs.yhid=yh.id " +
"inner join pt_gr gr on gr.grbh=yh.grbh " +
"where js.jgbh=#{organizationNumber} " +
"and gr.xingming like '%'||#{xingming}||'%' " +
"and yhjs.bmbh =any(regexp_split_to_array(#{bmbh},',')) group by gr.grbh,yh.id,gr.zjhm,gr.xingming" +
"${note}" +
"</script>")
解释:
例子中#{bmbh}的值,eg:“值1,值2,值n”