人事管理系統(tǒng)實(shí)習(xí)報(bào)告

-.z.軟件開發(fā)生產(chǎn)實(shí)習(xí)報(bào)告**班級(jí)項(xiàng)目名稱人事管理系統(tǒng)實(shí)習(xí)地點(diǎn)光谷軟件園實(shí)習(xí)時(shí)間實(shí)習(xí)成績指導(dǎo)教師簽字信息科學(xué)與工程學(xué)院2016年7月15日軟件開發(fā)生產(chǎn)實(shí)習(xí)報(bào)告實(shí)習(xí)目的1.1使學(xué)生全面了解軟件項(xiàng)目實(shí)施的過程，理解軟件企業(yè)對(duì)于程序員的基本素質(zhì)和技術(shù)能力要求。1.2使學(xué)生掌握J(rèn)SP及Servlet基本的JavaEE編程技術(shù)，能夠綜合運(yùn)用oracle數(shù)據(jù)庫及Eclipse開發(fā)環(huán)境進(jìn)行小型項(xiàng)目的開發(fā)。1.3重點(diǎn)培養(yǎng)學(xué)生的團(tuán)隊(duì)精神和協(xié)作意識(shí)，提高其口頭和書面的溝通能力。1.4使學(xué)生掌握快速學(xué)習(xí)新知識(shí)、新技術(shù)方法，培養(yǎng)良好的分析問題和解決問題的能力1.5重點(diǎn)提高學(xué)生的編程能力，使學(xué)生建立正確的編程理念，養(yǎng)成規(guī)的編程習(xí)慣。2．實(shí)習(xí)過程2.1技術(shù)準(zhǔn)備2.1.1JDBC（Java數(shù)據(jù)庫連接）技術(shù)Java數(shù)據(jù)庫連接是java語言中用來規(guī)客戶端程序如何來訪問數(shù)據(jù)庫的應(yīng)用程序接口，提供了諸如查詢和更新數(shù)據(jù)庫中數(shù)據(jù)的方法。本次程序利用該技術(shù)連接到oracle數(shù)據(jù)庫，實(shí)現(xiàn)數(shù)據(jù)的更新，刪除，插入。2.1.2JSP技術(shù)JSP其根本是一個(gè)簡化的Servlet技術(shù)，它是傳統(tǒng)的網(wǎng)頁HTML文件中插入java程序段。本次程序利用JSP技術(shù)實(shí)現(xiàn)其動(dòng)態(tài)跳轉(zhuǎn)。2.1.3用到的相關(guān)軟件jdk（運(yùn)行環(huán)境）：安裝好jdk后，設(shè)置好環(huán)境變量。Tomcat：進(jìn)行相應(yīng)的配置。EclipseJ2EE（開發(fā)環(huán)境）：啟動(dòng)開發(fā)環(huán)境，然后配置好之前安裝好的jdk。Oracle數(shù)據(jù)庫（10G)：運(yùn)行安裝程序，設(shè)置兼容性，以管理員身份運(yùn)行，設(shè)置密碼；安裝完成后檢查服務(wù)，確定以下兩個(gè)服務(wù)：OracleOraDb10g_home1TNSListener監(jiān)聽服務(wù)OracleServiceORCL（服務(wù)名稱ORCL）核心服務(wù)這兩個(gè)服務(wù)必須為開啟狀態(tài)。2.2項(xiàng)目實(shí)施2.2.1功能需求管理員登錄管理員登錄組織管理系統(tǒng)管理部門管理崗位管理設(shè)置關(guān)系部門管理主要用于部門的管理，描述人事管理系統(tǒng)中的部門信息，其中也包含了部門的上下級(jí)關(guān)系。部門管理包含對(duì)部門信息的查詢，以及添加部門；查詢部門時(shí)可對(duì)部門信息進(jìn)行修改和刪除操作。不可裁剪崗位管理主要用于崗位的管理，描述人事管理系統(tǒng)中的崗位信息。崗位管理包含對(duì)崗位信息的查詢，以及添加新的崗位；查詢崗位時(shí)可以崗位信息進(jìn)行修改和刪除操作，崗位管理系統(tǒng)管理主要用于管理員的管理，描述人事管理系統(tǒng)中的信息。管理員登錄進(jìn)入系統(tǒng)后，通過系統(tǒng)管理查詢管理員的信息，以及添加新的管理員，但不可刪除或更改管理員的信息。不可裁剪設(shè)置關(guān)系主要用于將各個(gè)不同的崗位歸到相應(yīng)的部門，便于管理。不可裁剪部門管理需求描述功能名稱部門管理優(yōu)先級(jí)高業(yè)務(wù)背景部門是構(gòu)成一個(gè)組織的基本單位。部門管理用于維護(hù)部門的基本信息，以及體現(xiàn)整個(gè)系統(tǒng)中部門之間的上下級(jí)關(guān)系，還有該部門的類型級(jí)別是公司還是部門。功能說明添加部門修改部門信息刪除部門約束條件系統(tǒng)要求部門的編號(hào)唯一。相關(guān)查詢查詢部門列表，點(diǎn)擊部門查詢出現(xiàn)所有的部門信息其他需求無裁剪說明不可裁剪流程描述開始開始登錄部門管理新建部門修改部門刪除部門查詢部門結(jié)束結(jié)束數(shù)據(jù)描述部門基本信息編號(hào)是部門名稱是類型（下拉框）分為公司、部門是是傳真是描述是上級(jí)部門（下拉框）分為各個(gè)部門，總經(jīng)辦和總公司是成立日期是崗位管理需求描述功能名稱崗位管理優(yōu)先級(jí)高業(yè)務(wù)背景崗位是指一個(gè)組織中由特定人員所承擔(dān)的多種職責(zé)的集合，一般來講崗位對(duì)應(yīng)到了特定的部門。但為了簡化實(shí)訓(xùn)項(xiàng)目，裁剪了崗位與部門之間的關(guān)系。本功能就是對(duì)各崗位進(jìn)行管理，包括增加、修改、刪除崗位，以及查詢崗位下的員工等。功能說明增加崗位修改崗位3.刪除崗位約束條件無相關(guān)查詢查詢崗位信息，包括編號(hào)，名稱，類型，所屬部門以及該崗位最大限制多少人。其他需求無裁剪說明不可裁剪流程描述開始開始登錄崗位管理新建崗位修改崗位刪除崗位查詢崗位結(jié)束數(shù)據(jù)描述崗位基本信息崗位編號(hào)是崗位名稱是類型（下拉框）分為管理，技術(shù)，營銷，市場等；是崗位編制限制崗位上最多可配置多少員工是所屬部門（下拉框）分為行政部，生產(chǎn)部，銷售部，技術(shù)部，財(cái)務(wù)部等。是備注1否備注2否備注3否系統(tǒng)管理需求描述功能名稱系統(tǒng)管理優(yōu)先級(jí)低業(yè)務(wù)背景管理管理員相關(guān)的信息功能說明1、添加管理員2、查詢管理員3、退出登錄約束條件無相關(guān)查詢管理員編號(hào)、等其他需求無裁剪說明不可裁剪。流程描述開始開始登錄系統(tǒng)管理添加管理員退出登錄查詢管理員結(jié)束數(shù)據(jù)描述管理員基本信息編號(hào)是名稱是登錄密碼是所屬部門否否入職日期否設(shè)置關(guān)系需求描述功能名稱設(shè)置關(guān)系優(yōu)先級(jí)低業(yè)務(wù)背景每個(gè)部門中有不同的崗位功能說明將不同的崗位保存到相應(yīng)的部門約束條件無相關(guān)查詢可通過查詢崗位信息來查詢?cè)搷徫坏乃鶎俨块T其他需求無裁剪說明不可裁剪。2.2.2總體設(shè)計(jì)本次人事管理系統(tǒng)要求完成管理員的登錄，添加管理員以及查詢管理員信息，部門信息的查詢，部門的添加，部門信息的刪除和修改，崗位信息的查詢，崗位的添加，崗位信息得到刪除和修改以及崗位和部門之間的關(guān)系設(shè)置。因此該系統(tǒng)除了基本的部門類，管理員類，崗位類等以外主要的就是對(duì)他們的操作類，主要如下：開始開始管理員登錄組織管理系統(tǒng)管理部門管理新建部門修改部門刪除部門查詢部門崗位管理新建崗位修改崗位刪除崗位查詢崗位設(shè)置關(guān)系系統(tǒng)管理添加管理員查詢管理員退出登錄結(jié)束模塊名稱功能簡述系統(tǒng)管理模塊管理員登錄類（ManagerServlet）查詢管理員信息類（ManagerSelectServlet）添加管理員信息類（ManagerAddServlet）部門管理模塊查詢部門信息類（SkdeptSelectServlet）修改部門信息類（SkdeptModifyServlet）刪除部門信息類（SkdeptDeleteServlet）添加部門類（SkdeptAddServlet）崗位管理模塊1、查詢崗位信息類（SkjobSelectServlet）2、修改崗位信息類（SkjobModifyServlet）3、刪除崗位信息類（SkjobDeleteServlet）4、添加崗位類（SkjobAddServlet）設(shè)置關(guān)系模塊添加關(guān)系類（AddSkdeptSkjob）添加關(guān)系類2（AddSkdeptSkjob2）2.2.3詳細(xì)設(shè)計(jì)與編碼系統(tǒng)管理模塊(1)管理員登錄功能描述管理員輸入賬戶密碼登進(jìn)人事管理系統(tǒng)數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;eption;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.ManagerDao;import.model.Manager;publicclassManagerServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); resp.setCharacterEncoding("utf-8"); Stringname=req.getParameter("yonghuming"); Stringpassword=req.getParameter("password");ManagerDaosd=newManagerDao(); HttpSessionsession=req.getSession(); try{ Managerstu=sd.login(name,password); if(stu==null) { session.setAttribute("errorMsg","用戶名或密碼錯(cuò)誤！"); session.setAttribute("redirectUrl","login.html"); req.getRequestDispatcher("error.jsp").forward(req,resp); } else { session.setAttribute("userInfo",stu); resp.sendRedirect("inde*.html"); } }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明(2)查詢管理員信息功能描述查詢管理員的基本信息數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava.util.List;on;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;import.dao.ManagerDao;import.model.Manager;publicclassManagerSelectServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ ManagerDaosd=newManagerDao(); try{ List<Manager>list=sd.find(); req.getSession().setAttribute("ManagerList",list); req.getRequestDispatcher("ManagerList.jsp").forward(req,resp); }catch(SQLE*ceptione) { e.printStackTrace(); } }}補(bǔ)充說明(3)添加管理員功能描述添加新的管理員數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;letResponse;importjava*.servlet.http.HttpSession;import.dao.ManagerDao;import.model.Manager;publicclassManagerAddServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); req.setCharacterEncoding("utf-8"); Stringname=req.getParameter("name"); Stringpassword=req.getParameter("pass"); Managerman=newManager(); req.setCharacterEncoding("utf-8"); req.setCharacterEncoding("utf-8"); man.setName(name); man.setPassword(password); ManagerDaod=newManagerDao(); intcount; try{ count=d.AddManager(man); if(count>=1) { req.getRequestDispatcher("addmanager.html").forward(req,resp); } else { HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","添加失敗"); session.setAttribute("redirectUrl","addmanager"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明部門管理模塊(1)查詢部門信息功能描述查詢部門的基本信息數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava.util.List;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;t;importjava*.servlet.http.HttpServletResponse;import.dao.SkdeptDao;import.model.Skdept;publicclassSkdeptSelectServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ SkdeptDaosd=newSkdeptDao(); try{ List<Skdept>list=sd.find(); req.getSession().setAttribute("SkdeptList",list); req.getRequestDispatcher("SkdeptList.jsp").forward(req,resp); }catch(SQLE*ceptione) { e.printStackTrace(); } }}補(bǔ)充說明(2)修改部門信息功能描述當(dāng)發(fā)現(xiàn)部門的信息有誤時(shí)，可進(jìn)行修改數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkdeptDao;import.model.Skdept;publicclassSkdeptModifyServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); resp.setCharacterEncoding("utf-8"); Stringid=req.getParameter("id"); Stringname=req.getParameter("name"); Stringtype=req.getParameter("type"); Stringtele=req.getParameter("tele"); Stringfa*=req.getParameter("fa*"); Stringdiscrip=req.getParameter("discrip"); Stringskdsuper=req.getParameter("skdsuper"); Stringcreatetime=req.getParameter("createtime"); Skdeptskd=newSkdept(); skd.setId(Integer.parseInt(id)); skd.setName(name); skd.setType(type); skd.setTele(Long.parseLong(tele)); skd.setFa*(fa*); skd.setDiscrip(discrip); skd.setSkdsuper(skdsuper); skd.setCreatetime(createtime); SkdeptDaosd=newSkdeptDao(); try{ intcount=sd.update(skd); if(count>=1) {//修改成功req.getRequestDispatcher("select").forward(req,resp); } else { //修改失敗處理 HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","修改失敗！"); session.setAttribute("redirectUrl","select"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(NumberFormatE*ceptione){ e.printStackTrace(); }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明(3)刪除部門信息功能描述將部門刪除數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkdeptDao;publicclassSkdeptDeleteServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); resp.setCharacterEncoding("utf-8"); Stringid=req.getParameter("id"); SkdeptDaosd=newSkdeptDao(); try{ intcount=sd.delete(Integer.parseInt(id)); if(count>=1) {//刪除成功req.getRequestDispatcher("select").forward(req,resp); } else { //刪除失敗處理 HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","刪除失??！"); session.setAttribute("redirectUrl","select")req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(NumberFormatE*ceptione){ e.printStackTrace(); }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明(4)添加部門功能描述添加新的部門數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava.util.Date;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkdeptDao;import.model.Skdept;publicclassSkdeptAddServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); req.setCharacterEncoding("utf-8"); try{ Stringname=req.getParameter("name"); Stringtype=req.getParameter("type"); Stringtele=req.getParameter("tele"); Stringfa*=req.getParameter("fa*"); Stringdiscrip=req.getParameter("discrip"); Stringskdsuper=req.getParameter("super"); Stringcreatetime=req.getParameter("createtime"); Skdeptskd=newSkdept(); req.setCharacterEncoding("utf-8"); req.setCharacterEncoding("utf-8"); skd.setName(name); skd.setType(type); skd.setTele(Long.parseLong(tele)); skd.setFa*(fa*); skd.setDiscrip(discrip); skd.setSkdsuper(skdsuper); skd.setCreatetime(createtime); SkdeptDaod=newSkdeptDao(); intcount; count=d.AddSkdept(skd); if(count>=1) { req.getRequestDispatcher("sec1.html").forward(req,resp); } else { HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","添加失敗"); session.setAttribute("redirectUrl","sec1.html"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(E*ceptione){ e.printStackTrace(); HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","添加失敗"); session.setAttribute("redirectUrl","adddept.html"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }}補(bǔ)充說明崗位管理模塊(1)查詢崗位信息功能描述查詢崗位的基本信息數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava.util.List;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;import.dao.SkjobDao;import.model.Skjob;publicclassSkjobSelectServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{SkjobDaosd=newSkjobDao(); try{ List<Skjob>list=sd.find(); req.getSession().setAttribute("SkjobList",list); req.getRequestDispatcher("SkjobList.jsp").forward(req,resp); }catch(SQLE*ceptione) { e.printStackTrace(); } }}補(bǔ)充說明(2)修改崗位信息功能描述對(duì)崗位的信息進(jìn)行修改數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkdeptDao;import.dao.SkjobDao;import.model.Skdept;import.model.Skjob;publicclassSkjobModifyServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); resp.setCharacterEncoding("utf-8"); Stringid=req.getParameter("id"); Stringname=req.getParameter("name"); Stringtype=req.getParameter("type"); Stringlimit=req.getParameter("limit"); Stringdeptno=req.getParameter("deptno"); Stringskd_id=req.getParameter("skd_id"); Stringe*planation1=req.getParameter("e*planation1"); Stringe*planation2=req.getParameter("e*planation2"); Stringe*planation3=req.getParameter("e*planation3"); Skjobskj=newSkjob(); skj.setId(Integer.parseInt(id)); skj.setName(name); skj.setType(type); skj.setLimit(Integer.parseInt(limit)); skj.setDeptno(deptno); skj.setSkd_id(Integer.parseInt(skd_id)); skj.setE*planation1(e*planation1); skj.setE*planation2(e*planation2); skj.setE*planation3(e*planation3); SkjobDaosd=newSkjobDao(); try{ intcount=sd.update(skj); if(count>=1) {//刪除成功 req.getRequestDispatcher("select").forward(req,resp); } else { //刪除失敗處理 HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","修改失??！"); session.setAttribute("redirectUrl","select"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(NumberFormatE*ceptione){ e.printStackTrace(); }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明(3)刪除崗位信息功能描述刪除掉沒有的崗位數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkjobDao;publicclassSkjobDeleteServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); resp.setCharacterEncoding("utf-8"); Stringid=req.getParameter("id"); SkjobDaosd=newSkjobDao(); try{ intcount=sd.delete(Integer.parseInt(id)); if(count>=1) { //刪除成功 req.getRequestDispatcher("select").forward(req,resp); } else { //刪除失敗處理 HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","刪除失敗！"); session.setAttribute("redirectUrl","select"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(NumberFormatE*ceptione){ e.printStackTrace(); }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明(4)添加崗位信息功能描述添加新的崗位數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkjobDao;import.model.Skjob;publicclassSkjobAddServlete*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doGet(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ req.setCharacterEncoding("utf-8"); req.setCharacterEncoding("utf-8"); try{ Stringname=req.getParameter("name"); Stringtype=req.getParameter("type"); Stringlimit=req.getParameter("limit"); Stringdeptno=req.getParameter("deptno"); Stringskd_id=req.getParameter("skd_id"); Stringe*planation1=req.getParameter("e*planation1"); Stringe*planation2=req.getParameter("e*planation2"); Stringe*planation3=req.getParameter("e*planation3"); Skjobskj=newSkjob(); req.setCharacterEncoding("utf-8"); req.setCharacterEncoding("utf-8"); skj.setName(name); skj.setType(type); skj.setLimit(Integer.parseInt(limit)); skj.setDeptno(deptno); skj.setSkd_id(Integer.parseInt(skd_id)); skj.setE*planation1(e*planation1); skj.setE*planation2(e*planation2); skj.setE*planation3(e*planation3); SkjobDaojob=newSkjobDao(); intcount; count=job.AddSkjob(skj); if(count>=1) { //成功 req.getRequestDispatcher("sec1.html").forward(req,resp); } else { HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","添加失敗"); session.setAttribute("redirectUrl","sec1.html"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }catch(E*ceptione){ e.printStackTrace(); HttpSessionsession=req.getSession(); session.setAttribute("errorMsg","添加失敗"); session.setAttribute("redirectUrl","addjob.html"); req.getRequestDispatcher("error.jsp").forward(req,resp); } }}補(bǔ)充說明關(guān)系模塊功能描述設(shè)置部門和崗位之間的關(guān)系數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava.sql.SQLE*ception;importjava.util.List;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;import.dao.SkdeptDao;import.dao.SkjobDao;import.model.Skdept;import.model.Skjob;publicclassAddSkdeptSkjobe*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ doPost(req,resp); } protectedvoiddoPost(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*ception,IOE*ception{ SkdeptDaoskd=newSkdeptDao(); SkjobDaoskj=newSkjobDao(); try{ List<Skjob>listj=skj.find(); List<Skdept>listd=skd.find(); req.getSession().setAttribute("SkdeptList",listd); req.getSession().setAttribute("SkjobList",listj); req.getRequestDispatcher("AddSkdeptSkjob.jsp").forward(req,resp); }catch(SQLE*ceptione){ e.printStackTrace(); } }}補(bǔ)充說明功能描述設(shè)置部門和崗位之間的關(guān)系數(shù)據(jù)結(jié)構(gòu)與算法package.servlet;importjava.io.IOE*ception;importjava*.servlet.ServletE*ception;importjava*.servlet.http.HttpServlet;importjava*.servlet.http.HttpServletRequest;importjava*.servlet.http.HttpServletResponse;importjava*.servlet.http.HttpSession;import.dao.SkjobDao;publicclassAddSkdeptSkjob2e*tendsHttpServlet{ protectedvoiddoGet(HttpServletRequestreq,HttpServletResponseresp) throwsServletE*