前几天分享了如何在docker上部署mysql,今天我们把它运用起来,通过springboot对mysql和mybatis进行整合
相关文章
1、docker上部署mysql
2、CentOS 7 安装mysql 8.0 图文教程
GitHub地址
点击进入→ Springboot整合mysql和mybatis Github Demo地址
准备阶段
1、安装好mysql后,新建一个库,执行下面的初始化脚本
-- ----------------------------
-- Table structure for user_info 是否使用utf8mb4自己决定
-- ----------------------------
DROP TABLE IF EXISTS `user_info`;
CREATE TABLE `user_info` (
`id` bigint(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
`user_name` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL DEFAULT NULL COMMENT '姓名',
`sex` int(1) NULL DEFAULT NULL COMMENT '性别',
`create_date` timestamp(0) NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP(0) COMMENT '创建日期',
PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB AUTO_INCREMENT = 5 CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci COMMENT = '用户信息表' ROW_FORMAT = Dynamic;
-- ----------------------------
-- Records of user_info
-- ----------------------------
INSERT INTO `user_info` VALUES (1, '小王', 0, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (2, '小明', 0, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (4, '小红', 1, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (8, '小孙', 0, '2019-11-05 10:02:20');
INSERT INTO `user_info` VALUES (9, '三叶', 1, '2019-11-05 10:06:36');
INSERT INTO `user_info` VALUES (10, '梨花', 1, '2019-11-05 10:47:52');
2、先展示项目的代码整体结构,如下图
3、新建springboot工程
4、配置pom文件和mysql参数
pom.xml
4.0.0
org.springframework.boot
spring-boot-starter-parent
2.2.0.RELEASE
com.example.demo
springboot-mysql-mybatis-demo
0.0.1-SNAPSHOT
springboot-mysql-mybatis-demo
Mysql And Mybatis Demo project for Spring Boot
1.8
org.springframework.boot
spring-boot-starter-web
mysql
mysql-connector-java
8.0.11
runtime
org.mybatis.spring.boot
mybatis-spring-boot-starter
2.1.1
org.springframework.boot
spring-boot-starter-test
test
org.junit.vintage
junit-vintage-engine
org.springframework.boot
spring-boot-maven-plugin
application.properties
PS:如果mybatis.mapper-locations需要匹配多个路径,可以用','分割,例如mybatis.mapper-locations=classpath:mybatis/mapper/*.xml,classpath:mybatis/mapper/**/*.xml 代表扫描mapper目录下的xml文件和mapper下一级目录下的xml文件,达到多级扫描效果
server.port=8066
#m