project xmlns"xsi
schemaLocation /POM/4.0.0 /xsd/maven-4.0.0.xsd modelVersion
<groupId>com.baomidou</groupId>
<artifactId>mybatis-plus-boot-starter</artifactId>
<version>3.3.1</version>
</dependency>
<!--rabbitmq-->
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-amqp</artifactId>
</dependency>
<dependency>
<groupId>org.glassfish.main.javaee-api</groupId>
<artifactId>javax.jms</artifactId>
<version>3.1.2.2</version>
</dependency>
<!--Excel操作⼯具包-->
<dependency>
<groupId>org.apache.poi</groupId>
<artifactId>poi-ooxml</artifactId>
<version>3.11</version>
</dependency>
<!-- mvnrepository/artifact/freemarker/freemarker --> <dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-freemarker</artifactId>
</dependency>
<dependency>
<groupId>com.github.pagehelper</groupId>
<artifactId>pagehelper-spring-boot-starter</artifactId>
<version>1.2.10</version>
</dependency>
<dependency>
<groupId>mysql</groupId>
<artifactId>mysql-connector-java</artifactId>
<scope>runtime</scope>
</dependency>
<dependency>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
<optional>true</optional>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-test</artifactId>
<scope>test</scope>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-starter-thymeleaf</artifactId>
</dependency>
<dependency>
<groupId>org.hibernate</groupId>
<artifactId>hibernate-core</artifactId>
<version>5.4.32.Final</version>
</dependency>
<dependency>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-test</artifactId>
</dependency>
<dependency>
<groupId>junit</groupId>
<artifactId>junit</artifactId>
</dependency>
<dependency>
<groupId>al.google</groupId>
<groupId>al.google</groupId>
<artifactId>android-json</artifactId>
<version>0.0.20131108.vaadin1</version>
<scope>compile</scope>
</dependency>
<dependency>
springboot aop<groupId>org.springframework</groupId>
<artifactId>spring-test</artifactId>
</dependency>
</dependencies>
<build>
<plugins>
<plugin>
<groupId>org.springframework.boot</groupId>
<artifactId>spring-boot-maven-plugin</artifactId>
<version>2.5.3</version>
<configuration>
<excludes>
<exclude>
<groupId>org.projectlombok</groupId>
<artifactId>lombok</artifactId>
</exclude>
</excludes>
</configuration>
</plugin>
</plugins>
</build>
</project>
mysql数据库建表以及数据
CREATE TABLE `enterprise_mq` (
`ID` varchar(150) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT 'UUID',
`CURRENCY` varchar(50) DEFAULT NULL COMMENT '结算币制',
`PAYENTNAME` varchar(255) DEFAULT NULL COMMENT '缴费企业名称',
`PAYENTCODE` varchar(255) DEFAULT NULL COMMENT '缴费企业统⼀社会信⽤代码',
`CHENTNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收费企业名称',
`CHENTCODE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收费企业统⼀社会信⽤代码',  `PAYMENT` varchar(50) DEFAULT NULL COMMENT '⽀付⽅式',
`REMARK` varchar(50) DEFAULT NULL COMMENT '摘要信息',
`RECORDERCODE` varchar(50) DEFAULT NULL COMMENT '制单⼈账户',
`RECORDERDESC` varchar(255) DEFAULT NULL COMMENT '制单⼈姓名',
`RECORDTIME` varchar(50) DEFAULT NULL COMMENT '制单时间',
`BILLNO` varchar(50) NOT NULL COMMENT '提单号',
PRIMARY KEY (`ID`,`BILLNO`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `details_mq` (
`MAIN_ID` varchar(64) NOT NULL COMMENT '主表ID',
`DETAILS_ID` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '详情号',
`BUSINESSLINK` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '业务环节',
`ITEM_TYPE` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收费类型',
`CHARGE_TYPE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '定价类型',
`ITEM_TITLE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '费项名称',
`SPECIFICATIONS` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '计费规格',
`CHARGE_UNIT` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '计费单位',
`TOTAL_NUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '计费数量',
`DATE_NUM` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '计费时长',
`SUBTOTAL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '计费单价',
`PAY_TOTAL` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '收费⾦额',
`PRICE` varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '价格说明',
PRIMARY KEY (`DETAILS_ID`,`MAIN_ID`) USING BTREE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE `order_mq` (
`BILLNO` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '提单号',
`SHIPCNAME` varchar(50) CHARACTER SET utf8 COLLATE utf8_general_ci DEFAULT NULL COMMENT '中⽂船名',
`SHIPENAME` varchar(50) DEFAULT NULL COMMENT '英⽂船名',
`VOYAGE` varchar(50) DEFAULT NULL COMMENT '航次',
PRIMARY KEY (`BILLNO`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
application.properties配置⽂件
#应⽤程序名称
spring.application.name=demo1
#配置服务启动端⼝
server.port=8090
#注册mysql驱动
spring.datasource.sql.cj.jdbc.Driver
spring.datasource.url=jdbc:mysql://127.0.0.1:3306/ssm_demo?characterEncoding=utf-8&useOldAliasMetadataBehavior=true spring.datasource.username=root
spring.datasource.password=123456
logging.level.mapper.*=DEBUG
#配置thymeleaf
spring.thymeleaf.cache=false
spring.thymeleaf.prefix=classpath:/templates/
spring.thymeleaf.check-template-location=true
spring.thymeleaf.suffix=.html
ding=UTF-8
de=HTML5
spring.mvc.static-path-pattern=/**
spring.mvc.servlet.load-on-startup=1
spring.t-type=text/html
#配置springframework
#req访问request
#spring.freemarker.frequest-context-attribute=req
#后缀名
spring.freemarker.suffix=.html
t-type= text/html
abled=true
#缓存配置
spring.freemarker.cache= false
#模板加载路径按需配置
#plate-loader-path: classpath:/templates/
#编码格式
spring.freemarker.charset=UTF-8
#mybatis
mybatis.mapper-locations=classpath:com/mapper/*.xml
#分页插件
pagehelper.helper-dialect=mysql
pagehelper.params=count=countSql
#rabbitMq
spring.rabbitmq.host=127.0.0.1
spring.rabbitmq.port=5672
spring.rabbitmq.username=guest
spring.rabbitmq.password=guest
freemarker-XML模板 (根据⾃⼰需求整改) 以下是分三级

版权声明：本站内容均来自互联网，仅供演示用，请勿用于商业和其他非法用途。如果侵犯了您的权益请与我们联系QQ:729038198，我们将在24小时内删除。