Spring Boot 2 ：Spring Boot项目依赖(重点)&&连接Mysql(重点)

技术Spring Mysql Mybatis-Plus

1.模型介绍

2.Mysql基本命令

3.IDEA连接Mysql（重点）

4.配置相关依赖（重点）

4.1在pom.xml文件中添加依赖：

Spring Boot Starter JDBC
Project Lombok
MySQL Connector/J
mybatis-plus-boot-starter
mybatis-plus-generator
依赖的解释

4.2配置application.properties（Mysql相关）

spring.datasource.username=root
spring.datasource.password=123456
spring.datasource.url=jdbc:mysql://localhost:3306/kob?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8
spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver
1
2
3
4

5.Spring Boot结构层次

@RestController
public class UserController {
    @Autowired //完成自动装配

    UserMapper userMapper;

    @GetMapping("/user/all")//请求映射
    public List<User> getAll(){
        return userMapper.selectList(null);
    }

    @GetMapping("/user/{userID}/")
    public User getUser(@PathVariable int userId){
        return userMapper.selectById(null);
    }


    @GetMapping("/user/add/{userId}/{username}/{password}/")
    public String addUser(@PathVariable int userId,@PathVariable String username,@PathVariable String password){
        User user = new User(userId,username,password);
        userMapper.insert(user);
        return "Add user successfully";
    }

    @GetMapping("/user/delete/{userId}/")
    public String deleteUser(@PathVariable int userId){
        userMapper.deleteById(userId);
        return "dele successfully";
    }
}
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