spring下连接mysql_使用Spring连接mysql数据库

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

spring bean 文件 my_connection.xml

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">

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();

}

}