spring与数据库的连接简单版

public class BeanText {

public static void main(String[] args) throws Exception {

ApplicationContext acContext=new ClassPathXmlApplicationContext("bean.xml");

       //数据源

DataSource daSource=(DataSource) acContext.getBean("datasource",DataSource.class);

     //连接

Connection connection=daSource.getConnection();

    //解析

PreparedStatement pStatement=connection.prepareStatement("insert into mysl values(null,?,?)");
pStatement.setString(1, "666");
pStatement.setString(2, "888");
pStatement.executeUpdate();


if(pStatement!=null) pStatement.close();
if(connection!=null) connection.close();
}

}

<?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-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/my"></property>

<!--数据库用户名-->
<property name="User" value="root" />
<!-- 指定连接数据库的密码 -->
<property name="Password" value="" />

<property name="MinPoolSize" value="2"></property>
<property name="MaxPoolSize" value="200"></property>
<property name="InitialPoolSize" value="2"></property>
<property name="MaxIdleTime" value="200"></property>
</bean>