Spring Boot数据访问：整合Mybatis

介绍

• MyBatis 是一款优秀的持久层框架，它支持定制化 SQL、存储过程以及高级映射。MyBatis 避免了几乎所有的 JDBC 代码和手动设置参数以及获取结果集。MyBatis 可以使用简单的 XML 或注解来配置和映射原生信息，将接口和 Java 的 POJOs(Plain Ordinary Java Object,普通的 Java对象)映射成数据库中的记录。

整合步骤

1、引入依赖

		<!-- mybatis -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>2.0.1</version>
		</dependency>
		
		<!-- Mysql数据库连接 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		

2、数据源配置

application-db.properties增加配置

spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://192.168.1.20:3306/first?useUnicode=true&characterEncoding=utf8&characterSetResults=utf8
spring.datasource.username=root
spring.datasource.password=meetyou

#指定bean目录
mybatis.typeAliasesPackage:com.yanyuan.first.entity
#指定mapper.xml目录
mybatis.mapperLocations:classpath:mappers/*.xml

3、创建数据表

#创建表
create table `user`(
	id int PRIMARY key auto_increment,
	`name` VARCHAR(20) not null comment '名字',
	age int,
	create_time datetime
);

#插入数据
insert into `user`(`name`, age, create_time) VALUES
('May', 5, SYSDATE()),
('June', 6, SYSDATE());

4、实体类

@Data
@Builder
public class User {
    private Integer id;
    private String name;
    private Integer age;
    private Date createTime;
}

5、Dao类

@Mapper
public interface UserMapper {
    User getById(@Param("id") Integer id);
    List<User> queryList();
    Integer add(User user);
    Integer updateById(User user);
    Integer deleteById(@Param("id") Integer id);
}

6、Mapper.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.yanyuan.first.dao.mybatis.UserMapper">

    <resultMap id="BaseResult" type="com.yanyuan.first.entity.User">
        <result property="id" column="id" jdbcType="INTEGER"/>
        <result property="name" column="name" jdbcType="VARCHAR"/>
        <result property="age" column="age" jdbcType="INTEGER"/>
        <result property="createTime" column="create_time" jdbcType="TIMESTAMP"/>
    </resultMap>
    <select id="getById" resultMap="BaseResult">
        SELECT * FROM user where id = #{id, jdbcType=INTEGER}
    </select>

    <select id="queryList" resultMap="BaseResult">
        SELECT * FROM user
    </select>

    <!-- 新增并且返回自增长ID  user.getId() -->
    <insert id="add" useGeneratedKeys="true" keyProperty="id">
        insert into user (name,age,create_time)
        values (
        #{name, jdbcType=VARCHAR},
        #{age, jdbcType=INTEGER},
        sysdate()
        )
    </insert>

    <update id="updateById" parameterType="com.yanyuan.first.entity.User">
        update user
        set name = #{name, jdbcType=VARCHAR} ,
        age = #{age, jdbcType=INTEGER}
        where id = #{id, jdbcType=INTEGER}
    </update>

    <update id="deleteById" parameterType="com.yanyuan.first.entity.User">
        delete from user where id = #{id, jdbcType=INTEGER}
    </update>
</mapper>

7、Junit测试类

@SpringBootTest
@Slf4j
class UserMapperTest {

    @Autowired
    UserMapper userMapper;


    @Test
    void getById() {
        log.info("getById id=1, user={}", userMapper.getById(1));
    }

    @Test
    void queryList() {
        log.info("queryList list={}", userMapper.queryList());

    }

    @Test
    void add() {
        User user = User.builder().name("July").age(7).build();
        int rows = userMapper.add(user);
        //输出插入行数和用户ID
        log.info("add user, rows = {}, id = {} ", rows, user.getId());
    }

    @Test
    void updateById() {
        User user = User.builder()
                .name("May五月")
                .age(5)
                .id(1)
                .build();
        int rows = userMapper.updateById(user);
        log.info("updateById , rows = {}, id = {} ", rows, user.getId());
    }

    @Test
    void deleteById() {
        int rows = userMapper.deleteById(3);
        log.info("deleteById , rows = {}, id = 3 ", rows);
    }
}

资料下载

• 源码地址：my-spring-boot
• 对应分支：data-mybaits