简单的Struts应用开发（4）

第五步:建立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;

}

}

（未完待续）