<data-sources>
<data-source key="helodata" type="org.apache.commons.dbcp.BasicDataSource">
<set-property
                  property="driverClassName"
                  value="com.microsoft.jdbc.sqlserver.SQLServerConnection" />
                <set-property
                  property="url"
                  value="jdbc:microsoft:sqlserver://192.168.14.10:1433;DatabaseName=jorwoobook" />
                <set-property
                  property="username"
                  value="sa" />
                <set-property
                  property="password"
                  value="dba" />
                <set-property
                  property="maxActive"
                  value="10" />
                <set-property
                  property="maxWait"
                  value="5000" />
                <set-property
                  property="defaultAutoCommit"
                  value="false" />
                <set-property
                  property="defaultReadOnly"
                  value="false" />
                <set-property
                  property="validationQuery"
                  value="SELECT COUNT(*) FROM storeuser" />
        </data-source>
    </data-sources>
先在Struts-config.xml中配置数据源连接池然后在action里面
DataSource ds = getDataSource(request);
就可以得到数据源
然后ds.getConnection() 就可以得到连接