在Seasar2中,写入的SQL判断条件,语法是/*IF*/SQL语句--ELSE SQL语句/*END*/
或者是/*IF*/中间是SQL语句/*END*/
,我刚刚弄错了,菊花疼
例子
SELECT KBN_CODE CD, KBN_NAME NM
FROM TEST
WHERE KBN_TYPE = '018'
/*IF age== "" */
AND KBN_CODE LIKE '1%'
--ELSE
AND KBN_CODE LIKE /*age*/
/*END*/
AND SECTION_CODE IN ('000000', /*shozokuCd*/)
ORDER BY SECTION_CODE, KBN_CODE