Mybatis动态查询sql:{choose,when,otherwise}
where pro.enterprise_user_id = #{uid} and pro.status_new!=0
<choose>
<when test='statusNew == "2"'>
AND (pro.status_new = 2 or pro.status_new = 4)
</when>
<when te...
原创
2018-03-06 19:47:55 ·
645 阅读 ·
0 评论