件_文_射_映_的_ibatis

--UserInfo.xml
<?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="User">

<typeAlias alias="User" type="com.ibatis.example.UserInfo"/>

<!-- 封转参数 这个参数顺序对应下面sql语句中的参数顺序 -->
<parameterMap class="java.util.HashMap" id="myParam">
<parameter property="id"/>
<parameter property="name"/>
</parameterMap>

<!-- 登录 多参数查询，通过parameterMap标签封装参数-->
<select id="login2" resultClass="User" parameterMap="myParam">
select * from UserInfo where usId=? and uSex=?
</select>

<!-- 查询所有 -->
<select id="getAllUserInfo" resultClass="User">
select * from UserInfo
</select>

<!-- 登录 java类拼装多个查询条件，直接传字符串过来-->
<select id="login" resultClass="User">
select * from UserInfo where $sql$
</select>

<!-- 根据Id查询 -->
<select id="getUserInfo" resultClass="User" parameterClass="int">
select * from UserInfo where usId=#uId#
</select>

<!-- 添加-->
<insert id="addUserInfo" parameterClass="com.ibatis.example.UserInfo">
insert into UserInfo (usId,uName,uSex,uAddress) values (#uId#,#uName#,#uSex#,#uAddress#)
</insert>

<!-- 删除 -->
<delete id="delUserInfo" parameterClass="int">
delete from UserInfo where usId=#usId#
</delete>

<!-- 修改 -->
<update id="updUserInfo" parameterClass="User">
update UserInfo set uName=#uName#, uSex=#uSex#, uAddress=#uAddress# where usId=#uId#
</update>

</sqlMap>