MyBatis Plus之注解实现动态SQL

 

参考下面的sql语句即可实现

@Select("<script>" +
"select gp.TEWRTYR,gp.FJFNM,gs.CVNNN,u.VCNBMBNV,gp.RAEER,gr.BVNCCVN\n" +
" from UPPBHT u\n" +
" left join GP_test gp\n" +
" on gp.GHFD=u.HDFGHF\n" +
" left join GP_WEWD gr\n" +
" ON gr.TRT=gp.VXZB\n" +
" left join FFGC gs\n" +
" ON gs.BCVNCVBN =gr.ZXCVZXB\n" +
" where\n" +
"<if test=\""+"gpPostQuery.rtyry!=null or gpPostQuery.rtyry != &quot;&quot;\">\n" +
" u.rtyry =#{gpPostQuery.rtyry}\n" +
"</if>\n" +
" <if test=\"gpPostQuery.dfrer!=null or gpPostQuery.dfrer != &quot;&quot;\">\n" +
" AND u.dfrer =#{gpPostQuery.dfrer}\n" +
"</if>\n" +
" <if test=\"gpPostQuery.ewrwerwrte!=null or gpPostQuery.ewrwerwrte != &quot;&quot;\">\n" +
" AND gs.ewrwerwrte=#{gpPostQuery.ewrwerwrte}\n" +
"</if>\n" +
"<if test=\"gpPostQuery.vhkkdfs!=null or gpPostQuery.vhkkdfs != &quot;&quot;\">\n" +
" AND gp.vhkkdfs=#{gpPostQuery.vhkkdfs} \n" +
"</if>\n"+
"</script>\n")

public List<Resultlls> getToResultGpCells(GpPostQuerygpPostQuery);