Springboot整合mybatis项目开发

1 数据库准备

1.1 创建数据库zhihu

1.2 创建表user,question

 DROP TABLE IF EXISTS `user`; CREATE TABLE `user` (   `id` int(11) unsigned NOT NULL AUTO_INCREMENT,   `name` varchar(64) NOT NULL DEFAULT '',   `password` varchar(128) NOT NULL DEFAULT '',   `salt` varchar(32) NOT NULL DEFAULT '',   `head_url` varchar(256) NOT NULL DEFAULT '',   PRIMARY KEY (`id`),   UNIQUE KEY `name` (`name`) ) ENGINE=InnoDB DEFAULT CHARSET=utf8;DROP TABLE IF EXISTS `question`;CREATE TABLE `question` (  `id` INT NOT NULL AUTO_INCREMENT,  `title` VARCHAR(255) NOT NULL,  `content` TEXT NULL,  `user_id` INT NOT NULL,  `created_date` DATETIME NOT NULL,  `comment_count` INT NOT NULL,  PRIMARY KEY (`id`),  INDEX `date_index` (`created_date` ASC));

2 项目结构