<?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" >
<mapper namespace="com.bsxqkj.mytest.dao.UserMapper" >
<insert id="add" parameterType="user">
insert into t_user(id,userName,passKey) values(#{id},#{userName},#{passKey})
</insert>
<update id="update" parameterType="user">
update t_user set id=#{id},userName=#{userName},passKey=#{passKey} where id=#{id}
</update>
<delete id="delete" parameterType="int">
delete from t_user where id=#{id}
</delete>
<select id="findById" parameterType="int" resultType="user">
select * from t_user where id=#{id}
</select>
<select id="findAll" resultType="user">
select * from t_user
</select>
</mapper>