spring容器获取DataSource对象，进行简单数据库应用

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