在struts-config.xml文件增加新节点
xml 代码
- <data-sources>
- <data-source type="org.apache.commons.dbcp.BasicDataSource">
- <set-property value="com.mysql.jdbc.Driver" property="driverClassName" />
- <set-property value="jdbc:mysql://localhost:3306/db_mysql" property="url" />
- <set-property value="root" property="username" />
- <set-property value="" property="password" />
- <set-property property="driverClass" value="true"/>
- <set-property property="readOnly" value="false"/>
- <set-property property="autoCommit" value="false"/>
- <set-property property="minCount" value="1"/>
- <set-property property="maxCount" value="10"/>
- /data-source>
- data-sources>
并在Action文件中增加以下内容:
java 代码
- public ActionForward execute(ActionMapping mapping, ActionForm form,
- HttpServletRequest request, HttpServletResponse response) {
- // TODO Auto-generated method stub
- javax.sql.DataSource ds = getDataSource(request);
- Connection conn = null;
- ResultSet rs = null;
- Statement st = null;
- try{
- conn = ds.getConnection();
- st = conn.createStatement();
- rs = st.executeQuery("select * from user01");
- request.setAttribute("rs", rs);
- }catch(Exception e){
- e.printStackTrace();
- }
- return mapping.findForward("forward");
- }