Spring指南

配置数据库连接

<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource" destroy-method="close">
		<property name="driverClassName">
			<value>com.mysql.jdbc.Driver</value>
		</property>
		<property name="url">
			<value>jdbc:mysql://localhost:3306/test1</value>
		</property>
		<property name="username">
			<value>root</value>
		</property>
		<property name="password">
			<value>password</value>
		</property>

public static void spring4() {
		ApplicationContext ctx = new FileSystemXmlApplicationContext(
				"src/main/resources/spring.xml");
		Connection conn = null;
		Statement stmt = null;
		DataSource dataSource=(BasicDataSource)ctx.getBean("dataSource");
		
		try {
			conn = dataSource.getConnection();
			stmt = conn.createStatement();
			stmt.executeUpdate("UPDATE test1 SET name = 'wwww'");
		} catch (SQLException e) {
			e.printStackTrace();
		} finally {
			if (stmt != null) {
				try {
					stmt.close();
				} catch (SQLException ex) {
					
				}
			}
			if (conn != null) {
				try {
					conn.close();
				} catch (SQLException ex) {
					
				}
			}
		}
	}