JAVAEE大报告

昆明理工大学信息工程与自动化学院学生实验报告（2012 —2013 学年第一学期）课程名称：JAVA EE技术开课实验室：信自楼444 2012 年 12 月 25 日一、实验目的通过上机，熟练掌握5层MVC设计模式。

二、内容及要求上机内容：用5层MVC分层模式完成用户管理的功能。

具有增加、删除、更新、显示、查询等功能。

三、步骤及具体实施1、简要描述程序的开发流程、文件部署截图、及各种配置；2、程序代码Com.city.oa.actionEmployeeAddAction:package com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.util.*;import com.city.oa.business.*;import com.city.oa.factory.*;import com.city.oa.value.EmployeeValue;import javax.servlet.RequestDispatcher;import javax.servlet.ServletConfig;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;public class EmployeeAddAction extends HttpServlet {/*** Constructor of the object.*/private static final long serialVersionUID = 1L;private Connection cn=null;public EmployeeAddAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code heretry {if(cn!=null&&(!cn.isClosed())) {cn.close();cn=null;}}catch(Exception e) {System.out.println("数据库关闭失败："+e.getMessage());}}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String userid =request.getParameter("userid");String name =request.getParameter("name");String password =request.getParameter("password");String ageString =request.getParameter("age");int age=Integer.parseInt(ageString);try{IEmployee emp=BussinessFactory.getEmployee();emp.add(userid, name, password, age);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}response.sendRedirect("main.do");}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post.** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request,response);}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}EmployeeDeleteAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.util.List;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.city.oa.business.IEmployee;import com.city.oa.factory.BussinessFactory;import com.city.oa.value.EmployeeValue;public class EmployeeDeleteAction extends HttpServlet {/*** Constructor of the object.*/public EmployeeDeleteAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String userid =request.getParameter("userid");try{IEmployee emp=BussinessFactory.getEmployee();emp.delete(userid);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}response.sendRedirect("main.do");}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException { // Put your code here}}EnployeeMainAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.util.*;import com.city.oa.business.*;import com.city.oa.factory.*;import com.city.oa.value.EmployeeValue;import javax.servlet.RequestDispatcher;import javax.servlet.ServletConfig;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;public class EmployeeMainAction extends HttpServlet {/*** Constructor of the object.*/private static final long serialVersionUID = 1L;private Connection cn=null;public EmployeeMainAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code heretry {if(cn!=null&&(!cn.isClosed())) {cn.close();cn=null;}}catch(Exception e) {System.out.println("数据库关闭失败："+e.getMessage());}}* The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {try{IEmployee emp=BussinessFactory.getEmployee();List<EmployeeValue> empList=emp.getList();request.setAttribute("empList",empList);RequestDispatcher rd=request.getRequestDispatcher("main.jsp");rd.forward(request, response);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}}/*** The doPost method of the servlet. <br>* This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request,response);}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init(ServletConfig config) throws ServletException { // Put your code here}}EmployeeModify.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.city.oa.business.IEmployee;import com.city.oa.factory.BussinessFactory;public class EmployeeModifyAction extends HttpServlet {/*** Constructor of the object.*/private static final long serialVersionUID = 1L;private Connection cn=null;public EmployeeModifyAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code heretry {if(cn!=null&&(!cn.isClosed())) {cn.close();cn=null;}}catch(Exception e) {System.out.println("数据库关闭失败："+e.getMessage());}}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String userid =request.getParameter("userid");String name =request.getParameter("name");String password =request.getParameter("password");String ageString =request.getParameter("age");int age=Integer.parseInt(ageString);IEmployee emp=BussinessFactory.getEmployee();try{emp.modify(userid, name, password, age);}catch(Exception e){System.out.println(userid+" "+name+" "+password+" "+age);System.out.println("Erro----------------------------------------------");String mess=e.getMessage();response.sendRedirect("error.jsp?mess="+mess);}response.sendRedirect("main.do");}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}LoginAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.sql.DriverManager;import java.sql.PreparedStatement;import java.sql.ResultSet;import java.util.ArrayList;import java.util.List;import javax.servlet.ServletContext;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse; import javax.servlet.http.HttpSession;import com.city.oa.business.IEmployee;import com.city.oa.factory.BussinessFactory;public class LoginAction extends HttpServlet {/*** Constructor of the object.*/public LoginAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}String driverName=null;String url=null;String user=null;String pass=null;Connection cn=null;/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String userid =request.getParameter("userid");String password =request.getParameter("password");HttpSession session=request.getSession(true);IEmployee emp=BussinessFactory.getEmployee();try{emp.check(userid, password);}catch(Exception e){System.out.println(userid+" "+password+" ");System.out.println("Erro----------------------------------------------");String mess=e.getMessage();response.sendRedirect("error.jsp?mess="+mess);}session.setAttribute("userid",userid);session.setAttribute("password",password);response.sendRedirect("employee/main.do");}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}logoutAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import javax.servlet.http.HttpSession;import com.city.oa.business.IEmployee;import com.city.oa.factory.BussinessFactory;public class LogoutAction extends HttpServlet {/*** Constructor of the object.*/public LogoutAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doPost(request,response);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurredpublic void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String userid =request.getParameter("userid");String password =request.getParameter("password");HttpSession session=request.getSession(true);IEmployee emp=BussinessFactory.getEmployee();try{emp.check(userid, password);}catch(Exception e){System.out.println(userid+" "+password+" ");System.out.println("Erro----------------------------------------------");String mess=e.getMessage();response.sendRedirect("error.jsp?mess="+mess);}session.setAttribute("userid",null);session.setAttribute("password",null);response.sendRedirect("employee/main.do");}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs */public void init() throws ServletException { // Put your code here}}NoticeAddAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.city.oa.business.IEmployee;import com.city.oa.business.INotice;import com.city.oa.factory.BussinessFactory;public class NoticeAddAction extends HttpServlet {* Constructor of the object.*/private static final long serialVersionUID = 1L;private Connection cn=null;public NoticeAddAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code heretry {if(cn!=null&&(!cn.isClosed())) {cn.close();cn=null;}}catch(Exception e) {System.out.println("数据库关闭失败："+e.getMessage());}}/*** The doGet method of the servlet. <br>* This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @param date* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String noticeid =request.getParameter("noticeid");String title =request.getParameter("title");String content =request.getParameter("content");String date =request.getParameter("date");try{INotice notice=BussinessFactory.getNotice();notice.add(noticeid, title, content, date);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}response.sendRedirect("noticemain.do");}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post.** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response.setContentType("text/html");PrintWriter out = response.getWriter();out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");out.println("<HTML>");out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");out.println(" <BODY>");out.print(" This is ");out.print(this.getClass());out.println(", using the POST method");out.println(" </BODY>");out.println("</HTML>");out.flush();out.close();}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs */public void init() throws ServletException { // Put your code here}}NoticeDelete.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.city.oa.business.IEmployee;import com.city.oa.business.INotice;import com.city.oa.factory.BussinessFactory;public class NoticeDeleteAction extends HttpServlet {/*** Constructor of the object.*/public NoticeDeleteAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code here}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get.** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {String noticeid =request.getParameter("noticeid");try{INotice notice=BussinessFactory.getNotice();notice.delete(noticeid);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}response.sendRedirect("noticemain.do");}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {response.setContentType("text/html");PrintWriter out = response.getWriter();out.println("<!DOCTYPE HTML PUBLIC \"-//W3C//DTD HTML 4.01 Transitional//EN\">");out.println("<HTML>");out.println(" <HEAD><TITLE>A Servlet</TITLE></HEAD>");out.println(" <BODY>");out.print(" This is ");out.print(this.getClass());out.println(", using the POST method");out.println(" </BODY>");out.println("</HTML>");out.flush();out.close();}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}NoticeMainAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import java.util.List;import javax.servlet.RequestDispatcher;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest; import javax.servlet.http.HttpServletResponse;import com.city.oa.business.IEmployee;import com.city.oa.business.INotice;import com.city.oa.factory.BussinessFactory;import com.city.oa.value.EmployeeValue;import com.city.oa.value.NoticeValue;public class NoticeMainAction extends HttpServlet {/*** Constructor of the object.*/private static final long serialVersionUID = 1L;private Connection cn=null;public NoticeMainAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code heretry {if(cn!=null&&(!cn.isClosed())) {cn.close();cn=null;}}catch(Exception e) {System.out.println("数据库关闭失败："+e.getMessage());}}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {try{INotice notice=BussinessFactory.getNotice();List<NoticeValue> noticeList=notice.getList();request.setAttribute("noticeList",noticeList);RequestDispatcher rd=request.getRequestDispatcher("main.jsp");rd.forward(request, response);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post. ** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {doGet(request,response);}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/public void init() throws ServletException {// Put your code here}}NoticeModifyAction.javapackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.sql.Connection;import javax.servlet.ServletException;import javax.servlet.http.HttpServlet;import javax.servlet.http.HttpServletRequest;import javax.servlet.http.HttpServletResponse;import com.city.oa.business.IEmployee;import com.city.oa.business.INotice;import com.city.oa.factory.BussinessFactory;public class NoticeModifyAction extends HttpServlet {/*** Constructor of the object.*/private static final long serialVersionUID = 1L;private Connection cn=null;public NoticeModifyAction() {super();}/*** Destruction of the servlet. <br>*/public void destroy() {super.destroy(); // Just puts "destroy" string in log// Put your code heretry {if(cn!=null&&(!cn.isClosed())) {cn.close();cn=null;}}catch(Exception e) {System.out.println("数据库关闭失败："+e.getMessage());}}/*** The doGet method of the servlet. <br>** This method is called when a form has its tag value method equals to get.** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doGet(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {doPost(request,response);}/*** The doPost method of the servlet. <br>** This method is called when a form has its tag value method equals to post.** @param request the request send by the client to the server* @param response the response send by the server to the client* @throws ServletException if an error occurred* @throws IOException if an error occurred*/public void doPost(HttpServletRequest request, HttpServletResponse response)throws ServletException, IOException {String noticeid =request.getParameter("noticeid");String title =request.getParameter("title");String content =request.getParameter("content");String date =request.getParameter("date");INotice notice=BussinessFactory.getNotice();try{notice.modify(noticeid, title, content, date);}catch(Exception e){String mess=e.getMessage();response.sendRedirect("../error.jsp?mess="+mess);}response.sendRedirect("noticemain.do");}/*** Initialization of the servlet. <br>** @throws ServletException if an error occurs*/。