<?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.itheima.dao.IUserDao"><!--查询所有--><selectid="findAll"resultType="com.itheima.domain.User">
select * from user
</select><!--保存用户--><insertid="saveUser"parameterType="com.itheima.domain.User">
insert into user(username,address,sex,birthday)values(#{username},#{address},#{sex},#{birthday});
</insert><!--更新用户--><updateid="updateUser"parameterType="com.itheima.domain.User">
update user set username=#{username},address=#{address},sex=#{sex},birthday=#{birthday} where id=#{id}
</update><!--删除用户--><deleteid="deleteUser"parameterType="java.lang.Integer">
delete from user where id=#{uid}
</delete></mapper>