发表更新SpringBoot2 分钟读完 (大约330个字)0次访问

SpringBoot集成Mybatis

SpringBoot官方推荐了两种方式：

  • 一个是在Java类上注解写sql
  • 一个是配置mapper.xml(本次举例)

引入依赖

pom.xml

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
<!--引入mybatis-springboot依赖-->
<dependency>
  <groupId>org.mybatis.spring.boot</groupId>
  <artifactId>mybatis-spring-boot-starter</artifactId>
  <version>2.1.3</version>
</dependency>
<!--引入mysql-->
<dependency>
  <groupId>mysql</groupId>
  <artifactId>mysql-connector-java</artifactId>
</dependency>
<!--引入druid依赖-->
<dependency>
  <groupId>com.alibaba</groupId>
  <artifactId>druid</artifactId>
  <version>1.1.23</version>
</dependency>

修改配置文件

application.properties

  • 配置数据源
1
2
3
4
5
6
# 配置数据源
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource
spring.datasource.driver-class-name=com.mysql.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/mybatis
spring.datasource.username=root
spring.datasource.password=root
  • 配置mybatis配置
1
2
3
4
5
#mybatis配置
#指定mapper配置文件位置
mybatis.mapper-locations=classpath:/com/buubiu/mapper/*.xml
#指定起别名来的类
mybatis.type-aliases-package=com.buubiu.entity

编辑入口类

在入口类加注解 @MapperScan('com.buubiu.dao')

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
package com.buubiu;

import org.mybatis.spring.annotation.MapperScan;
import org.springframework.boot.SpringApplication;
import org.springframework.boot.autoconfigure.SpringBootApplication;

/**
 * @author buubiu
 **/
@SpringBootApplication
@MapperScan("com.buubiu.dao")
public class Application {

	public static void main(String[] args) {
		SpringApplication.run(Application.class, args);
	}

}

开发控制类以及页面

1
2
3
4
5
6
7
8
9
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
package com.buubiu.controller;

import com.buubiu.entity.User;
import com.buubiu.service.UserService;
import java.util.List;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Controller;
import org.springframework.ui.Model;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RequestMapping;

/**
 * @author buubiu
 **/
@Controller
@RequestMapping("user")
public class UserController {

	@Autowired
	private UserService userService;

	@GetMapping("findAll")
	public String findAll(Model model) {
		List<User> users = userService.findAll();
		model.addAttribute("users", users);
		return "showAll";
	}

	@GetMapping("save")
	public String save(User user) {
		userService.save(user);
		return "redirect:/user/findAll";
	}

}

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
<!DOCTYPE html>
<html lang="en" xmlns:th="http://www.thymeleaf.org">
<head>
  <meta charset="UTF-8">
  <title>ShowAll</title>
</head>
<body>
  <ul th:each="user,userState:${users}">
    <li><span th:text="${user.id}"></span></li>
    <li><span th:text="${user.name}"></span></li>
    <li><span th:text="${user.age}"></span></li>
    <li><span th:text="${#dates.format(user.bir,'yyyy-MM-dd')}"></span></li>
  </ul>
<h1><a th:href="@{/user/save(name='buubiu中间',age='33',bir='1997/09/10')}">添加用户</a> </h1>
</body>
</html>

SpringBoot集成Mybatis

https://blog.buubiu.com/SpringBoot集成Mybatis/

作者

buubiu

发布于

2020-08-13

更新于

2024-01-25

许可协议

#

目录

×