3个包:可以到apche去下载 commons-dpcp,commons-pool ,servlet-api.
在struts-config.xml中配置是:
<data-sources>
<data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="url" value="jdbc:mysql://127.0.0.1:3306/jxtv3" />
<set-property property="username" value="root" />
<set-property property="password" value="1234" />
<set-property property="minCount" value="1" />
<set-property property="maxCount" value="10" />
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
</data-source>
</data-sources>
在struts中应用:
javax.sql.DataSource ds = null;
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
ds = getDataSource(request);
conn = ds.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
java.sql.ResultSet rs = stmt
.executeQuery("SELECT * FROM zjy_tb ORDER BY id");
while (rs.next()) {
System.out.println(rs.getString(1));
}
// return null;
request.getSession().setAttribute("conn",ds);
return mapping.findForward("ok");
}
在struts-config.xml中配置是:
<data-sources>
<data-source key="org.apache.struts.action.DATA_SOURCE" type="org.apache.commons.dbcp.BasicDataSource">
<set-property property="url" value="jdbc:mysql://127.0.0.1:3306/jxtv3" />
<set-property property="username" value="root" />
<set-property property="password" value="1234" />
<set-property property="minCount" value="1" />
<set-property property="maxCount" value="10" />
<set-property property="driverClassName" value="com.mysql.jdbc.Driver" />
</data-source>
</data-sources>
在struts中应用:
javax.sql.DataSource ds = null;
java.sql.Connection conn = null;
java.sql.Statement stmt = null;
ds = getDataSource(request);
conn = ds.getConnection();
stmt = conn.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,
ResultSet.CONCUR_READ_ONLY);
java.sql.ResultSet rs = stmt
.executeQuery("SELECT * FROM zjy_tb ORDER BY id");
while (rs.next()) {
System.out.println(rs.getString(1));
}
// return null;
request.getSession().setAttribute("conn",ds);
return mapping.findForward("ok");
}