数据库配置

最新推荐文章于 2022-09-27 17:41:12 发布

ZFLearn

最新推荐文章于 2022-09-27 17:41:12 发布

阅读量153

点赞数

本文链接：https://blog.csdn.net/ZFLearn/article/details/83028655

版权

``JDBC`

<dependency>
    <groupId>org.springframework</groupId>
    <artifactId>spring-jdbc</artifactId>
    <version>5.1.0.RELEASE</version>
</dependency>

Mysql

<dependency>
    <groupId>mysql</groupId>
    <artifactId>mysql-connector-java</artifactId>
    <version>8.0.12</version>
</dependency>

druid连接池

<dependency>
    <groupId>com.alibaba</groupId>
    <artifactId>druid</artifactId>
    <version>1.1.11</version>
</dependency>

HikariCP连接池以及c3p0连接池

<dependency>
	<groupId>com.zaxxer</groupId>
	<artifactId>HikariCP</artifactId>
	<version>3.2.0</version>
</dependency>

   <dependency>
    	<groupId>com.mchange</groupId>
    	<artifactId>c3p0</artifactId>
    	<version>0.9.5.2</version>
    </dependency>

xml 中数据库连接配置

 class="com.alibaba.druid.pool.DruidDataSource"
    <bean id="dataSource"
    		class="com.alibaba.druid.pool.DruidDataSource"
    		p:driverClassName="com.mysql.cj.jdbc.Driver"
    		p:url="jdbc:mysql:///test?serverTimezone=UTC" p:username="root"
    		p:password="12345678"/>
    	<bean id="jt" class="org.springframework.jdbc.core.JdbcTemplate" p:dataSource-ref="dataSource"/>