MySQL 数据库 配置

数据库 jdbc 依赖

    <dependencies>
        <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>8.0.15</version>
        </dependency>
    </dependencies>

---

数据库连接池(Druid)                                                                 

<!-- 数据库连接池 -->
<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.21</version>
</dependency>

连接方式:

spring.datasource.url=jdbc:mysql://localhost:3306/mall_pms?useUnicode=true&characterEncoding=UTF-8&serverTimezone=Asia/Shanghai
spring.datasource.username=root
spring.datasource.password=root

# 激活码 profilr 配置
spring.profiles.active=dve
# 连接数据库的固定配置
spring.datasource.type=com.alibaba.druid.pool.DruidDataSource

#mybatis 的xml 文件位置
mybatis.mapper-locations=classpath:mapper/*.xml

Apache DBCP 数据库连接池

<dependency>
    <groupId>commons-dbcp</groupId>
    <artifactId>commons-dbcp</artifactId>
    <version>1.4</version>
</dependency>