在mybatis的@Select中用not in 时

当在mybatis中用not in 时,需要用${LocalOrderNo}这样的形式来代替,而不能用#{LocalOrderNo}(把它当成一个整体的字符串了)

"SELECT * FROM common_payorder AS cp "
+" WHERE cp.`PaymentType`=#{paymentType} AND cp.`PayStatus`=#{payStatus}"
+" AND cp.createDate>=#{createDate}"
+" And cp.localorderno not in (${LocalOrderNo}) "

 

posted on 2016-02-17 17:26  学无止境2023  阅读(3450)  评论(0编辑  收藏  举报

导航