hibernate数据源,
<!-- 增加测试的数据源配置-->
<bean id="dataSourceTest" class="org.springframework.jdbc.datasource.LazyConnectionDataSourceProxy">
<property name="targetDataSource">
<ref local="testDataSource"/>
</property>
</bean>
<bean id="testDataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
<property name="driverClassName" value="${jdbc.test.driverClassName}" />
<property name="url" value="${jdbc.test.url}" />
<property name="username" value="${jdbc.test.username}" />
<property name="password" value="${jdbc.test.password}" />
</bean>
然后从spring中取得 dataSourceTest
ApplicationContext ac = new FileSystemXmlApplicationContext("applicationContext.xml");
ac.getBean("beanId");
<span style="white-space:pre"> </span>Connection</span> conn = dataSource.getConnection();
conn.setAutoCommit(false);
Statement statement = conn.createStatement();
statement.executeUpdate(sql);
conn.commit();// 事务提交
conn.setAutoCommit(true);
学习交流,请关注: