智能移動(dòng)方向Jsp開發(fā)實(shí)訓(xùn)任務(wù)書及實(shí)訓(xùn)報(bào)告-在線考試系統(tǒng)的制作

學(xué)校代碼：10128學(xué)號(hào)：201320905047學(xué)校代碼：10128學(xué)號(hào)：201320905047JSP開發(fā)實(shí)訓(xùn)報(bào)告書題目：在線考試系統(tǒng)的制作學(xué)生姓名：張志勇學(xué)院：理學(xué)院班級(jí)：信計(jì)13-1指導(dǎo)教師：李曉瑜、宋健、賴俊峰二〇一六年一月

一、項(xiàng)目名稱

在線考試系統(tǒng)-題庫子系統(tǒng)二、功能要求

a、用戶管理b、課程管理c、題庫管理三、需求分析《在線考試系統(tǒng)-題庫子系統(tǒng)》的用戶包括用戶管理員，試題管理員和題庫使用人員，旨在建立一個(gè)獨(dú)立的題庫系統(tǒng)，為在線考試生成試卷提供支持，包含用戶管理，科目管理，試題管理，生成試卷，試卷分析等內(nèi)容，為用戶提供了一個(gè)快速、全面、準(zhǔn)確的試題管理平臺(tái)。四、設(shè)計(jì)思想a、使用JavaWeb技術(shù)實(shí)現(xiàn)b、使用Mysql存儲(chǔ)數(shù)據(jù)c、基于MVC方式實(shí)現(xiàn)用例設(shè)計(jì)思路：（如下圖）分步詳解：第一步：創(chuàng)建項(xiàng)目名（zhangzhiyong）；第二步：創(chuàng)建項(xiàng)目所需要的包；第三步：導(dǎo)入需要的工具；第四步：創(chuàng)建數(shù)據(jù)庫的連接；第五步：需要的準(zhǔn)備工作做好之后，明確先做用戶管理系統(tǒng)（登錄，查看，刪除，修改，增加，退出；）；第六步：做好用戶管理之后進(jìn)行科目管理（增加，刪除，修改，查看；）；第七步：接下來進(jìn)行知識(shí)點(diǎn)管理（增加，刪除，修改，查看；）；五、具體實(shí)現(xiàn)一．用戶管理：需要的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('用戶名或密碼錯(cuò)誤，請(qǐng)重新輸入！');"); 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();//連接對(duì)象 PreparedStatementpstmt=null;//語句對(duì)象 //下邊是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=更新的行數(shù) }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();//連接對(duì)象 PreparedStatementpstmt=null;//語句對(duì)象 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=更新的行數(shù) }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } //userdao中的delete方法 publicintdelete(intid){ intm=-1; Connectionconn=DBUtil.getConnection();//連接對(duì)象 PreparedStatementpstmt=null;//語句對(duì)象 Stringsql="deletefromusersswhereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); m=pstmt.executeUpdate();//n=更新的行數(shù) }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();//連接對(duì)象 PreparedStatementpstmt=null;//語句對(duì)象 //下邊是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=更新的行數(shù) }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } publicintupdate(Subjectsubject){ intn=-1; Connectionconn=DBUtil.getConnection();//連接對(duì)象 PreparedStatementpstmt=null;//語句對(duì)象 //下邊是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=更新的行數(shù) }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnn; } publicintdelete(intid){ intm=-1; Connectionconn=DBUtil.getConnection();//連接對(duì)象 PreparedStatementpstmt=null;//語句對(duì)象 Stringsql="deletefromkuserwhereid=?"; try{ pstmt=conn.prepareStatement(sql); pstmt.setInt(1,id); m=pstmt.executeUpdate();//n=更新的行數(shù) }catch(SQLExceptione){ e.printStackTrace(); }finally{ DBUtil.closeJDBC(null,pstmt,conn); } returnm; } }三．知識(shí)點(diǎn)管理：需要的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