十、建立读取留言信息的Action
1、建立GuestBookJavaBean
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;
  }

}
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);
      
/**
        * 执行SQL语句,获取留言记录,这里将返回的每一个元素保存在Guestbook当中
        * 得到一个List,将来我们对List进行操作时的对象,就是一个Guestbook 类型的对象
        */

      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>
十二、读取留言的结果
 
十三、在保存留言后自动进入读取留言页面
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>
 
3、修改InputAction.java文件
 
//保存后自动转向到读取留言页面
return mapping.findForward("guestbook.read");