链接：https://pan.baidu.com/s/1iJP_mm3ijSjbHYyl5fRT-Q 

提取码：8is5 

 

1.1、数据库脚本

新建数据库表及初始化一些数据，脚本如下：

create table if not exists david.t_student_info

( id varchar(20) not null comment '主键' primary key, name varchar(50) default ' ' null comment '姓名', age decimal(3) default 20 null comment '年龄', sex char default 'M' null comment '性别 M-男，W-女', phone varchar(20) null comment '手机号', email varchar(30) null comment '电子邮箱', rsv1 varchar(100) null comment '备注字段' )comment '学生信息表'; INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10001', '张三', 20, 'M', '13988887777', 'zhangsan@163.com', '备注');

1.2、编写相关代码

编写Controller，Service，Dao，Mapper等，实现业务逻辑

StudInfoController INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10002', '李四', 18, 'W', '15988887777', 'lisi@163.com', '李四是张三的妹妹'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10003', '苍老师', 18, 'W', '15866668888', 'canglaoshi@163.com', '这里是苍老师的备注'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10004', '刘备', 30, 'M', '18666666666', 'liubei@163.com', '我是刘皇叔，专门卖草鞋'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10005', '关羽', 29, 'M', '18655555555', 'guanyu@163.com', '我是关羽，卖绿豆的'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10006', ' 孙悟空', 500, 'M', '19100002222', 'wukong@163.com', '我是孙悟空，我有金箍棒'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10007', ' 猪八戒', 488, 'M', '18900003333', 'bajie@163.com', '猪八戒'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10008', ' 沙僧', 200, 'M', '18678652388', 'shaseng@163.com', '我是沙僧'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10009', ' 唐僧', 25, 'M', '18766809012', 'shaseng@163.com', '我是唐僧，你们都是弟弟'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10010', ' 老树龙井', 20, 'W', '15988801234', 'longjing@163.com', 'laoshulongjing'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10011', ' 苏檀儿', 22, 'W', '18809826678', 'sutaner@163.com', '苏檀儿'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10012', ' 宁毅', 20, 'M', '15900008888', 'ningyi@163.com', '宁毅'); INSERT INTO david.t_student_info (id, name, age, sex, phone, email, rsv1) VALUES ('10013', ' 小婵', 18, 'W', '18566780092', 'xiaochan@163.com', '我是小婵'); /*** @author zhang_wei * @version 1.0.0 * @Classname StudInfoController * @Date 2021/2/26 11:07 * @Created by zhang_wei * @since 1.0.0 */ @Controller public class StudInfoController { Logger logger = LoggerFactory.getLogger(StudInfoController.class); @Autowired StudentInfoService studentInfoService; @RequestMapping("/getAll") @ResponseBody public List<StudentInfo> getAllStudentInfos() { List<StudentInfo> result = studentInfoService.findAll(); logger.info("result={}", result); return result; } }