智能移动方向Jsp开发实训任务书及实训报告-在线考试系统的制作

学校代码：10128学号：201320905047学校代码：10128学号：201320905047JSP开发实训报告书题目：在线考试系统的制作学生姓名：张志勇学院：理学院班级：信计13-1指导教师：李晓瑜、宋健、赖俊峰二〇一六年一月

一、项目名称

在线考试系统-题库子系统二、功能要求

a、用户管理b、课程管理c、题库管理三、需求分析《在线考试系统-题库子系统》的用户包括用户管理员，试题管理员和题库使用人员，旨在建立一个独立的题库系统，为在线考试生成试卷提供支持，包含用户管理，科目管理，试题管理，生成试卷，试卷分析等内容，为用户提供了一个快速、全面、准确的试题管理平台。四、设计思想a、使用JavaWeb技术实现b、使用Mysql存储数据c、基于MVC方式实现用例设计思路：（如下图）分步详解：第一步：创建项目名（zhangzhiyong）；第二步：创建项目所需要的包；第三步：导入需要的工具；第四步：创建数据库的连接；第五步：需要的准备工作做好之后，明确先做用户管理系统（登录，查看，删除，修改，增加，退出；）；第六步：做好用户管理之后进行科目管理（增加，删除，修改，查看；）；第七步：接下来进行知识点管理（增加，删除，修改，查看；）；五、具体实现一．用户管理：需要的servlet：（userservlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjava.io.PrintWriter;importjava.util.List;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.dao.UserDAO;importcn.zhangzhiyong.util.RequestUtil;@WebServlet("/UserServlet")publicclassUserServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicUserServlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); PrintWriterout=response.getWriter(); Stringtype=request.getParameter("type"); StringuserLogname=request.getParameter("userLogname"); StringuserPwd=request.getParameter("userPwd"); UserDAOdao=newUserDAO(); Useruser=dao.login(userLogname,userPwd); if("login".equals(type)){ if(user!=null){ request.getSession().setAttribute("SESSION_USER",user); response.sendRedirect("res/index.html"); }else{ out.print("<scripttype='text/javascript'>"); out.print("alert('用户名或密码错误，请重新输入！');"); out.print("window.location='login.jsp';"); out.print("</script>"); } }elseif("logout".equals(type)){ request.getSession().invalidate(); out.print("<scripttype='text/javascript'>"); out.print("window.location='login.jsp';"); out.print("</script>"); }elseif("list".equals(type)){ List<User>list=dao.selectAll(); request.setAttribute("list",list); request.getRequestDispatcher("res/user.jsp").forward(request,response); } } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（useraddservlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjava.io.PrintWriter;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.dao.UserDAO;importcn.zhangzhiyong.util.RequestUtil;@WebServlet("/UserAddServlet")publicclassUserAddServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicUserAddServlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); Stringlogin=request.getParameter("login"); Stringname=request.getParameter("name"); inttype=(request.getParameter("type")==null)? 3:Integer.parseInt(request.getParameter("type")); intstatus=(request.getParameter("status")==null)? 1:Integer.parseInt(request.getParameter("status")); Useruser=newUser(login,name,type,status); UserDAOdao=newUserDAO(); intn=dao.save(user); if(n==1){ response.sendRedirect("UserServlet?type=list"); }else{ response.sendRedirect("index.jsp"); } } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（UserDeleteServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.dao.UserDAO;importcn.zhangzhiyong.util.RequestUtil;importcn.zhangzhiyong.util.WebUtil;@WebServlet("/UserDeleteServlet")publicclassUserDeleteServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicUserDeleteServlet(){super();}protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("UTF-8");// System.out.println(request.getParameter("Id")); intid=RequestUtil.getInt(request,"Id"); UserDAOdao=newUserDAO(); dao.delete(id); WebUtil.forward(request,response,"UserServlet?type=list"); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ //TODOAuto-generatedmethodstub doGet(request,response); }}（UserUpdate1Servlet）packagecn.zhangzhiyong.service;importjava.io.File;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importjavax.servlet.http.Part;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.dao.UserDAO;importcn.zhangzhiyong.util.RequestUtil;importcn.zhangzhiyong.util.WebUtil;@WebServlet("/UserUpdate1Servlet")publicclassUserUpdate1ServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicUserUpdate1Servlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); intid=RequestUtil.getInt(request,"Id"); request.setAttribute("id",id); request.getRequestDispatcher("res/user-update.jsp").forward(request,response); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ //TODOAuto-generatedmethodstub doGet(request,response); }}（UserUpdateServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.dao.UserDAO;importcn.zhangzhiyong.util.RequestUtil;@WebServlet("/UserUpdateServlet")publicclassUserUpdateServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicUserUpdateServlet(){super();}protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); Stringlogin=request.getParameter("login"); Stringname=request.getParameter("name"); Stringpasswd=request.getParameter("passwd"); inttype=Integer.parseInt(request.getParameter("type")); intstatus=Integer.parseInt(request.getParameter("status")); intid=RequestUtil.getInt(request,"id"); Userusers=newUser(login,name,type,status); UserDAOdao=newUserDAO(); intn=dao.update(users); if(n==1){ response.sendRedirect("UserServlet?type=list"); }else{ response.sendRedirect("index.jsp"); } } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（UserViewServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjava.io.PrintWriter;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.dao.UserDAO;importcn.zhangzhiyong.util.RequestUtil;@WebServlet("/UserViewServlet")publicclassUserViewServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicUserViewServlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); PrintWriterout=response.getWriter(); Stringtype=request.getParameter("type"); StringuserLogname=request.getParameter("userLogname"); StringuserPwd=request.getParameter("userPwd"); UserDAOdao=newUserDAO(); intid=RequestUtil.getInt(request,"Id"); Useruser1=dao.selectById(id); request.setAttribute("user",user1); request.getRequestDispatcher("res/user-show.jsp").forward(request,response); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}需要的类：packagecn.zhangzhiyong.bean;importjava.sql.Timestamp;publicclassUser{ publicstaticfinalStringpasswd="123456"; privateintid; privateStringlogin; privateStringname; privateStringpassword; privateinttype; privateintstatus; privateTimestamplast_login; publicUser(Stringlogin2,Stringname2,inttype2,intstatus2){ super(); this.login=login2; =name2; this.type=type2; this.status=status2; } publicUser(){ } publicUser(intid2){ this.id=id2; } publicintgetId(){ returnid; } publicvoidsetId(intid){ this.id=id; } publicStringgetLogin(){ returnlogin; } publicvoidsetLogin(Stringlogin){ this.login=login; } publicStringgetName(){ returnname; } publicvoidsetName(Stringname){ =name; } publicStringgetPassword(){ returnpassword; } publicvoidsetPassword(Stringpassword){ this.password=password; } publicintgetType(){ returntype; } publicvoidsetType(inttype){ this.type=type; } publicintgetStatus(){ returnstatus; } publicvoidsetStatus(intstatus){ this.status=status; } publicTimestampgetLast_login(){ returnlast_login; } publicvoidsetLast_login(Timestamplast_login){ this.last_login=last_login; } } 需要的dao：packagecn.zhangzhiyong.dao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;importcn.zhangzhiyong.bean.User;importcn.zhangzhiyong.util.DBUtil;publicclassUserDAO{ //userdao中的save方法 publicintsave(Useruser){ intn=-1; Connectionconn=DBUtil.getConnection();//连接对象 PreparedStatementpstmt=null;//语句对象 //下边是s语句 Stringsql="insertintouserss" +"values(DL_USERSS.NEXTVAL,?,?,'123456',?,?,sysdate)"; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,user.getLogin()); pstmt.setString(2,user.getName()); pstmt.setInt(3,user.getType()); pstmt.setInt(4,user.getStatus()); n=pstmt.executeUpdate();//n=更新的行数 }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } publicUserlogin(StringuserLogname,StringuserPwd){ Connectionconn=DBUtil.getConnection(); PreparedStatementpstmt=null; ResultSetrs=null; Useru=null; Stringsql="selectid,login,name,passwd,type,status,last_login" +"fromuserswherelogin=?andpasswd=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,userLogname); pstmt.setString(2,userPwd); rs=pstmt.executeQuery(); if(rs.next()){ u=newUser(); u.setId(rs.getInt(1)); u.setLogin(rs.getString(2)); u.setName(rs.getString(3)); u.setPassword(rs.getString(4)); u.setType(rs.getInt(5)); u.setStatus(rs.getInt(6)); u.setLast_login(rs.getTimestamp(7)); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(rs,pstmt,conn); } returnu; } publicUserselectById(intId){ Useruser=newUser(); Connectionconn=DBUtil.getConnection(); PreparedStatementpstmt=null; ResultSetrs=null; Stringsql="select*fromusersswhereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setInt(1,Id); rs=pstmt.executeQuery(); if(rs.next()){ user.setId(rs.getInt(1)); user.setLogin(rs.getString(2)); user.setName(rs.getString(3)); user.setPassword(rs.getString(4)); user.setType(rs.getInt(5)); user.setStatus(rs.getInt(6)); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(rs,pstmt,conn); } returnuser; } publicList<User>selectAll(){ List<User>list=newArrayList<User>(); Connectionconn=DBUtil.getConnection(); PreparedStatementpstmt=null; ResultSetrs=null; Stringsql="select*fromuserssorderbyiddesc"; try{ pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()){ Useruser=newUser(); user.setId(rs.getInt(1)); user.setLogin(rs.getString(2)); user.setName(rs.getString(3)); user.setPassword(rs.getString(4)); user.setType(rs.getInt(5)); user.setStatus(rs.getInt(6)); list.add(user); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(rs,pstmt,conn); } returnlist; } //userdao中的update方法 publicintupdate(Userusers){ intn=-1; Connectionconn=DBUtil.getConnection();//连接对象 PreparedStatementpstmt=null;//语句对象 Stringsql="updateuserss" +"setlogin=?,name=?,passwd=123,type=?,status=?whereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,users.getLogin()); pstmt.setString(2,users.getName()); pstmt.setInt(3,users.getType()); pstmt.setInt(4,users.getStatus()); pstmt.setInt(5,users.getId()); n=pstmt.executeUpdate();//n=更新的行数 }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } //userdao中的delete方法 publicintdelete(intid){ intm=-1; Connectionconn=DBUtil.getConnection();//连接对象 PreparedStatementpstmt=null;//语句对象 Stringsql="deletefromusersswhereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); m=pstmt.executeUpdate();//n=更新的行数 }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnm; } }二．科目管理：需要的servlet：（SubjectViewServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.Subject;importcn.zhangzhiyong.dao.SubjectDAO;importcn.zhangzhiyong.util.RequestUtil;/***ServletimplementationclassSubjectViewServlet*/@WebServlet("/SubjectViewServlet")publicclassSubjectViewServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicSubjectViewServlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); SubjectDAOdao=newSubjectDAO(); intid=RequestUtil.getInt(request,"id"); Subjectsubject=dao.selectById(id); request.setAttribute("Subject",subject); request.getRequestDispatcher("res/subject-show.jsp").forward(request,response); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（SubjectUpdate2Servlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.Subject;importcn.zhangzhiyong.dao.SubjectDAO;importcn.zhangzhiyong.util.RequestUtil;@WebServlet("/SubjectUpdate2Servlet")publicclassSubjectUpdate2ServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicSubjectUpdate2Servlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ Subjectsubject=newSubject(); subject.setKname(RequestUtil.getString(request,"kname")); subject.setType(RequestUtil.getInt(request,"type")); subject.setKint(RequestUtil.getString(request,"kint")); subject.setId(RequestUtil.getInt(request,"id")); SubjectDAOdao=newSubjectDAO(); intn=dao.update(subject); response.sendRedirect("ServletListServlet?type=list"); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（SubjectUpdate0Servlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.Subject;importcn.zhangzhiyong.dao.SubjectDAO;importcn.zhangzhiyong.util.RequestUtil;/***ServletimplementationclassSubjectUpdate0Servlet*/@WebServlet("/SubjectUpdate0Servlet")publicclassSubjectUpdate0ServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicSubjectUpdate0Servlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); response.setContentType("text/html;charset=utf-8"); SubjectDAOdao=newSubjectDAO(); intid=RequestUtil.getInt(request,"id"); Subjectsubject=dao.selectById(id); request.setAttribute("Subject",subject); request.getRequestDispatcher("res/subject-update.jsp").forward(request,response); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（SubjectListServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjava.util.List;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.dao.SubjectDAO;importcn.zhangzhiyong.bean.Subject;/***ServletimplementationclassSubjectListServlet*/@WebServlet("/SubjectListServlet")publicclassSubjectListServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicSubjectListServlet(){super();//TODOAuto-generatedconstructorstub}protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("utf-8"); SubjectDAOdao=newSubjectDAO(); List<Subject>list=dao.selectAll(); request.setAttribute("list",list); request.getRequestDispatcher("res/subject1.jsp").forward(request,response); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（SubjectDeleteServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.dao.SubjectDAO;importcn.zhangzhiyong.util.RequestUtil;@WebServlet("/SubjectDeleteServlet")publicclassSubjectDeleteServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;publicSubjectDeleteServlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ request.setCharacterEncoding("UTF-8"); intid=RequestUtil.getInt(request,"id"); SubjectDAOdao=newSubjectDAO(); dao.delete(id); response.sendRedirect("SubjectListServlet?type=list"); } protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ doGet(request,response); }}（SubjectAddServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.Subject;importcn.zhangzhiyong.dao.SubjectDAO;importcn.zhangzhiyong.util.RequestUtil;/***ServletimplementationclassSubjectAddServlet*/@WebServlet("/SubjectAddServlet")publicclassSubjectAddServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;/***@seeHttpServlet#HttpServlet()*/publicSubjectAddServlet(){super();//TODOAuto-generatedconstructorstub} /** *@seeHttpServlet#doGet(HttpServletRequestrequest,HttpServletResponseresponse) */ protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ Subjectsubject=newSubject(); subject.setKname(RequestUtil.getString(request,"kname")); subject.setType(RequestUtil.getInt(request,"type")); subject.setKint(RequestUtil.getString(request,"kint")); SubjectDAOdao=newSubjectDAO(); intn=dao.save(subject); response.sendRedirect("SubjectListServlet?type=list"); } /** *@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse) */ protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ //TODOAuto-generatedmethodstub doGet(request,response); }}需要的类：packagecn.zhangzhiyong.bean;publicclassSubject{ privateintid; privateStringkname; privateinttype; privateStringkint; publicintgetId(){ returnid; } publicvoidsetId(intid){ this.id=id; } publicStringgetKname(){ returnkname; } publicvoidsetKname(Stringkname){ this.kname=kname; } publicintgetType(){ returntype; } publicvoidsetType(inttype){ this.type=type; } publicStringgetKint(){ returnkint; } publicvoidsetKint(Stringkint){ this.kint=kint; } }需要的dao：packagecn.zhangzhiyong.dao;importjava.sql.Connection;importjava.sql.PreparedStatement;importjava.sql.ResultSet;importjava.sql.SQLException;importjava.util.ArrayList;importjava.util.List;importcn.zhangzhiyong.util.DBUtil;importcn.zhangzhiyong.bean.Subject;publicclassSubjectDAO{ publicstaticList<Subject>selectAll(){ List<Subject>list=newArrayList<>(); Connectionconn=DBUtil.getConnection(); PreparedStatementpstmt=null; ResultSetrs=null; Stringsql="select*fromkuser"; try{ pstmt=conn.prepareStatement(sql); rs=pstmt.executeQuery(); while(rs.next()){ Subjectsubject=newSubject(); subject.setId(rs.getInt(1)); subject.setKname(rs.getString(2)); subject.setType(rs.getInt(3)); subject.setKint(rs.getString(4)); list.add(subject); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(rs,pstmt,conn); } returnlist; } publicSubjectselectById(intid){ Subjectsubject=newSubject(); Connectionconn=DBUtil.getConnection(); PreparedStatementpstmt=null; ResultSetrs=null; Stringsql="select*fromkuserwhereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); rs=pstmt.executeQuery(); if(rs.next()){ subject.setId(rs.getInt(1)); subject.setKname(rs.getString(2)); subject.setType(rs.getInt(3)); subject.setKint(rs.getString(4)); } }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(rs,pstmt,conn); } returnsubject; } publicintsave(Subjectsubject){ intn=-1; Connectionconn=DBUtil.getConnection();//连接对象 PreparedStatementpstmt=null;//语句对象 //下边是s语句 Stringsql="insertintokuser" +"values(seq_qst_kuser.nextval,?,?,?)"; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,subject.getKname()); pstmt.setInt(2,subject.getType()); pstmt.setString(3,subject.getKint()); n=pstmt.executeUpdate();//n=更新的行数 }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } publicintupdate(Subjectsubject){ intn=-1; Connectionconn=DBUtil.getConnection();//连接对象 PreparedStatementpstmt=null;//语句对象 //下边是s语句 Stringsql="updatekusersetkname=?,kint=?,type=?whereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setString(1,subject.getKname()); pstmt.setString(2,subject.getKint()); pstmt.setInt(3,subject.getType()); pstmt.setInt(4,subject.getId()); n=pstmt.executeUpdate();//n=更新的行数 }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } publicintdelete(intid){ intm=-1; Connectionconn=DBUtil.getConnection();//连接对象 PreparedStatementpstmt=null;//语句对象 Stringsql="deletefromkuserwhereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); m=pstmt.executeUpdate();//n=更新的行数 }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnm; } }三．知识点管理：需要的servlet：（KnowAddServlet）packagecn.zhangzhiyong.service;importjava.io.IOException;importjavax.servlet.ServletException;importjavax.servlet.annotation.WebServlet;importjavax.servlet.http.HttpServlet;importjavax.servlet.http.HttpServletRequest;importjavax.servlet.http.HttpServletResponse;importcn.zhangzhiyong.bean.knowlege;importcn.zhangzhiyong.dao.KnowlegeDAO;/***ServletimplementationclassKnowAddServlet*/@WebServlet("/KnowAddServlet")publicclassKnowAddServletextendsHttpServlet{ privatestaticfinallongserialVersionUID=1L;/***@seeHttpServlet#HttpServlet()*/publicKnowAddServlet(){super();} protectedvoiddoGet(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{request.setCharacterEncoding("utf-8"); Stringtitle=request.getParameter("title"); Stringdepict=request.getParameter("depict"); intsubject_id=Integer.parseInt(request.getParameter("subject_id")); Knowlegeknow=newKnowlege(title,depict,subject_id); KnowlegeDAOdao=newKnowlegeDAO(); intn=dao.save(know); if(n==1){ response.sendRedirect("KnowListServlet?type=list"); }else{ System.out.println("hhhh"); } } /** *@seeHttpServlet#doPost(HttpServletRequestrequest,HttpServletResponseresponse) */ protectedvoiddoPost(HttpServletRequestrequest,HttpServletResponseresponse)throwsServletException,IOException{ //TODOAuto-generatedme