<data-sources>
<data-source type="org.apache.commons.dbcp.BasicDataSource" key="dataSource">
<set-property value="com.microsoft.jdbc.sqlserver.SQLServerDriver" property="driverClassName" />
<set-property value="jdbc:microsoft:sqlserver://172.25.15.143;DatabaseName=TEST" property="url" />
<set-property value="10" property="maxCount" />
<set-property value="3" property="minCount" />
<set-property value="sa" property="username" />
<set-property value="as" property="password" />
</data-source>
public class ConnectionPool extends Action{
public ConnectionPool() {
}
protected Connection connectionPool(HttpServletRequest request) {
Connection conn = null;
try {
DataSource ds = this.getDataSource(request,"dataSource");
conn = ds.getConnection();
return conn;
}
catch (SQLException ex) {
System.out.println("Database connection is failure : " + ex.getMessage());
return null;
}
}
<data-source type="org.apache.commons.dbcp.BasicDataSource" key="dataSource">
<set-property value="com.microsoft.jdbc.sqlserver.SQLServerDriver" property="driverClassName" />
<set-property value="jdbc:microsoft:sqlserver://172.25.15.143;DatabaseName=TEST" property="url" />
<set-property value="10" property="maxCount" />
<set-property value="3" property="minCount" />
<set-property value="sa" property="username" />
<set-property value="as" property="password" />
</data-source>
public class ConnectionPool extends Action{
public ConnectionPool() {
}
protected Connection connectionPool(HttpServletRequest request) {
Connection conn = null;
try {
DataSource ds = this.getDataSource(request,"dataSource");
conn = ds.getConnection();
return conn;
}
catch (SQLException ex) {
System.out.println("Database connection is failure : " + ex.getMessage());
return null;
}
}
好像是这里错了
你试试我上面的,是可以的