数据库连接

一、第一种方法 

1.applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"
       xmlns:p="http://www.springframework.org/schema/p"
       >

<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
p:user = "root"
p:password="123"
p:driverClass="com.mysql.jdbc.Driver"
p:jdbcUrl="jdbc:mysql://127.0.0.1:3306/demo"
p:maxPoolSize="300"
p:minPoolSize="2"
p:initialPoolSize="2"
>
</bean>
</beans>

测试:

ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");

DataSource ds = (DataSource) ctx.getBean("dataSource");

System.out.println(ds.getConnection());

二、第二种方法:

application.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"
       xmlns:p="http://www.springframework.org/schema/p"
       >

<bean class="org.springframework.beans.factory.config.PreferencesPlaceholderConfigurer">
<property name="locations">
<!-- 列出你需要的读取的属性列表 -->
<list>
<value>jdbc.properties</value>
</list>
</property>
</bean>


<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
p:user = "${user}"
p:password="${password}"
p:driverClass="${driverClass}"
p:jdbcUrl="${jdbcUrl}"
p:maxPoolSize="${maxPoolSize}"
p:minPoolSize="${minPoolSize}"
p:initialPoolSize="${initialPoolSize}"
>
</bean>
</beans>

2.classpath:jdbc.properties

user = root
password=123
driverClass=com.mysql.jdbc.Driver
jdbcUrl=jdbc:mysql://127.0.0.1:3306/demo
maxPoolSize=300
minPoolSize=2
initialPoolSize=2

3.测试

ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");

DataSource ds = (DataSource) ctx.getBean("dataSource");

System.out.println(ds.getConnection());

三、第三种方法

applicationContext.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans
       http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"
       xmlns:p="http://www.springframework.org/schema/p"
       >

<bean class="org.springframework.beans.factory.config.PropertyOverrideConfigurer">
<property name="locations">
<!-- 列出你需要的读取的属性列表 -->
<list>
<value>jdbc.properties</value>
</list>
</property>
</bean>
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
>
</bean>

</beans>

2.jdbc.propertites

dataSource.user = root
dataSource.password=123
dataSource.driverClass=com.mysql.jdbc.Driver
dataSource.jdbcUrl=jdbc:mysql://127.0.0.1:3306/demo
dataSource.maxPoolSize=300
dataSource.minPoolSize=2
dataSource.initialPoolSize=2

3.测试

ApplicationContext ctx = new ClassPathXmlApplicationContext("applicationContext.xml");

DataSource ds = (DataSource) ctx.getBean("dataSource");

System.out.println(ds.getConnection());