一些配置模板

MyBatis

Mapper XML

模板1

<?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，namespace的值习惯上设置成包名+sql映射文件名，这样就能够保证namespace的值是唯一的 -->
<mapper namespace="cn.mybatis.mapper.UserMapper">
    
    <!-- 添加数据 -->
    <insert id="add" parameterType="cn.mybatis.beans.User">
        insert into t_user(name,age) value(#{name},#{age})
    </insert>
    
    <!-- 删除数据 -->
    <delete id="del" parameterType="int">
        delete from t_user where id = #{id}
    </delete>
    
    <!-- 修改数据 -->
    <update id="update" parameterType="cn.mybatis.beans.User">
        update t_user set name=#{name},age=#{age} where id=#{id}
    </update>
    
    <!--根据id查询得到一个user对象-->
    <select id="getUser" parameterType="int" resultType="cn.mybatis.beans.User">
        select * from t_user where id=#{id}
    </select>
    
</mapper>

模板2

<?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.yn.Mapper">
    <resultMap id="employeeMapper" type="com.yn.pojo.Employee">
        <id property="id" column="eid"/>
        <result property="name" column="ename"/>
        <result property="age" column="eage"/>
        <result property="position" column="eposition"/>
    </resultMap>
    <select id="getListById" resultMap="employeeMapper" parameterType="int">
        select *
        from employee
        where eid = #{id}
    </select>

</mapper>