fw_student_SqlMap.xml(SQL ºÍVOµÄÓ³ÉäÎļþ)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap PUBLIC "-//ibatis.apache.org//DTD SQL Map 2.0//EN" "http://ibatis.apache.org/dtd/sql-map-2.dtd">
<sqlMap namespace="fw_student">
<resultMap class="com.sias.Student" id="student">
<result column="name" property="name" jdbcType="VARCHAR2"/>
<result column="sex" property="sex" jdbcType="VARCHAR2"/>
</resultMap>
<select id="Select" resultMap="student">//±»SqlMapClientÀàµÄList queryForList(String)·½·¨µ÷ÓÃ
select name,sex from fw_student
</select>
<insert id="insert" parameterClass="com.sias.Student">//±»SqlMapClientÀàµÄ void insert(String,Object)·½·¨µ÷ÓÃ
insert into fw_student(name,sex) values(#name:VARCHAR2#,#sex:VARCHAR2#)
</insert>
<update id="update" parameterClass="java.util.Map">//±»SqlMapClientÀàµÄ  void update(String,Map)·½·¨µ÷ÓÃ
update fw_student cm set name='chang'
<isPropertyAvailable property="n">//Èç¹ûMap.put(String,value)ÖдæÔÚ±äÁ¿n(String="n"),ÔòʹÓÃWhere name=n;
where name='$n$'
</isPropertyAvailable>
</update>
</sqlMap>
ÕâÀïÐèҪ˵Ã÷µÄÊÇ$ºÍ#·ûºÅµÄÓ÷¨£º
ÀýÈç±äÁ¿MÊÇ×Ö·û´®ÀàÐÍ,ÔòÓ¦¸ÃÓÃ'$M$'»òÕß#M#,Èç¹ûÊÇintÐÍ£¬ÔòÓÃ$M$»ò#M#