1.1 项目数据库设计

1.1.1 数据库表设计

3.搭建盈利宝项目架构 - 图2
图片1.png

ylb.sql

2 搭建项目结构

1.IDEA创建项目类型为empty-project

1）创建mybatis逆向工程

创建maven项目，把表生成实体类，接口，mapper文件。
image.png
插件
存放在项目根目录下
3.搭建盈利宝项目架构 - 图4

  1. <?xml version="1.0" encoding="UTF-8"?>
  2. <!DOCTYPE generatorConfiguration
  3. PUBLIC "-//mybatis.org//DTD MyBatis Generator Configuration 1.0//EN"
  4. "http://mybatis.org/dtd/mybatis-generator-config_1_0.dtd">
  6. <generatorConfiguration>
  9.   <!-- 指定连接数据库的JDBC驱动包所在位置，指定到你本机的完整路径 -->
  10.   <!--<classPathEntry location="D:\course\server\mysql-connector-java-5.1.49.jar"/>-->
  11.   <!--
  12.   <dependency>
  13.   <groupId>mysql</groupId>
  14.   <artifactId>mysql-connector-java</artifactId>
  15.   <version>5.1.49</version>
  16. </dependency>
  17.   -->
  18.   <!--指定了这个依赖以上就不需要指定路径了-->
  20.   <!-- 配置table表信息内容体，targetRuntime指定采用MyBatis3的版本 -->
  21.   <context id="tables" targetRuntime="MyBatis3">
  23.     <!-- 抑制生成注释，由于生成的注释都是英文的，可以不让它生成 -->
  24.     <commentGenerator>
  25.       <property name="suppressAllComments" value="true" />
  26.     </commentGenerator>
  28.     <!-- 配置数据库连接信息 -->
  29.     <jdbcConnection driverClass="com.mysql.jdbc.Driver"
  30.       connectionURL="jdbc:mysql://localhost:3306/ylb"
  31.       userId="root"
  32.       password="123456">
  33.     </jdbcConnection>
  35.     <!-- 生成model类，targetPackage指定model类的包名， targetProject指定生成的model放在eclipse的哪个工程下面-->
  36.     <javaModelGenerator targetPackage="com.bjpowernode.api.model"
  37.       targetProject="D:\Program\Java\Project\ylb\mapper\src\main\java">
  38.       <property name="enableSubPackages" value="false" />
  39.       <property name="trimStrings" value="false" />
  40.     </javaModelGenerator>
  42.     <!-- 生成MyBatis的Mapper.xml文件，targetPackage指定mapper.xml文件的包名， targetProject指定生成的mapper.xml放在eclipse的哪个工程下面 -->
  43.     <sqlMapGenerator targetPackage="mappers" targetProject="D:\Program\Java\Project\ylb\mapper\src\main\resources">
  44.       <property name="enableSubPackages" value="false" />
  45.     </sqlMapGenerator>
  47.     <!-- 生成MyBatis的Mapper接口类文件,targetPackage指定Mapper接口类的包名， targetProject指定生成的Mapper接口放在eclipse的哪个工程下面 -->
  48.     <javaClientGenerator type="XMLMAPPER" targetPackage="com.bjpowernode.dataservice.mapper" targetProject="D:\Program\Java\Project\ylb\mapper\src\main\java">
  49.       <property name="enableSubPackages" value="false" />
  50.     </javaClientGenerator>
  52.     <!-- 数据库表名及对应的Java模型类名 -->
  53.     <table tableName="b_product_info" domainObjectName="Product"
  54.       enableCountByExample="false"
  55.       enableUpdateByExample="false"
  56.       enableDeleteByExample="false"
  57.       enableSelectByExample="false"
  58.       selectByExampleQueryId="false"/>
  60.     <table tableName="b_bid_info" domainObjectName="BidInfo"
  61.       enableCountByExample="false"
  62.       enableUpdateByExample="false"
  63.       enableDeleteByExample="false"
  64.       enableSelectByExample="false"
  65.       selectByExampleQueryId="false"/>
  68.     <table tableName="b_income_record" domainObjectName="Income"
  69.       enableCountByExample="false"
  70.       enableUpdateByExample="false"
  71.       enableDeleteByExample="false"
  72.       enableSelectByExample="false"
  73.       selectByExampleQueryId="false"/>
  76.       <table tableName="b_recharge_record" domainObjectName="Recharge"
  77.       enableCountByExample="false"
  78.       enableUpdateByExample="false"
  79.       enableDeleteByExample="false"
  80.       enableSelectByExample="false"
  81.       selectByExampleQueryId="false"/>
  84.       <table tableName="u_user" domainObjectName="SysUser"
  85.       enableCountByExample="false"
  86.       enableUpdateByExample="false"
  87.       enableDeleteByExample="false"
  88.       enableSelectByExample="false"
  89.       selectByExampleQueryId="false"/>
  92.       <table tableName="u_finance_account" domainObjectName="FinanceAccount"
  93.       enableCountByExample="false"
  94.       enableUpdateByExample="false"
  95.       enableDeleteByExample="false"
  96.       enableSelectByExample="false"
  97.       selectByExampleQueryId="false"/>
  98.       </context>
  100.       </generatorConfiguration>
  1. <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
  2.   xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
  3.   <modelVersion>4.0.0</modelVersion>
  5.   <groupId>com.bjpowernode</groupId>
  6.   <artifactId>mapper</artifactId>
  7.   <version>1.0-SNAPSHOT</version>
  8.   <packaging>jar</packaging>
  10.   <name>mapper</name>
  11.   <url>http://maven.apache.org</url>
  13.   <properties>
  14.     <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
  15.   </properties>
  17.   <dependencies>
  18.     <dependency>
  19.       <groupId>junit</groupId>
  20.       <artifactId>junit</artifactId>
  21.       <version>3.8.1</version>
  22.       <scope>test</scope>
  23.     </dependency>
  24.     <dependency>
  25.       <groupId>mysql</groupId>
  26.       <artifactId>mysql-connector-java</artifactId>
  27.       <version>5.1.49</version>
  28.     </dependency>
  29.   </dependencies>
  31.   <build>
  32.     <plugins>
  33.       <!--mybatis代码自动生成插件-->
  34.       <plugin>
  35.         <groupId>org.mybatis.generator</groupId>
  36.         <artifactId>mybatis-generator-maven-plugin</artifactId>
  37.         <version>1.3.6</version>
  38.         <configuration>
  39.           <!--配置文件的位置-->
  40.           <configurationFile>GeneratorMapper.xml</configurationFile>
  41.           <verbose>true</verbose>
  42.           <overwrite>true</overwrite>
  43.         </configuration>
  45.         <dependencies>
  46.           <dependency>
  47.             <groupId>mysql</groupId>
  48.             <artifactId>mysql-connector-java</artifactId>
  49.             <version>5.1.49</version>
  50.           </dependency>
  51.         </dependencies>
  53.       </plugin>
  54.     </plugins>
  55.   </build>
  56. </project>

在main下面创建resources
3.搭建盈利宝项目架构 - 图5
使用插件3.搭建盈利宝项目架构 - 图6

2)创建父项目image.png

3)创建micr-api项目

image.png

4)创建micr-dataservice项目

image.png
image.png
image.png
image.png
image.png

注意:
image.png
注意看这里爆红了，我们做以下修改。
在pom.xml(dataservice)中添加以下依赖。

  1.       <dependency>
  2.             <groupId>com.bjpowernode</groupId>
  3.             <artifactId>micr-api</artifactId>
  4.             <version>1.0.0</version>
  5.         </dependency>

image.png

5)添加父项目依赖

  1. <!--首先把夫项目改为springboot-->
  2. <parent>
  3.     <groupId>org.springframework.boot</groupId>
  4.     <artifactId>spring-boot-starter-parent</artifactId>
  5.     <version>2.6.3</version>
  6.     <relativePath/> <!-- lookup parent from repository -->
  7.   </parent>
  9. <!--添加依赖-->
  10. <properties>
  11.     <java.version>17</java.version>
  12.     <dubbo.version>2.7.8</dubbo.version>
  13.     <zookeeper.version>2.7.8</zookeeper.version>
  14.     <mybatis.version>2.2.2</mybatis.version>
  15.     <fastjson>1.2.51</fastjson>
  16.     <swagger.version>2.9.2</swagger.version>
  17.     <swagger.ui.version>1.9.6</swagger.ui.version>
  18.   </properties>
  20.   <dependencyManagement>
  21.     <dependencies>
  23.       <!--声明项目使用的gav-->
  24.       <!--Dubbo-->
  25.       <dependency>
  26.         <groupId>org.apache.dubbo</groupId>
  27.         <artifactId>dubbo-spring-boot-starter</artifactId>
  28.         <version>${dubbo.version}</version>
  29.       </dependency>
  31.       <!--Zookeeper-->
  32.       <dependency>
  33.         <groupId>org.apache.dubbo</groupId>
  34.         <artifactId>dubbo-dependencies-zookeeper</artifactId>
  35.         <version>${zookeeper.version}</version>
  36.         <type>pom</type>
  37.         <exclusions>
  38.           <exclusion>
  39.             <artifactId>slf4j-log4j12</artifactId>
  40.             <groupId>org.slf4j</groupId>
  41.           </exclusion>
  42.         </exclusions>
  43.       </dependency>
  45.       <!--MyBatis-->
  46.       <dependency>
  47.         <groupId>org.mybatis.spring.boot</groupId>
  48.         <artifactId>mybatis-spring-boot-starter</artifactId>
  49.         <version>${mybatis.version}</version>
  50.       </dependency>
  52.       <!--Fastjson-->
  53.       <dependency>
  54.         <groupId>com.alibaba</groupId>
  55.         <artifactId>fastjson</artifactId>
  56.         <version>${fastjson}</version>
  57.       </dependency>
  59.       <!--Swagger-->
  60.       <dependency>
  61.         <groupId>io.springfox</groupId>
  62.         <artifactId>springfox-swagger2</artifactId>
  63.         <version>${swagger.version}</version>
  64.       </dependency>
  66.       <dependency>
  67.         <groupId>io.springfox</groupId>
  68.         <artifactId>springfox-swagger-ui</artifactId>
  69.         <version>${swagger.version}</version>
  70.       </dependency>
  72.       <dependency>
  73.         <groupId>com.github.xiaoymin</groupId>
  74.         <artifactId>swagger-bootstrap-ui</artifactId>
  75.         <version>${swagger.ui.version}</version>
  76.       </dependency>
  77.     </dependencies>
  78.   </dependencyManagement>
  80. <!--添加插件-->
  81. <build>
  82.     <plugins>
  84.       <!-- 编译插件 -->
  85.       <plugin>
  86.         <artifactId>maven-compiler-plugin</artifactId>
  87.         <!-- 插件的版本 -->
  88.         <version>3.5.1</version>
  89.         <!-- 编译级别 -->
  90.         <configuration>
  91.           <source>1.8</source>
  92.           <target>1.8</target>
  93.           <!-- 编码格式 -->
  94.           <encoding>UTF-8</encoding>
  95.         </configuration>
  96.       </plugin>
  97.     </plugins>
  98.   </build>

6)添加micr-dataservice项目依赖

  1. <!--把父项目改为自己的-->
  2. <parent>
  3.         <groupId>com.bjpowernode</groupId>
  4.         <artifactId>micr-parent</artifactId>
  5.         <version>1.0.0</version>
  6.         <relativePath/> <!-- lookup parent from repository -->
  7. </parent>
  9. <!--添加依賴-->
  10.     <dependencies>
  11.         <dependency>
  12.             <groupId>com.bjpowernode</groupId>
  13.             <artifactId>micr-api</artifactId>
  14.             <version>1.0.0</version>
  15.         </dependency>
  16.         <dependency>
  17.             <groupId>org.mybatis.spring.boot</groupId>
  18.             <artifactId>mybatis-spring-boot-starter</artifactId>
  19.         </dependency>
  21.         <dependency>
  22.             <groupId>mysql</groupId>
  23.             <artifactId>mysql-connector-java</artifactId>
  24.             <scope>runtime</scope>
  25.         </dependency>
  26.         <dependency>
  27.             <groupId>org.springframework.boot</groupId>
  28.             <artifactId>spring-boot-starter-test</artifactId>
  29.             <scope>test</scope>
  30.         </dependency>
  31.     </dependencies>

在pom.xml(父项目)添加聚合

  1.   <modules>
  2.     <module>../micr-api</module>
  3.     <module>../micr-dataservice</module>
  4.   </modules>

application.yml核心配置文件(在resources目录下)

  1. #服务名称
  2. spring:
  3.   application:
  4.     name: micr-dataservice
  5.   datasource:
  6.     driver-class-name: com.mysql.cj.jdbc.Driver
  7.     url: jdbc:mysql://localhost:3306/ylb?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8
  8.     username: root
  9.     password: 123456
  11. #设置mybatis
  12. mybatis:
  13.   mapper-locations: classpath:/mappers/**/*.xml
  14.   configuration:
  15.     log-impl: org.apache.ibatis.logging.stdout.StdOutImpl
  16.     map-underscore-to-camel-case: true

配置启动类 加上@MapperScan(“com.bjpowernode.dataservice.mapper”)

  1. @MapperScan("com.bjpowernode.dataservice.mapper")
  2. @SpringBootApplication
  3. public class MicrDataserviceApplication {
  5.     public static void main(String[] args) {
  6.         SpringApplication.run(MicrDataserviceApplication.class, args);
  7.     }
  9. }

项目运行以下效果
image.png
dataservice设置Dubbo
在pom.xml(data-servcie)中添加以下依赖

  1. <!--Dubbo起步依赖-->
  2. <dependency>
  3.   <groupId>org.apache.dubbo</groupId>
  4.   <artifactId>dubbo-spring-boot-starter</artifactId>
  5. </dependency>
  6. <!--zookeeper-->
  7. <dependency>
  8.   <groupId>org.apache.dubbo</groupId>
  9.   <artifactId>dubbo-dependencies-zookeeper</artifactId>
  10.   <type>pom</type>
  11. </dependency>

application中添加dubbo服务配置

  1. #Dubbo配置
  2. dubbo:
  3.   registry:
  4.     address: zookeeper://localhost:2181
  5.   scan:
  6.     base-packages: com.bjpowernode.dataservice.service
  7.   provider:
  8.     timeout: 50000
  9.     retries: 0

在启动类上添加@EnableDubbo注解

  1. //启动Dubbo服务
  2. @EnableDubbo
  3. @MapperScan("com.bjpowernode.dataservice.mapper")
  4. @SpringBootApplication
  5. public class MicrDataserviceApplication {
  7.     public static void main(String[] args) {
  8.         SpringApplication.run(MicrDataserviceApplication.class, args);
  9.     }
  11. }

apache-zookeeper-3.5.5-bin.tar.gz
image.png
双击图标Zookeeper启动
运行项目
image.png

7)Web服务配置

c2bca2f890bcfb3a58131e7947511960.png
ac6d5066877b1c678bc831ec9bd888b7.png
image.png

将父项目改为自己的父项目

  1. <parent>
  2.   <groupId>com.bjpowernode</groupId>
  3.   <artifactId>micr-parent</artifactId>
  4.   <version>1.0.0</version>
  5.   <relativePath/> <!-- lookup parent from repository -->
  6. </parent>

在micr-parent中添加聚合

  1. <modules>
  2.   <module>../micr-api</module>
  3.   <module>../micr-dataservice</module>
  4.   <module>../micr-web</module>
  5. </modules>

web中的依赖项

  1. <dependencies>
  2.         <dependency>
  3.             <groupId>org.springframework.boot</groupId>
  4.             <artifactId>spring-boot-starter-web</artifactId>
  5.         </dependency>
  7.         <dependency>
  8.             <groupId>org.springframework.boot</groupId>
  9.             <artifactId>spring-boot-starter-test</artifactId>
  10.             <scope>test</scope>
  11.         </dependency>
  13.         <dependency>
  14.             <groupId>com.bjpowernode</groupId>
  15.             <artifactId>micr-api</artifactId>
  16.             <version>1.0.0</version>
  17.         </dependency>
  18.         <dependency>
  19.             <groupId>org.apache.dubbo</groupId>
  20.             <artifactId>dubbo-spring-boot-starter</artifactId>
  21.         </dependency>
  22.         <!--zookeeper-->
  23.         <dependency>
  24.             <groupId>org.apache.dubbo</groupId>
  25.             <artifactId>dubbo-dependencies-zookeeper</artifactId>
  26.             <type>pom</type>
  27.         </dependency>
  29.         <!--Swagger-->
  30.         <dependency>
  31.             <groupId>io.springfox</groupId>
  32.             <artifactId>springfox-swagger2</artifactId>
  33.         </dependency>
  35.         <dependency>
  36.             <groupId>io.springfox</groupId>
  37.             <artifactId>springfox-swagger-ui</artifactId>
  38.         </dependency>
  40.         <dependency>
  41.             <groupId>com.github.xiaoymin</groupId>
  42.             <artifactId>swagger-bootstrap-ui</artifactId>
  43.         </dependency>
  45.     </dependencies>
  1. spring:
  2.   application:
  3.     name: micro-web
  5. server:
  6.   port: 8000
  7.   servlet:
  8.    context-path: /api
  9.    encoding:
  10.      enabled: true
  11.      charset: utf-8
  12.      force: true
  14. dubbo:
  15.   registry:
  16.     address: zookeeper://localhost:2181
  17.   scan:
  18.     base-packages: com.bjpowernode.front
  19.   consumer:
  20.     check: false
  21.     timeout: 50000
  22.     retries: 0
  1. //启用Dubbo服务
  2. @EnableDubbo
  3. @SpringBootApplication
  4. public class MicrWebApplication {
  6.     public static void main(String[] args) {
  7.         SpringApplication.run(MicrWebApplication.class, args);
  8.     }
  10. }

点击运行是这个界面
image.png