哦,报什么错啊? 我的动态sql语句: <isNotEmpty prepend="and" property="NameZh"> (m.NAME_ZH like '%$NameZh$%') </isNotEmpty>
String wsjgbm="wsjgbm like '010101%'"; hashMap.put("wsjgbm",wsjgbm);<select id="get_tyjkjc_list" parameterClass="java.util.HashMap" resultClass="java.util.HashMap"> select wsjgbm,wsjgmc from bm_wsjg where #wsjgbm# </select>ibatis处理语法错误?????/??????????????????????????????????????????
where附近语法错误!!!!!!!!!!!!!!!!!!!
String wsjgbm="wsjgbm like '010101%'"; sqlMap.queryForObject("get_tyjkjc_list",wsjgbm);<select id="get_tyjkjc_list" parameterClass="string"> select wsjgbm,wsjgmc from bm_wsjg where $wsjgbm$ </select>
String value = "010101"; sqlMap.queryForObject("get_tyjkjc_list", value);<select id="get_tyjkjc_list" parameterClass="string"> select wsjgbm,wsjgmc from bm_wsjg where wsjgbm like #value#||'%' </select>
String value = "010101"; sqlMap.queryForObject("get_tyjkjc_list", value);<select id="get_tyjkjc_list" parameterClass="string"> select wsjgbm,wsjgmc from bm_wsjg where wsjgbm like '%'||#value#||'%' </select>
String wsjgbm="wsjgbm like '%$010101$%'";
我的动态sql语句:
<isNotEmpty prepend="and" property="NameZh">
(m.NAME_ZH like '%$NameZh$%')
</isNotEmpty>
hashMap.put("wsjgbm",wsjgbm);<select id="get_tyjkjc_list" parameterClass="java.util.HashMap" resultClass="java.util.HashMap">
select wsjgbm,wsjgmc from bm_wsjg where #wsjgbm#
</select>ibatis处理语法错误?????/??????????????????????????????????????????
sqlMap.queryForObject("get_tyjkjc_list",wsjgbm);<select id="get_tyjkjc_list" parameterClass="string">
select wsjgbm,wsjgmc from bm_wsjg where $wsjgbm$
</select>
sqlMap.queryForObject("get_tyjkjc_list", value);<select id="get_tyjkjc_list" parameterClass="string">
select wsjgbm,wsjgmc from bm_wsjg where wsjgbm like #value#||'%'
</select>
sqlMap.queryForObject("get_tyjkjc_list", value);<select id="get_tyjkjc_list" parameterClass="string">
select wsjgbm,wsjgmc from bm_wsjg where wsjgbm like '%'||#value#||'%'
</select>