SpringBoot 2.7教程:2.SpringBoot + Mysql 项目应用-2022年最新图文版本
本章主要目标:1.学习SpringBoot Mysql 项目搭建
2.学习使用Mybatis-Plus
一、右键新建Module 二、修改模板下载地址为阿里云 三、配置Group、Artifact 四、搜索添加依赖当前最常用的版本2.2.x、2.3.x将在2022年停止维护了。
下面我们以最新的版本2.7进行系统搭建。
五、确定项目存放目录 六、修改pom.xml文件 6.1 修改springboot版本为2.6.6
6.2 确定web、mysql、Mybatis-plus依赖1.8 UTF-8 UTF-8 2.7.0
七、书写代码 7.1 书写entity.User user表对应的数据实体类org.springframework.boot spring-boot-starter-webmysql mysql-connector-java8.0.17 com.baomidou mybatis-plus-boot-starter3.4.2
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
@TableName("user")
public class User {
@TableId(type = IdType.AUTO)
private Integer userId;
private String userName;
private Integer userSex;
public Integer getUserId() {
return userId;
}
public void setUserId(Integer userId) {
this.userId = userId;
}
public String getUserName() {
return userName;
}
public void setUserName(String userName) {
this.userName = userName;
}
public Integer getUserSex() {
return userSex;
}
public void setUserSex(Integer userSex) {
this.userSex = userSex;
}
@Override
public String toString() {
return "User{" +
"userId=" + userId +
", userName='" + userName + ''' +
", userSex=" + userSex +
'}';
}
}
7.2 书写 dao.UserDao
import com.baomidou.mybatisplus.core.mapper.BaseMapper; import com.duoduo.mysql.entity.User; import org.apache.ibatis.annotations.Mapper; @Mapper public interface UserDao extends BaseMapper7.3 书写Controller{ }
package com.duoduo.mysql.controller;
import com.duoduo.mysql.dao.UserDao;
import com.duoduo.mysql.entity.User;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.PutMapping;
import org.springframework.web.bind.annotation.RestController;
import javax.annotation.Resource;
@RestController
public class UserController {
@Resource
UserDao userDao;
@PutMapping("user/add")
public String mysqlAdd(){
User user = new User();
user.setUserName("zhangsan");
user.setUserSex(1);
userDao.insert(user);
return "succ";
}
@GetMapping("user/get")
public String mysqlGet() {
User user = userDao.selectById(1);
return user.toString();
}
@PostMapping("user/edit")
public String mysqlEdit(){
User user = new User();
user.setUserId(1);
user.setUserName("lisi");
user.setUserSex(1);
userDao.updateById(user);
return "succ";
}
@DeleteMapping("user/del")
public String mysqlDel(){
userDao.deleteById(1);
return "succ";
}
}
7.4 配置mysql连接信息,application.properties
# 数据库驱动: spring.datasource.driver-class-name=com.mysql.cj.jdbc.Driver # 数据源名称 spring.datasource.name=defaultDataSource # 数据库连接地址 spring.datasource.url=jdbc:mysql://服务器地址:3306/db_name?serverTimezone=UTC&characterEncoding=utf-8&useSSL=false # 数据库用户名&密码: spring.datasource.username=*** spring.datasource.password=***7.5 创建数据库和表结构
CREATE TABLE `user` ( `user_id` int(10) NOT NULL AUTO_INCREMENT, `user_name` varchar(255) CHARACTER SET latin1 NOT NULL, `user_sex` int(10) NOT NULL DEFAULT '0', PRIMARY KEY (`user_id`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4;八、启动Application测试使用Postman进行测试
PUT http://localhost:8080/user/add
GET http://localhost:8080/user/get
POST http://localhost:8080/user/edit
DELETE http://localhost:8080/user/del



