【项目】基于SaaS的餐掌柜项目实战阶段一基于SaaS的餐掌柜项目实战第1章基础架构搭建 4 核心代码 4.1 SpringCloud Alibaba+dubbo+Mybatis-plus整合

快来打我* 2024-03-23 14:31 2阅读 0赞

### 【项目】基于SaaS的餐掌柜项目实战 ###

#### 文章目录 ####

*   *  【项目】基于SaaS的餐掌柜项目实战
     *   *  阶段一 基于SaaS的餐掌柜项目实战
         *   *  第1章 基础架构搭建
             *  4 核心代码
             *   *  4.1 Spring Cloud Alibaba+dubbo+Mybatis-plus整合
                 *   *  4.1.1 dubbo框架整合
                     *  4.1.2 mybatisplus dubbo 代码整合
                     *  4.1.3 web工程和dubbo整合

![在这里插入图片描述][d52582aa1d3c47c4b0fe291fa55cf58b.png_pic_center]

#### 阶段一 基于SaaS的餐掌柜项目实战 ####

##### 第1章 基础架构搭建 #####

##### 4 核心代码 #####

###### 4.1 Spring Cloud Alibaba+dubbo+Mybatis-plus整合 ######

###### 4.1.1 dubbo框架整合 ######

（1） **restkeeper\_service\_common** 工程 **pom.xml** 文件添加

<dependency>
                <groupId>com.alibaba.cloud</groupId>
                <artifactId>spring-cloud-starter-dubbo</artifactId>
            </dependency>
    
            
            
            <dependency>
                <groupId>org.javassist</groupId>
                <artifactId>javassist</artifactId>
                <version>3.22.0-GA</version>
            </dependency>
    
            
            
            <dependency>
                <groupId>de.javakaffee</groupId>
                <artifactId>kryo-serializers</artifactId>
                <version>0.45</version>
            </dependency>
    
            <dependency>
                <groupId>com.esotericsoftware</groupId>
                <artifactId>kryo</artifactId>
                <version>4.0.2</version>
            </dependency>

![在这里插入图片描述][3e0fa8d8f64e4298b3867d32e56bbd38.png_pic_center]

（2）**resetkeeper\_operator** 工程

**bootstrap.yml开启配置中心**

![在这里插入图片描述][f4d2417b15b04accbd2b51e828bcb39b.png_pic_center]

1）新建**operator-dubbo-provider-dev.yml**

spring:
      main:
        allow-bean-definition-overriding: true
      datasource:
        driver-class-name: com.mysql.cj.jdbc.Driver
        url: jdbc:mysql://192.168.200.128:3306/restkeeper_operator?serverTimezone=Asia/Shanghai
        username: root
        password: 123456

![在这里插入图片描述][b385e85821ec491baf1e86de155c0836.png_pic_center]

直接发布

![在这里插入图片描述][8e3da719c08e4abe96abe98013a10ffb.png_pic_center]

2）修改**common.yml**

dubbo:
      scan:
        base-packages: com.restkeeper
      protocols:
        dubbo:
          name: dubbo
          port: -1
          serialization: kryo
      registry:
        address: spring-cloud://192.168.200.128
      consumer:
        timeout: 600000
    management:
      endpoints:
        web:
          exposure:
            include: "*"
    logging:
      level:
        com.restkeeper: debug

![在这里插入图片描述][ccdea80eb93b48ddbfc4a742be29449c.png_pic_center]

发布

![在这里插入图片描述][a506e9fc20bc45dc99721c505693387d.png_pic_center]

**Dubbo RPC中不同序列化生成字节大小比较**

序列化生成字节码的大小是一个比较有确定性的指标，它决定了远程调用的网络传输时间和带宽占用。

针对复杂对象的结果如下（数值越小越好）：

![在这里插入图片描述][13a1217c9ff54d858a1b4bd3bfb6ca45.png_pic_center]

###### 4.1.2 mybatisplus dubbo 代码整合 ######

`restkeeper_operator端工程`

1）使用dubbo的@service

package com.restkeeper.operator.service;
    
    import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
    import com.restkeeper.operator.entity.OperatorUser;
    import com.restkeeper.operator.mapper.OperatorUserMapper;
    import org.apache.dubbo.config.annotation.Service;
    
    //@Service("operatorUserService")
    @Service(version = "1.0.0",protocol = "dubbo")
    /**
     * dubbo中支持的协议
     * dubbo 默认
     * rmi
     * hessian
     * http
     * webservice
     * thrift
     * memcached
     * redis
     */
    public class OperatorUserServiceImpl extends ServiceImpl<OperatorUserMapper, OperatorUser> implements IOperatorUserService{
        
    }

![在这里插入图片描述][e76aa9a8215447a6b239a4ed118090d7.png_pic_center]

启动这个服务

![在这里插入图片描述][aba44026a97140ac8863f76a9be9fa96.png_pic_center]

很好，直接报错

![在这里插入图片描述][e227ace7efd1454c936ec0bba0aecb87.png_pic_center]

换了个JDK 版本，启动成功了，但是数据库连接出错了，因为我还没有创建mysql 容器，搞一个吧

docker run -d -p 3306:3306 -v /home/mysql/conf:/etc/mysql/conf.d -v /home/mysql/data:/var/lib/mysql -e MYSQL_ROOT_PASSWORD=123456 --name mysql mysql

![在这里插入图片描述][a68ddd9788594038bb407af0732cbc1c.png_pic_center]

将数据库表进行一下导入，创建一个 `restkeeper_operator` 数据库，如上，执行SQL 语句

SET NAMES utf8mb4;
    SET FOREIGN_KEY_CHECKS = 0;
    
    -- ----------------------------
    -- Table structure for t_enterprise_account
    -- ----------------------------
    DROP TABLE IF EXISTS `t_enterprise_account`;
    CREATE TABLE `t_enterprise_account`  (
      `enterprise_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '企业id',
      `enterprise_name` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '企业名称',
      `password` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码（后台自动下发）',
      `shop_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '商户号（下发生成）',
      `applicant` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '申请人',
      `phone` varchar(11) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '手机号（登录账号）',
      `application_time` datetime(0) NOT NULL COMMENT '申请时间（当前时间，精准到分）',
      `expire_time` datetime(0) NOT NULL COMMENT '到期时间 (试用下是默认七天后到期，状态改成停用)',
      `province` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(省)',
      `area` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(区)',
      `city` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '地址(市)',
      `address` varchar(200) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '详细地址',
      `status` int(11) NOT NULL DEFAULT 1 COMMENT '状态(0试用，1正式，-1禁用)',
      `last_update_time` datetime(0) NOT NULL COMMENT '操作时间',
      `is_deleted` int(11) NULL DEFAULT 0 COMMENT '逻辑删除',
      PRIMARY KEY (`enterprise_id`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '企业账号管理' ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for t_operator_user
    -- ----------------------------
    DROP TABLE IF EXISTS `t_operator_user`;
    CREATE TABLE `t_operator_user`  (
      `uid` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户id',
      `loginname` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '用户名',
      `loginpass` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '密码',
      PRIMARY KEY (`uid`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '运营端管理员' ROW_FORMAT = Dynamic;
    
    -- ----------------------------
    -- Table structure for t_sys_dict
    -- ----------------------------
    DROP TABLE IF EXISTS `t_sys_dict`;
    CREATE TABLE `t_sys_dict`  (
      `dict_id` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NOT NULL COMMENT '数据id',
      `dict_name` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '字典名称',
      `dict_data` varchar(64) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '内容',
      `category` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '所属分类',
      `info` varchar(32) CHARACTER SET utf8 COLLATE utf8_bin NULL DEFAULT NULL COMMENT '信息',
      `last_update_time` timestamp(0) NULL DEFAULT NULL COMMENT '最后更新时间',
      PRIMARY KEY (`dict_id`) USING BTREE
    ) ENGINE = InnoDB CHARACTER SET = utf8 COLLATE = utf8_bin COMMENT = '全局字典表' ROW_FORMAT = Dynamic;
    
    SET FOREIGN_KEY_CHECKS = 1;

![在这里插入图片描述][a9e27feb478a46bfb743ba84ccfa71cf.png_pic_center]

OK，重启一下，打开Nacos 控制台

![在这里插入图片描述][1511b3ea739046f8aac3858d30dbd75c.png_pic_center]

服务已经注册上来了，查看详情

![在这里插入图片描述][aec3339e27dd44c5bb5f83d8c6f49b81.png_pic_center]

端口20880 ，对数据库进行操作测试

![在这里插入图片描述][ea68c71edfc349eabbab0f78f5bd1c78.png_pic_center]

新增一个用户

![在这里插入图片描述][5a0376b2466b48b998df0ee2367a6ca0.png_pic_center]

OK， 添加成功，看看数据库

![在这里插入图片描述][f4a97f190c65421299b3b62992334cf9.png_pic_center]

没问题

###### 4.1.3 web工程和dubbo整合 ######

1）`修改restkeeper_operator_web在配置中心中的配置文件 添加dubbo支持`

#设置dubbo支持
    dubbo:
      registry:
        address: spring-cloud://192.168.200.128
      cloud:
        subscribed-services: operator-dubbo-provider
      protocols:
        dubbo:
          port: -1
          name: dubbo
          serialization: kryo
      consumer:
        timeout: 600000

![在这里插入图片描述][b9b5d59b7d8748959682fc41158794ba.png_pic_center]

直接发布

![在这里插入图片描述][9ba1c10542494f69833546e7cd6c9813.png_pic_center]

2） `修改UserController`

![在这里插入图片描述][b86df2b55da64bc8bb472967cd67738c.png_pic_center]

这样表现层的服务也就完成了和Dubbo 的整合

启动表现层服务

![在这里插入图片描述][f91656ab865c4575b74fa389f489a53d.png_pic_center]

![在这里插入图片描述][b4db8448a3da4c5cb07ce960e307adce.png_pic_center]

OK， 启动完成，看看服务列表

![在这里插入图片描述][a0af9e5646a4450ba2f2c6ea2a596c67.png_pic_center]

没问题，注册上来了 ，测试接口http://localhost:8083/pageList/1/10

![在这里插入图片描述][280976637c9e47189f138c08cc00aca8.png_pic_center]

因为笔者数据库里面就一条数据，所以就这样了

[d52582aa1d3c47c4b0fe291fa55cf58b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/053acb85c2f742c5a74f9fa4cd6308db.png
[3e0fa8d8f64e4298b3867d32e56bbd38.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/aaebe87892b549188c8837531775166c.png
[f4d2417b15b04accbd2b51e828bcb39b.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/165ab7da3c3d49cd95c27adb5a3a8010.png
[b385e85821ec491baf1e86de155c0836.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/d615283552564a5db81a6428cfad767f.png
[8e3da719c08e4abe96abe98013a10ffb.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/3a302add5d2f46838c7b71e8226912f4.png
[ccdea80eb93b48ddbfc4a742be29449c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/3655dfd669e3455e9a392faa08308bb2.png
[a506e9fc20bc45dc99721c505693387d.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/65b0acbfba414472a4b3e42e28ee7697.png
[13a1217c9ff54d858a1b4bd3bfb6ca45.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/ced9371a9b8c489993553bdeabd3bedf.png
[e76aa9a8215447a6b239a4ed118090d7.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/838aff677fac47d8bbca28ab51af3901.png
[aba44026a97140ac8863f76a9be9fa96.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/fe150ebbadb0402ab81fd1d176306306.png
[e227ace7efd1454c936ec0bba0aecb87.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/2a8bf01075b542d8adce636664ac3dd3.png
[a68ddd9788594038bb407af0732cbc1c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/7fb45daa0d474d6db326cde7dddbebb8.png
[a9e27feb478a46bfb743ba84ccfa71cf.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/53bb916635824282b7c4ad1cbc938e9b.png
[1511b3ea739046f8aac3858d30dbd75c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/d00c478ddda64b009956498afb0402cc.png
[aec3339e27dd44c5bb5f83d8c6f49b81.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/91b952477d9f45f4a4c9c91c65682b15.png
[ea68c71edfc349eabbab0f78f5bd1c78.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/7a58f41f4d6b44aea077818fa7f845d4.png
[5a0376b2466b48b998df0ee2367a6ca0.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/fd03a95cbe424ae8a4accbe7dd42d88f.png
[f4a97f190c65421299b3b62992334cf9.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/0b160752800c4c05a1f4dd806aef504d.png
[b9b5d59b7d8748959682fc41158794ba.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/edc45ddd169746dc905d3d3f35490f1d.png
[9ba1c10542494f69833546e7cd6c9813.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/51784231f99d47fd9ca1b783c185b9d6.png
[b86df2b55da64bc8bb472967cd67738c.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/0ebafa24e51b437cbb2a70afaf2fbac4.png
[f91656ab865c4575b74fa389f489a53d.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/cb8333adacf64b6b878c37896da9b316.png
[b4db8448a3da4c5cb07ce960e307adce.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/d9b1b69195f240df877e25d59d9cbb41.png
[a0af9e5646a4450ba2f2c6ea2a596c67.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/8413617f63824466aadc735928ecc7a5.png
[280976637c9e47189f138c08cc00aca8.png_pic_center]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/23/2b371aa9e50f4405b197dee197abd400.png