emp.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Dep">
<typeAlias alias="Dep" type="com.po.Dep" />
<resultMap id="DepResult" class="Dep">
<result properly="did" column="did"/>
<result properly="dname" column="dname"/>
</resultMap>
<!-- 添加 -->
<insert id="save" parameterClass="Dep">
<![CDATA[insert into dep values(#did#,#dname#)]]>
</insert>
<!-- 修改 -->
<update id="update" parameterClass="Dep">
<![CDATA[update dep set dname=#dname# where did=#did#]]>
</update>
<!-- 删除 -->
<delete id="delete" parameterClass="Integer">
<![CDATA[delete dep where did = #did#]]>
</delete>
<!-- 查询所有 -->
<select id="findAll" parameterClass="Integer" resultClass="Dep">
<![CDATA[select * from dep where did=#did#]]>
</select>
<!-- 按条件查询 -->
<select id="findById" resultClass="Dep">
<![CDATA[select * from dep]]>
</select>
</sqlMap>
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Dep">
<typeAlias alias="Dep" type="com.po.Dep" />
<resultMap id="DepResult" class="Dep">
<result properly="did" column="did"/>
<result properly="dname" column="dname"/>
</resultMap>
<!-- 添加 -->
<insert id="save" parameterClass="Dep">
<![CDATA[insert into dep values(#did#,#dname#)]]>
</insert>
<!-- 修改 -->
<update id="update" parameterClass="Dep">
<![CDATA[update dep set dname=#dname# where did=#did#]]>
</update>
<!-- 删除 -->
<delete id="delete" parameterClass="Integer">
<![CDATA[delete dep where did = #did#]]>
</delete>
<!-- 查询所有 -->
<select id="findAll" parameterClass="Integer" resultClass="Dep">
<![CDATA[select * from dep where did=#did#]]>
</select>
<!-- 按条件查询 -->
<select id="findById" resultClass="Dep">
<![CDATA[select * from dep]]>
</select>
</sqlMap>
emp.xml:
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE sqlMap
PUBLIC "-//iBATIS.com//DTD SQL Map 2.0//EN"
"http://www.ibatis.com/dtd/sql-map-2.dtd">
<sqlMap namespace="Emp">
<typeAlias alias="Emp" type="com.po.Emp" />
<resultMap id="EmpResult" class="Emp">
<result property="eid" column="eid" />
<result property="ename" column="ename" />
<result property="esex" column="esex" />
<result property="did" column="did" />
</resultMap>
<!-- 添加 -->
<insert id="save" parameterClass="Emp">
<![CDATA[insert into emp values(#eid#,#ename#,#esex#,#did#)]]>
</insert>
<!-- 修改 -->
<update id="update" parameterClass="Emp">
<![CDATA[update emp set ename=#ename#,esex=#esex#,did=#did# where eid=#eid#]]>
</update>
<!-- 删除 -->
<delete id="delete" parameterClass="int">
<![CDATA[delete emp where eid = #eid#]]>
</delete>
<!-- 按条件查询 -->
<select id="findById" resultClass="Emp" parameterClass="int" >
<![CDATA[select * from emp where eid=#eid#]]>
</select>
<!-- 查询所有 -->
<select id="findAll" resultMap="EmpResult">
<![CDATA[select * from emp]]>
</select>
</sqlMap>