mybatis配置文件

mybatis配置文件包含：

mybatis-config.xml

<?xml version="1.0" encoding="UTF-8" ?>
<!DOCTYPE configuration
        PUBLIC "-//mybatis.org//DTD Config 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-config.dtd">
<configuration>
    <properties resource="jdbc.properties"/>
    <!-- 环境：说明可以配置多个，default:指定生效的环境 -->
    <environments default="development">
        <!-- id:环境的唯一标识 -->
        <environment id="development">
            <!-- 事务管理器，type：类型 -->
            <transactionManager type="JDBC" />
            <!-- 数据源：type-池类型的数据源 -->
            <dataSource type="POOLED">
                <property name="driver" value="${jdbc.driverClass}"/>
                <property name="url" value="${jdbc.url}" />
                <property name="username" value="${jdbc.username}"/>
                <property name="password" value="${jdbc.password}"/>
            </dataSource>
        </environment>
    </environments>
    <!-- 映射文件 -->
    <mappers>
        <mapper resource="UserMapper.xml"/>
    </mappers>
</configuration>

jdbc.properties

jdbc.driverClass = com.mysql.jdbc.Driver
jdbc.url = jdbc:mysql:///mybatis
jdbc.username = root
jdbc.password = root

XxxMapper.xml

<?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="cn.itcast.mapper.UserMapper">
    <!--一定要记住，要记住，和本文件的名字一致一致，是唯一标识，唯一标识-->
    <!-- 查询的statement，id：在同一个命名空间下的唯一标识，resultType：sql语句的结果集封装类型 -->
    <!-- sql语句结尾要写；-->
    <!-- resultType里面写的是User的copy reference-->
    <select id="queryUserById" resultType="cn.itcast.pojo.User">
		select * ,user_name as userName from tb_user where id=#{id};
	</select>

    <select id="queryUserAll" resultType="cn.itcast.pojo.User">
        select * ,user_name as username from tb_user;
    </select>

    <insert id="insertUser" parameterType="cn.itcast.pojo.User">
        insert into tb_user(
         user_name,
         password,
         name,
         age,
         sex,
         birthday,
         created,
         updated
        )
        values(
        #{userName},
        #{password},
        #{name},
        #{age},
        #{sex},
        #{birthday},
        NOW(),
        NOW()
        );
    </insert>

    <update id="updateUser" parameterType="cn.itcast.pojo.User">
        update tb_user
        set
        user_name = #{userName},
        password = #{password},
        name = #{name},
        age = #{age},
        sex = #{sex},
        birthday = #{birthday},
        updated = NOW()
        where
           (id = #{id});
    </update>


    <delete id="deleteUserById" parameterType="java.lang.Long">
        delete from tb_user where id = #{id}
    </delete>
</mapper>