使用Struts管理数据源

引言：需要加入commons-dbcp-xxx.jar ,commons-pool-xxx.jar 和commons-collections-xxx.jar 文件

1.配置Struts-config.xml

  <data-sources>
   <data-source key="mysqlDatabase" type="org.apache.commons.dbcp.BasicDataSource">
   <!-- set the  driver of database  -->
    <set-property property="driverClassName" value="com.mysql.jdbc.Driver"/>
    <!-- set database url -->
    <set-property property="url" value="jdbc:mysql://localhost:3306/strutsdemo"/>
    <!-- set connection pool max connectcount -->
    <set-property property="maxCount" value="5"/>
    <!-- set connection pool mix connectcount -->
    <set-property property="mixCount" value="1"/>
    <!-- set connection pool max active  connectcount -->
    <set-property property="maxActive" value="5"/>
    <!-- set connection pool max idle  connectcount -->
    <set-property property="maxIdle" value="500"/>
    <!-- set connection pool max waiting connectcount -->
    <set-property property="maxWait" value="1000"/>
    <!-- set database username -->
    <set-property property="username" value="root"/>
    <!-- set database userpassword -->
    <set-property property="password" value="root"/>
   </data-source>
  </data-sources>

2.通过jsp页面访问该数据源(不推荐)

 DataSource ds = (DataSource)application.getAttribute("mysqlDatabase");
 Connection conn = ds.getConnection();
 Statement stmt = conn.createStatement();
 String sql = "select * from userinfo";
 ResultSet rs = stmt.executeQuery(sql);
 while(rs.next()){
  out.print(rs.getInt(1));
  out.print(rs.getString(2));
  out.print(rs.getString(3));
 }