4、新增ebook表,生成持久层代码
第一步:运行 SQL
# 电子书表
drop table if exists `ebook`;
create table `ebook`
(
`id` bigint not null comment 'id',
`name` varchar(50) comment '名称',
`category1_id` bigint comment '分类1',
`category2_id` bigint comment '分类2',
`description` varchar(200) comment '描述',
`cover` varchar(200) comment '封面',
`doc_count` int comment '文档数',
`view_count` int comment '阅读数',
`vote_count` int comment '点赞数',
primary key (`id`)
) engine = innodb
default charset = utf8mb4 comment ='电子书';
insert into `ebook` (id, name, description)
values (1, 'Spring Boot 入门教程', '零基础入门 Java 开发,企业级应用开发最佳首选框架');
insert into `ebook` (id, name, description)
values (2, 'Vue 入门教程', '零基础入门 Vue 开发,企业级应用开发最佳首选框架');
insert into `ebook` (id, name, description)
values (3, 'Python 入门教程', '零基础入门 Python 开发,企业级应用开发最佳首选框架');
insert into `ebook` (id, name, description)
values (4, 'Mysql 入门教程', '零基础入门 Mysql 开发,企业级应用开发最佳首选框架');
insert into `ebook` (id, name, description)
values (5, 'Oracle 入门教程', '零基础入门 Oracle 开发,企业级应用开发最佳首选框架');
第二步:查看运行结果
![image-20210718185129891](https://i-blog.csdnimg.cn/blog_migrate/5b3326b7850e7cd3faabbdedf6459766.png)
第三步:修改代码生成器文件 generator-config.xml
<table tableName="ebook"/>
第四步:执行生成器结果
![image-20210718185623879](https://i-blog.csdnimg.cn/blog_migrate/ff96969024b55561ba6604cacd9eefd9.png)
第五步:创建 EBookService
package com.zibo.wiki.serivce;
import com.zibo.wiki.domain.Ebook;
import com.zibo.wiki.mapper.EbookMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import java.util.List;
@Service
public class EBookService {
@Autowired
private EbookMapper ebookMapper;
public List<Ebook> list(){
return ebookMapper.selectByExample(null);
}
}
第六步:创建 EBookController
package com.zibo.wiki.controller;
import com.zibo.wiki.domain.Ebook;
import com.zibo.wiki.serivce.EBookService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.RequestMapping;
import org.springframework.web.bind.annotation.RestController;
import java.util.List;
@RestController
public class EBookController {
@Autowired
private EBookService eBookService;
@RequestMapping("/ebook/list")
public List<Ebook> list(){
return eBookService.list();
}
}
第七步:新建 ebook.http
GET http://localhost:8080/ebook/list
Accept: application/json
###
第八步:启动项目,测试
![image-20210718190459750](https://i-blog.csdnimg.cn/blog_migrate/5c5f659a8c76197b69d3fd9c406bd7a8.png)