ibatis中#和$有什么区别?
ouyka 2006-11-15 02:36:49 #和$有什么区别,即select * from topic where id=#id#和select * from topic where id=$id$有区别吗?
还有我要执行这个语句select * from topic where boardid in (1,2,3),配置文件如下:
这样写会报错:
<select id="getLists" resultMap="topicListResult" parameterClass="topicInfo">
select * from topic
<dynamic prepend="where">
<isNotNull prepend="and" property="boardid">
boardid in (#boardid#)
</isNotNull>
</dynamic>
</select>
这样写就没事,即用$替换#
<select id="getLists" resultMap="topicListResult" parameterClass="topicInfo">
select * from topic
<dynamic prepend="where">
<isNotNull prepend="and" property="boardid">
boardid in ($boardid$)
</isNotNull>
</dynamic>
</select>
这是为什么?