Question

iBatis UPDATE 的书写

<update id="update" parameterType="com.bus.domain.Transportation">
update transportation_tb
<set>
bus_id = #{busId},
station_id = #{stationId},
bus_direct =#{busDirect},
line_id = #{lineId}
</set>
<where>
device_id = #{deviceId}
and
gps_time_stamp = #{gpsTimeStamp}
</where>
</update>
在set标签里，不用再写set吗？如
<set>
set
bus_id = #{busId},
station_id = #{stationId},
bus_direct =#{busDirect},
line_id = #{lineId}
</set>
谢谢。

Answer 1

<update id="editStudent" parameterClass="com.ssi.bean.Students" >
update student
<dynamic prepend="set" >

<isNotEqual prepend="," property="age" compareValue="0">
age = $age$
</isNotEqual>
<isNotNull prepend="," property="name" >
name = '$name$'
</isNotNull>
</dynamic>
where id = $id$
</update>