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