我的:在 struts-config里写:
<data-sources>
<data-source key="xxxx" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="url"
value="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=xxxxx"/>
<set-property property="maxActive"
value="5" />
<set-property property="username"
value="xx" />
<set-property property="password"
value="xx" />
<set-property property="autoCommit"
value="true" />
</data-source>
</data-sources>
<data-sources>
<data-source key="xxxx" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="driverClassName"
value="com.microsoft.jdbc.sqlserver.SQLServerDriver" />
<set-property property="url"
value="jdbc:microsoft:sqlserver://127.0.0.1:1433;DatabaseName=xxxxx"/>
<set-property property="maxActive"
value="5" />
<set-property property="username"
value="xx" />
<set-property property="password"
value="xx" />
<set-property property="autoCommit"
value="true" />
</data-source>
</data-sources>
楼主觉得那个容易配置就用哪个(建议用struts的配置,这样产生的datasource是和你的具体应用绑定的).连接池开源产品还有很多,如c3p0,proxypool等.个人比较喜欢c3p0.