maven引入
<dependency>
<groupId>com.cloudhopper.proxool</groupId>
<artifactId>proxool</artifactId>
<version>0.9.1</version>
</dependency>
属性文件定义连接属性
jdbc-0.driver-url =jdbc:sqlserver://ip:port;databaseName=dbName
jdbc-0.driver =com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc-0.user=sa
jdbc-0.password=sa
jdbc-0.maximumConnectionCount=200
Spring boot Config类中初始化
@Configuration //标识该类被纳入spring容器中实例化并管理
@ServletComponentScan //用于扫描所有的Servlet、filter、listener
public class DataSourceConfig {
@Bean
@ConfigurationProperties(prefix = "jdbc-0")
public DataSource DataSource() {
return DataSourceBuilder.create().type(ProxoolDataSource.class).build();
}
}