<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() 就可以得到连接
<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() 就可以得到连接
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货