前言

环境:

java version "1.8.0_45"

Java(TM) SE Runtime Environment (build 1.8.0_45-b15)

Java HotSpot(TM) 64-Bit Server VM (build 25.45-b02, mixed mode)

mysql Server version: 8.0.13

Eclipse IDE Version: Photon Release (4.8.0)

问题&解决

1.初始化Maven工程过慢

使用国外站点进行更新，实在太浪费时间，所以修改为国内站点

在pom.xml中添加(pom.xml集成了依赖关系)

<repositories>

		<repository>

			<id>alimaven</id>

			<name>aliyun maven</name>

			<url>http://maven.aliyun.com/nexus/content/groups/public/</url>

		</repository>

		</repositories>

完整pom.xml如下

<?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 http://maven.apache.org/xsd/maven-4.0.0.xsd">

	<modelVersion>4.0.0</modelVersion>

	<groupId>com.winter</groupId>

	<artifactId>springboot-mybatis-demo</artifactId>

	<version>0.0.1-SNAPSHOT</version>

	<packaging>jar</packaging>

	<name>springboot-mybatis-demo</name>

	<description>Demo project for Spring Boot</description>

	<parent>

		<groupId>org.springframework.boot</groupId>

		<artifactId>spring-boot-starter-parent</artifactId>

		<version>1.5.6.RELEASE</version>

		<relativePath/> <!-- lookup parent from repository -->

	</parent>

	<repositories>

		<repository>

			<id>alimaven</id>

			<name>aliyun maven</name>

			<url>http://maven.aliyun.com/nexus/content/groups/public/</url>

		</repository>

		</repositories>

	<properties>

		<project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>

		<project.reporting.outputEncoding>UTF-8</project.reporting.outputEncoding>

		<java.version>1.8</java.version>

	</properties>

	<dependencies>

		<dependency>

			<groupId>org.springframework.boot</groupId>

			<artifactId>spring-boot-starter-jdbc</artifactId>

		</dependency>

		<dependency>

			<groupId>org.mybatis.spring.boot</groupId>

			<artifactId>mybatis-spring-boot-starter</artifactId>

			<version>1.3.0</version>

		</dependency>

		<dependency>

			<groupId>org.springframework.boot</groupId>

			<artifactId>spring-boot-starter-thymeleaf</artifactId>

		</dependency>

		<dependency>

			<groupId>org.springframework.boot</groupId>

			<artifactId>spring-boot-starter-web</artifactId>

		</dependency>

		<dependency>

			<groupId>org.springframework.boot</groupId>

			<artifactId>spring-boot-starter-test</artifactId>

			<scope>test</scope>

		</dependency>

		<dependency>

			<groupId>mysql</groupId>

			<artifactId>mysql-connector-java</artifactId>

			<version>8.0.13</version>

		</dependency>

		<!-- alibaba的druid数据库连接池 -->

		<dependency>

			<groupId>com.alibaba</groupId>

			<artifactId>druid</artifactId>

			<version>1.0.11</version>

		</dependency>

		<dependency>

			<groupId>com.fasterxml.jackson.core</groupId>

			<artifactId>jackson-core</artifactId>

		</dependency>

		<dependency>

			<groupId>com.fasterxml.jackson.core</groupId>

			<artifactId>jackson-databind</artifactId>

		</dependency>

		<dependency>

			<groupId>com.fasterxml.jackson.datatype</groupId>

			<artifactId>jackson-datatype-joda</artifactId>

		</dependency>

		<dependency>

			<groupId>com.fasterxml.jackson.module</groupId>

			<artifactId>jackson-module-parameter-names</artifactId>

		</dependency>

		<!-- 分页插件 -->

		<dependency>

			<groupId>com.github.pagehelper</groupId>

			<artifactId>pagehelper-spring-boot-starter</artifactId>

			<version>1.1.2</version>

		</dependency>

		<!-- alibaba的druid数据库连接池 -->

		<dependency>

			<groupId>com.alibaba</groupId>

			<artifactId>druid-spring-boot-starter</artifactId>

			<version>1.1.0</version>

		</dependency>

		<!-- 读取project文件 -->

		<dependency>

			<groupId>net.sf.mpxj</groupId>

			<artifactId>mpxj</artifactId>

			<version>7.1.0</version>

		</dependency>

		<!-- https://mvnrepository.com/artifact/org.springframework.boot/spring-boot-starter-logging -->

		<dependency>

			<groupId>org.springframework.boot</groupId>

			<artifactId>spring-boot-starter-logging</artifactId>

		</dependency>

		<!--可以引入日志 @Slf4j注解-->

		<dependency>

			<groupId>org.projectlombok</groupId>

			<artifactId>lombok</artifactId>

		</dependency>

	</dependencies>

	<build>

		<plugins>

			<plugin>

				<groupId>org.springframework.boot</groupId>

				<artifactId>spring-boot-maven-plugin</artifactId>

			</plugin>

			<!-- mybatis generator 自动生成代码插件 -->

			<plugin>

				<groupId>org.mybatis.generator</groupId>

				<artifactId>mybatis-generator-maven-plugin</artifactId>

				<version>1.3.2</version>

				<configuration>

					<configurationFile>${basedir}/src/main/resources/generator/generatorConfig.xml</configurationFile>

					<overwrite>true</overwrite>

					<verbose>true</verbose>

				</configuration>

			</plugin>

		</plugins>

	</build>

</project>

2.Spring Boot 集成druid时时区问题和连接超时问题

添加&serverTimezone=GMT%2B8&autoReconnect=true

完整application.yml如下

server:

  port: 8080

spring:

    datasource:

        name: test

        url: jdbc:mysql://localhost:3306/test?useUnicode=true&characterEncoding=UTF-8&serverTimezone=GMT%2B8&autoReconnect=true&failOverReadOnly=false&allowMultiQueries=true

        username: root

        password: root

        # 使用druid数据源

        type: com.alibaba.druid.pool.DruidDataSource

        driver-class-name: com.mysql.cj.jdbc.Driver

        filters: stat

        maxActive: 20

        initialSize: 1

        maxWait: 60000

        minIdle: 1

        timeBetweenEvictionRunsMillis: 60000

        minEvictableIdleTimeMillis: 300000

        validationQuery: select 'x'

        testWhileIdle: true

        testOnBorrow: false

        testOnReturn: false

        poolPreparedStatements: true

        maxOpenPreparedStatements: 20

mybatis:

  mapper-locations: classpath:mapping/*.xml

  type-aliases-package: com.winter.model

#pagehelper

pagehelper:

    helperDialect: mysql

    reasonable: true

    supportMethodsArguments: true

    params: count=countSql

3.完整工程下载

Chasssser

CSDN

巴特西

springboot-mybatis-demo遇到的坑

前言

问题&解决

1.初始化Maven工程过慢

2.Spring Boot 集成druid时时区问题和连接超时问题

3.完整工程下载

最新文章

热门文章