学习目标理
理解FastDFS工作流程
分布式文件管理系统文件上传文件下载文件删除文件缓存控制
搭建文件上传微服务
- 相册管理(实战)
- 规格参数管理(实战)
-
1 FastDFS
1.1 FastDFS简介
1.1.1 FastDFS体系结构
FastDFS是一个开源的轻量级分布式文件系统,它对文件进行管理,功能包括:文件存储、文件同步、文件访问(文件上传、文件下载)等,解决了大容量存储和负载均衡的问题。特别适合以文件为载体的在线服务,如相册网站、视频网站等等。
FastDFS为互联网量身定制,充分考虑了冗余备份、负载均衡、线性扩容等机制,并注重高可用、高性能等指标,使用FastDFS很容易搭建一套高性能的文件服务器集群提供文件上传、下载等服务。
FastDFS 架构包括 Tracker server 和 Storage server。客户端请求 Tracker server 进行文件上传、下载,通过Tracker server 调度最终由 Storage server 完成文件上传和下载。
Tracker server 作用是负载均衡和调度,通过 Tracker server 在文件上传时可以根据一些策略找到Storage server 提供文件上传服务。可以将 tracker 称为追踪服务器或调度服务器。Storage server 作用是文件存储,客户端上传的文件最终存储在 Storage 服务器上,Storageserver 没有实现自己的文件系统而是利用操作系统的文件系统来管理文件。可以将storage称为存储服务器。
1.1.2 上传流程

客户端上传文件后存储服务器将文件 ID 返回给客户端,此文件 ID 用于以后访问该文件的索引信息。文件索引信息包括:组名,虚拟磁盘路径,数据两级目录,文件名。
组名:文件上传后所在的 storage 组名称,在文件上传成功后有storage 服务器返回,需要客户端自行保存。
虚拟磁盘路径:storage 配置的虚拟路径,与磁盘选项store_path对应。如果配置了
store_path0 则是 M00,如果配置了 store_path1 则是 M01,以此类推。
数据两级目录:storage 服务器在每个虚拟磁盘路径下创建的两级目录,用于存储数据
文件。
*文件名:与文件上传时不同。是由存储服务器根据特定信息生成,文件名包含:源存储
服务器 IP 地址、文件创建时间戳、文件大小、随机数和文件拓展名等信息。1.2 FastDFS搭建
1.2.1 安装FastDFS镜像
我们使用Docker搭建FastDFS的开发环境,虚拟机中已经下载了fastdfs的镜像,可以通过
docker images查看,如下图:
拉取镜像(已经下载了该镜像,大家无需下载了)docker pull morunchang/fastdfs
运行tracker
docker run -d --name tracker --net=host morunchang/fastdfs sh tracker.sh
运行storage
docker run -d --name storage --net=host -e TRACKER_IP=192.168.211.132:22122 -e GROUP_NAME=group1 morunchang/fastdfs sh storage.sh
使用的网络模式是–net=host, 192.168.211.132是宿主机的IP
- group1是组名,即storage的组
- 如果想要增加新的storage服务器,再次运行该命令,注意更换 新组名
1.2.2 配置Nginx
Nginx在这里主要提供对FastDFS图片访问的支持,Docker容器中已经集成了Nginx,我们需要修改nginx的配置,进入storage的容器内部,修改nginx.conf
进入后docker exec -it storage /bin/bash
添加以下内容vi /etc/nginx/conf/nginx.conf

上图配置如下:
禁止缓存(该步骤不需要做!保留缓存更好!):location ~ /M00 {root /data/fast_data/data;ngx_fastdfs_module;}
退出容器add_header Cache-Control no-store;
重启storage容器exit
查看启动容器docker restart storage
docker ps
开启启动设置9f2391f73d97 morunchang/fastdfs "sh storage.sh" 12 minutes ago Up 12 seconds storagee22a3c7f95ea morunchang/fastdfs "sh tracker.sh" 13 minutes ago Up 13 minutes tracker
docker update --restart=always trackerdocker update --restart=always storage
1.3 文件存储微服务
创建文件管理微服务changgou-service-file,该工程主要用于实现文件上传以及文件删除等功能。1.3.1 pom.xml依赖
修改pom.xml,引入依赖<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><parent><artifactId>changgou-service</artifactId><groupId>com.changgou</groupId><version>1.0-SNAPSHOT</version></parent><modelVersion>4.0.0</modelVersion><artifactId>changgou-service-file</artifactId><description>文件上传工程</description><!--依赖包--><dependencies><dependency><groupId>net.oschina.zcx7878</groupId><artifactId>fastdfs-client-java</artifactId><version>1.27.0.0</version></dependency><dependency><groupId>com.changgou</groupId><artifactId>changgou-common</artifactId><version>1.0-SNAPSHOT</version></dependency></dependencies></project>
1.3.2 FastDFS配置
在resources文件夹下创建fasfDFS的配置文件fdfs_client.conf
connect_timeout:连接超时时间,单位为秒。connect_timeout=60network_timeout=60charset=UTF-8http.tracker_http_port=8080tracker_server=192.168.211.132:22122
network_timeout:通信超时时间,单位为秒。发送或接收数据时。假设在超时时间后还不能发送或接收数据,则本次网络通信失败
charset: 字符集
http.tracker_http_port :.tracker的http端口
tracker_server: tracker服务器IP和端口设置1.3.3 application.yml配置
在resources文件夹下创建application.yml
max-file-size是单个文件大小,max-request-size是设置总上传的数据大小spring:servlet:multipart:max-file-size: 10MBmax-request-size: 10MBapplication:name: fileserver:port: 18082eureka:client:service-url:defaultZone: http://127.0.0.1:7001/eurekainstance:prefer-ip-address: truefeign:hystrix:enabled: true
1.3.4 启动类
创建com.changgou包,创建启动类FileApplication
这里禁止了DataSource的加载创建。@SpringBootApplication(exclude={DataSourceAutoConfiguration.class})@EnableEurekaClientpublic class FileApplication {public static void main(String[] args) {SpringApplication.run(FileApplication.class);}}
1.4 文件上传
1.4.1 文件信息封装
文件上传一般都有文件的名字、文件的内容、文件的扩展名、文件的md5值、文件的作者等相关属性,我们可以创建一个对象封装这些属性,代码如下:
创建com.changgou.file.FastDFSFile代码如下:
(可选)测试文件相关操作:public class FastDFSFile implements Serializable {//文件名字private String name;//文件内容private byte[] content;//文件扩展名private String ext;//文件MD5摘要值private String md5;//文件创建作者private String author;public FastDFSFile(String name, byte[] content, String ext, String md5, String author) {this.name = name;this.content = content;this.ext = ext;this.md5 = md5;this.author = author;}public FastDFSFile(String name, byte[] content, String ext) {this.name = name;this.content = content;this.ext = ext;}public FastDFSFile() {}//..get..set..toString}
package com.changgou.file.test;import org.csource.fastdfs.*;import org.junit.Test;import java.io.*;import java.net.InetSocketAddress;/*** 描述** @author 三国的包子* @version 1.0* @package PACKAGE_NAME ** @since 1.0*/public class FastdfsClientTest {/*** 文件上传** @throws Exception*/@Testpublic void upload() throws Exception {//加载全局的配置文件ClientGlobal.init("C:\\Users\\Administrator\\IdeaProjects\\beike\\changgou\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//创建TrackerClient客户端对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient对象获取TrackerServer信息TrackerServer trackerServer = trackerClient.getConnection();//获取StorageClient对象StorageClient storageClient = new StorageClient(trackerServer, null);//执行文件上传String[] jpgs = storageClient.upload_file("C:\\Users\\Administrator\\Pictures\\5b13cd6cN8e12d4aa.jpg", "jpg", null);for (String jpg : jpgs) {System.out.println(jpg);}}@Testpublic void delete() throws Exception {//加载全局的配置文件ClientGlobal.init("C:\\Users\\Administrator\\IdeaProjects\\beike\\changgou\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//创建TrackerClient客户端对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient对象获取TrackerServer信息TrackerServer trackerServer = trackerClient.getConnection();//获取StorageClient对象StorageClient storageClient = new StorageClient(trackerServer, null);//执行文件上传int group1 = storageClient.delete_file("group1", "M00/00/00/wKjThF1VEiyAJ0xzAANdC6JX9KA522.jpg");System.out.println(group1);}@Testpublic void download() throws Exception {//加载全局的配置文件ClientGlobal.init("C:\\Users\\Administrator\\IdeaProjects\\beike\\changgou\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//创建TrackerClient客户端对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient对象获取TrackerServer信息TrackerServer trackerServer = trackerClient.getConnection();//获取StorageClient对象StorageClient storageClient = new StorageClient(trackerServer, null);//执行文件上传byte[] bytes = storageClient.download_file("group1", "M00/00/00/wKjThF1VFfKAJRJDAANdC6JX9KA980.jpg");File file = new File("D:\\ceshi\\1234.jpg");FileOutputStream fileOutputStream = new FileOutputStream(file);BufferedOutputStream bufferedOutputStream = new BufferedOutputStream(fileOutputStream);bufferedOutputStream.write(bytes);bufferedOutputStream.close();fileOutputStream.close();}//获取文件的信息数据@Testpublic void getFileInfo() throws Exception {//加载全局的配置文件ClientGlobal.init("C:\\Users\\Administrator\\IdeaProjects\\beike\\changgou\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//创建TrackerClient客户端对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient对象获取TrackerServer信息TrackerServer trackerServer = trackerClient.getConnection();//获取StorageClient对象StorageClient storageClient = new StorageClient(trackerServer, null);//执行文件上传FileInfo group1 = storageClient.get_file_info("group1", "M00/00/00/wKjThF1VFfKAJRJDAANdC6JX9KA980.jpg");System.out.println(group1);}}
1.4.2 文件操作
创建com.changgou.util.FastDFSClient类,在该类中实现FastDFS信息获取以及文件的相关操作,代码如下:
(1)初始化Tracker信息
在com.changgou.util.FastDFSClient类中初始化Tracker信息,在类中添加如下静态块:
(2)文件上传/**** 初始化tracker信息*/static {try {//获取tracker的配置文件fdfs_client.conf的位置String filePath = new ClassPathResource("fdfs_client.conf").getPath();//加载tracker配置信息ClientGlobal.init(filePath);} catch (Exception e) {e.printStackTrace();}}
在类中添加如下方法实现文件上传:
(3)获取文件信息/***** 文件上传* @param file : 要上传的文件信息封装->FastDFSFile* @return String[]* 1:文件上传所存储的组名* 2:文件存储路径*/public static String[] upload(FastDFSFile file){//获取文件作者NameValuePair[] meta_list = new NameValuePair[1];meta_list[0] =new NameValuePair(file.getAuthor());/**** 文件上传后的返回值* uploadResults[0]:文件上传所存储的组名,例如:group1* uploadResults[1]:文件存储路径,例如:M00/00/00/wKjThF0DBzaAP23MAAXz2mMp9oM26.jpeg*/String[] uploadResults = null;try {//创建TrackerClient客户端对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient对象获取TrackerServer信息TrackerServer trackerServer = trackerClient.getConnection();//获取StorageClient对象StorageClient storageClient = new StorageClient(trackerServer, null);//执行文件上传uploadResults = storageClient.upload_file(file.getContent(), file.getExt(), meta_list);} catch (Exception e) {e.printStackTrace();}return uploadResults;}
在类中添加如下方法实现获取文件信息:
(4)文件下载/**** 获取文件信息* @param groupName:组名* @param remoteFileName:文件存储完整名*/public static FileInfo getFile(String groupName,String remoteFileName){try {//创建TrackerClient对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient获得TrackerServer信息TrackerServer trackerServer =trackerClient.getConnection();//通过TrackerServer获取StorageClient对象StorageClient storageClient = new StorageClient(trackerServer,null);//获取文件信息return storageClient.get_file_info(groupName,remoteFileName);} catch (Exception e) {e.printStackTrace();}return null;}
在类中添加如下方法实现文件下载:
(5)文件删除实现//下载图片public static byte[] downFile(String groupName, String remoteFileName) throws Exception {//1.创建一个配置文件 用于填写服务端的ip和端口//2.加载配置文件 建立链接// ClientGlobal.init("C:\\Users\\admin\\IdeaProjects\\98\\changgou98\\changgou-parent\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//3.创建trackerClientTrackerClient trackerClient = new TrackerClient();//4.根据trackerclient获取到链接对象 trackerServerTrackerServer trackerServer = trackerClient.getConnection();//5.创建storageServer对象 设置null//6.创建stroageClient --->提供了很多的操作图片的API的代码(上传图片,下载 ,删除)StorageClient storageClient = new StorageClient(trackerServer, null);//7.下在图片//参数1 指定要下载的组名//参数2 指定要下载的远程文件路径byte[] group1s = storageClient.download_file(groupName, remoteFileName);return group1s;}
(6)获取组信息(了解)/**** 文件删除实现* @param groupName:组名* @param remoteFileName:文件存储完整名*///删除图片public static boolean deleteFile(String groupName, String remoteFileName) throws Exception {//1.创建一个配置文件 用于填写服务端的ip和端口//2.加载配置文件 建立链接//ClientGlobal.init("C:\\Users\\admin\\IdeaProjects\\98\\changgou98\\changgou-parent\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//3.创建trackerClientTrackerClient trackerClient = new TrackerClient();//4.根据trackerclient获取到链接对象 trackerServerTrackerServer trackerServer = trackerClient.getConnection();//5.创建storageServer对象 设置null//6.创建stroageClient --->提供了很多的操作图片的API的代码(上传图片,下载 ,删除)StorageClient storageClient = new StorageClient(trackerServer, null);int group1 = storageClient.delete_file(groupName, remoteFileName);if (group1 == 0) {return true;} else {return false;}}
(7)根据文件组名和文件存储路径获取Storage服务的IP、端口信息(了解)/**** 获取组信息* @param groupName :组名*/public static StorageServer getStorages(String groupName){try {//创建TrackerClient对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient获取TrackerServer对象TrackerServer trackerServer = trackerClient.getConnection();//通过trackerClient获取Storage组信息return trackerClient.getStoreStorage(trackerServer,groupName);} catch (Exception e) {e.printStackTrace();}return null;}
(8)获取Tracker服务地址(了解)/**** 根据文件组名和文件存储路径获取Storage服务的IP、端口信息* @param groupName :组名* @param remoteFileName :文件存储完整名*/public static ServerInfo[] getServerInfo(String groupName, String remoteFileName){try {//创建TrackerClient对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient获取TrackerServer对象TrackerServer trackerServer = trackerClient.getConnection();//获取服务信息return trackerClient.getFetchStorages(trackerServer,groupName,remoteFileName);} catch (Exception e) {e.printStackTrace();}return null;}
(9)优化/**** 获取Tracker服务地址*/public static String getTrackerUrl(){try {//创建TrackerClient对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient获取TrackerServer对象TrackerServer trackerServer = trackerClient.getConnection();//获取Tracker地址return "http://"+trackerServer.getInetSocketAddress().getHostString()+":"+ClientGlobal.getG_tracker_http_port();} catch (IOException e) {e.printStackTrace();}return null;}
我们可以发现,上面所有方法中都会涉及到获取TrackerServer或者StorageClient,我们可以把它们单独抽取出去,分别在类中添加如下2个方法:
修改其他方法,在需要使用TrackerServer和StorageClient的时候,直接调用上面的方法,完整代码如下:/**** 获取TrackerServer*/public static TrackerServer getTrackerServer() throws Exception{//创建TrackerClient对象TrackerClient trackerClient = new TrackerClient();//通过TrackerClient获取TrackerServer对象TrackerServer trackerServer = trackerClient.getConnection();return trackerServer;}/**** 获取StorageClient* @return* @throws Exception*/public static StorageClient getStorageClient() throws Exception{//获取TrackerServerTrackerServer trackerServer = getTrackerServer();//通过TrackerServer创建StorageClientStorageClient storageClient = new StorageClient(trackerServer,null);return storageClient;}
package com.changgou.file.util;import com.changgou.file.FastDFSFile;import org.csource.common.MyException;import org.csource.common.NameValuePair;import org.csource.fastdfs.ClientGlobal;import org.csource.fastdfs.StorageClient;import org.csource.fastdfs.TrackerClient;import org.csource.fastdfs.TrackerServer;import org.springframework.core.io.ClassPathResource;import java.io.ByteArrayInputStream;import java.io.File;import java.io.FileOutputStream;import java.io.IOException;/*** @author ljh* @version 1.0* @date 2020/9/22 11:57* @description 标题* @package com.changgou.file.util*/public class FastDFSClient {static {try {ClassPathResource resource = new ClassPathResource("fdfs_client.conf");ClientGlobal.init(resource.getPath());} catch (IOException e) {e.printStackTrace();} catch (MyException e) {e.printStackTrace();}}//上传图片public static String[] upload(FastDFSFile file) throws Exception {//1.创建一个配置文件 用于填写服务端的ip和端口//2.加载配置文件 建立链接//3.创建trackerClientTrackerClient trackerClient = new TrackerClient();//4.根据trackerclient获取到链接对象 trackerServerTrackerServer trackerServer = trackerClient.getConnection();//5.创建storageServer对象 设置null//6.创建stroageClient --->提供了很多的操作图片的API的代码(上传图片,下载 ,删除)StorageClient storageClient = new StorageClient(trackerServer, null);//参数1 指定要上传图片的本地的图片的绝对路径//参数2 指定要上传图片的图片的扩展名(jpg/png)不要带点//参数3 指定元数据 指的是 图片的高度 日期,像素...... 可以不给,NameValuePair[] meta_list = new NameValuePair[]{//像素 高度 大小new NameValuePair(file.getName())};String[] jpgs = storageClient.upload_file(file.getContent(), file.getExt(), meta_list);return jpgs;}//下载图片public static byte[] downFile(String groupName, String remoteFileName) throws Exception {//1.创建一个配置文件 用于填写服务端的ip和端口//2.加载配置文件 建立链接// ClientGlobal.init("C:\\Users\\admin\\IdeaProjects\\98\\changgou98\\changgou-parent\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//3.创建trackerClientTrackerClient trackerClient = new TrackerClient();//4.根据trackerclient获取到链接对象 trackerServerTrackerServer trackerServer = trackerClient.getConnection();//5.创建storageServer对象 设置null//6.创建stroageClient --->提供了很多的操作图片的API的代码(上传图片,下载 ,删除)StorageClient storageClient = new StorageClient(trackerServer, null);//7.下在图片//参数1 指定要下载的组名//参数2 指定要下载的远程文件路径byte[] group1s = storageClient.download_file(groupName, remoteFileName);return group1s;}//删除图片public static boolean deleteFile(String groupName, String remoteFileName) throws Exception {//1.创建一个配置文件 用于填写服务端的ip和端口//2.加载配置文件 建立链接//ClientGlobal.init("C:\\Users\\admin\\IdeaProjects\\98\\changgou98\\changgou-parent\\changgou-service\\changgou-service-file\\src\\main\\resources\\fdfs_client.conf");//3.创建trackerClientTrackerClient trackerClient = new TrackerClient();//4.根据trackerclient获取到链接对象 trackerServerTrackerServer trackerServer = trackerClient.getConnection();//5.创建storageServer对象 设置null//6.创建stroageClient --->提供了很多的操作图片的API的代码(上传图片,下载 ,删除)StorageClient storageClient = new StorageClient(trackerServer, null);int group1 = storageClient.delete_file(groupName, remoteFileName);if (group1 == 0) {return true;} else {return false;}}//获取图片的信息 //todo}
1.4.3 文件上传
创建一个FileController,在该控制器中实现文件上传操作,代码如下:
配置:yaml@RestControllerpublic class FileController {@Value("${pic.url}")private String picPath;//1.请求路径//2.参数//3.返回值/*** 图片上传** @param file* @return*/@PostMapping("/upload")public String upload(MultipartFile file) {try {if (!file.isEmpty()) {//1.获取到文件本身的字节数组byte[] content = file.getBytes();//2.获取文件的名称 --》获取图片的后缀String name = file.getOriginalFilename();//1234.jpg//3.上传到fastdfs上//[0] =group1//[1] =M00/00/00/wKjThF-qeNyATiVHAAAl8vdCW2Y824.pngString[] upload = FastDFSClient.upload(new FastDFSFile(name,//文件名content,//文件的本身的字节数组StringUtils.getFilenameExtension(name)));//4.拼接Ulr// http://192.168.211.132:8080/group1/M00/00/00/wKjThF-qeNyATiVHAAAl8vdCW2Y824.pngString realPath = picPath+"/"+upload[0]+"/"+upload[1];//5.返回url给页面return realPath;}} catch (Exception e) {e.printStackTrace();}return null;}}
1.5 Postman测试文件上传
步骤:
1、选择post请求方式,输入请求地址 http://localhost:18082/upload
2、填写Headers
3、填写bodyKey:Content-TypeValue:multipart/form-data
选择form-data 然后选择文件file 点击添加文件,最后发送即可。
访问[http://192.168.211.132:8080/group1/M00/00/00/wKjThF0DBzaAP23MAAXz2mMp9oM26.jpeg](http://192.168.211.132:8080/group1/M00/00/00/wKjThF0DBzaAP23MAAXz2mMp9oM26.jpeg)如下图
注意,这里每次访问的端口是8080端口,访问的端口其实是storage容器的nginx端口,如果想修改该端口可以直接进入到storage容器,然后修改即可。docker exec -it storage /bin/bashvi /etc/nginx/conf/nginx.conf

修改后重启storage即可根据自己修改的端口访问图片了。2 相册管理(实战)
2.1 需求分析
相册是用于存储图片的管理单元,我们通常会将商品的图片先上传到相册中,在添加商品时可以直接在相册中选择,获取相册中的图片地址,保存到商品表中。
前端交互方式见管理后台的静态原型2.2 表结构分析
tb_album 表(相册表)
| 字段名称 | 字段含义 | 字段类型 | 备注 |
|---|---|---|---|
| id | 编号 | BIGINT(20) | 主键 |
| title | 相册名称 | VARCHAR(100) | |
| image | 相册封面 | VARCHAR(100) | |
| image_items | 图片列表 | TEXT |
表中image_items数据如下示例:
[{"url": "http://localhost:9101/img/1.jpg","uid": 1548143143154,"status": "success"},{"url": "http://localhost:9101/img/7.jpg","uid": 1548143143155,"status": "success"}]
2.3 代码实现
2.3.1 Pojo
在changgou-service-goods-api工程中创建com.changgou.goods.pojo.Album,代码如下:
@Table(name="tb_album")public class Album implements Serializable{@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "id")private Long id;//编号@Column(name = "title")private String title;//相册名称@Column(name = "image")private String image;//相册封面@Column(name = "image_items")private String imageItems;//图片列表//get...set...toString..}
2.3.2 Dao
在changgou-service-goods中创建com.changgou.goods.dao.AlbumMapper接口,代码如下:
public interface AlbumMapper extends Mapper<Album> {}
2.3.3 业务层
(1)业务层接口
在changgou-service-goods中创建com.changgou.goods.service.AlbumService接口,并添加常用方法,代码如下:
public interface AlbumService {/**** Album多条件分页查询* @param album* @param page* @param size* @return*/PageInfo<Album> findPage(Album album, int page, int size);/**** Album分页查询* @param page* @param size* @return*/PageInfo<Album> findPage(int page, int size);/**** Album多条件搜索方法* @param album* @return*/List<Album> findList(Album album);/**** 删除Album* @param id*/void delete(Long id);/**** 修改Album数据* @param album*/void update(Album album);/**** 新增Album* @param album*/void add(Album album);/*** 根据ID查询Album* @param id* @return*/Album findById(Long id);/**** 查询所有Album* @return*/List<Album> findAll();}
(2)业务层实现类
在changgou-service-goods中创建com.changgou.goods.service.impl.AlbumServiceImpl,并实现接口方法,代码如下:
@Servicepublic class AlbumServiceImpl implements AlbumService {@Autowiredprivate AlbumMapper albumMapper;/*** Album条件+分页查询* @param album 查询条件* @param page 页码* @param size 页大小* @return 分页结果*/@Overridepublic PageInfo<Album> findPage(Album album, int page, int size){//分页PageHelper.startPage(page,size);//搜索条件构建Example example = createExample(album);//执行搜索return new PageInfo<Album>(albumMapper.selectByExample(example));}/*** Album分页查询* @param page* @param size* @return*/@Overridepublic PageInfo<Album> findPage(int page, int size){//静态分页PageHelper.startPage(page,size);//分页查询return new PageInfo<Album>(albumMapper.selectAll());}/*** Album条件查询* @param album* @return*/@Overridepublic List<Album> findList(Album album){//构建查询条件Example example = createExample(album);//根据构建的条件查询数据return albumMapper.selectByExample(example);}/*** Album构建查询对象* @param album* @return*/public Example createExample(Album album){Example example=new Example(Album.class);Example.Criteria criteria = example.createCriteria();if(album!=null){// 编号if(!StringUtils.isEmpty(album.getId())){criteria.andEqualTo("id",album.getId());}// 相册名称if(!StringUtils.isEmpty(album.getTitle())){criteria.andLike("title","%"+album.getTitle()+"%");}// 相册封面if(!StringUtils.isEmpty(album.getImage())){criteria.andEqualTo("image",album.getImage());}// 图片列表if(!StringUtils.isEmpty(album.getImageItems())){criteria.andEqualTo("imageItems",album.getImageItems());}}return example;}/*** 删除* @param id*/@Overridepublic void delete(Long id){albumMapper.deleteByPrimaryKey(id);}/*** 修改Album* @param album*/@Overridepublic void update(Album album){albumMapper.updateByPrimaryKey(album);}/*** 增加Album* @param album*/@Overridepublic void add(Album album){albumMapper.insert(album);}/*** 根据ID查询Album* @param id* @return*/@Overridepublic Album findById(Long id){return albumMapper.selectByPrimaryKey(id);}/*** 查询Album全部数据* @return*/@Overridepublic List<Album> findAll() {return albumMapper.selectAll();}}
2.3.4 控制层
在changgou-service-service工程中创建com.changgou.goods.controller.AlbumController,代码如下:
@RestController@RequestMapping("/album")@CrossOriginpublic class AlbumController {@Autowiredprivate AlbumService albumService;/**** Album分页条件搜索实现* @param album* @param page* @param size* @return*/@PostMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@RequestBody(required = false) Album album, @PathVariable int page, @PathVariable int size){//执行搜索PageInfo<Album> pageInfo = albumService.findPage(album, page, size);return new Result(true,StatusCode.OK,"查询成功",pageInfo);}/**** Album分页搜索实现* @param page:当前页* @param size:每页显示多少条* @return*/@GetMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@PathVariable int page, @PathVariable int size){//分页查询PageInfo<Album> pageInfo = albumService.findPage(page, size);return new Result<PageInfo>(true,StatusCode.OK,"查询成功",pageInfo);}/**** 多条件搜索品牌数据* @param album* @return*/@PostMapping(value = "/search" )public Result<List<Album>> findList(@RequestBody(required = false) Album album){List<Album> list = albumService.findList(album);return new Result<List<Album>>(true,StatusCode.OK,"查询成功",list);}/**** 根据ID删除品牌数据* @param id* @return*/@DeleteMapping(value = "/{id}" )public Result delete(@PathVariable Long id){albumService.delete(id);return new Result(true,StatusCode.OK,"删除成功");}/**** 修改Album数据* @param album* @param id* @return*/@PutMapping(value="/{id}")public Result update(@RequestBody Album album,@PathVariable Long id){//设置主键值album.setId(id);//修改数据albumService.update(album);return new Result(true,StatusCode.OK,"修改成功");}/**** 新增Album数据* @param album* @return*/@PostMappingpublic Result add(@RequestBody Album album){albumService.add(album);return new Result(true,StatusCode.OK,"添加成功");}/**** 根据ID查询Album数据* @param id* @return*/@GetMapping("/{id}")public Result<Album> findById(@PathVariable Long id){//根据ID查询Album album = albumService.findById(id);return new Result<Album>(true,StatusCode.OK,"查询成功",album);}/**** 查询Album全部数据* @return*/@GetMappingpublic Result<Album> findAll(){List<Album> list = albumService.findAll();return new Result<Album>(true, StatusCode.OK,"查询成功",list) ;}}
3 规格参数模板(实战)
3.1 需求分析
规格参数模板是用于管理规格参数的单元。规格是例如颜色、手机运行内存等信息,参数是例如系统:安卓(Android)后置摄像头像素:2000万及以上 热点:快速充电等信息 。
前端交互方式见管理后台的静态原型
3.2 表结构分析
规格参数模板相关的表有3个
tb_template 表(模板表)
| 字段名称 | 字段含义 | 字段类型 | 字段长度 | 备注 |
|---|---|---|---|---|
| id | ID | INT | ||
| name | 模板名称 | VARCHAR | ||
| spec_num | 规格数量 | INT | ||
| para_num | 参数数量 | INT |
tb_spec 表( 规格表)
| 字段名称 | 字段含义 | 字段类型 | 字段长度 | 备注 |
|---|---|---|---|---|
| id | ID | INT | ||
| name | 名称 | VARCHAR | ||
| options | 规格选项 | VARCHAR | ||
| seq | 排序 | INT | ||
| template_id | 模板ID | INT |
tb_para 表(参数表)
| 字段名称 | 字段含义 | 字段类型 | 字段长度 | 备注 |
|---|---|---|---|---|
| id | id | INT | ||
| name | 名称 | VARCHAR | ||
| options | 选项 | VARCHAR | ||
| seq | 排序 | INT | ||
| template_id | 模板ID | INT |
3.3 模板管理
3.3.1 Pojo
在changgou-service-goods-api工程中创建com.changgou.goods.pojo.Template,代码如下:
@Table(name="tb_template")public class Template implements Serializable{@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "id")private Integer id;//ID@Column(name = "name")private String name;//模板名称@Column(name = "spec_num")private Integer specNum;//规格数量@Column(name = "para_num")private Integer paraNum;//参数数量//..get..set..toString}
3.3.2 Dao
在changgou-service-goods中创建com.changgou.goods.dao.TemplateMapper,代码如下:
public interface TemplateMapper extends Mapper<Template> {}
3.3.3 业务层
(1)业务层接口
在changgou-service-goods中创建com.changgou.goods.service.TemplateService接口,并添加相关方法,代码如下:
public interface TemplateService {/**** Template多条件分页查询* @param template* @param page* @param size* @return*/PageInfo<Template> findPage(Template template, int page, int size);/**** Template分页查询* @param page* @param size* @return*/PageInfo<Template> findPage(int page, int size);/**** Template多条件搜索方法* @param template* @return*/List<Template> findList(Template template);/**** 删除Template* @param id*/void delete(Integer id);/**** 修改Template数据* @param template*/void update(Template template);/**** 新增Template* @param template*/void add(Template template);/*** 根据ID查询Template* @param id* @return*/Template findById(Integer id);/**** 查询所有Template* @return*/List<Template> findAll();}
(2)业务层接口实现类
在changgou-service-goods中创建com.changgou.goods.service.impl.TemplateServiceImpl实现类,并实现对应的方法,代码如下:
@Servicepublic class TemplateServiceImpl implements TemplateService {@Autowiredprivate TemplateMapper templateMapper;/*** Template条件+分页查询* @param template 查询条件* @param page 页码* @param size 页大小* @return 分页结果*/@Overridepublic PageInfo<Template> findPage(Template template, int page, int size){//分页PageHelper.startPage(page,size);//搜索条件构建Example example = createExample(template);//执行搜索return new PageInfo<Template>(templateMapper.selectByExample(example));}/*** Template分页查询* @param page* @param size* @return*/@Overridepublic PageInfo<Template> findPage(int page, int size){//静态分页PageHelper.startPage(page,size);//分页查询return new PageInfo<Template>(templateMapper.selectAll());}/*** Template条件查询* @param template* @return*/@Overridepublic List<Template> findList(Template template){//构建查询条件Example example = createExample(template);//根据构建的条件查询数据return templateMapper.selectByExample(example);}/*** Template构建查询对象* @param template* @return*/public Example createExample(Template template){Example example=new Example(Template.class);Example.Criteria criteria = example.createCriteria();if(template!=null){// IDif(!StringUtils.isEmpty(template.getId())){criteria.andEqualTo("id",template.getId());}// 模板名称if(!StringUtils.isEmpty(template.getName())){criteria.andLike("name","%"+template.getName()+"%");}// 规格数量if(!StringUtils.isEmpty(template.getSpecNum())){criteria.andEqualTo("specNum",template.getSpecNum());}// 参数数量if(!StringUtils.isEmpty(template.getParaNum())){criteria.andEqualTo("paraNum",template.getParaNum());}}return example;}/*** 删除* @param id*/@Overridepublic void delete(Integer id){templateMapper.deleteByPrimaryKey(id);}/*** 修改Template* @param template*/@Overridepublic void update(Template template){templateMapper.updateByPrimaryKey(template);}/*** 增加Template* @param template*/@Overridepublic void add(Template template){templateMapper.insert(template);}/*** 根据ID查询Template* @param id* @return*/@Overridepublic Template findById(Integer id){return templateMapper.selectByPrimaryKey(id);}/*** 查询Template全部数据* @return*/@Overridepublic List<Template> findAll() {return templateMapper.selectAll();}}
3.3.4 控制层
在changgou-service-goods中创建com.changgou.goods.controller.TemplateController,代码如下:
@RestController@RequestMapping("/template")@CrossOriginpublic class TemplateController {@Autowiredprivate TemplateService templateService;/**** Template分页条件搜索实现* @param template* @param page* @param size* @return*/@PostMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@RequestBody(required = false) Template template, @PathVariable int page, @PathVariable int size){//执行搜索PageInfo<Template> pageInfo = templateService.findPage(template, page, size);return new Result(true,StatusCode.OK,"查询成功",pageInfo);}/**** Template分页搜索实现* @param page:当前页* @param size:每页显示多少条* @return*/@GetMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@PathVariable int page, @PathVariable int size){//分页查询PageInfo<Template> pageInfo = templateService.findPage(page, size);return new Result<PageInfo>(true,StatusCode.OK,"查询成功",pageInfo);}/**** 多条件搜索品牌数据* @param template* @return*/@PostMapping(value = "/search" )public Result<List<Template>> findList(@RequestBody(required = false) Template template){List<Template> list = templateService.findList(template);return new Result<List<Template>>(true,StatusCode.OK,"查询成功",list);}/**** 根据ID删除品牌数据* @param id* @return*/@DeleteMapping(value = "/{id}" )public Result delete(@PathVariable Integer id){templateService.delete(id);return new Result(true,StatusCode.OK,"删除成功");}/**** 修改Template数据* @param template* @param id* @return*/@PutMapping(value="/{id}")public Result update(@RequestBody Template template,@PathVariable Integer id){//设置主键值template.setId(id);//修改数据templateService.update(template);return new Result(true,StatusCode.OK,"修改成功");}/**** 新增Template数据* @param template* @return*/@PostMappingpublic Result add(@RequestBody Template template){templateService.add(template);return new Result(true,StatusCode.OK,"添加成功");}/**** 根据ID查询Template数据* @param id* @return*/@GetMapping("/{id}")public Result<Template> findById(@PathVariable Integer id){//根据ID查询Template template = templateService.findById(id);return new Result<Template>(true,StatusCode.OK,"查询成功",template);}/**** 查询Template全部数据* @return*/@GetMappingpublic Result<Template> findAll(){List<Template> list = templateService.findAll();return new Result<Template>(true, StatusCode.OK,"查询成功",list) ;}}
3.4 规格管理
3.4.1 Pojo
在changgou-service-goods-api中创建com.changgou.goods.pojo.Spec,代码如下:
@Table(name="tb_spec")public class Spec implements Serializable{@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "id")private Integer id;//ID@Column(name = "name")private String name;//名称@Column(name = "options")private String options;//规格选项@Column(name = "seq")private Integer seq;//排序@Column(name = "template_id")private Integer templateId;//模板ID//get..set..toString}
3.4.2 Dao
在changgou-service-goods中创建com.changgou.goods.dao.SpecMapper,代码如下:
public interface SpecMapper extends Mapper<Spec> {}
3.4.3 业务层
(1)业务层接口
在changgou-service-goods中创建com.changgou.goods.service.SpecService接口,并实现对应的方法,代码如下:
public interface SpecService {/**** Spec多条件分页查询* @param spec* @param page* @param size* @return*/PageInfo<Spec> findPage(Spec spec, int page, int size);/**** Spec分页查询* @param page* @param size* @return*/PageInfo<Spec> findPage(int page, int size);/**** Spec多条件搜索方法* @param spec* @return*/List<Spec> findList(Spec spec);/**** 删除Spec* @param id*/void delete(Integer id);/**** 修改Spec数据* @param spec*/void update(Spec spec);/**** 新增Spec* @param spec*/void add(Spec spec);/*** 根据ID查询Spec* @param id* @return*/Spec findById(Integer id);/**** 查询所有Spec* @return*/List<Spec> findAll();}
(2)业务层实现类
在changgou-service-goods中创建com.changgou.goods.service.impl.SpecServiceImpl,代码如下:
@Servicepublic class SpecServiceImpl implements SpecService {@Autowiredprivate SpecMapper specMapper;@Autowiredprivate TemplateMapper templateMapper;/*** Spec条件+分页查询* @param spec 查询条件* @param page 页码* @param size 页大小* @return 分页结果*/@Overridepublic PageInfo<Spec> findPage(Spec spec, int page, int size){//分页PageHelper.startPage(page,size);//搜索条件构建Example example = createExample(spec);//执行搜索return new PageInfo<Spec>(specMapper.selectByExample(example));}/*** Spec分页查询* @param page* @param size* @return*/@Overridepublic PageInfo<Spec> findPage(int page, int size){//静态分页PageHelper.startPage(page,size);//分页查询return new PageInfo<Spec>(specMapper.selectAll());}/*** Spec条件查询* @param spec* @return*/@Overridepublic List<Spec> findList(Spec spec){//构建查询条件Example example = createExample(spec);//根据构建的条件查询数据return specMapper.selectByExample(example);}/*** Spec构建查询对象* @param spec* @return*/public Example createExample(Spec spec){Example example=new Example(Spec.class);Example.Criteria criteria = example.createCriteria();if(spec!=null){// IDif(!StringUtils.isEmpty(spec.getId())){criteria.andEqualTo("id",spec.getId());}// 名称if(!StringUtils.isEmpty(spec.getName())){criteria.andLike("name","%"+spec.getName()+"%");}// 规格选项if(!StringUtils.isEmpty(spec.getOptions())){criteria.andEqualTo("options",spec.getOptions());}// 排序if(!StringUtils.isEmpty(spec.getSeq())){criteria.andEqualTo("seq",spec.getSeq());}// 模板IDif(!StringUtils.isEmpty(spec.getTemplateId())){criteria.andEqualTo("templateId",spec.getTemplateId());}}return example;}/*** 删除* @param id*/@Overridepublic void delete(Integer id){//查询模板Spec spec = specMapper.selectByPrimaryKey(id);//变更模板数量updateSpecNum(spec,-1);//删除指定规格specMapper.deleteByPrimaryKey(id);}/*** 修改Spec* @param spec*/@Overridepublic void update(Spec spec){specMapper.updateByPrimaryKey(spec);}/*** 增加Spec* @param spec*/@Overridepublic void add(Spec spec){specMapper.insert(spec);//变更模板数量updateSpecNum(spec,1);}/*** 根据ID查询Spec* @param id* @return*/@Overridepublic Spec findById(Integer id){return specMapper.selectByPrimaryKey(id);}/*** 查询Spec全部数据* @return*/@Overridepublic List<Spec> findAll() {return specMapper.selectAll();}/*** 修改模板统计数据* @param spec:操作的模板* @param count:变更的数量*/public void updateSpecNum(Spec spec,int count){//修改模板数量统计Template template = templateMapper.selectByPrimaryKey(spec.getTemplateId());template.setSpecNum(template.getSpecNum()+count);templateMapper.updateByPrimaryKeySelective(template);}}
这里注意,每次执行增加和删除的时候,需要调用模板,修改统计数据,另外大家思考下,如果是修改呢,是否会对模板统计数据造成变更呢?
3.4.4 控制层
在changgou-service-goods中创建com.changgou.goods.controller.SpecController,代码如下:
@RestController@RequestMapping("/spec")@CrossOriginpublic class SpecController {@Autowiredprivate SpecService specService;/**** Spec分页条件搜索实现* @param spec* @param page* @param size* @return*/@PostMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@RequestBody(required = false) Spec spec, @PathVariable int page, @PathVariable int size){//执行搜索PageInfo<Spec> pageInfo = specService.findPage(spec, page, size);return new Result(true,StatusCode.OK,"查询成功",pageInfo);}/**** Spec分页搜索实现* @param page:当前页* @param size:每页显示多少条* @return*/@GetMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@PathVariable int page, @PathVariable int size){//分页查询PageInfo<Spec> pageInfo = specService.findPage(page, size);return new Result<PageInfo>(true,StatusCode.OK,"查询成功",pageInfo);}/**** 多条件搜索品牌数据* @param spec* @return*/@PostMapping(value = "/search" )public Result<List<Spec>> findList(@RequestBody(required = false) Spec spec){List<Spec> list = specService.findList(spec);return new Result<List<Spec>>(true,StatusCode.OK,"查询成功",list);}/**** 根据ID删除品牌数据* @param id* @return*/@DeleteMapping(value = "/{id}" )public Result delete(@PathVariable Integer id){specService.delete(id);return new Result(true,StatusCode.OK,"删除成功");}/**** 修改Spec数据* @param spec* @param id* @return*/@PutMapping(value="/{id}")public Result update(@RequestBody Spec spec,@PathVariable Integer id){//设置主键值spec.setId(id);//修改数据specService.update(spec);return new Result(true,StatusCode.OK,"修改成功");}/**** 新增Spec数据* @param spec* @return*/@PostMappingpublic Result add(@RequestBody Spec spec){specService.add(spec);return new Result(true,StatusCode.OK,"添加成功");}/**** 根据ID查询Spec数据* @param id* @return*/@GetMapping("/{id}")public Result<Spec> findById(@PathVariable Integer id){//根据ID查询Spec spec = specService.findById(id);return new Result<Spec>(true,StatusCode.OK,"查询成功",spec);}/**** 查询Spec全部数据* @return*/@GetMappingpublic Result<Spec> findAll(){List<Spec> list = specService.findAll();return new Result<Spec>(true, StatusCode.OK,"查询成功",list) ;}}
3.5 参数管理
3.5.1 Pojo
在changgou-service-goods-api中创建com.changgou.goods.pojo.Para,代码如下:
@Table(name="tb_para")public class Para implements Serializable{@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "id")private Integer id;//id@Column(name = "name")private String name;//名称@Column(name = "options")private String options;//选项@Column(name = "seq")private Integer seq;//排序@Column(name = "template_id")private Integer templateId;//模板ID//get..set..toString}
3.5.2 Dao
在changgou-service-goods中创建com.changgou.goods.dao.ParaMapper,代码如下:
public interface ParaMapper extends Mapper<Para> {}
3.5.3 业务层
(1)业务层接口
在changgou-service-goods中创建com.changgou.goods.service.ParaService接口,并添加常用方法,代码如下:
public interface ParaService {/**** Para多条件分页查询* @param para* @param page* @param size* @return*/PageInfo<Para> findPage(Para para, int page, int size);/**** Para分页查询* @param page* @param size* @return*/PageInfo<Para> findPage(int page, int size);/**** Para多条件搜索方法* @param para* @return*/List<Para> findList(Para para);/**** 删除Para* @param id*/void delete(Integer id);/**** 修改Para数据* @param para*/void update(Para para);/**** 新增Para* @param para*/void add(Para para);/*** 根据ID查询Para* @param id* @return*/Para findById(Integer id);/**** 查询所有Para* @return*/List<Para> findAll();}
(2)业务层接口实现类
在changgou-service-goods中创建com.changgou.goods.service.impl.ParaServiceImpl接口实现类,代码如下:
@Servicepublic class ParaServiceImpl implements ParaService {@Autowiredprivate ParaMapper paraMapper;@Autowiredprivate TemplateMapper templateMapper;/*** Para条件+分页查询* @param para 查询条件* @param page 页码* @param size 页大小* @return 分页结果*/@Overridepublic PageInfo<Para> findPage(Para para, int page, int size){//分页PageHelper.startPage(page,size);//搜索条件构建Example example = createExample(para);//执行搜索return new PageInfo<Para>(paraMapper.selectByExample(example));}/*** Para分页查询* @param page* @param size* @return*/@Overridepublic PageInfo<Para> findPage(int page, int size){//静态分页PageHelper.startPage(page,size);//分页查询return new PageInfo<Para>(paraMapper.selectAll());}/*** Para条件查询* @param para* @return*/@Overridepublic List<Para> findList(Para para){//构建查询条件Example example = createExample(para);//根据构建的条件查询数据return paraMapper.selectByExample(example);}/*** Para构建查询对象* @param para* @return*/public Example createExample(Para para){Example example=new Example(Para.class);Example.Criteria criteria = example.createCriteria();if(para!=null){// idif(!StringUtils.isEmpty(para.getId())){criteria.andEqualTo("id",para.getId());}// 名称if(!StringUtils.isEmpty(para.getName())){criteria.andLike("name","%"+para.getName()+"%");}// 选项if(!StringUtils.isEmpty(para.getOptions())){criteria.andEqualTo("options",para.getOptions());}// 排序if(!StringUtils.isEmpty(para.getSeq())){criteria.andEqualTo("seq",para.getSeq());}// 模板IDif(!StringUtils.isEmpty(para.getTemplateId())){criteria.andEqualTo("templateId",para.getTemplateId());}}return example;}/*** 删除* @param id*/@Overridepublic void delete(Integer id){//根据ID查询Para para = paraMapper.selectByPrimaryKey(id);//修改模板统计数据updateParaNum(para,-1);paraMapper.deleteByPrimaryKey(id);}/*** 修改Para* @param para*/@Overridepublic void update(Para para){paraMapper.updateByPrimaryKey(para);}/*** 增加Para* @param para*/@Overridepublic void add(Para para){paraMapper.insert(para);//修改模板统计数据updateParaNum(para,1);}/*** 根据ID查询Para* @param id* @return*/@Overridepublic Para findById(Integer id){return paraMapper.selectByPrimaryKey(id);}/*** 查询Para全部数据* @return*/@Overridepublic List<Para> findAll() {return paraMapper.selectAll();}/*** 修改模板统计数据* @param para:操作的参数* @param count:变更的数量*/public void updateParaNum(Para para, int count){//修改模板数量统计Template template = templateMapper.selectByPrimaryKey(para.getTemplateId());template.setParaNum(template.getParaNum()+count);templateMapper.updateByPrimaryKeySelective(template);}}
3.5.4 控制层
在changgou-service-goods下创建com.changgou.goods.controller.ParaController,代码如下:
@RestController@RequestMapping("/para")@CrossOriginpublic class ParaController {@Autowiredprivate ParaService paraService;/**** Para分页条件搜索实现* @param para* @param page* @param size* @return*/@PostMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@RequestBody(required = false) Para para, @PathVariable int page, @PathVariable int size){//执行搜索PageInfo<Para> pageInfo = paraService.findPage(para, page, size);return new Result(true,StatusCode.OK,"查询成功",pageInfo);}/**** Para分页搜索实现* @param page:当前页* @param size:每页显示多少条* @return*/@GetMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@PathVariable int page, @PathVariable int size){//分页查询PageInfo<Para> pageInfo = paraService.findPage(page, size);return new Result<PageInfo>(true,StatusCode.OK,"查询成功",pageInfo);}/**** 多条件搜索品牌数据* @param para* @return*/@PostMapping(value = "/search" )public Result<List<Para>> findList(@RequestBody(required = false) Para para){List<Para> list = paraService.findList(para);return new Result<List<Para>>(true,StatusCode.OK,"查询成功",list);}/**** 根据ID删除品牌数据* @param id* @return*/@DeleteMapping(value = "/{id}" )public Result delete(@PathVariable Integer id){paraService.delete(id);return new Result(true,StatusCode.OK,"删除成功");}/**** 修改Para数据* @param para* @param id* @return*/@PutMapping(value="/{id}")public Result update(@RequestBody Para para,@PathVariable Integer id){//设置主键值para.setId(id);//修改数据paraService.update(para);return new Result(true,StatusCode.OK,"修改成功");}/**** 新增Para数据* @param para* @return*/@PostMappingpublic Result add(@RequestBody Para para){paraService.add(para);return new Result(true,StatusCode.OK,"添加成功");}/**** 根据ID查询Para数据* @param id* @return*/@GetMapping("/{id}")public Result<Para> findById(@PathVariable Integer id){//根据ID查询Para para = paraService.findById(id);return new Result<Para>(true,StatusCode.OK,"查询成功",para);}/**** 查询Para全部数据* @return*/@GetMappingpublic Result<Para> findAll(){List<Para> list = paraService.findAll();return new Result<Para>(true, StatusCode.OK,"查询成功",list) ;}}
4 商品分类(实战)
4.1 需求分析
商品分类一共分三级管理,主要作用是在网站首页中显示商品导航,以及在管理后台管理商品时使用。
前端交互方式见管理后台的静态原型
4.2 表结构分析
tb_category 表 (商品分类)
| 字段名称 | 字段含义 | 字段类型 | 字段长度 | 备注 |
|---|---|---|---|---|
| id | 分类ID | INT | ||
| name | 分类名称 | VARCHAR | ||
| goods_num | 商品数量 | INT | ||
| is_show | 是否显示 | CHAR | 0 不显示 1显示 | |
| is_menu | 是否导航 | CHAR | 0 不时导航 1 为导航 | |
| seq | 排序 | INT | ||
| parent_id | 上级ID | INT | ||
| template_id | 模板ID | INT |
4.3 实现
4.3.1 Pojo
在changgou-service-goods-api中创建com.changgou.goods.pojo.Category,代码如下:
@Table(name="tb_category")public class Category implements Serializable{@Id@GeneratedValue(strategy = GenerationType.IDENTITY)@Column(name = "id")private Integer id;//分类ID@Column(name = "name")private String name;//分类名称@Column(name = "goods_num")private Integer goodsNum;//商品数量@Column(name = "is_show")private String isShow;//是否显示@Column(name = "is_menu")private String isMenu;//是否导航@Column(name = "seq")private Integer seq;//排序@Column(name = "parent_id")private Integer parentId;//上级ID@Column(name = "template_id")private Integer templateId;//模板ID//..set..get..toString}
4.3.2 Dao
在changgou-servicegoods中创建com.changgou.goods.dao.CategoryMapper接口,代码如下:
public interface CategoryMapper extends Mapper<Category> {}
4.3.3 业务层
(1)业务层接口
修改changgou-service-goods,添加com.changgou.goods.service.CategoryService接口,代码如下:
public interface CategoryService {/**** Category多条件分页查询* @param category* @param page* @param size* @return*/PageInfo<Category> findPage(Category category, int page, int size);/**** Category分页查询* @param page* @param size* @return*/PageInfo<Category> findPage(int page, int size);/**** Category多条件搜索方法* @param category* @return*/List<Category> findList(Category category);/**** 删除Category* @param id*/void delete(Integer id);/**** 修改Category数据* @param category*/void update(Category category);/**** 新增Category* @param category*/void add(Category category);/*** 根据ID查询Category* @param id* @return*/Category findById(Integer id);/**** 查询所有Category* @return*/List<Category> findAll();/**** 根据父节点ID查询* @param pid:父节点ID*/List<Category> findByParentId(Integer pid);}
(2)业务层接口实现类
修改changgou-service-goods,添加com.changgou.goods.service.impl.CategoryServiceImpl接口实现类,代码如下:
@Servicepublic class CategoryServiceImpl implements CategoryService {@Autowiredprivate CategoryMapper categoryMapper;/*** Category条件+分页查询* @param category 查询条件* @param page 页码* @param size 页大小* @return 分页结果*/@Overridepublic PageInfo<Category> findPage(Category category, int page, int size){//分页PageHelper.startPage(page,size);//搜索条件构建Example example = createExample(category);//执行搜索return new PageInfo<Category>(categoryMapper.selectByExample(example));}/*** Category分页查询* @param page* @param size* @return*/@Overridepublic PageInfo<Category> findPage(int page, int size){//静态分页PageHelper.startPage(page,size);//分页查询return new PageInfo<Category>(categoryMapper.selectAll());}/*** Category条件查询* @param category* @return*/@Overridepublic List<Category> findList(Category category){//构建查询条件Example example = createExample(category);//根据构建的条件查询数据return categoryMapper.selectByExample(example);}/*** Category构建查询对象* @param category* @return*/public Example createExample(Category category){Example example=new Example(Category.class);Example.Criteria criteria = example.createCriteria();if(category!=null){// 分类IDif(!StringUtils.isEmpty(category.getId())){criteria.andEqualTo("id",category.getId());}// 分类名称if(!StringUtils.isEmpty(category.getName())){criteria.andLike("name","%"+category.getName()+"%");}// 商品数量if(!StringUtils.isEmpty(category.getGoodsNum())){criteria.andEqualTo("goodsNum",category.getGoodsNum());}// 是否显示if(!StringUtils.isEmpty(category.getIsShow())){criteria.andEqualTo("isShow",category.getIsShow());}// 是否导航if(!StringUtils.isEmpty(category.getIsMenu())){criteria.andEqualTo("isMenu",category.getIsMenu());}// 排序if(!StringUtils.isEmpty(category.getSeq())){criteria.andEqualTo("seq",category.getSeq());}// 上级IDif(!StringUtils.isEmpty(category.getParentId())){criteria.andEqualTo("parentId",category.getParentId());}// 模板IDif(!StringUtils.isEmpty(category.getTemplateId())){criteria.andEqualTo("templateId",category.getTemplateId());}}return example;}/*** 删除* @param id*/@Overridepublic void delete(Integer id){categoryMapper.deleteByPrimaryKey(id);}/*** 修改Category* @param category*/@Overridepublic void update(Category category){categoryMapper.updateByPrimaryKey(category);}/*** 增加Category* @param category*/@Overridepublic void add(Category category){categoryMapper.insert(category);}/*** 根据ID查询Category* @param id* @return*/@Overridepublic Category findById(Integer id){return categoryMapper.selectByPrimaryKey(id);}/*** 查询Category全部数据* @return*/@Overridepublic List<Category> findAll() {return categoryMapper.selectAll();}/**** 根据父节点ID查询* @param pid:父节点ID*/@Overridepublic List<Category> findByParentId(Integer pid) {Category category = new Category();category.setParentId(pid);return categoryMapper.select(category);}}
4.3.4 控制层
修改changgou-service-goods,添加com.changgou.goods.controller.CategoryController,代码如下:
@RestController@RequestMapping("/category")@CrossOriginpublic class CategoryController {@Autowiredprivate CategoryService categoryService;/**** Category分页条件搜索实现* @param category* @param page* @param size* @return*/@PostMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@RequestBody(required = false) Category category, @PathVariable int page, @PathVariable int size){//执行搜索PageInfo<Category> pageInfo = categoryService.findPage(category, page, size);return new Result(true,StatusCode.OK,"查询成功",pageInfo);}/**** Category分页搜索实现* @param page:当前页* @param size:每页显示多少条* @return*/@GetMapping(value = "/search/{page}/{size}" )public Result<PageInfo> findPage(@PathVariable int page, @PathVariable int size){//分页查询PageInfo<Category> pageInfo = categoryService.findPage(page, size);return new Result<PageInfo>(true,StatusCode.OK,"查询成功",pageInfo);}/**** 多条件搜索品牌数据* @param category* @return*/@PostMapping(value = "/search" )public Result<List<Category>> findList(@RequestBody(required = false) Category category){List<Category> list = categoryService.findList(category);return new Result<List<Category>>(true,StatusCode.OK,"查询成功",list);}/**** 根据ID删除品牌数据* @param id* @return*/@DeleteMapping(value = "/{id}" )public Result delete(@PathVariable Integer id){categoryService.delete(id);return new Result(true,StatusCode.OK,"删除成功");}/**** 修改Category数据* @param category* @param id* @return*/@PutMapping(value="/{id}")public Result update(@RequestBody Category category,@PathVariable Integer id){//设置主键值category.setId(id);//修改数据categoryService.update(category);return new Result(true,StatusCode.OK,"修改成功");}/**** 新增Category数据* @param category* @return*/@PostMappingpublic Result add(@RequestBody Category category){categoryService.add(category);return new Result(true,StatusCode.OK,"添加成功");}/**** 根据ID查询Category数据* @param id* @return*/@GetMapping("/{id}")public Result<Category> findById(@PathVariable Integer id){//根据ID查询Category category = categoryService.findById(id);return new Result<Category>(true,StatusCode.OK,"查询成功",category);}/**** 查询Category全部数据* @return*/@GetMappingpublic Result<Category> findAll(){List<Category> list = categoryService.findAll();return new Result<Category>(true, StatusCode.OK,"查询成功",list) ;}/*** 根据父ID查询*/@RequestMapping(value ="/list/{pid}")public Result<Category> findByPrantId(@PathVariable(value = "pid")Integer pid){//根据父节点ID查询List<Category> list = categoryService.findByParentId(pid);return new Result<Category>(true,StatusCode.OK,"查询成功",list);}}
5 抽取service和controller
经过上边的实战。我们发现大量的重复劳动发生了。所以能否有一个思想能解决以上的问题呢,这个思想就是:
程序员只需要继承或者实现某一个抽象类或者接口就可以直接使用所有的CRUD方法,就好比我们使用过的通用的MAPPER和通用的spring data jpa一样呢?
答案当然是肯定可以滴,接下来我们来解决下。
思路如下:
解释:
编写接口和抽象类--- 接口定义操作行为和方法--- 抽象类提供具体操作行为和方法 与此同时通过泛型来实现操作的具体对象 由子类提供编写子类实现类 继承抽象类--- 子类具体实现 向上调用super方法进行赋值,给予抽象类的具体操作类型即可以上图 指定的是service的操作方式。与此同时controller的操作方式也是类似
5.1 抽取service
(1)创建changgou-core工程打包方式为pom
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><parent><artifactId>changgou-parent</artifactId><groupId>com.changgou</groupId><version>1.0-SNAPSHOT</version></parent><modelVersion>4.0.0</modelVersion><artifactId>changgou-core</artifactId><description>核心工程</description><modules><module>changgou-core-service</module><module>changgou-core-controller</module></modules><packaging>pom</packaging></project>
(2)创建changgou-core-service 打包方式为jar
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><parent><artifactId>changgou-core</artifactId><groupId>com.changgou</groupId><version>1.0-SNAPSHOT</version></parent><modelVersion>4.0.0</modelVersion><artifactId>changgou-core-service</artifactId><dependencies><dependency><groupId>com.changgou</groupId><artifactId>changgou-common-db</artifactId><version>1.0-SNAPSHOT</version></dependency></dependencies></project>
(3)创建changgou-core-controller工程
<?xml version="1.0" encoding="UTF-8"?><project xmlns="http://maven.apache.org/POM/4.0.0"xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"><parent><artifactId>changgou-core</artifactId><groupId>com.changgou</groupId><version>1.0-SNAPSHOT</version></parent><modelVersion>4.0.0</modelVersion><artifactId>changgou-core-controller</artifactId><dependencies><dependency><groupId>com.changgou</groupId><artifactId>changgou-core-service</artifactId><version>1.0-SNAPSHOT</version></dependency></dependencies></project>
(4)定义接口和抽象类
具体代码参考项目资料:
(5)测试service:
changgou-service-goods工程中添加依赖:
<dependency><groupId>com.changgou</groupId><artifactId>changgou-core-service</artifactId><version>1.0-SNAPSHOT</version></dependency>
修改service接口,添加继承
public interface BrandService extends CoreService<Brand>{}
修改实现类 添加构造方法提交
@Servicepublic class BrandServiceImpl extends CoreServiceImpl<Brand> implements BrandService {private BrandMapper brandMapper;// 此处的@Autowired注解,表示参数brandMapper从bean中获取@Autowiredpublic BrandServiceImpl(BrandMapper brandMapper) {super(brandMapper, Brand.class);this.brandMapper = brandMapper;}}
测试:
@SpringBootTest@RunWith(SpringRunner.class)public class GoodsApplicationTest {@Autowiredprivate BrandService brandService;@Testpublic void findAll() {List<Brand> brandList = brandService.selectAll();for (Brand brand : brandList) {System.out.println(">>>>>>>" + brand.getName());}}@Testpublic void findAllByCondition() {Brand brand = new Brand();brand.setId(1);brand.setName("华");PageInfo<Brand> byPage = brandService.findByPage(1, 2, brand);List<Brand> list = byPage.getList();for (Brand brand111 : list) {System.out.println(">>>>>>>>>>>>>>>>>>>>>:" + brand111.getName());}}}
此时没有任何的CRUD的代码存在,即可实现基本的CRUD的功能了。
5.2 抽取controller
思路:
操作步骤:
(1)创建工程core-controller并创建接口和抽象类
代码具体参考资料:
(2)测试controller
changgou-service-goods中添加依赖:
<dependency><groupId>com.changgou</groupId><artifactId>changgou-core-controller</artifactId><version>1.0-SNAPSHOT</version></dependency>
修改BrandController:
@RestController@RequestMapping("/brand")@CrossOriginpublic class BrandController extends AbstractCoreController<Brand> {private BrandService brandService;@Autowiredpublic BrandController(BrandService brandService) {super(brandService, Brand.class);this.brandService = brandService;}}
测试CRUD功能:
