Spring Boot -原生 mybatis

青旅半醒 2023-10-12 18:45 44阅读 0赞

## 实体类（参考文末完整代码地址，以下只贴出关键代码） ##

## mapper ##

package com.lfsun.springbootormmybatis.mapper;
    
    import com.lfsun.springbootormmybatis.entity.User;
    import org.apache.ibatis.annotations.Mapper;
    import org.apache.ibatis.annotations.Param;
    import org.apache.ibatis.annotations.Select;
    import org.springframework.stereotype.Component;
    
    import java.util.List;
    
    /**
     * <p>
     * User Mapper
     * </p>
     */
    @Mapper
    @Component
    public interface UserMapper {
        
    
        /**
         * 查询所有用户
         *
         * @return 用户列表
         */
        @Select("SELECT * FROM orm_user")
        List<User> selectAllUser();
    
        /**
         * 根据id查询用户
         *
         * @param id 主键id
         * @return 当前id的用户，不存在则是 {
        @code null}
         */
        @Select("SELECT * FROM orm_user WHERE id = #{id}")
        User selectUserById(@Param("id") Long id);
    
        /**
         * 保存用户
         *
         * @param user 用户
         * @return 成功 - {
        @code 1} 失败 - {
        @code 0}
         */
        int saveUser(@Param("user") User user);
    
        /**
         * 删除用户
         *
         * @param id 主键id
         * @return 成功 - {
        @code 1} 失败 - {
        @code 0}
         */
        int deleteById(@Param("id") Long id);
    
    }

## 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">
    <mapper namespace="com.lfsun.springbootormmybatis.mapper.UserMapper">
    
        <insert id="saveUser">
            INSERT INTO `orm_user` (`name`,
                                    `password`,
                                    `salt`,
                                    `email`,
                                    `phone_number`,
                                    `status`,
                                    `create_time`,
                                    `last_login_time`,
                                    `last_update_time`)
            VALUES (#{user.name},
                    #{user.password},
                    #{user.salt},
                    #{user.email},
                    #{user.phoneNumber},
                    #{user.status},
                    #{user.createTime},
                    #{user.lastLoginTime},
                    #{user.lastUpdateTime})
        </insert>
    
        <delete id="deleteById">
            DELETE
            FROM `orm_user`
            WHERE `id` = #{id}
        </delete>
    </mapper>

## 测试 ##

package com.lfsun.springbootormmybatis.mapper;
    
    import cn.hutool.core.collection.CollUtil;
    import cn.hutool.core.date.DateTime;
    import cn.hutool.core.util.IdUtil;
    import cn.hutool.crypto.SecureUtil;
    import com.lfsun.springbootormmybatis.SpringBootOrmMybatisApplicationTests;
    import com.lfsun.springbootormmybatis.entity.User;
    import lombok.extern.slf4j.Slf4j;
    import org.junit.Assert;
    import org.junit.Test;
    import org.springframework.beans.factory.annotation.Autowired;
    
    import java.util.List;
    
    /**
     * <p>
     * UserMapper 测试类
     * </p>
     */
    @Slf4j
    public class UserMapperTest extends SpringBootOrmMybatisApplicationTests {
        
        @Autowired
        private UserMapper userMapper;
    
        /**
         * 测试查询所有
         */
        @Test
        public void selectAllUser() {
        
            List<User> userList = userMapper.selectAllUser();
            Assert.assertTrue(CollUtil.isNotEmpty(userList));
            log.debug("【userList】= {}", userList);
        }
    
        /**
         * 测试根据主键查询单个
         */
        @Test
        public void selectUserById() {
        
            User user = userMapper.selectUserById(1L);
            Assert.assertNotNull(user);
            log.debug("【user】= {}", user);
        }
    
        /**
         * 测试保存
         */
        @Test
        public void saveUser() {
        
            String salt = IdUtil.fastSimpleUUID();
            User user = User.builder().name("testSave3").password(SecureUtil.md5("123456" + salt)).salt(salt).email("testSave3@lfsun.com").phoneNumber("4232423432").status(1).lastLoginTime(new DateTime()).createTime(new DateTime()).lastUpdateTime(new DateTime()).build();
            int i = userMapper.saveUser(user);
            Assert.assertEquals(1, i);
        }
    
        /**
         * 测试根据主键删除
         */
        @Test
        public void deleteById() {
        
            int i = userMapper.deleteById(4L);
            Assert.assertEquals(1, i);
        }
    }

## 完整代码地址 ##

[spring-boot 集成原生 mybatis 示例][spring-boot _ mybatis]

[spring-boot _ mybatis]: https://gitee.com/lfsun666/springboot-study-2023/tree/master/spring-boot-orm-mybatis