1.txt

一个简单的struts 应用例子具体步骤代码

   userActionForm uaf=new userActionForm();
   PreparedStatement ps = null;
   String sql="select * from  myuser where user_id=?";
   try {
         ps = con.prepareStatement(sql);
         ps.setString(1,key.trim());
         rs=ps.executeQuery();
        if(rs.next())
           {
            uaf.setUser_id(rs.getString("user_id"));
            uaf.setUser_name(rs.getString("user_name"));
            uaf.setDep(rs.getString("dep"));
            uaf.setTel(rs.getString("tel"));
            uaf.setAction("edit");
           }
        }
        catch (SQLException e)
        {
         System.out.println("sql error");
        }
       finally
       {
        try{
               con.close();
               db.d_close();
             }
        catch(Exception e) {}
        }
      System.out.println("mod"+key);
     return uaf;
    }
  //----------------------------------------
  public void delUser(String key)
   {
   db=new getDbConnection();
   con=db.getCon();
   PreparedStatement ps = null;
   String sql="delete  from  myuser where user_id=?";
   try {
         ps = con.prepareStatement(sql);
         ps.setString(1,key.trim());
         ps.executeUpdate();
        }
        catch (SQLException e)
        {
         System.out.println("sql error");
        }
       finally
       {
        try{
               con.close();
               db.d_close();
             }
        catch(Exception e) {}
        }
      System.out.println("del"+key);
    }
   //----------------------------------
  public Collection getAlluser()
  {
   db=new getDbConnection();
   con=db.getCon();
   ResultSet rs=null;
   userActionForm uaf=new userActionForm();
   PreparedStatement ps = null;

   ArrayList rslist = new ArrayList();

   String sql="select * from myuser u,mydep d where u.dep=d.dep_id";
   try {
         ps = con.prepareStatement(sql);
         rs=ps.executeQuery();
        while(rs.next())
           {
            HashMap rscol = new HashMap();
            rscol.put("user_id",rs.getString("user_id"));
            rscol.put("user_name",rs.getString("user_name"));
            rscol.put("dep",rs.getString("dep"));
            rscol.put("dep_name",rs.getString("dep_name"));
            rscol.put("tel",rs.getString("tel"));
            rslist.add(rscol);
           }
        }
        catch (SQLException e)
        {
         System.out.println("sql error");
        }
       finally
       {
        try{
               con.close();
               db.d_close();
             }
        catch(Exception e) {}
        }
     return rslist;
    }
   //----------------------------------
}

第五步:建立Action  (userAction.java)

这里我们将建产两个Action .
 
userAction.java 将完成以下工作.
1.添加(前期数据准备. 主是提取部门资料.并传递给adduser.jsp)
2.修改(前期数据准备)
3.删除
4.查看所有用户资料.

user1Action.java 将完成以下工作
1.添加用户(对myuser表操作)
2.修改用户(对myuser表操作)

package mystruts;

import org.apache.struts.action.*;
import javax.servlet.http.*;
import mystruts.*;
import java.util.*;
import java.sql.*;
import ConnectionPool.*;

public class userAction extends Action {
  public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse)  throws Exception
  {
   userdao dao=new userdao();
   HttpServletRequest request=httpServletRequest;
   String action;
   if(request.getParameter("action").equals("") || request.getParameter("action")==null)
   {
     action="add";
   }
   else
   {
     action=request.getParameter("action");
   }
  if(action.equals("add"))
  {
    request.setAttribute("dep",this.getDep());
    return (actionMapping.findForward("add"));
  }
  if(action.equals("edit"))
  {
   String key=request.getParameter("key");
   request.setAttribute("dep",this.getDep());
   request.setAttribute("userActionForm",dao.getUser(key));
   return (actionMapping.findForward("add"));
  }
  if(action.equals("del"))
    {
      String key=request.getParameter("key");
      dao.delUser(key);
     return (actionMapping.findForward("delview"));
    }
  if(action.equals("view"))
    {
     request.setAttribute("rs",dao.getAlluser());
     return (actionMapping.findForward("view"));
    }

   return null;
  }
  //---------------------------------------------
  public  Collection getDep()
  {
   getDbConnection db=new getDbConnection();
   Connection con=db.getCon();
   ResultSet rs=null;

   PreparedStatement ps = null;

   ArrayList rslist = new ArrayList();

   String sql="select * from mydep";
   try {
         ps = con.prepareStatement(sql);
         rs=ps.executeQuery();
        while(rs.next())
           {
            HashMap rscol = new HashMap();
            rscol.put("id",rs.getString("dep_id"));
            rscol.put("name1",rs.getString("dep_name"));
            rslist.add(rscol);
           }
        }
        catch (SQLException e)
        {
         System.out.println("sql error");
        }
       finally
       {
        try{
               con.close();
               db.d_close();
             }
        catch(Exception e) {}
        }
     return rslist;
   }
}

 

package mystruts;

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

public class user1Action extends Action {
  public ActionForward execute(ActionMapping actionMapping, ActionForm actionForm, HttpServletRequest httpServletRequest, HttpServletResponse httpServletResponse) throws Exception
  {
    userActionForm uaf = (userActionForm) actionForm;
    if(uaf.getAction().equals("add"))
    {
      new userdao().userInsert(uaf);
      return (actionMapping.findForward("view"));
    }
    if(uaf.getAction().equals("edit"))
    {
      new userdao().userUpdate(uaf);
      return (actionMapping.findForward("view"));
    }
  return null;
  }
}


第六步:建立JSP视图页面 (主要有两个jsp文件. 添加页面. adduser.jsp 查看页面 viewuser.jsp)

adduser.jsp

<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-template.tld" prefix="template" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ page contentType="text/html; charset=gb2312" %>
<html:html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>
adduser
</title>
</head>
<body>
<h1> </h1>
<p>
<html:form action="/user1Action.do" method="POST">
<html:hidden property="action"/>
<br>
部门:
 <html:select property="dep">
     <html:options collection="dep" property="id" labelProperty="name1"/>
 </html:select>
<br>
ID:
<logic:equal name="userActionForm" property="action" scope="request" value="add">
<html:text property="user_id"/>
</logic:equal>
<logic:equal name="userActionForm" property="action" scope="request" value="edit">
<html:text property="user_id" readonly="true"/>
</logic:equal>
<br>
名字:<html:text property="user_name"/>
<br>
电话:<html:text property="tel"/>
<br>
<html:submit property="submit" value="Submit"/><br>
<html:reset value ="Reset"/>
</html:form>
</body>
</html:html>

viewuser.jsp

<%@ taglib uri="/WEB-INF/struts-logic.tld" prefix="logic" %>
<%@ taglib uri="/WEB-INF/struts-template.tld" prefix="template" %>
<%@ taglib uri="/WEB-INF/struts-bean.tld" prefix="bean" %>
<%@ taglib uri="/WEB-INF/struts-html.tld" prefix="html" %>
<%@ page contentType="text/html; charset=GBK" %>
<html:html>
<head>
<title>
viewuser
</title>
</head>
<body>
<div align="center"><a href="userAction.do?action=add">add </a></div>
<table width="60%" border="1" align="center">
  <tr bgcolor="#CCCCCC">
    <td>ID</td>
    <td>user_name</td>
    <td>dep</td>
    <td>tel</td>
    <td>modify</td>
    <td>del</td>
  </tr>
  <logic:iterate name="rs" id="user" scope="request" type="java.util.HashMap">
  <tr>
    <td><bean:write name="user" property="user_id"/> </td>
    <td><bean:write name="user" property="user_name"/> </td>
    <td><bean:write name="user" property="dep_name"/> </td>
    <td><bean:write name="user" property="tel"/> </td>
    <td><a href="userAction.do?action=edit&key=<bean:write name="user" property="user_id"/>">modify</a></td>
    <td><a href="userAction.do?action=del&key=<bean:write name="user" property="user_id"/>">del</a></td>
  </tr>
  </logic:iterate>
</table>
</body>
</html:html>

建产一个转向页面 (index.jsp)
<%@ page contentType="text/html; charset=gb2312" %>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
</head>

<body>
<% response.sendRedirect("userAction.do?action=view"); %>
</body>
</html>

递七步:建立struts配置文件 (WEB-INF/config-struts.xml)

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE struts-config PUBLIC "-//Apache Software Foundation//DTD Struts Configuration 1.1//EN" "http://jakarta.apache.org/struts/dtds/struts-config_1_1.dtd">
<struts-config>
  <form-beans>
    <form-bean name="userActionForm" type="mystruts.userActionForm" />
  </form-beans>
  <action-mappings>
    <action type="mystruts.userAction" scope="request" path="/userAction">
      <forward name="view" path="/viewuser.jsp" />
      <forward name="add" path="/adduser.jsp" />
      <forward name="delview" path="/userAction.do?action=view" />
    </action>
    <action name="userActionForm" type="mystruts.user1Action" scope="request" path="/user1Action">
      <forward name="view" path="/userAction.do?action=view" />
    </action>
  </action-mappings>
</struts-config>

运行程序:
启动tomcat
启动IE  在地址栏中输入:http://localhost:8080/mystruts

OK.....