当前页面: 开发资料首页 → Java 专题 → 给Struts配一个Access数据库源

给Struts配一个Access数据库源

摘要: 给Struts配一个Access数据库源

</td> </tr> <tr> <td height="35" valign="top" class="ArticleTeitle">
一、准备工作
在access中创建数据库eBookStore.mdb和表book（从本站下载），并在windows控制面板中设置好数据源page

<table width="681" height="24" border="0"> <tr> <td width="412">指向eBookStore.mdb。另有三个需要的jar文件：

1、commons-dbcp-1.2.1.jar
下载地址：http://apache.linuxforum.net/dist/jakarta/commons/dbcp/binaries/

2、struts-legacy.jar
下载地址：http://apache.linuxforum.net/dist/jakarta/struts/struts-legacy/

3、commons-pool-1.2.jar
下载地址：http://apache.linuxforum.net/dist/jakarta/commons/pool/binaries/

二、struts-config.xml配置
<?xml version="1.0" encoding="ISO-8859-1" ?> </td> <td width="259"> </td> </tr> </table>
struts-config PUBLIC
"-//Apache Software Foundation//DTD Struts Configuration 1.2//EN"
"http://jakarta.apache.org/struts/dtds/struts-config_1_2.dtd">

<form-beans>
</form-beans>

三、Action类：DataSourceAction.java

package page;
import org.apache.struts.action.*;
import javax.servlet.http.*;

import java.util.*;
import javax.sql.*;
import java.sql.*;

public class DataSourceAction extends Action {

public DataSourceAction(){}

public ActionForward execute(ActionMapping mapping, ActionForm form, HttpServletRequest request,
HttpServletResponse response) throws Exception {
try{
DataSource ds=this.getDataSource(request,"dataSource");
Connection con = ds.getConnection();
Statement stmt = con.createStatement();
String sql = "SELECT * FROM book";
ResultSet rs = stmt.executeQuery(sql);
request.setAttribute("result",rs);
}catch(Exception e){
e.printStackTrace();
System.out.println("数据库连接出现异常");
}

return (mapping.findForward("success"));
}
}

四、测试页:testpage.jsp

<%@ page contentType="text/html; charset=gb2312" language="java"%>
<%@ page import="java.sql.*" %>

<%
ResultSet rs =(ResultSet)request.getAttribute("result");
while(rs.next()){
out.println(rs.getString("name")+"-----");
out.println(rs.getString("author")+"
");
}
%>

OK!!!!

五。测试：
从本站下载测试的目录结构TestPage,放入tomcat的webapps目录下，在浏览器中输入：
http://127.0.0.1:8080/TestPage/page.do

function TempSave(ElementID) { CommentsPersistDiv.setAttribute("CommentContent",document.getElementById(ElementID).value); CommentsPersistDiv.save("CommentXMLStore"); } function Restore(ElementID) { CommentsPersistDiv.load("CommentXMLStore"); document.getElementById(ElementID).value=CommentsPersistDiv.getAttribute("CommentContent"); } </td> </tr> <tr>

↑返回目录
前一篇: struts中的分页实例
后一篇: struts编程学习-标签logic:iterate