智能移动方向Jsp开发实训任务书及实训报告
《智能移动方向Jsp开发实训任务书及实训报告》由会员分享,可在线阅读,更多相关《智能移动方向Jsp开发实训任务书及实训报告(33页珍藏版)》请在装配图网上搜索。
1、Java项目实训(JSP)实训任务书一、实训目标通过项目实训,掌握Java Web平台下编程的方法,掌握JSP,Servlet,request,response等技术。课程要求从两个方面的能力目标实现,素养目标要求学员在通过学习具备相对应的学习技能、素养要求;技术目标要求学员必须掌握课程产品所定义的知识与技能。(1)素养目标v 阅读、编写项目开发文档的能力;v 根据项目需求设计模块功能并编码实现的能力v 问题解决能力、总结归纳能力;(2)技术目标v 使用Java Web技术实现在线考试系统-题库子系统;二、实训内容 参见附件:在线考试系统-题库子系统需求说明书三、实训进度安排按教学计划规定,该
2、设计总学时数为3周,其进度及时间大致分配如下:序号设计内容天数(约占比例)1JSP知识回顾与补强22用户管理模块23科目管理模块24考题管理模块35项目点评、总结1总计10天四、考核评定考核分类考核方式成绩比例课堂表现平时成绩出勤、平时项目检查30项目考核项目评审项目实战表现、自主学习70 内蒙古工业大学JSP开发实训题目 在线考试系统-题库子系统 指导教师: 姓名: 学号: 班级: 信计13-1 专业: 信息与计算科学 地点: 实验楼数学系机房 时间: 一、项目名称在线考试系统-题库子系统二、功能要求 a、用户管理 b、课程管理 c、题库管理 三、需求分析 在线考试系统-题库子系统的用户包括
3、用户管理员,试题管理员和题库使用人员,旨在建立一个独立的题库系统,为在线考试生成试卷提供支持,包含用户管理,科目管理,试题管理,生成试卷,试卷分析等内容,为用户提供了一个快速、全面、准确的试题管理平台。四、设计思想 a、使用Java Web技术实现 b、使用Mysql存储数据 c、基于MVC方式实现用例五、具体实现一、 Servlet方面 当客户端浏览器向服务器请求一个 Servlet 时,服务器收到该请求后,首先到容器中检索与请求匹配的 Servlet 实例是否已经存在。若不存在,则 Servlet 容器负责加载并实例化出该类 Servlet的一个实例对象,接着容器框架负责调用该实例的 in
4、it() 方法来对实例做一些初始化工作,然后Servlet 容器运行该实例的 service() 方法。若 Servlet 实例已经存在,则容器框架直接调用该实例的 service() 方法。service() 方法在运行时,自动派遣运行与用户请求相对应的 doXX() 方法来响应用户发起的请求。通常,每个 Servlet 类在容器中只存在一个实例,每当请求到来时,则分配一条线程来处理该请求。二、 JSP方面 当客户端浏览器向服务器请求一个 JSP 页面时,服务器收到该请求后,首先检查所请求的这个JSP 文件内容 ( 代码 ) 是否已经被更新,或者是否是 JSP 文件创建后的第一次被访问:如果
5、是,那么,这个 JSP 文件就会在服务器端的 JSP 引擎作用下转化为一个 Servlet 类的 Java 源代码文件。紧接着,这个 Servlet 类会在 Java 编译器的作用下被编译成一个字节码文件,并装载到 jvm 解释执行。剩下的就等同于 Servlet 的处理过程了。如果被请求的 JSP 文件内容 ( 代码 ) 没有被修改,那么它的处理过程也等同于一个 Servlet 的处理过程。即直接由服务器检索出与之对应的 Servlet 实例来处理。三、 实现代码 在实现用户添加中,通过DBUtil实现与数据库的链接,通过一个useradd.jsp 中通过“post”提交给useraddse
6、rvlet来处理数据,useraddservlet将提取到的数据通过DAO包中的方法来具体实现具体的功能。DAO包中都是为了实现查看,添加,修改,删除提供方法供别的servlet调用。四、 实现的关键代码 1.artcleAddServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(UTF-8);String ArtId = req
7、uest.getParameter(artcleId);String ArtName = request.getParameter(artcleName);String ArtDepict= request.getParameter(artcleDepict);String ArtsubjectId= request.getParameter(artclesubjectId);Artcle Art = new Artcle(ArtId,ArtName,ArtDepict,ArtsubjectId); ArticleDAO dao=new ArticleDAO(); int n=dao.save
8、(Art); if (n=1) request.getRequestDispatcher(artcleListServlet).forward(request, response); else System.out.println(List 错误); 2.artcleListServlet中的DoGet方法protected void doGet(HttpServletRequest request,HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(UT
9、F-8);ArticleDAO dao = new ArticleDAO();List list = (List) dao.selectAll();request.setAttribute(list, list);request.getRequestDispatcher(article.jsp).forward(request,response);2. PointAddServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletExcep
10、tion, IOException request.setCharacterEncoding(utf-8);int subjectId=RequestUtil.getInt(request, id);SubjectDAO dao=new SubjectDAO();Subject sub=dao.findSubById(subjectId);request.setAttribute(subject, sub);WebUtil.forward(request, response, PointAdd.jsp);4.PointDeleteServlet中的DoGet方法protected void d
11、oGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(UTF-8);int id=RequestUtil.getInt(request,id);PointDAO dao= new PointDAO();dao.deletePointById(id);WebUtil.forward(request, response, PointListServlet);5.PointListServlet中的
12、DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(utf-8);SubjectDAO dao =new SubjectDAO();request.setAttribute(subjectList, dao.selectAll();int id = RequestUtil.getInt(request, id);if(id0)PointDAO p
13、dao = new PointDAO();List pointList=pdao.findPointsBySubject(id);request.setAttribute(pointList, pointList);WebUtil.forward(request, response, PointList.jsp);6.PointSaveServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
14、 request.setCharacterEncoding(UTF-8);String pointId = request.getParameter(pointId);String pointName = request.getParameter(pointName);String pointAbs= request.getParameter(pointAbs);String subjectId= request.getParameter(subjectId);Point point = new Point(pointId,pointName,pointAbs,subjectId); Poin
15、tDAO dao=new PointDAO(); int n=dao.save(point); if (n=1) request.getRequestDispatcher(PointListServlet).forward(request, response); else System.out.println(List 错误); 7.PointViewServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOE
16、xception request.setCharacterEncoding(UTF-8);int id=RequestUtil.getInt(request,id);PointDAO dao=new PointDAO();Point point = dao.findPointById(id);request.setAttribute(point, point);WebUtil.forward(request, response, PointView.jsp);8.SubjectUpdateStep2Servlet中的DoGet方法protected void doGet(HttpServlet
17、Request request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(UTF-8);int id=Integer.parseInt(request.getParameter(subjectId);Subject sub =dao.findSubById(id);System.out.println(sub.getSubjectId();String subName = request.getParameter(subjectName);in
18、t subState = (request.getParameter(subjectState) = null)?1:Integer.parseInt(request.getParameter(subjectState);String subAbs= request.getParameter(subjectAbs);sub.setSubjectName(subName);sub.setSubjectState(subState);sub.setSubjectAbs(subAbs);System.out.println(sub.getSubjectName();dao.updateSub(sub
19、);WebUtil.forward(request, response, SubjectListServlet);9.SubjectAddServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(UTF-8);String subId = request.getParameter(subjectId);String subName =
20、 request.getParameter(subjectName);int subState = (request.getParameter(subjectState) = null)?1:Integer.parseInt(request.getParameter(subjectState);String subAbs= request.getParameter(subjectAbs);Subject sub = new Subject(subId,subName,subState,subAbs); SubjectDAO dao=new SubjectDAO(); int n=dao.sav
21、e(sub); if (n=1) request.getRequestDispatcher(SubjectListServlet).forward(request, response); else System.out.println(List 错误); 10.SubjectDeleteServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEnco
22、ding(UTF-8);int id=RequestUtil.getInt(request,id);SubjectDAO dao= new SubjectDAO();dao.deleteSubById(id);WebUtil.forward(request, response, SubjectListServlet);11.SubjectListServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOExce
23、ption request.setCharacterEncoding(UTF-8);SubjectDAO dao =new SubjectDAO();List list = dao.selectAll();request.setAttribute(list, list);request.getRequestDispatcher(SubjectList.jsp).forward(request, response);12.SubjectUpdateServlet中的DoGet方法protected void doGet(HttpServletRequest request, HttpServle
24、tResponse response) throws ServletException, IOException request.setCharacterEncoding(UTF-8);int id=RequestUtil.getInt(request,id);SubjectDAO dao=new SubjectDAO();Subject sub = dao.findSubById(id);request.setAttribute(sub, sub);WebUtil.forward(request, response, SubjectUpdate.jsp);13.SubjectViewServ
25、let中的DoGet方法protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException request.setCharacterEncoding(UTF-8);int id=RequestUtil.getInt(request,id);SubjectDAO dao=new SubjectDAO();Subject sub = dao.findSubById(id);request.setAttribute(sub, sub);W
26、ebUtil.forward(request, response, SubView.jsp);14. LoginServlet中的DoGet方法response.getWriter().append(Served at: ).append(request.getContextPath();15. UserAddServlet中的DoGet方法String userId = request.getParameter(userId);String userLogname = request.getParameter(userName);String userPwd = request.getPar
27、ameter(userPwd);String userRealname = request.getParameter(userRname);int userType = (request.getParameter(userType) = null) ? 3 : Integer.parseInt(request.getParameter(userType);int userState = (request.getParameter(userState) = null) ? 1: Integer.parseInt(request.getParameter(userState);User user
28、= new User(userId, userLogname, userPwd, userRealname,userType, userState);UserDAO dao = new UserDAO();int n = dao.save(user);if (n = 1) request.getRequestDispatcher(UserListServlet?type=list).forward(request, response); else System.out.println(List );16. UserDeleteServlet中的DoGet方法int id = RequestUt
29、il.getInt(request, id);UserDAO dao = new UserDAO();dao.deleteUserById(id);WebUtil.forward(request, response, UserListServlet?type=list);17. UserListServlet中的DoGet方法request.setCharacterEncoding(UTF-8);String type = request.getParameter(type);UserDAO dao = new UserDAO();if (list.equals(type) List list
30、 = dao.selectAll();request.setAttribute(list, list);request.getRequestDispatcher(UserList.jsp).forward(request,response);18. UserUpdateServlet中的DoGet方法request.setCharacterEncoding(UTF-8);int id = RequestUtil.getInt(request, id);UserDAO dao = new UserDAO();User user = dao.findUserById(id);request.set
31、Attribute(user, user);WebUtil.forward(request, response, userUpdate.jsp);19. UserUpdateStep2Servlet中的DoGet方法request.setCharacterEncoding(UTF-8);int userId = Integer.parseInt(request.getParameter(userId);User user = dao.findUserById(userId);System.out.println(user.getUserId();String userLogname = req
32、uest.getParameter(userName);String userRealname = request.getParameter(userRname);int userType = (request.getParameter(userType) = null) ? 3 : Integer.parseInt(request.getParameter(userType);int userState = (request.getParameter(userState) = null) ? 1: Integer.parseInt(request.getParameter(userState
33、);user.setUserName(userLogname);user.setUserRname(userRealname);user.setUserType(userType);user.setUserState(userState);System.out.println(user.getUserName();System.out.println(user.getUserRname();dao.updateUser(user);WebUtil.forward(request, response, UserListServlet?type=list);20. UserViewServlet中
34、的DoGet方法request.setCharacterEncoding(UTF-8);int id = RequestUtil.getInt(request, id);UserDAO dao = new UserDAO();User user = dao.findUserById(id);request.setAttribute(user, user);WebUtil.forward(request, response, view.jsp);21.AirticDAO中关键代码public ArticleDAO() class ArtcleDAO public List selectAll()
35、 List list = new ArrayList(); Connection conn = DBUtil.getConnection(); PreparedStatement pstmt = null; ResultSet rs = null; String sql = SELECT AR_id,AR_name,AR_DEPICT,AR_SUBJECT_ID + FROM et_artcle ORDER BY AR_id; try pstmt = conn.prepareStatement(sql); rs = pstmt.executeQuery(); while (rs.next()
36、Artcle art = new Artcle(); art.setArtcleId(rs.getInt(1); art.setArtcleName(rs.getString(2); art.setArtcleDepict(rs.getString(3); art.setArtclesubjectId(rs.getInt(4); list.add(art); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(rs, pstmt, conn); return list; public Artcle findA
37、rtById(int arId) Artcle art = new Artcle(); Connection conn = DBUtil.getConnection(); PreparedStatement pstmt = null; ResultSet rs = null; String sql = SELECT * FROM et_artcle WHERE ar_id=?; try pstmt = conn.prepareStatement(sql); pstmt.setInt(1, arId); rs = pstmt.executeQuery(); if (rs.next() art.s
38、etArtcleId(rs.getInt(1); art.setArtcleName(rs.getString(2); art.setArtcleDepict(rs.getString(3); art.setArtclesubjectId(rs.getInt(4); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(rs, pstmt, conn); return art; public int deleteArtById(int arId) int n = -1; Connection conn = DB
39、Util.getConnection(); PreparedStatement pstmt = null; String sql = delete from et_artcle where ar_id=?; try pstmt = conn.prepareStatement(sql); pstmt.setInt(1, arId); n = pstmt.executeUpdate(); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(null, pstmt, conn); return n; public
40、int updateArt(Artcle art) int n = -1; Connection conn = DBUtil.getConnection(); PreparedStatement pstmt = null; String sql = update et_artcle set ar_name=?,ar_depict=?,ar_subject_id=? where ar_id=?; try pstmt = conn.prepareStatement(sql); pstmt.setString(1, art.getArtcleName(); pstmt.setString(2, ar
41、t.getArtcleDepict(); pstmt.setInt(3, art.getArtclesubjectId(); pstmt.setInt(4, art.getArtcleId(); n = pstmt.executeUpdate(); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(null, pstmt, conn); return n; public int save(Artcle art) int n = -1;Connection conn = DBUtil.getConnectio
42、n();PreparedStatement pstmt = null;String sql = INSERT INTO et_artcle + VALUES(?,?,?,?);try pstmt = conn.prepareStatement(sql);pstmt.setInt(1, art.getArtcleId();pstmt.setString(2, art.getArtcleName();pstmt.setString(3, art.getArtcleDepict();pstmt.setInt(4, art.getArtclesubjectId();n = pstmt.executeU
43、pdate(); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(null, pstmt, conn);return 0;public List selectAll() List list = new ArrayList();Connection conn = DBUtil.getConnection();PreparedStatement pstmt = null;ResultSet rs = null;String sql = SELECT AR_id,AR_name,AR_DEPICT,AR_SUB
44、JECT_ID+ FROM et_artcle ORDER BY AR_id;try pstmt = conn.prepareStatement(sql);rs = pstmt.executeQuery();while (rs.next() Artcle art = new Artcle();art.setArtcleId(rs.getInt(1);art.setArtcleName(rs.getString(2);art.setArtcleDepict(rs.getString(3);art.setArtclesubjectId(rs.getInt(4);list.add(art); cat
45、ch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(rs, pstmt, conn);return list;22.PointDAO中关键代码public class PointDAO public int save(Point sub) int n=-1;Connection conn = DBUtil.getConnection();PreparedStatement pstmt = null;String sql =INSERT INTO et_point + VALUES(?,?,?,?);try pstm
46、t = conn.prepareStatement(sql);pstmt.setInt(1,sub.getPointId();pstmt.setString(2, sub.getPointName();pstmt.setString(3, sub.getPointAbs();pstmt.setInt(4, sub.getSubjectId();n=pstmt.executeUpdate(); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(null, pstmt, conn);return n;publi
47、c List selectAll()List list =new ArrayList(); Connection conn=DBUtil.getConnection(); PreparedStatement pstmt=null; ResultSet rs=null; String sql=SELECT * FROM et_point ORDER BY p_id; try pstmt =conn.prepareStatement(sql);rs=pstmt.executeQuery(); while (rs.next() Point sub = new Point();sub.setSubje
48、ctId(rs.getInt(1);sub.setPointName(rs.getString(2);sub.setPointAbs(rs.getString(3);sub.setSubjectId(rs.getInt(4);list.add(sub); catch (SQLException e) e.printStackTrace();finallyDBUtil.closeJDBC(rs,pstmt,conn); return list; public Point findPointById(int pId) Point sub = new Point(); Connection conn
49、 =DBUtil.getConnection(); PreparedStatement pstmt=null; ResultSet rs=null; String sql =SELECT * FROM et_point WHERE p_id=?; try pstmt=conn.prepareStatement(sql); pstmt.setInt(1, pId); rs=pstmt.executeQuery(); if(rs.next() sub.setPointId(rs.getInt(1); sub.setPointName(rs.getString(2); sub.setPointAbs
50、(rs.getString(3); sub.setSubjectId(rs.getInt(4); catch(SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(rs, pstmt, conn); return sub;public List findPointsBySubject(int sId)List list =new ArrayList();/ Connection conn =DBUtil.getConnection(); PreparedStatement pstmt=null; ResultSet rs=n
51、ull; String sql =SELECT * FROM et_point WHERE sj_id=?; try pstmt=conn.prepareStatement(sql); pstmt.setInt(1, sId); rs=pstmt.executeQuery(); while(rs.next() Point sub = new Point(); sub.setPointId(rs.getInt(1); sub.setPointName(rs.getString(2); sub.setPointAbs(rs.getString(3); sub.setSubjectId(rs.get
52、Int(4); list.add(sub); catch(SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(rs, pstmt, conn); return list;public int deletePointById(int pId)int n=-1;Connection conn = DBUtil.getConnection();PreparedStatement pstmt = null;String sql =delete from et_point where p_id=?;try pstmt = conn.
53、prepareStatement(sql);pstmt.setInt(1,pId);n=pstmt.executeUpdate(); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(null, pstmt, conn);return n;public int updatepoint(Point sub)int n=-1;Connection conn = DBUtil.getConnection();PreparedStatement pstmt = null;String sql =update et_
54、point set p_name=?,sj_state=?,sj_abs=? where sj_id=?;try pstmt = conn.prepareStatement(sql);pstmt.setString(1, sub.getPointName();pstmt.setString(2, sub.getPointAbs();pstmt.setInt(3,sub.getSubjectId();n=pstmt.executeUpdate(); catch (SQLException e) e.printStackTrace(); finally DBUtil.closeJDBC(null, pstmt, conn);return n;23.SubjectDAO中关键代码public class SubjectDAO public int save(Subject sub) int n = -1
- 温馨提示:
1: 本站所有资源如无特殊说明,都需要本地电脑安装OFFICE2007和PDF阅读器。图纸软件为CAD,CAXA,PROE,UG,SolidWorks等.压缩文件请下载最新的WinRAR软件解压。
2: 本站的文档不包含任何第三方提供的附件图纸等,如果需要附件,请联系上传者。文件的所有权益归上传用户所有。
3.本站RAR压缩包中若带图纸,网页内容里面会有图纸预览,若没有图纸预览就没有图纸。
4. 未经权益所有人同意不得将文件中的内容挪作商业或盈利用途。
5. 装配图网仅提供信息存储空间,仅对用户上传内容的表现方式做保护处理,对用户上传分享的文档内容本身不做任何修改或编辑,并不能对任何下载内容负责。
6. 下载文件中如有侵权或不适当内容,请与我们联系,我们立即纠正。
7. 本站不保证下载资源的准确性、安全性和完整性, 同时也不承担用户因使用这些下载资源对自己和他人造成任何形式的伤害或损失。
最新文档
- 四年级科学下册《食物包装上的信息》教科版课件
- 加强官德修养-做有德领导教学课件
- 医院药物临床试验机构资料管理员专项培训教材课件
- 北京中小学学生电子学籍管理系统一年级信息录入培训课件
- 医疗服务全面质量管理-课件
- 加强处方点评促进合理用药课件
- 加强学科建设打造品牌医院提升三级医院综合服务能力培训课件
- 化工设备检修安全技术概述课件
- 四年级下册英语Unit2WhattimeisitPartA课时课件
- 化工设备常用零部件图样及结构选用概述课件
- 加强学习履行职责做一名称职的党务干部支部书记培训课件2
- 医务人员艾滋病病毒职业暴露的预防及处理课件
- 四年级上第四单元三位数乘两位数解决问题课件
- 四年级数学上册计算工具的认识及计算课件免
- 四年级期末家长会(语文)课件