?? adminmemberaction.java
字號:
?
+
/*
* 作者:荊明君
* 時間:2007年12月15日
* 功能:平臺操作人員管理-添加刪除和瀏覽平臺操作人員(賬戶管理)。
*/
package com.mole.struts.action;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.HttpSession;
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.mole.struts.bean.AdminMemberBean;
import com.mole.struts.dao.AdminMemberDAO;
import com.mole.struts.form.AdminMemberForm;
/**
* MyEclipse Struts Creation date: 12-15-2007
*
* XDoclet definition:
*
* @struts.action path="/adminMemberInfo" name="adminMemberInfoForm"
* input="/adminMemberInfo.jsp" scope="request" validate="true"
*/
public class AdminMemberAction extends Action {
/*
* Generated Methods
*/
/**
* Method execute
*
* @param mapping
* @param form
* @param request
* @param response
* @return ActionForward
*/
public ActionForward execute(ActionMapping mapping, ActionForm form,
HttpServletRequest request, HttpServletResponse response) {
String loginId = (String) request.getSession().getAttribute("user");
AdminMemberDAO dao = new AdminMemberDAO();
if (!dao.checkRole(loginId)) {
HttpSession session = request.getSession();
session.setAttribute("title", "錯誤信息");
session.setAttribute("message", "你無權限或訪問失敗!");
session.setAttribute("returnUrl", "show.do?action=null");
return mapping.findForward("goMessage");
}
ActionForward forward = null;
String action = request.getParameter("action");
if (action == null || action.equals("show")) {// 獲取瀏覽平臺操作人員賬戶頁面
AdminMemberBean[] memberInfo = dao.getMemberInfo(loginId);
request.setAttribute("memberInfo", memberInfo);
forward = mapping.findForward("goAdminMember");
} else if (action.equals("modify")) {// 獲取修改平臺操作人員賬戶頁面
AdminMemberBean memberDetail = dao.getMemberDetail(request
.getParameter("memberId"));
request.setAttribute("memberDetail", memberDetail);
forward = mapping.findForward("goAdminMemberDetail");
} else if (action.equals("delete")) {// 刪除一條平臺操作人員賬戶記錄
String sql = "DELETE FROM [administrator] WHERE ID="
+ request.getParameter("memberId");
dao.executeUpdate(sql);
forward = new ActionForward("/adminMember.do?action=show");
} else if (action.equals("add")) {// 獲取添加平臺操作人員賬戶頁面
forward = mapping.findForward("goAdminMemberAdd");
} else if (action.equals("onAdd")) {// 添加一條平臺操作人員賬戶記錄
AdminMemberForm aForm = (AdminMemberForm) form;
String sql = "INSERT INTO [Administrator] ([loginName],[password],[Role],[State],[Name],[Gender],[Email],[Telephone],[Cellphone],[Address])"
+ "VALUES('"
+ aForm.getLoginName()
+ "','"
+ aForm.getNewPassword()
+ "','"
+ aForm.getRole()
+ "','"
+ aForm.getState()
+ "','"
+ aForm.getName()
+ "','"
+ aForm.getGender()
+ "','"
+ aForm.getEmail()
+ "','"
+ aForm.getTelephone()
+ "','"
+ aForm.getCellphone()
+ "','" + aForm.getAddress() + "')";
dao.executeUpdate(sql);
forward = new ActionForward("/adminMember.do?action=show");
} else if (action.equals("onModify")) {// 修改一條平臺操作人員賬戶記錄
AdminMemberForm aForm = (AdminMemberForm) form;
String sql = "UPDATE [Administrator] SET role=" + aForm.getRole()
+ ",state=" + aForm.getState() + " WHERE ID="
+ request.getParameter("memberId");
dao.executeUpdate(sql);
forward = new ActionForward("/adminMember.do?action=show");
}
return forward;
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -