Spring Boot入门初体验(2)--配置Druid与MyBatis连接Mysql

2019独角兽企业重金招聘Python工程师标准>>>

1.Maven配置Druid、Mybatis

在pom.xml

		<!-- druid 数据源监控 -->
		<dependency>
			<groupId>com.alibaba</groupId>
			<artifactId>druid</artifactId>
			<version>1.1.10</version>
		</dependency>
		<!-- mysql驱动包 -->
		<dependency>
			<groupId>mysql</groupId>
			<artifactId>mysql-connector-java</artifactId>
			<scope>runtime</scope>
		</dependency>
		<!-- mybatis -->
		<dependency>
			<groupId>org.mybatis.spring.boot</groupId>
			<artifactId>mybatis-spring-boot-starter</artifactId>
			<version>1.3.2</version>
		</dependency>

2.yml配置Druid、Mybatis

在application.yml

mybatis:
  #配置文件
  config-location: classpath:mybatis/mybatis-config.xml
  #Mapper文件
  mapper-locations: classpath:mybatis/mapper/*.xml  
  
spring:
   datasource:
    driver-class-name: com.mysql.jdbc.Driver
    type: com.alibaba.druid.pool.DruidDataSource
    url: jdbc:mysql://localhost:3306/${dbName}?useUnicode=true&characterEncoding=utf8
    username: ${username}
    password:${password}
    initial-size: 10
    # 最大连接池数量
    max-active: 100
    # 最小连接池数量
    min-idle: 10
    # 配置获取连接等待超时的时间
    max-wait: 60000

3.Druid映射连接池属性

package com.example.common;

import com.alibaba.druid.pool.DruidDataSource;
import org.springframework.boot.context.properties.ConfigurationProperties;
import org.springframework.context.annotation.Bean;
import org.springframework.context.annotation.Configuration;

import javax.sql.DataSource;

/**
 * 配置druid初始化
 */
@Configuration
public class DruidConfig {

    @ConfigurationProperties(prefix = "spring.datasource")
    @Bean
    public DataSource druidDataSource(){
        DruidDataSource druidDataSource = new DruidDataSource();
        return druidDataSource;
    }
}

4.项目结构

application.yml
application-{name}.xml
可在主配置文件使用

spring:
  #激活数据源
  profiles:
    active: druid
	
spring:
  #不使用active 说明只是一个代码块
  profiles: druid
    

转载于:https://my.oschina.net/u/2500431/blog/2050057