SSH框架,简单的多表查询

package cn.lanou.staff.action; import java.util.List; import javax.annotation.Resource; import javax.servlet.http.HttpServletRequest; import org.apache.struts2.interceptor.ServletRequestAware; import com.opensymphony.xwork2.ActionContext; import com.opensymphony.xwork2.ActionSupport; import cn.lanou.staff.service.DepartmentServiceInterface; import cn.lanou.staff.service.PostServiceInterface; import cn.lanou.staff.service.StaffServiceInterface; import cn.lanou.util.Util; public class StaffAction extends ActionSupport implements ServletRequestAware{ @Resource(name=StaffServiceInterface.STAFFSERVICEIMP) private StaffServiceInterface service; public void setService(StaffServiceInterface service) { this.service = service; } @Resource(name = PostServiceInterface.POSTSERVICEIMP) private PostServiceInterface postService; public void setService(PostServiceInterface service) { this.postService = service; } @Resource(name=DepartmentServiceInterface.DEPARTMENTSERVICEIMP) private DepartmentServiceInterface departmentService; public void setDepartmentService(DepartmentServiceInterface departmentService) { this.departmentService = departmentService; } // 跳转首页 public String showList() { // 查询所有用户 List<StaffVo> ls = this.service.searchAllStaff(); ActionContext.getContext().put("ls", ls); // 查询所有部门 List<DeptmentVO> deptS = this.departmentService.searchAllDepartment(); ActionContext.getContext().put("deptS", deptS); return "showList"; } // 进行编辑 public String editPage() { String staffId = this.request.getParameter("staffId"); // 根据staffId查询这个员工的信息 StaffVo v = this.service.searchStaffById(staffId); ActionContext.getContext().put("v", v); // 查询所有部门 List<DeptmentVO> deptS = this.departmentService.searchAllDepartment(); // 如果去和默认的一样的部门 for(int i = 0; i < deptS.size(); i++) { if (deptS.get(i).getDepName().equals(v.getDepName())) { deptS.remove(i); } } // 查询出员工所在部门的所有岗位 List<PostVo> posts = this.postService.searchPostsByDeptId(v.getDepId()); for(int i = 0; i < posts.size();i++) { if (posts.get(i).getPostName().equals(v.getPostName())) { posts.remove(i); } } ActionContext.getContext().put("deptS", deptS); ActionContext.getContext().put("posts", posts); return "editPage"; } // 保存编辑 public String saveEdit() { // 获取到请求的数据 String staffId = this.request.getParameter("staffId"); String loginName = this.request.getParameter("loginName"); String loginPwd = this.request.getParameter("loginPwd"); String oldPassword = this.request.getParameter("oldPassword"); String staffName = this.request.getParameter("staffName"); String gender = this.request.getParameter("gender"); String deptId = this.request.getParameter("deptId"); String PostId = this.request.getParameter("PostId"); String onDutyDate = this.request.getParameter("onDutyDate"); StaffVo vo = new StaffVo(); vo.setStaffId(staffId); vo.setLoginName(loginName); vo.setLoginPwd(loginPwd); vo.setOldPassword(oldPassword); vo.setStaffName(staffName); vo.setGender(gender); vo.setDepId(deptId); vo.setPostId(PostId); vo.setOnDutyDate(onDutyDate); if (!oldPassword.equals(loginPwd)) { // 判断密码是否修改了 // 判断密码是不是合法， 不合法的话回显 Boolean passReg = Util.passwordReg(vo.getLoginPwd(), vo.getLoginName()); if (passReg == false) { // 密码不好使 vo.setLoginPwd(vo.getOldPassword()); // 改成原来的密码 ActionContext.getContext().put("v", vo); // 查询所有部门 List<DeptmentVO> deptS = this.departmentService.searchAllDepartment(); // 如果去和默认的一样的部门 for(int i = 0; i < deptS.size(); i++) { if (deptS.get(i).getDepName().equals(vo.getDepName())) { deptS.remove(i); } } ActionContext.getContext().put("deptS", deptS); addFieldError("loginPwd", "密码不合符规范"); return "editPage"; } } // 进行更新 this.service.updateStaff(vo); return "saveEdit"; } // 跳转到保存的界面 public String savePage() { List<DeptmentVO> deptS = this.departmentService.searchAllDepartment(); ActionContext.getContext().put("deptS", deptS); return "savePage"; } // 保存用户 public String saveStaff() { String loginName = this.request.getParameter("loginName"); String password = this.request.getParameter("password"); String staffName = this.request.getParameter("staffName"); String gender = this.request.getParameter("gender"); String deptId = this.request.getParameter("deptId"); String PostId = this.request.getParameter("PostId"); String onDutyDate = this.request.getParameter("onDutyDate"); StaffVo staffVo = new StaffVo(); staffVo.setLoginName(loginName); String pass = Util.EncoderByMd5(password); staffVo.setLoginPwd(pass); staffVo.setStaffName(staffName); staffVo.setGender(gender); staffVo.setDepId(deptId); staffVo.setPostId(PostId); staffVo.setOnDutyDate(onDutyDate); this.service.saveStaff(staffVo); return "saveStaff"; } private HttpServletRequest request; @Override public void setServletRequest(HttpServletRequest arg0) { this.request = arg0; } }