<?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">
<!--namespace,是为了解决冲突问题,通常就是包名+类名指定 -->
<!-- 如果使用mapper接口的方式,这里的namespace指定为mapper的全路径-->
<mapper namespace="itat.zttc.shop.model.User">
<!-- <mapper namespace="itat.zttc.shop.mapper.UserMapper"> -->
<insert id="add" parameterType="User">
<!-- 引入参数的属性值 #{username} -->
insert into t_user (username,password,nickname,type)
value(#{username},#{password},#{nickname},#{type})
</insert>
<update id="update" parameterType="User">
update t_user set password=#{password},nickname=#{nickname},type=#{type} where id=#{id}
</update>
<delete id="delete" parameterType="int">
delete from t_user where id=#{id}
</delete>
<select id="load" parameterType="int" resultType="User">
select * from t_user where id=#{id}
</select>
<!-- 返回List这种集合形式,依然可以使用resultType="实体对象"-->
<select id="list" resultType="User">
select * from t_user
</select>
</mapper>