@Select({ "<script>", "select * from user_info where 1=1", "<when test='name!=null and name!='' '>", "and name = #{name}", "</when>", "</script>"})判斷條件是name不為空并且不等于''(空字符串)這該怎么寫呢?上面這個寫法是錯的
1 回答

慕田峪4524236
TA貢獻1875條經驗 獲得超5個贊
這樣試試
@Select("<script>" + "select * from user_info where 1=1" + "<where>" + "<if test=test='name!=null and name!=''>" + "and name = #{name}"+ "</if>" + "</script>")
添加回答
舉報
0/150
提交
取消