例子:
@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}||'%' "

最低0.47元/天 解锁文章
2293

被折叠的 条评论
为什么被折叠?



