1. 项目准备
项目demo简述:
前端:nginx部署页面,并反向代理后端api接口
后端:SpringBoot + Mybatis,web项目访问mysql数据库
1.1 后端项目
1.1.1 数据库表
user
表
CREATE DATABASE IF NOT EXISTS `demo` DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;
USE `demo`;
SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;
-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
`id` bigint(20) NOT NULL AUTO_INCREMENT,
`name` varchar(30) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL,
`age` int(11) NULL DEFAULT NULL,
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 3 CHARACTER SET = utf8 COLLATE = utf8_general_ci ROW_FORMAT = Compact;
-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES (1, 'Jack', 22);
INSERT INTO `user` VALUES (2, 'Tom', 21);
SET FOREIGN_KEY_CHECKS = 1;
1.1.2 SpringBoot项目
同普通SpringBoot项目一样,整合Mybatis,可参考我其他的博客。下面只给出Controller,和访问结果。
package ace.gjh.controller;
import ace.gjh.service.UserService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.RestController;
/**
* @author ACE_GJH
* @date 2021/5/7
*/
@RestController
public class UserController {
@Autowired
private UserService userService;
@GetMapping