mybatis-mapper文件介绍

<?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>