张新杰的blog

struts终于通了，写到这里：

1、struts-config.xml中配置：
 <data-sources>
  <data-source key="A" type="org.apache.commons.dbcp.BasicDataSource">
   <set-property property="description" value="Airline DB Connection config" />
   <set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
   <set-property property="maxCount" value="10" />
   <set-property property="url" value="jdbc:mysql://localhost/struts" /> 
   <set-property property="username" value="root" />
   <set-property property="password" value="root" />
   <set-property property="maxWait" value="5000" />
   <set-property property="defaultAutoCommit" value="false" />
   <set-property property="defaultReadOnly" value="false" />
  </data-source>
 </data-sources>

2、需要4个jar放到放到WEB-INF/lib/中，tomcat下的common/lib/中也放一份吧
名字：commons-collections.jar，commons-dbcp-1.2.1.jar，commons-pool.jar，mysql-connector-java-5.0.0-beta-bin.jar

3、写个简单的Action
public ActionForward execute(ActionMapping mapping, ActionForm form,
   HttpServletRequest request, HttpServletResponse response)
 {
  try {
   DataSource dataSourceA = getDataSource(request,"A");
   Connection myConnectionA = dataSourceA.getConnection();
   
   System.out.println("myConnectionA:"+myConnectionA);
   
  } catch (SQLException e) {
   e.printStackTrace();
  }
  return null;
 }

4、根据你的配置访问这个Action就可以了，后台打出Connection的对象