当前页面: 开发资料首页 → 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