'${aaa}' 加单引号也不行,不能在外面家引号, ----sql:select BIZ_ID, BIZ_CODE, DETAIL_ID, IS_CUS_URL, BIZ_CLIENT_VERSION, BIZ_STATUS, SHARE_URL, SHARE_TYPE from TBL_BCS_SHARE where BIZ_CODE in ('one,two,three')
and share_type =? 14:26:27.422 INFO [io-8080-exec-10] c.h.c.m.i.p.DiclectStatementHandlerInterceptor - ----pra:com.ums.bcs.front.model.Share@12a1062 14:26:27.422 INFO [io-8080-exec-10] c.h.c.m.i.p.DiclectStatementHandlerInterceptor - ---------------------------------------------------------
直接 in ( $xxx$ ) 可以吧。我以前项目就这么做。
用$肯定可以的,ibatis根本不会修改你传入的值,只可能是你传值出错
from TBL_BCS_SHARE where (BIZ_CODE in ('BIZ-NATIONAL-SOUTUDI','BIZ-NATIONAL-DEFUALT' $) and SHARE_TYPE=?) 多有个$号, 后面的$号不要 改成 where (BIZ_CODE in ('BIZ-NATIONAL-SOUTUDI','BIZ-NATIONAL-DEFUALT' )
'${aaa}' 加单引号
'${aaa}' 加单引号也不行,不能在外面家引号, ----sql:select BIZ_ID,
BIZ_CODE,
DETAIL_ID,
IS_CUS_URL,
BIZ_CLIENT_VERSION,
BIZ_STATUS,
SHARE_URL,
SHARE_TYPE
from TBL_BCS_SHARE
where BIZ_CODE in ('one,two,three')
and share_type =?
14:26:27.422 INFO [io-8080-exec-10] c.h.c.m.i.p.DiclectStatementHandlerInterceptor - ----pra:com.ums.bcs.front.model.Share@12a1062
14:26:27.422 INFO [io-8080-exec-10] c.h.c.m.i.p.DiclectStatementHandlerInterceptor - ---------------------------------------------------------
where (BIZ_CODE in ('BIZ-NATIONAL-SOUTUDI','BIZ-NATIONAL-DEFUALT' $)
and SHARE_TYPE=?)
多有个$号, 后面的$号不要 改成 where (BIZ_CODE in ('BIZ-NATIONAL-SOUTUDI','BIZ-NATIONAL-DEFUALT' )