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)); } } }
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】博客园社区专享云产品让利特惠,阿里云新客6.5折上折
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 没有源码,如何修改代码逻辑?
· 一个奇形怪状的面试题:Bean中的CHM要不要加volatile?
· [.NET]调用本地 Deepseek 模型
· 一个费力不讨好的项目,让我损失了近一半的绩效!
· .NET Core 托管堆内存泄露/CPU异常的常见思路
· DeepSeek “源神”启动!「GitHub 热点速览」
· 微软正式发布.NET 10 Preview 1:开启下一代开发框架新篇章
· C# 集成 DeepSeek 模型实现 AI 私有化(本地部署与 API 调用教程)
· DeepSeek R1 简明指南:架构、训练、本地部署及硬件要求
· 2 本地部署DeepSeek模型构建本地知识库+联网搜索详细步骤