1:环境要求及其文件结构 配置 文件 以c3p0为例配置连接池: <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"> <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource" destroy-method="close">> <property name="driverClass" value="com.mysql.jdbc.Driver" /> <property name="jdbcUrl" value="jdbc:mysql://127.0.0.1:3306/sampledb" /> <property name="user" value="root" /> <property name="password" value="root" /> </bean> </beans> 如果是用的是dbcp则需要 commons-dbcp.jar commons-pool.jar 配置如下: <?xml version="1.0" encoding="UTF-8"?> <beans xmlns="http://www.springframework.org/schema/beans" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:aop="http://www.springframework.org/schema/aop" xmlns:tx="http://www.springframework.org/schema/tx" xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-2.0.xsd http://www.springframework.org/schema/aop http://www.springframework.org/schema/aop/spring-aop-2.0.xsd http://www.springframework.org/schema/tx http://www.springframework.org/schema/tx/spring-tx-2.0.xsd"> <bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close"> <property name="driverClassName" value="com.mysql.jdbc.Driver" /> <property name="url" value="jdbc:mysql://127.0.0.1:3306/sampledb" /> <property name="username" value="root" /> <property name="password" value="root" /> </bean> </beans> 测试使用 package com.macower.spring.dao.test; import java.sql.Connection; import java.sql.ResultSet; import java.sql.SQLException; import java.sql.Statement; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; public class JdbcUtil { /** * 简单的获取下连接 * @return */ public static Connection getConnection(){ Connection conn = null; ApplicationContext ctx = new ClassPathXmlApplicationContext("app*.xml"); DataSource dms = (DataSource) ctx.getBean("dataSource"); try { conn = dms.getConnection(); } catch (SQLException e) { e.printStackTrace(); } return conn; } /** * 测试使用 * @param args * @throws Exception */ public static void main(String[] args) throws Exception { System.out.println(getConnection()); Statement stmt = getConnection().createStatement(); ResultSet rs = stmt.executeQuery("select * from t_user"); while(rs.next()){ System.out.println(rs.getString(2)+ ": "+ rs.getInt(1)); } } }