Spring Boot实现SDAO服务
1.数据库表设计
CREATE DATABASE `springbootlearn`;
CREATE TABLE `student` (
`id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT 'ID',
`name` varchar(50) NOT NULL DEFAULT '' COMMENT '姓名',
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8;
INSERT INTO `springbootlearn`.`students` (`id`, `name`) VALUES ('1', '小明');
INSERT INTO `springbootlearn`.`students` (`id`, `name`) VALUES ('2', '小花');
2.数据配置
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/spr
共有 0 条评论