@Select({ "<script>", "select * from user_info where 1=1", "<when test='name!=null and name!='' '>", "and name = #{name}", "</when>", "</script>"})判斷條件是name不為空并且不等于''(空字符串)這該怎么寫(xiě)呢?上面這個(gè)寫(xiě)法是錯(cuò)的
1 回答
慕田峪4524236
TA貢獻(xiàn)1875條經(jīng)驗(yàn) 獲得超5個(gè)贊
這樣試試
@Select("<script>" + "select * from user_info where 1=1" + "<where>" + "<if test=test='name!=null and name!=''>" + "and name = #{name}"+ "</if>" + "</script>")添加回答
舉報(bào)
0/150
提交
取消