tiantao

一、下载必要的jar包。有四个包要下载（网上有贴子说只要下面前三个包就可以了，但我在配置的时候如果没有第四个包会报错）。
http://apache.linuxforum.net/dist/jakarta/commons/dbcp/binaries/commons-dbcp-1.2.zip
http://apache.linuxforum.net/dist/jakarta/commons/pool/binaries/commons-pool-1.2.zip
http://apache.linuxforum.net/dist/jakarta/struts/struts-legacy/struts-legacy-1.0.zip
http://apache.linuxforum.net/dist/jakarta/commons/collections/binaries/commons-collections-3.1.zip
把这四个jar包放到web应用的WEB-INF/lib目录下，还有要把DB2的驱动程序包也放到这里（在Tomcat也可以把数据库的驱动包放到%Tomcat_Home%/common/lib目录下或%Resin_Home%/lib目录下，这样在启动Web服务器的时候就会加载这个包，服务器和Web应用都可以使用驱动程序类。Websphere还不太清楚，摸索中……）

二、在struts-config.xml中添加Data Source

Xml代码 <data-sources>
<data-source key="datasource" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="db2admin" />
<set-property property="minCount" value="3" />
<set-property property="maxCount" value="10" />
<set-property property="username" value="db2admin" />
<set-property property="driverClassName"
value="COM.ibm.db2.jdbc.net.DB2Driver"/>
<set-property property="description" value="test" />
<set-property property="url"
value="jdbc:db2://localhost:6789/DB2ADMIN.TEST" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="true" />
</data-source>
</data-sources>

<data-sources>
<data-source key="datasource" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="password" value="db2admin" />
<set-property property="minCount" value="3" />
<set-property property="maxCount" value="10" />
<set-property property="username" value="db2admin" />
<set-property property="driverClassName"
value="COM.ibm.db2.jdbc.net.DB2Driver"/>
<set-property property="description" value="test" />
<set-property property="url"
value="jdbc:db2://localhost:6789/DB2ADMIN.TEST" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="true" />
</data-source>
</data-sources>
如果要配置多个data source，可以给每个data source指定不同的key，然后在程序中根据key指定要引用的数据源。

三、测试数据源。配置好以后就可以在ActionServlet中使用了 [color]

Java代码DataSource ds = getDataSource(request,"datasource");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SQL String");

DataSource ds = getDataSource(request,"datasource");
Connection conn = ds.getConnection();
Statement stmt = conn.createStatement();
ResultSet rs = stmt.executeQuery("SQL String");
[/color]
附： Struts1.1中struts-config.xml的配置(as follows)：
Xml代码
[color]
<data-sources >
<data-source key="datasource" type="org.apache.struts.util.GenericDataSource">
<set-property property="password" value="db2admin" />
<set-property property="minCount" value="2" />
<set-property property="maxCount" value="10" />
<set-property property="user" value="db2admin" />
<set-property property="driverClass"
value="COM.ibm.db2.jdbc.net.DB2Driver"/>
<set-property property="description" value="test" />
<set-property property="url"
value="jdbc:db2://localhost:6789/DB2ADMIN.TEST" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="true" />
</data-source>
</data-sources>

<data-sources >
<data-source key="datasource" type="org.apache.struts.util.GenericDataSource">
<set-property property="password" value="db2admin" />
<set-property property="minCount" value="2" />
<set-property property="maxCount" value="10" />
<set-property property="user" value="db2admin" />
<set-property property="driverClass"
value="COM.ibm.db2.jdbc.net.DB2Driver"/>
<set-property property="description" value="test" />
<set-property property="url"
value="jdbc:db2://localhost:6789/DB2ADMIN.TEST" />
<set-property property="readOnly" value="false" />
<set-property property="autoCommit" value="true" />
</data-source>
</data-sources>[/color]
注意：1.2和1.1在配置上不一样的地方
Java代码
<data-source key="datasource" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="username" value="db2admin" />
<set-property property="driverClassName" value="COM.ibm.db2.jdbc.net.DB2Driver" />