使用Spring连接mysql数据库

来源：互联网发布：阿里妈妈淘宝卖家编辑：程序博客网时间：2024/05/16 04:30

本例是使用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/beanshttp://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 {//insertpublic 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();}}