使用Spring连接mysql数据库

本例是使用spring定义数据源Bean，使用c3p0数据源实现连接

spring bean 文件 my_connection.xml

<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xmlns="http://www.springframework.org/schema/beans"
	xsi:schemaLocation="http://www.springframework.org/schema/beans
	http://www.springframework.org/schema/beans/spring-beans-3.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://localhost/java"/>
		<property name="user" value="root"/>
		<property name="password" value="root"/>
		<property name="maxPoolSize" value="40"/>
		<property name="minPoolSize" value="1"/>
		<property name="initialPoolSize" value="1"/>
		<property name="maxIdleTime" value="20"/>
	</bean>
</beans>

java测试文件

import java.sql.Connection;
import java.sql.PreparedStatement;

import javax.sql.DataSource;

import org.springframework.context.ApplicationContext;
import org.springframework.context.support.ClassPathXmlApplicationContext;


public class ConnectionTest {

	//insert
	public static void main(String[] args) throws Exception {
		ApplicationContext ctx=new ClassPathXmlApplicationContext("mysql_connection.xml");
		DataSource ds=ctx.getBean("dataSource", DataSource.class);
		Connection conn=ds.getConnection();
		PreparedStatement stmt=conn.prepareStatement("insert into city values(null,?,?,?)");
		stmt.setString(1, "广东省");
		stmt.setString(2, "深圳");
		stmt.setString(3, "南山");
		stmt.executeUpdate();
		
		if(stmt!=null)stmt.close();
		if(conn!=null)conn.close();
	}

}