Druid数据源配置

一:添加依赖

复制代码
       <dependency>
            <groupId>mysql</groupId>
            <artifactId>mysql-connector-java</artifactId>
            <version>${mysql.version}</version>
        </dependency>

         <dependency>
            <groupId>com.alibaba</groupId>
            <artifactId>druid</artifactId>
            <version>${druid.version}</version>
        </dependency>        
复制代码

二:加载配置文件代码

复制代码
/***
 * 
 * @author zhanchaohan
 *
 */
public class DruidUtill {

    public DruidDataSource init() throws FileNotFoundException, IOException {
        Properties properties=new Properties();
        properties.load(DruidUtill.class.getResourceAsStream("/druid.properties"));
        
        
        DruidDataSource dataSource = new DruidDataSource();
        
        dataSource.configFromPropety(properties);
        
        return dataSource;
    }
}
复制代码

三:配置文件

复制代码
druid.name=myDruid
druid.url=jdbc:mysql://localhost:3306/test
druid.username=root
druid.password=
druid.testWhileIdle=
druid.testOnBorrow=
druid.validationQuery=
druid.useGlobalDataSourceStat=
druid.useGloalDataSourceStat=
druid.asyncInit=
druid.filters=
druid.timeBetweenLogStatsMillis=
druid.stat.sql.MaxSize=
druid.clearFiltersEnable=
druid.resetStatEnable=
druid.notFullTimeoutRetryCount=
druid.timeBetweenEvictionRunsMillis=
druid.maxWaitThreadCount=
druid.maxWait=
druid.failFast=
druid.phyTimeoutMillis=
druid.phyMaxUseCount=
druid.minEvictableIdleTimeMillis=
druid.maxEvictableIdleTimeMillis=
druid.keepAlive=
druid.keepAliveBetweenTimeMillis=
druid.poolPreparedStatements=
druid.initVariants=
druid.initGlobalVariants=
druid.useUnfairLock=
druid.driverClassName=
druid.initialSize=
druid.minIdle=
druid.maxActive=
druid.killWhenSocketReadTimeout=
druid.connectProperties=
druid.maxPoolPreparedStatementPerConnectionSize=
druid.initConnectionSqls=
druid.load.spifilter.skip=
druid.checkExecuteTime=
复制代码

四:测试

复制代码
/***
 * 
 * @author zhanchaohan
 *
 */
public class DruidUtillTest {
    private DruidDataSource druidDataSource;
    
    @Before
    public void init() throws FileNotFoundException, IOException {
        DruidUtill du=new DruidUtill();
        
        druidDataSource=du.init();
    }
    @Test
    public void test1() throws SQLException {
        DruidPooledConnection dpc=    druidDataSource.getConnection();
        
        PreparedStatement preparedStatement=dpc.prepareStatement("show tables");
        ResultSet resultSet=preparedStatement.executeQuery();
        
        while(resultSet.next()) {
            System.out.println(resultSet.getString(1));
        }
    }
}
复制代码

 

posted @   Jachs  阅读(1261)  评论(0编辑  收藏  举报
编辑推荐:
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
阅读排行:
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤
点击右上角即可分享
微信分享提示
桃之夭夭,灼灼其华。