Mybatis 测试

作者: HeloWxl | 来源:发表于2022-08-14 22:05 被阅读0次

03搭建MyBatis
java MyBatis逆向工程配置
第一个mybatis应用测试
MyBatis - 自动区分环境
Mybatis 测试
SpringBoot集成MyBatisCommonMapper
5/10day51_查询&多表
SSM整合(简易图书管理项目)
mybatis源码之二缓存
Mybatis（二）HelloWorld

单表增删改查

新增

UserDao.xml

 <!--新增所有列-->
    <insert id="insert" keyProperty="id" useGeneratedKeys="true">
        insert into test.user(user_name, age, nick_name, create_time)
        values (#{userName}, #{age}, #{nickName}, #{createTime})
    </insert>

UserDao.java

    /**
     * 新增数据
     *
     * @param user 实例对象
     * @return 影响行数
     */
    int insert(User user);

UserDaoTest.java

    /**
     * 创建会话工厂
     * @return
     * @throws IOException
     */
    public SqlSessionFactory getSqlSessionFactory() throws IOException {
        String resource = "mybatis-config.xml";
        InputStream inputStream = Resources.getResourceAsStream(resource);
        return new SqlSessionFactoryBuilder().build(inputStream);
    }

    /**
     * 新增
     * @throws IOException
     */
    @Test
    public void insert() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        UserDao userDao = openSession.getMapper(UserDao.class);
        User user = new User();
        user.setUserName("halo");
        user.setNickName("Halos");
        user.setAge(22);
        int res = userDao.insert(user);
        System.out.println(res);
    }

日志

Connected to the target VM, address: '127.0.0.1:55181', transport: 'socket'
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Opening JDBC Connection
DEBUG - Created connection 685558284.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@28dcca0c]
DEBUG - ==>  Preparing: insert into test.user(user_name, age, nick_name, create_time) values (?, ?, ?, ?) 
DEBUG - ==> Parameters: halo(String), 22(Integer), Halos(String), null
DEBUG - <==    Updates: 1
1
DEBUG - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@28dcca0c]
Disconnected from the target VM, address: '127.0.0.1:55181', transport: 'socket'

修改

UserDao.xml

 <!--通过主键修改数据-->
    <update id="update">
        update test.user
        <set>
            <if test="userName != null and userName != ''">
                user_name = #{userName},
            </if>
            <if test="age != null">
                age = #{age},
            </if>
            <if test="nickName != null and nickName != ''">
                nick_name = #{nickName},
            </if>
            <if test="createTime != null">
                create_time = #{createTime},
            </if>
        </set>
        where id = #{id}
    </update>

UserDao.java

/**
     * 修改数据
     *
     * @param user 实例对象
     * @return 影响行数
     */
    int update(User user);

UserDaoTest.java

    /**
     * 修改
     * @throws IOException
     */
    @Test
    public void updateById() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        UserDao userDao = openSession.getMapper(UserDao.class);
        User user = new User();
        user.setId(3);
        user.setUserName("helo");
        user.setNickName("Helos");
        user.setAge(24);
        int res = userDao.update(user);
        System.out.println(res);
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1686369710.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@6483f5ae]
DEBUG - ==>  Preparing: update test.user SET user_name = ?, age = ?, nick_name = ? where id = ? 
DEBUG - ==> Parameters: helo(String), 24(Integer), Helos(String), 3(Integer)
DEBUG - <==    Updates: 1
1

删除

UserDao.xml

  <!--通过主键删除-->
    <delete id="deleteById">
        delete from test.user where id = #{id}
    </delete>

UserDao.java

    /**
     * 通过主键删除数据
     *
     * @param id 主键
     * @return 影响行数
     */
    int deleteById(Integer id);

UserDaoTest.java

  /**
     * 删除
     * @throws IOException
     */
    @Test
    public void deleteById() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        UserDao userDao = openSession.getMapper(UserDao.class);
        int res = userDao.deleteById(3);
        System.out.println(res);
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1739876329.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@67b467e9]
DEBUG - ==>  Preparing: delete from test.user where id = ? 
DEBUG - ==> Parameters: 3(Integer)
DEBUG - <==    Updates: 1
1

查询

UserDao.xml

  <!--通过实体作为筛选条件查询-->
    <select id="queryAll" resultMap="UserMap">
        select
        id, user_name, age, nick_name, create_time
        from test.user
        <where>
            <if test="id != null">
                and id = #{id}
            </if>
            <if test="userName != null and userName != ''">
                and user_name = #{userName}
            </if>
            <if test="age != null">
                and age = #{age}
            </if>
            <if test="nickName != null and nickName != ''">
                and nick_name = #{nickName}
            </if>
            <if test="createTime != null">
                and create_time = #{createTime}
            </if>
        </where>
    </select>

UserDao.java

   /**
     * 通过实体作为筛选条件查询
     *
     * @param user 实例对象
     * @return 对象列表
     */
    List<User> queryAll(User user);

UserDaoTest.java

 /**
     * 按条件查询所有
     * @throws IOException
     */
    @Test
    public void queryAll() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        UserDao userDao = openSession.getMapper(UserDao.class);
        User user = new User();
        user.setAge(24);
        List<User> list= userDao.queryAll(user);
        System.out.println(list.toString());
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Cache Hit Ratio [com.kdgc.wangxianlin.dao.UserDao]: 0.0
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1475491159.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@57f23557]
DEBUG - ==>  Preparing: select id, user_name, age, nick_name, create_time from test.user WHERE age = ? 
DEBUG - ==> Parameters: 24(Integer)
DEBUG - <==      Total: 1
[User{id=4, userName='Tony', age=24, nickName='托尼', createTime=null}]

批量新增/删除

批量新增

UserDao.xml

    <insert id="insertBatch" keyProperty="id" useGeneratedKeys="true">
        insert into test.user(user_name, age, nick_name, create_time)
        values
        <foreach collection="entities" item="entity" separator=",">
            (#{entity.userName}, #{entity.age}, #{entity.nickName}, #{entity.createTime})
        </foreach>
    </insert>

UserDao.java

    /**
     * 批量新增数据（MyBatis原生foreach方法）
     *
     * @param entities List<User> 实例对象列表
     * @return 影响行数
     */
    int insertBatch(@Param("entities") List<User> entities);

UserDaoTest.java

 /**
     * 批量插入
     * @throws IOException
     */
    @Test
    public void insertBatch() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        UserDao userDao = openSession.getMapper(UserDao.class);
        List<User> list= new ArrayList<>();
        User user = new User();
        user.setUserName("Tony");
        user.setNickName("托尼");
        user.setAge(24);

        list.add(user);
        User user2 = new User();
        user2.setUserName("Hony");
        user2.setNickName("哈尼");
        user2.setAge(22);
        list.add(user2);

        int res= userDao.insertBatch(list);
        System.out.println(res);
        openSession.commit();
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Opening JDBC Connection
DEBUG - Created connection 323326911.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@134593bf]
DEBUG - ==>  Preparing: insert into test.user(user_name, age, nick_name, create_time) values (?, ?, ?, ?) , (?, ?, ?, ?) 
DEBUG - ==> Parameters: Tony(String), 24(Integer), 托尼(String), null, Hony(String), 22(Integer), 哈尼(String), null
DEBUG - <==    Updates: 2
2
DEBUG - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@134593bf]

批量删除

UserDao.xml

   <!-- void deleteBatch(List<Long> ids);-->
    <delete id="deleteBatch" parameterType="list">
        <!-- DELETE from user where id in(2,3,4,5) -->
        <!-- collection="list":遍历的集合  index:索引  item:每次遍历得到的对象 open:以什么开始 close:以什么关闭 separator:分隔符 -->
        DELETE from user where id in
        <foreach collection="list"  item="id" open="(" close=")" separator=",">
            #{id}
        </foreach>
    </delete>

UserDao.java

   /**
     * 批量删除数据
     *
     * @param id 主键
     * @return 影响行数
     */
    int deleteBatch(List<Integer> id);

UserDaoTest.java

   /**
     * 批量删除
     * @throws IOException
     */
    @Test
    public void deleteBatch() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        UserDao userDao = openSession.getMapper(UserDao.class);
        List<Integer> list= new ArrayList<>();
        list.add(3);
        list.add(4);
        int res= userDao.deleteBatch(list);
        System.out.println(res);
        openSession.commit();
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Opening JDBC Connection
DEBUG - Created connection 323326911.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@134593bf]
DEBUG - ==>  Preparing: DELETE from user where id in ( ? , ? ) 
DEBUG - ==> Parameters: 3(Integer), 4(Integer)
DEBUG - <==    Updates: 2
2
DEBUG - Committing JDBC Connection [com.mysql.jdbc.JDBC4Connection@134593bf]

缓存

一级缓存

测试一

先查询、在查询第二次

  /**
     * 一级缓存查询 测试
     * @throws IOException
     */
    @Test
    public void oneCache() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        try{
            UserDao userDao = openSession.getMapper(UserDao.class);
            // 第一次查询
            User user = userDao.queryById(4);
            System.out.println("user"+ user.toString());

            // 第二次查询
            User user1 = userDao.queryById(4);
            System.out.println("user1"+user1.toString());
        }finally {
            openSession.close();
        }
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Cache Hit Ratio [com.kdgc.wangxianlin.dao.UserDao]: 0.0
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1209669119.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - ==>  Preparing: select id, user_name, age, nick_name, create_time from test.user where id = ? 
DEBUG - ==> Parameters: 4(Integer)
DEBUG - <==      Total: 1
userUser{id=4, userName='Tony', age=24, nickName='托尼', createTime=null}
DEBUG - Cache Hit Ratio [com.kdgc.wangxianlin.dao.UserDao]: 0.0
user1User{id=4, userName='Tony', age=24, nickName='托尼', createTime=null}
DEBUG - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - Returned connection 1209669119 to pool.

测试二

先查询、在更新、在查询

/**
     * 一级缓存查询 测试2
     * @throws IOException
     */
    @Test
    public void oneCache02() throws IOException {
        SqlSessionFactory sqlSessionFactory = getSqlSessionFactory();
        SqlSession openSession = sqlSessionFactory.openSession();
        try{
            UserDao userDao = openSession.getMapper(UserDao.class);
            // 第一次查询
            User user = userDao.queryById(4);
            System.out.println("user"+ user.toString());

            // 更新操作
            user.setAge(18);
            userDao.update(user);

            // 第二次查询
            User user1 = userDao.queryById(4);
            System.out.println("user1"+user1.toString());

        }finally {
            openSession.close();
        }
    }

日志

DEBUG - Logging initialized using 'class org.apache.ibatis.logging.slf4j.Slf4jImpl' adapter.
DEBUG - Logging initialized using 'class org.apache.ibatis.logging.log4j.Log4jImpl' adapter.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - PooledDataSource forcefully closed/removed all connections.
DEBUG - Cache Hit Ratio [com.kdgc.wangxianlin.dao.UserDao]: 0.0
DEBUG - Opening JDBC Connection
DEBUG - Created connection 1209669119.
DEBUG - Setting autocommit to false on JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - ==>  Preparing: select id, user_name, age, nick_name, create_time from test.user where id = ? 
DEBUG - ==> Parameters: 4(Integer)
DEBUG - <==      Total: 1
userUser{id=4, userName='Tony', age=24, nickName='托尼', createTime=null}
DEBUG - ==>  Preparing: update test.user SET user_name = ?, age = ?, nick_name = ? where id = ? 
DEBUG - ==> Parameters: Tony(String), 18(Integer), 托尼(String), 4(Integer)
DEBUG - <==    Updates: 1
DEBUG - Cache Hit Ratio [com.kdgc.wangxianlin.dao.UserDao]: 0.0
DEBUG - ==>  Preparing: select id, user_name, age, nick_name, create_time from test.user where id = ? 
DEBUG - ==> Parameters: 4(Integer)
DEBUG - <==      Total: 1
user1User{id=4, userName='Tony', age=18, nickName='托尼', createTime=Sun Aug 14 22:21:25 CST 2022}
DEBUG - Rolling back JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - Resetting autocommit to true on JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - Closing JDBC Connection [com.mysql.jdbc.JDBC4Connection@481a15ff]
DEBUG - Returned connection 1209669119 to pool.

03搭建MyBatis
搭建MyBatis项目 1、下载MyBatis、创建项目、导包； 2、创建测试用例，测试数据库、测试Bean对象；...
java MyBatis逆向工程配置
mybatis-generator.xml 测试
第一个mybatis应用测试
第一个mybatis应用测试项目结构mybatis_Structure.png 所需jar包，本测试使用mave...
MyBatis - 自动区分环境
更多MyBatis实战内容，请参考：MyBatis - 实战指南背景在开发时，经常会用到测试，甚至是压测。测试...
Mybatis 测试
单表增删改查新增 UserDao.xml UserDao.java UserDaoTest.java 日志修改...
SpringBoot集成MyBatisCommonMapper
1. pom配置引入spring boot, mybatis-spring, tk.mybatis, h2测试数...
5/10day51_查询&多表
回顾优化测试方法 mybatis查询和多表一 Mybatis单表查询 1.1 resultMap标签如果数据...
SSM整合(简易图书管理项目)
1.maven配置 2.spring 整合mybatis 并且测试Dao层业务 2.1 mybatis 核心配置文...
mybatis源码之二缓存
mybatis源码之二缓存 1：一级缓存设置 1.1:mybatis-config文件配置 1.2: 测试代码...
Mybatis（二）HelloWorld
一、创建一张测试表二、创建对应的javaBean 三、导入包 mybatis-3.4.1.jar（mybatis...

Mybatis 测试

单表增删改查

UserDao.xml

UserDao.java

UserDaoTest.java

日志

UserDao.xml

UserDao.java

UserDaoTest.java

日志

UserDao.xml

UserDao.java

UserDaoTest.java

日志

UserDao.xml

UserDao.java

UserDaoTest.java

日志

批量新增/删除

UserDao.xml

UserDao.java

UserDaoTest.java

日志

UserDao.xml

UserDao.java

UserDaoTest.java

日志

缓存

一级缓存

日志

日志

相关文章

网友评论

延伸阅读

深度阅读

栏目导航

热点阅读