pom依赖
1<?xml version="1.0" encoding="UTF-8"?> 2<project xmlns="http://maven.apache.org/POM/4.0.0" 3 xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 4 xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> 5 <modelVersion>4.0.0</modelVersion> 6 7 <groupId>top.xz.hand</groupId> 8 <artifactId>innocent-gennerator</artifactId> 9 <version>1.0-SNAPSHOT</version> 10 11 <parent> 12 <groupId>org.springframework.boot</groupId> 13 <artifactId>spring-boot-starter-parent</artifactId> 14 <version>2.1.2.RELEASE</version> 15 <relativePath /> 16 </parent> 17<properties> 18 <spring.boot.version>2.1.2.RELEASE</spring.boot.version> 19</properties> 20<dependencies> 21 <!--springboot相关jar--> 22 <dependency> 23 <groupId>org.springframework.boot</groupId> 24 <artifactId>spring-boot-starter-web</artifactId> 25 </dependency> 26 <dependency> 27 <groupId>org.mybatis.spring.boot</groupId> 28 <artifactId>mybatis-spring-boot-starter</artifactId> 29 <version>1.3.2</version> 30 </dependency> 31 <dependency> 32 <groupId>org.springframework.boot</groupId> 33 <artifactId>spring-boot-starter-test</artifactId> 34 <scope>test</scope> 35 </dependency> 36 <dependency> 37 <groupId>org.springframework.boot</groupId> 38 <artifactId>spring-boot-starter-thymeleaf</artifactId> 39 </dependency> 40 41 <dependency> 42 <groupId>org.springframework.boot</groupId> 43 <artifactId>spring-boot-configuration-processor</artifactId> 44 <optional>true</optional> 45 </dependency> 46 <dependency> 47 <groupId>org.springframework.boot</groupId> 48 <artifactId>spring-boot-starter-jdbc</artifactId> 49 </dependency> 50 <dependency> 51 <groupId>org.springframework.boot</groupId> 52 <artifactId>spring-boot-starter-aop</artifactId> 53 </dependency> 54 <dependency> 55 <groupId>org.springframework.boot</groupId> 56 <artifactId>spring-boot-starter-freemarker</artifactId> 57 </dependency> 58 <dependency> 59 <groupId>org.springframework.boot</groupId> 60 <artifactId>spring-boot-starter-logging</artifactId> 61 </dependency> 62 <dependency> 63 <groupId>org.springframework.boot</groupId> 64 <artifactId>spring-boot-starter-data-redis</artifactId> 65 <!--<version>${spring.boot.version}</version>--> 66 67 </dependency> 68 <!--springboot相关jar 结束--> 69 70 <dependency> 71 <groupId>junit</groupId> 72 <artifactId>junit</artifactId> 73 <version>4.12</version> 74 </dependency> 75 <!--mybatis自动生成工具--> 76 <dependency> 77 <groupId>org.mybatis.generator</groupId> 78 <artifactId>mybatis-generator-core</artifactId> 79 <version>1.3.5</version> 80 <scope>test</scope> 81 </dependency> 82 83 <!-- mybatis 工具包--> 84 <dependency> 85 <groupId>tk.mybatis</groupId> 86 <artifactId>mapper</artifactId> 87 <version>3.4.2</version> 88 </dependency> 89 90 <!--代码生成器依赖--> 91 <dependency> 92 <groupId>org.freemarker</groupId> 93 <artifactId>freemarker</artifactId> 94 <version>2.3.23</version> 95 <scope>test</scope> 96 </dependency> 97 <dependency> 98 <groupId>org.apache.commons</groupId> 99 <artifactId>commons-lang3</artifactId> 100 <version>3.8</version> 101 </dependency> 102 <dependency> 103 <groupId>com.google.guava</groupId> 104 <artifactId>guava</artifactId> 105 <version>21.0</version> 106 </dependency> 107 108 <dependency> 109 <groupId>io.springfox</groupId> 110 <artifactId>springfox-swagger2</artifactId> 111 <version>2.8.0</version> 112 </dependency> 113 <dependency> 114 <groupId>io.springfox</groupId> 115 <artifactId>springfox-swagger-ui</artifactId> 116 <version>2.8.0</version> 117 </dependency> 118 <!--<!– https://mvnrepository.com/artifact/io.swagger/swagger-annotations –>--> 119 <!--<dependency>--> 120 <!--<groupId>io.swagger</groupId>--> 121 <!--<artifactId>swagger-annotations</artifactId>--> 122 <!--<version>1.5.22</version>--> 123 <!--</dependency>--> 124 <!--<!– https://mvnrepository.com/artifact/io.swagger/swagger-core –>--> 125 <!--<dependency>--> 126 <!--<groupId>io.swagger</groupId>--> 127 <!--<artifactId>swagger-core</artifactId>--> 128 <!--<version>1.5.22</version>--> 129 <!--</dependency>--> 130 <dependency> 131 <groupId>com.mangofactory</groupId> 132 <artifactId>swagger-springmvc</artifactId> 133 <version>1.0.2</version> 134 </dependency> 135 <dependency> 136 <groupId>com.mangofactory</groupId> 137 <artifactId>swagger-models</artifactId> 138 <version>1.0.2</version> 139 </dependency> 140 <dependency> 141 <groupId>com.wordnik</groupId> 142 <artifactId>swagger-annotations</artifactId> 143 <version>1.3.11</version> 144 </dependency> 145 146 <dependency> 147 <groupId>com.fasterxml.jackson.core</groupId> 148 <artifactId>jackson-core</artifactId> 149 <version>2.8.0</version> 150 </dependency> 151 <dependency> 152 <groupId>com.fasterxml.jackson.core</groupId> 153 <artifactId>jackson-annotations</artifactId> 154 <version>2.8.0</version> 155 </dependency> 156 <dependency> 157 <groupId>com.fasterxml.jackson.core</groupId> 158 <artifactId>jackson-databind</artifactId> 159 <version>2.8.0</version> 160 </dependency> 161 <!--解决2.0版本springboot冲突--> 162 <dependency> 163 <groupId>mysql</groupId> 164 <artifactId>mysql-connector-java</artifactId> 165 </dependency> 166 167 <dependency> 168 <groupId>com.fasterxml.jackson.datatype</groupId> 169 <artifactId>jackson-datatype-joda</artifactId> 170 </dependency> 171 <dependency> 172 <groupId>com.fasterxml.jackson.module</groupId> 173 <artifactId>jackson-module-parameter-names</artifactId> 174 </dependency> 175 <!-- 分页插件 --> 176 <dependency> 177 <groupId>com.github.pagehelper</groupId> 178 <artifactId>pagehelper-spring-boot-starter</artifactId> 179 <version>1.2.5</version><!--1.1.2版本冲突--> 180 </dependency> 181 <!-- alibaba的druid数据库连接池 --> 182 <dependency> 183 <groupId>com.alibaba</groupId> 184 <artifactId>druid-spring-boot-starter</artifactId> 185 <version>1.1.0</version> 186 </dependency> 187 <!-- Druid数据库连接池组件 --> 188 <dependency> 189 <groupId>com.alibaba</groupId> 190 <artifactId>druid</artifactId> 191 <version>1.1.3</version> 192 </dependency> 193 <dependency> 194 <groupId>tk.mybatis</groupId> 195 <artifactId>mapper</artifactId> 196 <version>4.0.4</version> 197 </dependency> 198 <dependency> 199 <groupId>redis.clients</groupId> 200 <artifactId>jedis</artifactId> 201 <!--<version>2.8.1</version>--> 202 </dependency> 203 <!-- https://mvnrepository.com/artifact/org.apache.commons/commons-pool2 --> 204 <dependency> 205 <groupId>org.apache.commons</groupId> 206 <artifactId>commons-pool2</artifactId> 207 <version>2.6.0</version> 208 </dependency> 209 <!--<dependency>--> 210 <!--<groupId>com.rabbitmq</groupId>--> 211 <!--<artifactId>amqp-client</artifactId>--> 212 <!--<version>3.3.4</version>--> 213 <!--</dependency>--> 214 <dependency> 215 <groupId>org.springframework.boot</groupId> 216 <artifactId>spring-boot-starter-amqp</artifactId> 217 </dependency> 218 219</dependencies> 220 <build> 221 <plugins> 222 <plugin> 223 <artifactId>maven-compiler-plugin</artifactId> 224 <configuration> 225 <source>1.8</source> 226 <target>1.8</target> 227 <encoding>UTF-8</encoding> 228 </configuration> 229 </plugin> 230 <plugin> 231 <groupId>org.springframework.boot</groupId> 232 <artifactId>spring-boot-maven-plugin</artifactId> 233 <configuration> 234 <fork>true</fork> 235 <mainClass>com.xx.app.chain.fabric.App</mainClass> 236 <layout>ZIP</layout> 237 </configuration> 238 <executions> 239 <execution> 240 <goals> 241 <goal>repackage</goal> 242 </goals> 243 </execution> 244 </executions> 245 </plugin> 246 </plugins> 247 <resources> 248 <resource> 249 <directory>src/main/java</directory> 250 <includes> 251 <include>**/*.yml</include> 252 <include>**/*.properties</include> 253 <include>**/*.xml</include> 254 </includes> 255 <filtering>false</filtering> 256 </resource> 257 <resource> 258 <directory>src/main/resources</directory> 259 <includes> 260 <include>**/*.yml</include> 261 <include>**/*.properties</include> 262 <include>**/*.xml</include> 263 </includes> 264 <filtering>false</filtering> 265 </resource> 266 </resources> 267 </build> 268 269 270 271 272</project>
yml文件配置数据参数
1server: 2 port: 8090 3spring: 4 datasource: 5 driver-class-name: com.mysql.cj.jdbc.Driver 6 url: jdbc:mysql://localhost:3306/innocent?useUnicode=true&characterEncoding=utf8&serverTimezone=GMT%2B8&useSSL=false 7 username: root 8 password: root123 9 type: com.alibaba.druid.pool.DruidDataSource 10 druid: 11 #最大活跃数 12 maxActive: 20 13 #初始化数量 14 initialSize: 1 15 #最大连接等待超时时间 16 maxWait: 60000 17 #打开PSCache，并且指定每个连接PSCache的大小 18 poolPreparedStatements: true 19 maxPoolPreparedStatementPerConnectionSize: 20 20 #通过connectionProperties属性来打开mergeSql功能；慢SQL记录 21 #connectionProperties: druid.stat.mergeSql=true;druid.stat.slowSqlMillis=5000 22 minIdle: 1 23 timeBetweenEvictionRunsMillis: 60000 24 minEvictableIdleTimeMillis: 300000 25 validationQuery: select 1 from dual 26 testWhileIdle: true 27 testOnBorrow: false 28 testOnReturn: false 29 #配置监控统计拦截的filters，去掉后监控界面sql将无法统计,'wall'用于防火墙 30 filters: stat, wall, log4j
配置数据源项
1package top.xz.hand.config; 2 3import com.alibaba.druid.pool.DruidDataSource; 4import org.springframework.beans.factory.annotation.Value; 5import org.springframework.boot.context.properties.ConfigurationProperties; 6import org.springframework.context.annotation.Bean; 7import org.springframework.context.annotation.Configuration; 8 9import javax.sql.DataSource; 10 11@Configuration 12public class Druidconfig { 13 14 @Bean 15 @ConfigurationProperties(prefix="spring.datasource") 16 public DataSource druidDataSource() { 17 DruidDataSource druidDataSource = new DruidDataSource(); 18 return druidDataSource; 19 } 20}