一、准备工作
   在access中创建数据库eBookStore.mdb和表book（从本站下载），并在windows控制面板中设置好数据源page

指向eBookStore.mdb。另有三个需要的jar文件：

1、commons-dbcp-1.2.1.jar
下载地址：http://apache.linuxforum.net/dist/jakarta/commons/dbcp/binaries/ 

2、struts-legacy.jar
下载地址：
http://apache.linuxforum.net/dist/jakarta/struts/struts-legacy/ 

3、commons-pool-1.2.jar
下载地址：http://apache.linuxforum.net/dist/jakarta/commons/pool/binaries/ 

二、struts-config.xml配置
<?xml version="1.0" encoding="ISO-8859-1" ?>  

<!DOCTYPE struts-config PUBLIC
          "-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
          "http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd">

<struts-config>
<data-sources>
   <data-source key="dataSource" type="org.apache.commons.dbcp.BasicDataSource">
            <set-property property="driverClassName" value="sun.jdbc.odbc.JdbcOdbcDriver" />
            <set-property property="url" value="jdbc:odbc:page" />
            <set-property property="username" value="admin" />
            <set-property property="password" value="" />
            <set-property property="maxActive" value="20" />
            <set-property property="maxWait" value="5000" />
            <set-property property="defaultAutoCommit" value="true" />
            <set-property property="defaultReadOnly" value="false" />
            <set-property property="validationQuery" value="SELECT 1" />
            <set-property property="removeAbandoned" value="true" />
            <set-property property="removeAbandonedTimeout" value="120" />            
            <set-property property="encoding" value="false" />            
        </data-source>

 </data-sources>
  <form-beans>
  </form-beans>
  <global-forwards>
  </global-forwards>
  <action-mappings>
  <action path="/page" type="page.DataSourceAction" scope="request">
  <forward name="success" path="/pagetest.jsp"/>
  </action>
  </action-mappings>
  <controller>
  </controller>
</struts-config>

三、Action类：DataSourceAction.java

package page;
import org.apache.struts.action.*;
import javax.servlet.http.*;

import java.util.*;
import javax.sql.*;
import java.sql.*;

public class DataSourceAction extends Action {

 public DataSourceAction(){}
 
 public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
 HttpServletResponse response) throws Exception {   
  try{
      DataSource ds=this.getDataSource(request,"dataSource");   
      Connection con = ds.getConnection();
      Statement stmt = con.createStatement();
      String sql = "SELECT * FROM book";
      ResultSet rs = stmt.executeQuery(sql); 
      request.setAttribute("result",rs);
   }catch(Exception e){
          e.printStackTrace();
          System.out.println("数据库连接出现异常");
      } 
   
     
         
          return (mapping.findForward("success"));
  } 
}

四、测试页:testpage.jsp

<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>

<%
   ResultSet rs =(ResultSet)request.getAttribute("result");
   while(rs.next()){
         out.println(rs.getString("name")+"-----");
         out.println(rs.getString("author")+"<br>");
   }
 %>

OK!!!!

五。测试：
    从本站下载测试的目录结构TestPage,放入tomcat的webapps目录下，在浏览器中输入：
     http://127.0.0.1:8080/TestPage/page.do