mystruts
|-- WEB-INF
| |-- lib
| | |-- struts.jar
| |-- classes
| | |-- ConnectionPool
| | | |-- getDbConnection.class
| | |-- mystruts
| | | |-- user1Action.class
| | | |-- userAction.class
| | | |-- userActionForm.class
| | | |-- userdao.class
| |-- struts-bean.tld
| |-- struts-config.xml
| |-- struts-html.tld
| |-- struts-logic.tld
| |-- struts-template.tld
|-- adduser.jsp
|-- index.jsp
|-- viewuser.jsp
在 tomcat/conf/Catalina/localhost 建立 mystruts.xml:
<Context path="/mystruts" docBase="D:\www\mystruts\mystruts\mystruts" debug="0" privileged="true">
<Resource name="jdbc/TestDB"
auth="Container"
type="javax.sql.DataSource"/>
<ResourceParams name="jdbc/TestDB">
<parameter>
<name>factory</name>
<value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
</parameter>
<parameter><name>maxActive</name><value>10</value></parameter>
<parameter><name>maxIdle</name><value>5</value></parameter>
<parameter><name>maxWait</name><value>10000</value></parameter>
<parameter><name>username</name><value>sa</value></parameter>
<parameter><name>password</name><value>test</value></parameter>
<parameter><name>driverClassName</name><value>net.sourceforge.jtds.jdbc.Driver</value></parameter>
<parameter><name>url</name><value>jdbc:jtds:sqlserver://192.168.10.223:1433/mystruts</value></parameter>
</ResourceParams>
</Context>
注意:請將 JDBC 驅動程式複製到 Tomcat 5.0/common/lib;struts.jar 放入 mystruts/WEB-INF/lib。
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE web-app PUBLIC "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
"https://java.sun.com/dtd/web-app_2_3.dtd">
<web-app>
<servlet>
<servlet-name>action</servlet-name>
<servlet-class>org.apache.struts.action.ActionServlet</servlet-class>
<init-param><param-name>debug</param-name><param-value>2</param-value></init-param>
<init-param><param-name>config</param-name><param-value>/WEB-INF/struts-config.xml</param-value></init-param>
<load-on-startup>2</load-on-startup>
</servlet>
<servlet-mapping>
<servlet-name>action</servlet-name>
<url-pattern>*.do</url-pattern>
</servlet-mapping>
<taglib><taglib-uri>/WEB-INF/struts-bean.tld</taglib-uri><taglib-location>/WEB-INF/struts-bean.tld</taglib-location></taglib>
<taglib><taglib-uri>/WEB-INF/struts-html.tld</taglib-uri><taglib-location>/WEB-INF/struts-html.tld</taglib-location></taglib>
<taglib><taglib-uri>/WEB-INF/struts-logic.tld</taglib-uri><taglib-location>/WEB-INF/struts-logic.tld</taglib-location></taglib>
<taglib><taglib-uri>/WEB-INF/struts-template.tld</taglib-uri><taglib-location>/WEB-INF/struts-template.tld</taglib-location></taglib>
</web-app>
配置完成,下一步將建立資料庫連線池 Bean 與資料表。