springboot + maven + mybatis-plus + mysql8 整合

最新推荐文章于 2025-02-07 09:28:31 发布

ilyuc

最新推荐文章于 2025-02-07 09:28:31 发布

阅读量2k

点赞数 1

本文链接：https://blog.youkuaiyun.com/ilyucs/article/details/112333626

版权

springboot 2.4.1
JDK 1.8
mybatis-plus 3.2.0
mysql-connector-java 8.0.11
druid 1.1.18

1、假数据

在这里插入图片描述
sql脚本

/*
Navicat MySQL Data Transfer

Source Server         : mysql
Source Server Version : 80022
Source Host           : localhost:3306
Source Database       : mytest

Target Server Type    : MYSQL
Target Server Version : 80022
File Encoding         : 65001

Date: 2021-01-11 19:32:11
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for user
-- ----------------------------
DROP TABLE IF EXISTS `user`;
CREATE TABLE `user` (
  `name` varchar(32) DEFAULT NULL COMMENT '姓名',
  `alisa` varchar(32) DEFAULT NULL,
  `age` int DEFAULT NULL COMMENT '年龄',
  `hall` varchar(16) DEFAULT NULL COMMENT '身高',
  `sex` varchar(16) DEFAULT NULL COMMENT '性别',
  `weight` double DEFAULT NULL COMMENT '体重',
  `email` varchar(64) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of user
-- ----------------------------
INSERT INTO `user` VALUES ('张三', 'zhangsan', '18', '180', 'male', '70', 'zhangsan@gmail.com');
INSERT INTO `user` VALUES ('李四', 'lisi', '19', '181', 'female', '60', 'lisi@126.com');
INSERT INTO `user` VALUES ('王五', 'wangwu', '20', '182', 'male', '80', 'wangwu@qq.com');
INSERT INTO `user` VALUES ('赵六', 'zhaoliu', '21', '183', 'male', '75', 'zhaoliu@163.com');

2、pom.xml

<?xml version="1.0" encoding="UTF-8"?>
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
         xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <parent>
        <groupId>org.springframework.boot</groupId>
        <artifactId>spring-boot-starter-parent</artifactId>

最低0.47元/天解锁文章