spring的各种dataSource配置

view plain copy to clipboard print ?

1. <?xml version="1.0"encoding="UTF-8"?>
2. <beans xmlns="http://www.springframework.org/schema/beans"
3. xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"xmlns:context="http://www.springframework.org/schema/context"
4. xmlns:aop="http://www.springframework.org/schema/aop"xmlns:tx="http://www.springframework.org/schema/tx"
5. xmlns:jee="http://www.springframework.org/schema/jee"
6. xsi:schemaLocation="http://www.springframework.org/schema/beans
7. http://www.springframework.org/schema/beans/spring-beans-2.5.xsd
8. http://www.springframework.org/schema/context
9. http://www.springframework.org/schema/context/spring-context-2.5.xsd
10. http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.5.xsd
11. http://www.springframework.org/schema/jee http://www.springframework.org/schema/jee/spring-jee-2.5.xsd
12. http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.5.xsd">
13. <context:property-placeholder location="classpath:jdbc_config.properties"/>
14. <!--
15. DriverManagerDataSource:在每个连接请求时新建一个连接。
16. SingleConnectionDataSource:在每个连接请求时都返回同一连接。
17. -->
18. <bean id="dataSource"class="org.springframework.jdbc.datasource.DriverManagerDataSource">
19. <property name="driverClassName"value="${driverClassName}"/>
20. <property name="url"value="${url}"/>
21. <property name="username"value="${username}"/>
22. <property name="password"value="${password}"/>
23. </bean>
24. </beans>

。。。。。

view plain copy to clipboard print ?

1. <context:property-placeholder location="classpath:dbcp_config.properties"/>
2. <bean id="dataSource"class="org.apache.commons.dbcp.BasicDataSource"
3. destroy-method="close">
4. <property name="driverClassName"value="${driverClassName}"/>
5. <property name="url"value="${url}"/>
6. <property name="username"value="${username}"/>
7. <property name="password"value="${password}"/>
8. <property name="initialSize"value="${initialSize}"/>
9. <property name="maxActive"value="${maxActive}"/>
10. <property name="maxIdle"value="${maxIdle}"/>
11. <property name="minIdle"value="${minIdle}"/>
12. <property name="maxWait"value="${maxWait}"/>
13. <property name="defaultAutoCommit"value="${defaultAutoCommit}"/>
14. </bean>

。。。。。

view plain copy to clipboard print ?

1. <context:property-placeholder location="classpath:c3p0_config.properties"/>
2. <bean id="dataSource"
3. class="com.mchange.v2.c3p0.ComboPooledDataSource">
4. <property name="user"value="${user}"/>
5. <property name="password"value="${password}"/>
6. <property name="jdbcUrl"value="${jdbcUrl}"/>
7. <property name="driverClass"value="${driverClass}"/>
9. <property name="checkoutTimeout"value="${checkoutTimeout}"/>
10. <property name="idleConnectionTestPeriod"value="${idleConnectionTestPeriod}"/>
11. <property name="initialPoolSize"value="${initialPoolSize}"/>
12. <property name="maxIdleTime"value="${maxIdleTime}"/>
14. <property name="maxPoolSize"value="${maxPoolSize}"/>
15. <property name="minPoolSize"value="${minPoolSize}"/>
16. <property name="maxStatements"value="${maxStatements}"/>
17. </bean>

。。。。。

view plain copy to clipboard print ?

2. <!--
3. <bean id="dataSource"class="org.springframework.jndi.JndiObjectFactoryBean"
4. scope="singleton">
5. <property name="jndiName"value="/jdbc/spring-jndi"/>
6. < !--
7. 当resourceRef 属性为true时，jndiName会被添加java:comp/env/，从应用服务器的JNDI目录获取数据源
8. -- >
9. <property name="resourceRef"ref="true"/>
10. </bean>
11. -->
12. <!-- jee 命名空间里的jee:jndi-lookup 元素可以从jndi获取对象。下面的XML等效于前面对JndiObjectFactoryBean的明确声明 -->
13. <jee:jndi-lookup id="dataSource"jndi-name="/jdbc/spring-jndi"resource-ref="true"/>

。。。。。


测试使用一下

view plain copy to clipboard print ?

1. <importresource="classpath:bean-dbcp.xml"/>
2. <bean id="helloJdbcDao"class="cn.partner4java.jdbc.impl.HelloJdbcDaoBean">
3. <property name="dataSource"ref="dataSource"/>
4. </bean>

。。。。。。

view plain copy to clipboard print ?

1. packagecn.partner4java.jdbc;
2. importjava.sql.Connection;
3. importjava.sql.SQLException;
4. /**
5. * 存jdbc练习
6. * @author wangchanglong
7. *
8. */
9. publicinterfaceHelloJdbcDao {
10. publicConnection getConnection()throwsSQLException;
11. }

。。。。。。

view plain copy to clipboard print ?

1. packagecn.partner4java.jdbc.impl;
2. importjava.sql.Connection;
3. importjava.sql.SQLException;
4. importjavax.sql.DataSource;
5. importcn.partner4java.jdbc.HelloJdbcDao;
6. /**
7. * 最简单的练习
8. * @author wangchanglong
9. *
10. */
11. publicclassHelloJdbcDaoBeanimplementsHelloJdbcDao{
12. publicDataSource dataSource;
13. publicvoidsetDataSource(DataSource dataSource) {
14. this.dataSource = dataSource;
15. }
16. publicConnection getConnection()throwsSQLException {
17. returndataSource.getConnection();
18. }
20. }

。。。。。

view plain copy to clipboard print ?

1. packagecn.partner4java.jdbc.junit;
2. importjava.sql.SQLException;
3. importorg.springframework.context.ApplicationContext;
4. importorg.springframework.context.support.ClassPathXmlApplicationContext;
5. importcn.partner4java.jdbc.HelloJdbcDao;
6. importjunit.framework.TestCase;
7. publicclassHelloJdbcDaoBeanTestextendsTestCase {
8. publicHelloJdbcDao helloJdbcDao;
9. @Override
10. protectedvoidsetUp()throwsException {
11. ApplicationContext ac =newClassPathXmlApplicationContext("beans-jdbc.xml");
12. helloJdbcDao = (HelloJdbcDao) ac.getBean("helloJdbcDao");
13. }
15. publicvoidtestGetConn()throwsSQLException{
16. System.out.println(helloJdbcDao.getConnection());
17. }
19. }