<?xml version="1.0" encoding="UTF-8"?><!DOCTYPE mapper
PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
"http://mybatis.org/dtd/mybatis-3-mapper.dtd"><mappernamespace="com.dao.UserDaoMapper"><!-- 如果实体类的属性名与表的字段名不同时 --><resultMaptype="User"id="userMap"><idproperty="id"column="id"javaType="java.lang.Integer"/><resultproperty="username"column="username"javaType="java.lang.String"/><resultproperty="password"column="password"javaType="java.lang.String"/><resultproperty="sex"column="sex"javaType="java.lang.String"/><resultproperty="age"column="age"javaType="java.lang.Integer"/></resultMap><selectid="findById"parameterType="int"resultType="User">
select * from user
where id=#{id}
</select><selectid="fingByCondition"parameterType="User"resultMap="userMap">
select * from user where 1=1
<iftest="username!=null">
and username like#{username}
</if><iftest="sex!=null">
and sex#={sex}
</if><iftest="age!=null">
and age#={age}
</if></select><selectid="findAll"resultType="User">
select * from user
</select><insertid="saveUser"parameterType="User">
insert into user
(id,
username,
password,
sex,
age)
values
(#{id},
#{username},
#{password},
#{sex},
#{age})
</insert><updateid="updateUser"parameterType="User">
update user set
username=#{username},
password=#{password},
sex=#{sex},
age#={age}
where id=#{id}
</update><deleteid="removeUser"parameterType="int">
delete from user
where id=#{id}
</delete></mapper>