MyBatis的Mapper接口动态代理

最新推荐文章于 2024-09-25 11:13:12 发布

原创最新推荐文章于 2024-09-25 11:13:12 发布 · 451 阅读

1 ·

CC 4.0 BY-SA版权

编程学习同时被 2 个专栏收录

10 篇文章

订阅专栏

MyBatis

3 篇文章

订阅专栏

本文介绍如何使用MyBatis实现Mapper接口的动态代理，包括定义User2Mapper接口及其实现方法，创建对应的user2Mapper.xml配置文件，并在mybatis-config.xml中注册。最后通过测试代码展示了查询所有记录的功能。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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());
        }