MyBatis的配置文件

1. .创建MyBatis的全局配置文件

<?xml version="1.0" encoding="UTF-8" ?>

<environments default="development">
    <environment id="development">
        <transactionManager type="JDBC" />

        <dataSource type="POOLED">
            <property name="driver" value="com.mysql.jdbc.Driver" />
            <property name="url" value="jdbc:mysql://localhost:3306/test_mybatis" />
            <property name="username" value="root" />
            <property name="password" value="123456" />
        </dataSource>
    </environment>
</environments>
<!-- 引入SQL映射文件,Mapper映射文件  -->
<mappers>
    <mapper resource = "mapper/mapper.xml"></mapper>
</mappers>

2. 创建Mybatis的sql映射文件

<?xml version="1.0" encoding="UTF-8" ?> select last_name lastnamel,email,gender from employee;

   insert into employee (last_name,email,gender) values (#{lastname},#{email},#{gender})
</insert>

<update id="updateEmp" parameterType="pojo.Employee">
    update employee set email =#{email},gender =#{gender} where last_name =#{lastname}
</update>

<delete id="delEmp" parameterType="int">
    delete from employee where id = #{id}
</delete>

注意： ① Mapper接口与Mapper映射文件的绑定在Mppper映射文件中的标签中的namespace中必须指定Mapper接口的全类名 ② Mapper映射文件中的增删改查标签的id必须指定成Mapper接口中的方法名.