spring整合c3p0连接池

<!-- 读取db.properties文件 -->
	<context:property-placeholder location="classpath:db.properties"/>
<!-- 配置c3p0连接池 -->
	<bean name="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
		<property name="driverClass" value="${jdbc.driverClass}"></property>
		<property name="user" value="${jdbc.user}"></property>
		<property name="password" value="${jdbc.password}"></property>
		<property name="jdbcUrl" value="${jdbc.jdbcUrl}"></property>
    </bean>

  db.properties内容

jdbc.driverClass=com.mysql.jdbc.Driver
jdbc.user=root
jdbc.password=password
jdbc.jdbcUrl=jdbc:mysql://localhost:3306/mybase?characterEncoding=utf8&useUnicode=true&useSSL=false&serverTimezone=UTC

 

posted @ 2019-03-11 20:04  long_yang  阅读(201)  评论(0编辑  收藏  举报