SpringBoot系列课程(二)-SpringBoot整合MyBatis

1.SpringBoot和MyBatis整合

1.2. 准备数据

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for singer
-- ----------------------------
DROP TABLE IF EXISTS `singer`;
CREATE TABLE `singer` (
  `id` int(4) NOT NULL AUTO_INCREMENT,
  `name` varchar(20) DEFAULT NULL,
  `age` int(3) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `works` varchar(50) NOT NULL,
  `sex` char(1) DEFAULT NULL,
  `idcard` varchar(20) NOT NULL,
  PRIMARY KEY (`id`),
  UNIQUE KEY `idcard` (`idcard`)
) ENGINE=InnoDB AUTO_INCREMENT=12 DEFAULT CHARSET=gbk;

-- ----------------------------
-- Records of singer
-- ----------------------------
INSERT INTO `singer` VALUES ('1', '汪峰', '50', '2010-10-10', '飞得更高', '男', '34535434535675467567');
INSERT INTO `singer` VALUES ('2', '小A', '18', '2010-10-20', '双杰伦', '男', '345354345356754673');
INSERT INTO `singer` VALUES ('3', '哈林', '56', '2010-11-10', '情非得已', '男', '3453543453567543');
INSERT INTO `singer` VALUES ('4', '娜姐', '60', '2010-10-13', '征服', '女', '345354345356754676');
INSERT INTO `singer` VALUES ('7', '小A', '18', '2001-10-10', '乡村爱情进行曲', '男', '3454354354354385');
INSERT INTO `singer` VALUES ('8', '赵四', '55', '2001-10-10', '乡村爱情进行曲', '男', '3454354354354775');
INSERT INTO `singer` VALUES ('9', '赵四', '55', '2001-10-10', '乡村爱情进行曲', '男', '3454354366664775');
INSERT INTO `singer` VALUES ('10', '小沈阳', '55', '2001-10-10', '乡村爱情进行曲', '男', '3554354366664775');
INSERT INTO `singer` VALUES ('11', '小花', '18', '2010-10-13', '协奏曲', '女', '23423423424324');

1.2. 加入依赖

<!--导入MyBatis的场景启动器-->
        <dependency>
            <groupId>org.mybatis.spring.boot</groupId>
            <artifactId>mybatis-spring-boot-starter</artifactId>
            <version>2.0.0</version>
        </dependency>

        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid-spring-boot-starter</artifactId>
            <version>1.1.10</version>
        </dependency>

        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>5.1.28</version>
        </dependency>

1.3. 加入Mapper接口

import com.bruceliu.bean.Singer;

import java.util.List;

/**
 * @BelongsProject: SpringBoot-helloworld
 * @BelongsPackage: com.bruceliu.mapper
 * @CreateTime: 2020-10-19 15:23
 * @Description: TODO
 */
public interface SingerMapper {

    List<Singer> findSingers();
}

1.4. 加入Mapper接口XML文件

<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.bruceliu.mapper.SingerMapper">

    <select id="findSingers" resultType="com.bruceliu.bean.Singer">
        select * from singer
    </select>

</mapper>

1.5. 数据库配置信息

# 配置数据的连接信息
spring.datasource.url=jdbc:mysql://127.0.0.1/singerdb?useUnicode=true&characterEncoding=utf-8
spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource


#MyBatis参数配置
# 指定Mapper.xml位置
mybatis.mapper-locations=classpath:mappers/*.xml
# 给实体类取别名
mybatis.type-aliases-package=com.bruceliu.bean

1.6 Mapper接口注解

@Mapper
public interface SingerMapper {

    List<Singer> findSingers();
}

2.SpringBoot执行单元测试

2.1.导入测试依赖

<!--SpringBoot和Junit整合-->
<dependency>
    <groupId>org.springframework.boot</groupId>
    <artifactId>spring-boot-starter-test</artifactId>
    <scope>test</scope>
</dependency>

2.2.测试类

@RunWith(SpringRunner.class) //测试SpringBoot框架。启动SpringBoot框架
@SpringBootTest(classes = APP.class)
public class TestMyBatis {

    @Resource
    SingerMapper singerMapper;

    @Test
    public void test1(){
        List<Singer> singers = singerMapper.findSingers();
        for (Singer singer : singers) {
            System.out.println(singer);
        }
    }

}