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 mapperPUBLIC "-//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 {@ResourceSingerMapper singerMapper;@Testpublic void test1(){List<Singer> singers = singerMapper.findSingers();for (Singer singer : singers) {System.out.println(singer);}}}

總結

以上是生活随笔為你收集整理的SpringBoot系列课程(二)-SpringBoot整合MyBatis的全部內容，希望文章能夠幫你解決所遇到的問題。

如果覺得生活随笔網站內容還不錯，歡迎將生活随笔推薦給好友。