MyBatis的Mapper接口动态代理

MyBatis的Mapper接口动态代理

一、创建Mapper接口，提供类User2的增删改查方法

public interface User2Mapper {
    int addUser2(User2 user2);
    int deleteUser2ById(String id);
    int updateUser2ById(String id,String username);
    List<User2> getAll();
    User2 getUser2ById(String id);
}

二、创建对应的user2Mapper.xml文件

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="org.rong.mapping.User2Mapper">
    <insert id="addUser2" parameterType="org.rong.bean.User2">
        INSERT INTO user2 set username=#{username},id=#{id}
    </insert>

    <select id="getAll" resultType="org.rong.bean.User2">
        SELECT * FROM user2
    </select>
    <select id="getUser2ById" resultType="org.rong.bean.User2" parameterType="String">
        SELECT * FROM user2 WHERE id=#{id}
    </select>

</mapper>

三、在mybatis-conf.xml中注册user2Mapper.xml文件

    <mappers>
        <mapper resource="org/rong/mapping/userMapper.xml"/>
        <mapper resource="org/rong/mapping/user2Mapper.xml"/>
    </mappers>

四、测试

SqlSessionFactory sqlSessionFactory = SqlSessionFactoryUtils.getInstance();
        SqlSession sqlSession = sqlSessionFactory.openSession();
        User2Mapper user2Mapper = sqlSession.getMapper(User2Mapper.class);
        List<User2> all = user2Mapper.getAll();
        sqlSession.commit();
        sqlSession.close();
        for (User2 user2 : all) {
            System.out.println(user2.toString());
        }