springboot中的桥接模式+装饰器模式

JdbcTemplate源码介绍

桥接模式就是把一个大类拆分成多个小类,不需要过多层次的继承

在使用对象的时候,传入数据源接口

 在数据源接口可以看到,有不同的数据源实现类,只需要在jdbcTemplate传入不同的实现类

就可以操作对应数据源的功能,执行增删改查

在每个数据源内部都会自己去连接数据库,使用的时候 不需要关心你内部到底是怎么实现的

我们在使用easyexcel的时候,在监听器中不能使用@Autowired 这样注入 会是null

需要通过构造注入的方式传进来,但是每一个导入模版都需要一个监听类,太过麻烦了

那么我们使用桥接模式来改造下

项目使用springcloud alibaba

引入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 https://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>

    <groupId>com.example</groupId>
    <artifactId>demo</artifactId>
    <version>0.0.1-SNAPSHOT</version>
    <name>demo</name>
    <description>Demo project for Spring Boot</description>
    <properties>
        <java.version>1.8</java.version>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>
        <spring-boot.version>2.3.7.RELEASE</spring-boot.version>
        <spring-cloud-alibaba.version>2.2.2.RELEASE</spring-cloud-alibaba.version>
    </properties>

    <dependencies>
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter</artifactId>
        </dependency>
        <!--这个web包一定要有,否则项目启动不起来-->
        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-web</artifactId>
        </dependency>
        <dependency>
            <groupId>com.alibaba.cloud</groupId>
            <artifactId>spring-cloud-starter-alibaba-nacos-discovery</artifactId>
        </dependency>

        <dependency>
            <groupId>org.springframework.boot</groupId>
            <artifactId>spring-boot-starter-test</artifactId>
            <scope>test</scope>
            <exclusions>
                <exclusion>
                    <groupId>org.junit.vintage</groupId>
                    <artifactId>junit-vintage-engine</artifactId>
                </exclusion>
            </exclusions>
        </dependency>



        <!-- 添加MyBatisPlus的依赖 -->
        <dependency>
            <groupId>com.baomidou</groupId>
            <artifactId>mybatis-plus-boot-starter</artifactId>
            <version>3.5.1</version>
        </dependency>
        <!-- MySQL数据 -->
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.16</version>
        </dependency>
        <!-- druid  连接池-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>1.1.14</version>
        </dependency>
        <dependency>
            <groupId>org.projectlombok</groupId>
            <artifactId>lombok</artifactId>
            <optional>true</optional>
        </dependency>


        <!--引入easyexcel-->
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>easyexcel</artifactId>
            <version>3.1.0</version>
        </dependency>
        <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>fastjson</artifactId>
            <version>1.2.47</version>
        </dependency>

    </dependencies>

    <dependencyManagement>
        <dependencies>
            <dependency>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-dependencies</artifactId>
                <version>${spring-boot.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
            <dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-alibaba-dependencies</artifactId>
                <version>${spring-cloud-alibaba.version}</version>
                <type>pom</type>
                <scope>import</scope>
            </dependency>
        </dependencies>
    </dependencyManagement>

    <build>
        <plugins>
            <plugin>
                <groupId>org.apache.maven.plugins</groupId>
                <artifactId>maven-compiler-plugin</artifactId>
                <version>3.8.1</version>
                <configuration>
                    <source>1.8</source>
                    <target>1.8</target>
                    <encoding>UTF-8</encoding>
                </configuration>
            </plugin>
            <plugin>
                <groupId>org.springframework.boot</groupId>
                <artifactId>spring-boot-maven-plugin</artifactId>
                <version>2.3.7.RELEASE</version>
                <configuration>
                    <mainClass>com.example.demo.DemoApplication</mainClass>
                </configuration>
                <executions>
                    <execution>
                        <id>repackage</id>
                        <goals>
                            <goal>repackage</goal>
                        </goals>
                    </execution>
                </executions>
            </plugin>
        </plugins>
    </build>

</project>

配置application.properties

# 应用名称
spring.application.name=kucun

server.port=8089

# Nacos认证信息
spring.cloud.nacos.discovery.username=nacos
spring.cloud.nacos.discovery.password=nacos
# Nacos 服务发现与注册配置,其中子属性 server-addr 指定 Nacos 服务器主机和端口
spring.cloud.nacos.discovery.server-addr=localhost:8848
# 注册到 nacos 的指定 namespace,默认为 public
spring.cloud.nacos.discovery.namespace=public



spring.datasource.driverClassName=com.mysql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://localhost:3306/dmg?serverTimezone=Asia/Shanghai&useUnicode=true&characterEncoding=utf-8&useSSL=true
spring.datasource.username=root
spring.datasource.password=root
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource


mybatis-plus.mapper-locations=classpath:mappers/*.xml
# 控制台打印sql语句
mybatis-plus.configuration.log-impl=org.apache.ibatis.logging.stdout.StdOutImpl

创建表结构

CREATE TABLE `chu_chai` (
  `id` bigint NOT NULL AUTO_INCREMENT,
  `cc_name` varchar(50) DEFAULT NULL COMMENT '出差名称',
  `cc_day` int DEFAULT NULL COMMENT '出差天数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

CREATE TABLE `qingjia` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(50) DEFAULT NULL COMMENT '请假名称',
  `day` int DEFAULT NULL COMMENT '请假天数',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=18 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='请假表';

实体类

package com.example.demo.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import lombok.Data;

@Data
public class CcData {

    @ExcelProperty("出差名称")
    private String ccName;

    @ExcelProperty("出差天数")
    private Integer ccDay;

    
}
package com.example.demo.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;

@Data
@TableName("chu_chai")
public class ChuChai {

    //主键
    @TableId(type = IdType.AUTO)
    private Long id;

    //出差名称
    private String ccName;

    //出差天数
    private Integer ccDay;

}
package com.example.demo.entity;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import lombok.Data;
@TableName("qingjia")
@Data
public class QingJia {

    //主键
    @TableId(type = IdType.AUTO)
    private Long id;

    //请假名称
    private String name;

    //请假天数
    private Integer day;


}
package com.example.demo.entity;

import com.alibaba.excel.annotation.ExcelProperty;
import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableId;
import lombok.Data;

@Data
public class QjData {

    @ExcelProperty("请假名称")
    private String name;

    @ExcelProperty("请假天数")
    private Integer day;


}

dao层

package com.example.demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.entity.ChuChai;

public interface ChuChaiDao extends BaseMapper<ChuChai> {

}
package com.example.demo.dao;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.example.demo.entity.QingJia;

public interface QingJiaDao extends BaseMapper<QingJia> {

}

接口层

CommonService是公共的上传接口,其他实现类实现这个接口,在传入监听器类的时候,传入对应的实现类就可以了

package com.example.demo.service;

import java.util.List;

public interface CommonService {

    /**
     *
     * 添加
     * @param
     * @return
     * @throws Exception
     */
    public void add(List<Object> list);
}
package com.example.demo.service.impl;

import com.example.demo.dao.ChuChaiDao;
import com.example.demo.dao.QingJiaDao;
import com.example.demo.entity.CcData;
import com.example.demo.entity.ChuChai;
import com.example.demo.entity.QingJia;
import com.example.demo.service.CommonService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class CcServiceImpl implements CommonService {

    @Autowired
    private ChuChaiDao chuChaiDao;

    @Override
    public void add(List<Object> list) {
        for (int i = 0; i < list.size(); i++) {
            //解析对象
            CcData data=(CcData) list.get(i);
            //转换成操作数据库实体
            ChuChai chuChai=new ChuChai();
            BeanUtils.copyProperties(data,chuChai);
            // todo 你们可以写成批量的接口,我这里只是模拟下数据
            chuChaiDao.insert(chuChai);
        }
    }
}
package com.example.demo.service.impl;

import com.example.demo.dao.QingJiaDao;
import com.example.demo.entity.CcData;
import com.example.demo.entity.ChuChai;
import com.example.demo.entity.QingJia;
import com.example.demo.entity.QjData;
import com.example.demo.service.CommonService;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.beans.factory.config.ConfigurableBeanFactory;
import org.springframework.stereotype.Service;

import java.util.List;

@Service
public class QjServiceImpl implements CommonService {

    @Autowired
    private QingJiaDao qingJiaDao;

    @Override
    public void add(List<Object> list) {
        for (int i = 0; i < list.size(); i++) {
            //解析对象
            QjData data=(QjData) list.get(i);
            //转换成操作数据库实体
            QingJia qj=new QingJia();
            BeanUtils.copyProperties(data,qj);
            // todo 你们可以写成批量的接口,我这里只是模拟下数据
            qingJiaDao.insert(qj);
        }
    }
}

公共的导入监听器

package com.example.demo.listener;

import com.alibaba.excel.context.AnalysisContext;
import com.alibaba.excel.event.AnalysisEventListener;
import com.alibaba.excel.util.ListUtils;
import com.alibaba.fastjson.JSON;
import com.example.demo.service.CommonService;
import lombok.extern.slf4j.Slf4j;
import org.springframework.beans.factory.annotation.Autowired;

import java.util.ArrayList;
import java.util.List;
import java.util.Map;

/**
 *
 * 公共的excel导入监听器
 * @param
 * @return
 * @throws Exception
 */
@Slf4j
public class CommonListener extends AnalysisEventListener<Object> {

    private List<Object> list = new ArrayList<>();

    /**
     *
     * 在监听器中不能使用@Autowired 这样注入 会是null
       所以我们这里通过构造注入的方式传进来
     * @param
     * @return
     * @throws Exception
     */
    private CommonService commonService;

    public CommonListener(CommonService commonService){
        this.commonService=commonService;
    }

    @Override
    public void invoke(Object data, AnalysisContext context) {
        log.info("解析到一条数据:{}", data);
        list.add(data);
    }

    @Override
    public void doAfterAllAnalysed(AnalysisContext context) {
        saveData();
        log.info("所有数据解析完成!");
    }

    /**
     * 加上存储数据库
     */
    private void saveData() {
        log.info("{}条数据,开始存储数据库!", list.size());
        //调用公共的添加接口
        commonService.add(list);
        log.info("存储数据库成功!");
    }
}

请假控制层

往监听器类传参只需要传入对应的接口就行

package com.example.demo.controller;

import com.alibaba.excel.EasyExcel;
import com.example.demo.entity.QjData;
import com.example.demo.listener.CommonListener;
import com.example.demo.service.impl.QjServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.*;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;

@RestController
public class QingJiaController {

    @Autowired
    private QjServiceImpl qjService;

    @PostMapping("qj/upload")
    @ResponseBody
    public String upload(MultipartFile file) throws IOException {
        EasyExcel.read(file.getInputStream(), QjData.class,
                new CommonListener(qjService)).sheet().doRead();
        return "success";
    }
}

出差控制层

往监听器类传参只需要传入对应的接口就行

package com.example.demo.controller;

import com.alibaba.excel.EasyExcel;
import com.example.demo.entity.CcData;
import com.example.demo.entity.QjData;
import com.example.demo.listener.CommonListener;
import com.example.demo.service.impl.CcServiceImpl;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.web.bind.annotation.GetMapping;
import org.springframework.web.bind.annotation.PostMapping;
import org.springframework.web.bind.annotation.ResponseBody;
import org.springframework.web.bind.annotation.RestController;
import org.springframework.web.multipart.MultipartFile;

import java.io.IOException;

@RestController
public class CcController {

    @Autowired
    private CcServiceImpl ccService;

    @PostMapping("cc/upload")
    @ResponseBody
    public String upload(MultipartFile file) throws IOException {
        EasyExcel.read(file.getInputStream(), CcData.class,
                new CommonListener(ccService)).sheet().doRead();
        return "success";
    }
}

创建一些模拟数据

 

调用接口进行测试 

 可以看到数据已经落入到数据库中了

装饰器模式就是不改变原有的的结构,使用类包裹着这个接口,对齐进行增强

我们使用的new CommonListener就是装饰器模式,包裹着(接口)

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值