用Eclipse开发Struts实例-G
十、建立读取留言信息的Action类
1、建立GuestBook的JavaBean类
package com.meixin.beans;
public class Guestbook
{
private int id;
private String name;
private String email;
private String url;
private String content;
private String title;
private String time;
public String getTime()
{
return time;
}
public void setTime(String time)
{
this.time = time;
}
//id是主键,不提供set方法
public int getId()
{
return id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public String getEmail()
{
return email;
}
public void setEmail(String email)
{
this.email = email;
}
public String getUrl()
{
return url;
}
public void setUrl(String url)
{
this.url = url;
}
public String getContent()
{
return content;
}
public void setContent(String content)
{
this.content = content;
}
public String getTitle()
{
return title;
}
public void setTitle(String title)
{
this.title = title;
}
}
public class Guestbook
{
private int id;
private String name;
private String email;
private String url;
private String content;
private String title;
private String time;
public String getTime()
{
return time;
}
public void setTime(String time)
{
this.time = time;
}
//id是主键,不提供set方法
public int getId()
{
return id;
}
public String getName()
{
return name;
}
public void setName(String name)
{
this.name = name;
}
public String getEmail()
{
return email;
}
public void setEmail(String email)
{
this.email = email;
}
public String getUrl()
{
return url;
}
public void setUrl(String url)
{
this.url = url;
}
public String getContent()
{
return content;
}
public void setContent(String content)
{
this.content = content;
}
public String getTitle()
{
return title;
}
public void setTitle(String title)
{
this.title = title;
}
}
2、读取留言的Action类
package com.meixin.struts.action;
import java.sql.SQLException;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.Http.httpservletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionFORM;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.meixin.beans.Guestbook;
public class ReadAction extends Action
{
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
{
// 读取留言的SQL语句,以id降序排列,后发的留言先显示
String sql = "select * from guestbook order by id desc";
try
{
// 建立上下文对象,初始化
Context context = new InitialContext();
// 获取数据源,在Tomcat中的context.xml中设置的数据源名字要一样
DataSource ds = (DataSource) context
.lookup("java:/comp/env/jdbc/mssqlds");
// 获取数据库的连接
// ds.getConnection();
// 用QueryRunner封装数据源,这个类完成了许多数据库的操作
QueryRunner qr = new QueryRunner(ds);
List list = (List) qr.query(sql, new BeanListHandler(
Guestbook.class));
for(int i = 0;i<list.size();i++)
{
System.out.println(((Guestbook)list.get(i)).getName());
}
// 用request.setAttribute()将结果传入到jsP页面中
request.setAttribute("list", list);
}
catch (NamingException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
//转向forward值为guestbook.display对应的页面
return mapping.findForward("guestbook.display");
}
}
import java.sql.SQLException;
import java.util.List;
import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.Http.httpservletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;
import org.apache.commons.dbutils.QueryRunner;
import org.apache.commons.dbutils.handlers.BeanListHandler;
import org.apache.struts.action.Action;
import org.apache.struts.action.ActionFORM;
import org.apache.struts.action.ActionForward;
import org.apache.struts.action.ActionMapping;
import com.meixin.beans.Guestbook;
public class ReadAction extends Action
{
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response)
{
// 读取留言的SQL语句,以id降序排列,后发的留言先显示
String sql = "select * from guestbook order by id desc";
try
{
// 建立上下文对象,初始化
Context context = new InitialContext();
// 获取数据源,在Tomcat中的context.xml中设置的数据源名字要一样
DataSource ds = (DataSource) context
.lookup("java:/comp/env/jdbc/mssqlds");
// 获取数据库的连接
// ds.getConnection();
// 用QueryRunner封装数据源,这个类完成了许多数据库的操作
QueryRunner qr = new QueryRunner(ds);
List list = (List) qr.query(sql, new BeanListHandler(
Guestbook.class));
for(int i = 0;i<list.size();i++)
{
System.out.println(((Guestbook)list.get(i)).getName());
}
// 用request.setAttribute()将结果传入到jsP页面中
request.setAttribute("list", list);
}
catch (NamingException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
catch (SQLException e)
{
// TODO Auto-generated catch block
e.printStackTrace();
}
//转向forward值为guestbook.display对应的页面
return mapping.findForward("guestbook.display");
}
}
十一、建立display.jsp文件
<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>显示留言</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keyWords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/CSS" href="styles.css">
-->
</head>
<body>
<!-- 用c:forEach循环输出在Action中setAttribute()方法传来的list中的值 -->
<c:forEach items="${requestScope.list }"
var="article">
<c:out value="${article.id}"></c:out>
<c:out value="${article.name}"></c:out>
<c:out value="${article.email}"></c:out>
<c:out value="${article.url}"></c:out>
<c:out value="${article.title}"></c:out>
<c:out value="${article.content}"></c:out>
<c:out value="${article.time}"></c:out>
<br>
<br>
</c:forEach>
<br>
</body>
</html>
<%@ taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%>
<%
String path = request.getContextPath();
String basePath = request.getScheme() + "://"
+ request.getServerName() + ":" + request.getServerPort()
+ path + "/";
%>
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<base href="<%=basePath%>">
<title>显示留言</title>
<meta http-equiv="pragma" content="no-cache">
<meta http-equiv="cache-control" content="no-cache">
<meta http-equiv="expires" content="0">
<meta http-equiv="keyWords" content="keyword1,keyword2,keyword3">
<meta http-equiv="description" content="This is my page">
<!--
<link rel="stylesheet" type="text/CSS" href="styles.css">
-->
</head>
<body>
<!-- 用c:forEach循环输出在Action中setAttribute()方法传来的list中的值 -->
<c:forEach items="${requestScope.list }"
var="article">
<c:out value="${article.id}"></c:out>
<c:out value="${article.name}"></c:out>
<c:out value="${article.email}"></c:out>
<c:out value="${article.url}"></c:out>
<c:out value="${article.title}"></c:out>
<c:out value="${article.content}"></c:out>
<c:out value="${article.time}"></c:out>
<br>
<br>
</c:forEach>
<br>
</body>
</html>
十二、读取留言的结果
十三、在保存留言后自动进入读取留言页面
1、建立forward
2、struts-config.xml内容如下
已在struts-config.xml加入了以下代码
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
<form-beans>
<form-bean name="inputForm"
type="org.apache.struts.validator.DynaValidatorForm">
<form-property name="title" type="java.lang.String" />
<form-property name="content" type="java.lang.String" />
<form-property name="url" type="java.lang.String" />
<form-property name="email" type="java.lang.String" />
<form-property name="name" type="java.lang.String" />
</form-bean>
</form-beans>
<global-exceptions />
<global-forwards>
<forward name="guestbook.display" path="/form/display.jsp" />
<forward name="guestbook.read" path="/read.do" redirect="true" />
</global-forwards>
<action-mappings>
<action attribute="inputForm" input="/form/input.jsp"
name="inputForm" path="/input" scope="request"
type="com.meixin.struts.action.InputAction" />
<action name="readForm" path="/read"
type="com.meixin.struts.action.ReadAction" />
</action-mappings>
<message-resources
parameter="com.meixin.struts.ApplicationResources" />
<!-- 加入Struts的一个插件,对表单进行验证,这里只能手动添加 -->
<plug-in className="org.apache.struts.validator.ValidatorPlugIn">
<set-property property="pathnames"
value="/org/apache/struts/validator/validator-rules.xml,/WEB-INF/validations.xml" />
</plug-in>
</struts-config>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.3//EN" "http://struts.apache.org/dtds/struts-config_1_3.dtd">
<struts-config>
<form-beans>
<form-bean name="inputForm"
type="org.apache.struts.validator.DynaValidatorForm">
<form-property name="title" type="java.lang.String" />
<form-property name="content" type="java.lang.String" />
<form-property name="url" type="java.lang.String" />
<form-property name="email" type="java.lang.String" />
<form-property name="name" type="java.lang.String" />
</form-bean>
</form-beans>
<global-exceptions />
<global-forwards>
<forward name="guestbook.display" path="/form/display.jsp" />
<forward name="guestbook.read" path="/read.do" redirect="true" />
</global-forwards>
<action-mappings>
<action attribute="inputForm" input="/form/input.jsp"
name="inputForm" path="/input" scope="request"
type="com.meixin.struts.action.InputAction" />
<action name="readForm" path="/read"
type="com.meixin.struts.action.ReadAction" />
</action-mappings>
<message-resources
parameter="com.meixin.struts.ApplicationResources" />
<!-- 加入Struts的一个插件,对表单进行验证,这里只能手动添加 -->
<plug-in className="org.apache.struts.validator.ValidatorPlugIn">
<set-property property="pathnames"
value="/org/apache/struts/validator/validator-rules.xml,/WEB-INF/validations.xml" />
</plug-in>
</struts-config>
3、修改InputAction.java文件
//保存后自动转向到读取留言页面
return mapping.findForward("guestbook.read");
return mapping.findForward("guestbook.read");
相关文章