Spring Boot整合MyBatis

前言:这段时间用springboot感觉确实挺好用的,很大程度上的简化了开发,由其是它的自动化配置,让大大的提高了开发效率,现在我们要让SpringBoot与MyBatis一起工作。下面就来详细介绍如何在Spring Boot中整合MyBatis,并通过注解方式实现映射。

1.0 创建项目

1.1 首先创建springboot工程,点击file ——> new ——>project ——>Spring Initializr

1.2 点击下一步,按如下操作就好

1.3

1.4

1.5

1.6 操作完成后对应的pom文件如下(由于忘记选中mysql,需要手动添加mysql的maven依赖。)

[XML]纯文本查看__复制代码

?

01

02

03

04

05

06

07

08

09

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

30

31

32

33

34

35

36

37

38

39

40

41

42

43

44

45

46

47

48

49

50

51

52

53

54

55

56

57

<?`xml version="1.0" encoding="UTF-8"`?>

<`project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"`

xsi:schemaLocation`="http://maven.apache.org/POM/4.0.0 [url=http://maven.apache.org/xsd/maven-4.0.0.xsd]http://maven.apache.org/xsd/maven-4.0.0.xsd[/url]">`

<`modelVersion>4.0.0</modelVersion`>

<`groupId>cn.itcast</groupId`>

<`artifactId>springboot-mybatis</artifactId`>

<`version>0.0.1-SNAPSHOT</version`>

<`packaging>jar</packaging`>

<`name>springboot-mybatis</name`>

<`description>Demo project for Spring Boot</description`>

<`parent`>

<`groupId>org.springframework.boot</groupId`>

<`artifactId>spring-boot-starter-parent</artifactId`>

<`version>2.0.3.RELEASE</version`>

<`relativePath`/> <!-- lookup parent from repository -->

</`parent`>

<`properties`>

<`project.build.sourceEncoding>UTF-8</project.build.sourceEncoding`>

<`project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding`>

<`java.version>1.8</java.version`>

</`properties`>

<`dependencies`>

<`dependency`>

<`groupId>org.mybatis.spring.boot</groupId`>

<`artifactId>mybatis-spring-boot-starter</artifactId`>

<`version>1.3.2</version`>

</`dependency`>

<`dependency`>

<`groupId>org.springframework.boot</groupId`>

<`artifactId>spring-boot-starter-test</artifactId`>

<`scope>test</scope`>

</`dependency`>

<!--mysql-->

<`dependency`>

<`groupId>mysql</groupId`>

<`artifactId>mysql-connector-java</artifactId`>

<`version>5.1.21</version`>

</`dependency`>

</`dependencies`>

<`build`>

<`plugins`>

<`plugin`>

<`groupId>org.springframework.boot</groupId`>

<`artifactId>spring-boot-maven-plugin</artifactId`>

</`plugin`>

</`plugins`>

</`build`>

</`project`>

1.7  修改application.yml 文件,添加数据库连接信息

[XML]纯文本查看__复制代码

?

1

2

3

4

5

6

spring:

datasource:

url: jdbc:mysql://localhost:3306/book

username: root

password: root

driver-class-name: com.mysql.jdbc.Driver

同其他Spring Boot工程一样,简单且简洁的的完成了基本配置,下面看看如何在这个基础下轻松方便的使用MyBatis访问数据库。

2.0 使用mybatis

2.1 创建数据库表book

[SQL]纯文本查看__复制代码

?

1

2

3

4

5

6

CREATE TABLE `book` (

`bookid` int`(11) NOT NULL AUTO_INCREMENT,`

`bookname` varchar`(50) NOT NULL`,

`state` int`(11) NOT NULL`,

PRIMARY KEY (`bookid`)

) ENGINE=InnoDB AUTO_INCREMENT=6 DEFAULT CHARSET=utf8;

2.2 创建对应实体

[Java]纯文本查看__复制代码

?

01

02

03

04

05

06

07

08

09

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

25

26

27

28

29

public class Book {

private Integer bookid;

private String bookname;

public Integer getBookid() {

return bookid;

}

public void setBookid(Integer bookid) {

this`.bookid = bookid;`

}

public String getBookname() {

return bookname;

}

public void setBookname(String bookname) {

this`.bookname = bookname;`

}

@Override

public String toString() {

return "Book{" +

"bookid=" + bookid +

", bookname='" + bookname + '\`'' +`

'}'`;`

}

}

2.3 创建BookMapper

[Java]纯文本查看__复制代码

?

01

02

03

04

05

06

07

08

09

10

11

12

import org.apache.ibatis.annotations.Mapper;

import org.apache.ibatis.annotations.Select;

import org.xixilover.entity.Book;

import java.util.List;

@Mapper

public interface BookDaoMapper {

@Select`("select bookid,bookname from book")`

List<Book> getList();

}

2.4 创建单元测试

[Java]纯文本查看__复制代码

?

01

02

03

04

05

06

07

08

09

10

11

12

13

14

15

16

17

18

19

20

21

22

23

24

package cn.itcast.springbootmybatis;

import org.junit.Test;

import org.junit.runner.RunWith;

import org.springframework.beans.factory.annotation.Autowired;

import org.springframework.boot.test.context.SpringBootTest;

import org.springframework.test.context.junit4.SpringJUnit4ClassRunner;

import java.util.List;

@RunWith`(SpringJUnit4ClassRunner.class)`

@SpringBootTest`(classes = SpringbootMybatisApplication.class)`

public class UserDaoMapperTest {

@Autowired

private BookDaoMapper bookDaoMapper;

@Test

public void testGetList(){

List<Book> list = bookDaoMapper.getList();

System.out.println(list);

}

}

3.0 测试结果如下

[Java]纯文本查看__复制代码

?

1

[Book{bookid=`1, bookname='java'}, Book{bookid=2, bookname='c'}, Book{bookid=3, bookname='c#'}, Book{bookid=4, bookname='php'}, Book{bookid=5, bookname='js'`}]

评论

暂无评论