连接Mysql和Spring Boot依赖
技术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
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";
}
}