javaee 期末考查报告要求.docx

1、javaee 期末考查报告要求 考查课程报告课程名称： Java EE技术 学 院： 信息工程与自动化学院 专业年级： 2010级计算机系 班 学 号： 学生姓名： 指导教师： 日 期： 2012-12-30 期末考查结果评定评分项目分值得分报告条理清晰，内容详实，体会深刻40报告格式符合规范10程序符合要求40界面美观，功能有扩充10评语：成绩：指导教师签字：评定日期： 年 月 日1课程目的12要求与内容13运行环境14设计及实现15程序运行截图886总结和体会 907.参考文献 911.课程目的学生通过学习该课程后，着重应掌握跨平台WEB编程技术的知识和技能，主要掌握 jsp、Servle

2、t、JavaBean、JDBC、数据库连接池、MyEclipse环境、EL、JSTL 核心标签库、TOMCAT容器、MVC架构等基本知识和基本技能，在知识、能力和素质等方面达到能够独立的从事WEB服务器架构和服务器端软件开发的目标，本课程在人才培养过程中占有重要的不可替代的地位及作用，它把各专业基础知识综合在一起，形成一个培养提高学生专业能力的好课程，为同学走向社会、就业等奠定了坚实的自信心和牢固专业知识，极大地提高同学在社会就业竞争中的竞争力。2.要求与内容按照MVC设计模式，以5层的分层结构设计实现管理。数据表需自行设计建立，数据库连接采用连接池的方式；view层主要以JSP页面方式实现，

3、在页面中采用EL、JSTL标签库，并采用页面组装的方式合成top、left、bottom区域的内容；Control层用Servlet实现；Model层用分层方式实现，分为VALUE类、DAO的接口、接口实现类和工厂、Business的接口、接口实现类和工厂，数据库连接工厂。3运行环境MyEclipse 10, SQL server 20084.设计及实现1、com.city.oa.action（1）EmployeeAddAction package com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;

4、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.Bussine

5、ssFactory;import com.city.oa.value.EmployeeValue;public class EmployeeAddAction extends HttpServlet /* * Constructor of the object. */ public EmployeeAddAction() super(); /* * Destruction of the servlet. */ public void destroy() super.destroy(); / Just puts destroy string in log / Put your code here

6、 /* * The doGet method of the servlet. * * 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 I

7、OException 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 ageStrin

8、g = 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(employee/error.jsp?mess=+mess); /* * The doPost method of the servlet. * *

9、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

10、void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException doGet(request,response); /* * Initialization of the servlet. * * throws ServletException if an error occurs */ public void init() throws ServletException / Put your code here （2）EmployeeDeleteA

11、ction package 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 c

12、om.city.oa.dao.impl.EmployeeDaoImpl;import com.city.oa.factory.BussinessFactory;public class EmployeeDeleteAction extends HttpServlet /* * Constructor of the object. */ public EmployeeDeleteAction() super(); /* * Destruction of the servlet. */ public void destroy() super.destroy(); / Just puts destr

13、oy string in log / Put your code here /* * The doGet method of the servlet. * * 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 Servlet

14、Exception * 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 = r

15、equest.getParameter(password); String ageStr = request.getParameter(age); int age = Integer.parseInt(ageStr); try IEmployee emp = BussinessFactory.getEmployee(); emp.delete(userid, name, password, age); catch (Exception e) String mess = e.getMessage(); response.sendRedirect(employee/error.jsp?mess=

16、+ mess); / 获得删除超链接传来的参数 String sId = request.getParameter(userid); int id = Integer.parseInt(sId); / 调用模型层删除方法 String sql = delete from userinfo where userid=?; EmployeeDaoImpl sBean = new EmployeeDaoImpl(); int count = sBean.getDelete(sql, id); String url = ; if (count 0) url = employee/SearchList.

17、jsp; else url = employee/error.jsp; request.setAttribute(error, 删除); request.getRequestDispatcher(url).forward(request, response); /* * The doPost method of the servlet. * * This method is called when a form has its tag value method equals to * post. * * param request * the request send by the clien

18、t 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(req

19、uest, response); /* * Initialization of the servlet. * * throws ServletException * if an error occurs */ public void init() throws ServletException / Put your code here （3）EmployeeInsertActionpackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import javax.servlet.Servle

20、tException;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 EmployeeInsertAction exten

21、ds HttpServlet /* * Constructor of the object. */ public EmployeeInsertAction() super(); /* * Destruction of the servlet. */ public void destroy() super.destroy(); / Just puts destroy string in log / Put your code here /* * The doGet method of the servlet. * * This method is called when a form has i

22、ts 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, H

23、ttpServletResponse response) throws ServletException, IOException /获取前台页面信息 String userid=request.getParameter(userid); String name=request.getParameter(name); String password=request.getParameter(password); String sex=request.getParameter(sex); String Sage=request.getParameter(age); int age=Integer

24、.parseInt(Sage); /封装到JavaBean对象中 com.city.oa.value.EmployeeValue jBean=new com.city.oa.value.EmployeeValue(); jBean.setName(name); jBean.setPassword(password); jBean.setSex(sex); jBean.setAge(age); /调用模型层 String sql=insert into userinfo values(?,?,?,?); IEmployee emp=BussinessFactory.getEmployee();

25、EmployeeInsertAction sBean=new EmployeeInsertAction(); int count=sBean.getInsert(sql, jBean); String url=; if(count0) url=employee/SearchList.jsp; else url=employee/error.jsp; request.setAttribute(error,注册); /转发 request.getRequestDispatcher(url).forward(request, response); private int getInsert(Stri

26、ng sql, EmployeeValue jBean) / TODO Auto-generated method stub return 0; /* * The doPost method of the servlet. * * 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 serv

27、er 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. * * throws Servl

28、etException if an error occurs */ public void init() throws ServletException / Put your code here （4）EmployeeMainActionpackage com.city.oa.action;import java.io.IOException;import java.io.PrintWriter;import java.util.*;import com.city.oa.business.*;import com.city.oa.factory.*;import com.city.oa.val

29、ue.EmployeeValue;import javax.servlet.RequestDispatcher;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. */ pub