分享一个最新的druid数据源配置

来源：互联网发布：手机超市软件编辑：程序博客网时间：2024/05/17 10:38

maven依赖

<!-- mysql --><dependency>    <groupId>mysql</groupId>    <artifactId>mysql-connector-java</artifactId>    <version>6.0.5</version></dependency><!-- 阿里巴巴druid连接池 --><dependency>    <groupId>com.alibaba</groupId>    <artifactId>druid</artifactId>    <version>1.0.27</version></dependency>

bean配置

<!-- 配置数据源 --><bean id="dataSource" class="com.alibaba.druid.pool.DruidDataSource" init-method="init" destroy-method="close">     <property name="url" value="${jdbc.url}" />    <property name="username" value="${jdbc.username}" />    <property name="password" value="${jdbc.password}" />    <property name="filters" value="stat" />    <property name="maxActive" value="20" />    <property name="initialSize" value="1" />    <property name="maxWait" value="60000" />    <property name="minIdle" value="1" />    <property name="timeBetweenEvictionRunsMillis" value="60000" />    <property name="minEvictableIdleTimeMillis" value="300000" />    <property name="testWhileIdle" value="true" />    <property name="testOnBorrow" value="false" />    <property name="testOnReturn" value="false" />    <property name="poolPreparedStatements" value="true" />    <property name="maxOpenPreparedStatements" value="20" /></bean>

jdbc.properties

#服务器地址jdbc.driverClassName=com.mysql.cj.jdbc.Driverjdbc.url=jdbc:mysql://你的地址:3306/你的数据库?characterEncoding=utf-8&serverTimezone=UTCjdbc.username=你的用户名jdbc.password=你的密码

参考文献

阿里druid的github地址

0 0