Spring Boot开发简单网页（员工管理系统）（十三）：整合MyBatis+MySQL

在前面的项目中我们的数据库是在dao层伪造的，并没有连接到数据库

现在我们使用MySQL来存储员工信息，并整合MyBatis来操作数据库中的数据。

整合MyBatis+MySQL之后完整代码的百度云下载链接：

链接：https://pan.baidu.com/s/1UqLNZ-CKuDleJDtw9ct3qw

提取码：lrrs

1、创建数据库

CREATE DATABASE mydatabase;

DROP TABLE IF EXISTS `Employee`;

CREATE TABLE `Employee` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`lastName` VARCHAR(50) NOT NULL DEFAULT '',
	`email` VARCHAR(50) DEFAULT '',
	`gander` INT DEFAULT NULL,
	`departmentId` INT(10) DEFAULT NULL,
	`birth` DATE NOT NULL,
	PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8;

BEGIN;
INSERT INTO `Employee` VALUES (1001, 'AA', 'A123456789@qq.com', 1, 101, NOW());
INSERT INTO `Employee` VALUES (1002, 'BB', 'B123456789@qq.com', 0, 102, NOW());
INSERT INTO `Employee` VALUES (1003, 'CC', 'C123456789@qq.com', 1, 103, NOW());
INSERT INTO `Employee` VALUES (1004, 'DD', 'D123456789@qq.com', 0, 104, NOW());
INSERT INTO `Employee` VALUES (1005, 'EE', 'E123456789@qq.com', 1, 105, NOW());
COMMIT;

DROP TABLE IF EXISTS `Department`;

CREATE TABLE `Department` (
	`id` INT(10) UNSIGNED NOT NULL AUTO_INCREMENT,
	`departmentName` VARCHAR(50) DEFAULT '',
	PRIMARY KEY (`id`)
) ENGINE=INNODB DEFAULT CHARSET=utf8 ;

BEGIN;
INSERT INTO `Department` VALUES (101,'教学部');
INSERT INTO `Department` VALUES (102,'市场部');
INSERT INTO `Department` VALUES (103,'教研部');
INSERT INTO `Department` VALUES (104,'运营部');
INSERT INTO `Department` VALUES (105,'后勤部');
COMMIT;

2、导入依赖

我们在pom.xml中导入mybatis和mysql的相关依赖