简单的struts应用开发（4）

简单的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);

}

}