1
创建Sping环境。
在SPring容器里,配置DataSource,数据源。
<?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:p="http://www.springframework.org/schema/p"
xsi:schemaLocation="http://www.springframework.org/schema/beans http://www.springframework.org/schema/beans/spring-beans-4.0.xsd">
<bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource">
<property name="driverClass" value="com.mysql.jdbc.Driver"></property>
<property name="jdbcUrl" value="jdbc:mysql://localhost/news"/>
<property name="user" value="root"/>
<property name="password" value="admin"/>
<property name="maxPoolSize" value="200"/>
<property name="minPoolSize" value="2"/>
<property name="initialPoolSize" value="2"/>
<property name="maxIdleTime" value="200"/>
</bean>
</beans>
2
编写测试类:
package test;
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 BeanTest {
public static void main(String args[])throws Exception{
ApplicationContext ctx=new ClassPathXmlApplicationContext("beans.xml");
DataSource ds=ctx.getBean("dataSource",DataSource.class);
Connection conn=ds.getConnection();
PreparedStatement pstmt=conn.prepareStatement("insert into news values(?,?)");
pstmt.setInt(1, 12);
pstmt.setString(2, "tan");
pstmt.executeUpdate();
if(pstmt!=null) pstmt.close();
if(conn!=null) conn.close();
}
}
测试查看数据库。
数据库的脚本:
create database news ;use news ;create table news(id int(10),name varchar(20));