<?xml version="1.0" encoding="GBK"?>
<beans xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
   xmlns="http://www.springframework.org/schema/beans"
   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">
   <!-- PropertyPlaceholderConfigurer是一個容器后處理器，它會讀取
   屬性文件信息，并將這些信息設(shè)置成Spring配置文件的數(shù)據(jù)。 -->
   <bean class=
      "org.springframework.beans.factory.config.PropertyPlaceholderConfigurer">
      <property name="locations">
        <list>
           <value>dbconn.properties</value>
           <!-- 如果有多個屬性文件,依次在下面列出來 -->
           <!--value>wawa.properties</value-->
        </list>
      </property>
   </bean>
   <!-- 定義數(shù)據(jù)源Bean，使用C3P0數(shù)據(jù)源實現(xiàn) -->
   <bean id="dataSource" class="com.mchange.v2.c3p0.ComboPooledDataSource"
      destroy-method="close"
      p:driverClass="${jdbc.driverClassName}"
      p:jdbcUrl="${jdbc.url}"
      p:user="${jdbc.username}"
      p:password="${jdbc.password}"/>
</beans>

jdbc.driverClassName=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/spring
jdbc.username=root
jdbc.password=32147

package lee;
import javax.sql.DataSource;
import java.sql.*;
import org.springframework.context.*;
import org.springframework.context.support.*;
public class BeanTest
{
  public static void main(String[] args)throws Exception
  {
    ApplicationContext ctx = new
      ClassPathXmlApplicationContext("beans.xml");
    DataSource ds = (DataSource)ctx.getBean("dataSource");
    Connection conn = ds.getConnection();
    PreparedStatement pstmt = conn.prepareStatement(
      "insert into news_inf value(null , ? , ?)");
    pstmt.setString(1 , "瘋狂Java講義1");
    pstmt.setString(2 , "Struts 2權(quán)威指南2");
    pstmt.executeUpdate();
    pstmt.close();
    conn.close();
  }
}