智能移动方向jsp开发实训任务书及实训报告--在线考试系统的制作--大学毕业设计论文.doc

学校代码： 10128
学 号： 201320905047

JSP开发实训报告书

题 目：在线考试系统的制作
学生姓名：张志勇
学 院：理学院
班 级：信计13-1
指导教师：李晓瑜、宋健、赖俊峰

二〇一六年一月

一、项目名称
　　在线考试系统-题库子系统
二、功能要求

– a、用户管理
– b、课程管理
– c、题库管理

三、需求分析
《在线考试系统-题库子系统》的用户包括用户管理员，试题管理员和题库使用人员，旨在建立一个独立的题库系统，为在线考试生成试卷提供支持，包含用户管理，科目管理，试题管理，生成试卷，试卷分析等内容，为用户提供了一个快速、全面、准确的试题管理平台。

四、设计思想
a、使用Java Web技术实现
b、使用Mysql存储数据
c、基于MVC方式实现用例
设计思路：（如下图）

分步详解：
第一步：创建项目名（zhangzhiyong）；
第二步：创建项目所需要的包；
第三步：导入需要的工具；
第四步：创建数据库的连接；
第五步：需要的准备工作做好之后，明确先做用户管理系统（登录，查看，删除，修改，增加，退出；）；
第六步：做好用户管理之后进行科目管理（增加，删除，修改，查看；）；
第七步：接下来进行知识点管理（增加，删除，修改，查看；）；

五、具体实现
一．用户管理：
需要的servlet：
（user servlet）
package cn.zhangzhiyong.service;
import java.io.IOException;
import java.io.PrintWriter;
import java.util.List;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.dao.UserDAO;
import cn.zhangzhiyong.util.RequestUtil;
@WebServlet("/UserServlet")
public class UserServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public UserServlet() {
super();
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out=response.getWriter();
String type=request.getParameter("type");
String userLogname=request.getParameter("userLogname");
String userPwd=request.getParameter("userPwd");
UserDAO dao=new UserDAO();
User user=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("<script type='text/javascript'>");
out.print("alert('用户名或密码错误，请重新输入！');");
out.print("window.location='login.jsp';");
out.print("</script>");
}
}else if("logout".equals(type)){
request.getSession().invalidate();
out.print("<script type='text/javascript'>");
out.print("window.location='login.jsp';");
out.print("</script>");
}else if("list".equals(type)){
List<User> list=dao.selectAll();
request.setAttribute("list",list);
request.getRequestDispatcher("res/user.jsp").forward(request, response);
}

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

}
（user add servlet）
package cn.zhangzhiyong.service;
import java.io.IOException;
import java.io.PrintWriter;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.dao.UserDAO;
import cn.zhangzhiyong.util.RequestUtil;
@WebServlet("/UserAddServlet")
public class UserAddServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

public UserAddServlet() {
super();
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");

String login=request.getParameter("login");
String name=request.getParameter("name");
int type=(request.getParameter("type")==null)?
3:Integer.parseInt(request.getParameter("type")); int status=(request.getParameter("status")==null)?
1:Integer.parseInt(request.getParameter("status"));
User user=new User(login,name,type,status);
UserDAO dao=new UserDAO();
int n=dao.save(user);
if(n==1){
response.sendRedirect("UserServlet?type=list");
}else{
response.sendRedirect("index.jsp");
}

}

protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

}
（UserDeleteServlet）
package cn.zhangzhiyong.service;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.dao.UserDAO;
import cn.zhangzhiyong.util.RequestUtil;
import cn.zhangzhiyong.util.WebUtil;

@WebServlet("/UserDeleteServlet")
public class UserDeleteServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

public UserDeleteServlet() {
super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("UTF-8");
// System.out.println(request.getParameter("Id"));
int id=RequestUtil.getInt(request,"Id");
UserDAO dao=new UserDAO();
dao.delete(id);
WebUtil.forward(request, response, "UserServlet?type=list");
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
（UserUpdate1Servlet）
package cn.zhangzhiyong.service;
import java.io.File;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.servlet.http.Part;
import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.dao.UserDAO;
import cn.zhangzhiyong.util.RequestUtil;
import cn.zhangzhiyong.util.WebUtil;
@WebServlet("/UserUpdate1Servlet")
public class UserUpdate1Servlet extends HttpServlet {
private static final long serialVersionUID = 1L;

public UserUpdate1Servlet() {
super();

}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");

int id=RequestUtil.getInt(request,"Id");

request.setAttribute("id", id);
request.getRequestDispatcher("res/user-update.jsp").forward(request, response);

}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
// TODO Auto-generated method stub
doGet(request, response);
}

}
（UserUpdateServlet）
package cn.zhangzhiyong.service;
import java.io.IOException;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.dao.UserDAO;
import cn.zhangzhiyong.util.RequestUtil;
@WebServlet("/UserUpdateServlet")
public class UserUpdateServlet extends HttpServlet {
private static final long serialVersionUID = 1L;
public UserUpdateServlet() {
super();
}
protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");

String login=request.getParameter("login");
String name=request.getParameter("name");
String passwd=request.getParameter("passwd");
int type=Integer.parseInt(request.getParameter("type"));
int status=Integer.parseInt(request.getParameter("status"));

int id=RequestUtil.getInt(request,"id");
User users=new User(login,name,type,status);
UserDAO dao=new UserDAO();
int n=dao.update(users);
if(n==1){
response.sendRedirect("UserServlet?type=list");
}else{
response.sendRedirect("index.jsp");
}

}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

}
（UserViewServlet）
package cn.zhangzhiyong.service;

import java.io.IOException;
import java.io.PrintWriter;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.dao.UserDAO;
import cn.zhangzhiyong.util.RequestUtil;
@WebServlet("/UserViewServlet")
public class UserViewServlet extends HttpServlet {
private static final long serialVersionUID = 1L;

public UserViewServlet() {
super();
}

protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
request.setCharacterEncoding("utf-8");
response.setContentType("text/html;charset=utf-8");
PrintWriter out=response.getWriter();
String type=request.getParameter("type");
String userLogname=request.getParameter("userLogname");
String userPwd=request.getParameter("userPwd");
UserDAO dao=new UserDAO();
int id=RequestUtil.getInt(request,"Id");
User user1=dao.selectById(id);
request.setAttribute("user",user1);
request.getRequestDispatcher("res/user-show.jsp").forward(request, response);
}
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
doGet(request, response);
}

}

需要的类：
package cn.zhangzhiyong.bean;

import java.sql.Timestamp;

public class User {
public static final String passwd="123456";
private int id;
private String login;
private String name;
private String password;
private int type;
private int status;
private Timestamp last_login;
public User(String login2, String name2, int type2, int status2) {
super();
this.login=login2;
this.name=name2;
this.type=type2;
this.status=status2;
}
public User() {
}
public User(int id2) {
this.id=id2;
}
public int getId() {
return id;
}
public void setId(int id) {
this.id = id;
}
public String getLogin() {
return login;
}
public void setLogin(String login) {
this.login = login;
}
public String getName() {
return name;
}
public void setName(String name) {
this.name = name;
}
public String getPassword() {
return password;
}
public void setPassword(String password) {
this.password = password;
}
public int getType() {
return type;
}
public void setType(int type) {
this.type = type;
}
public int getStatus() {
return status;
}
public void setStatus(int status) {
this.status = status;
}
public Timestamp getLast_login() {
return last_login;
}
public void setLast_login(Timestamp last_login) {
this.last_login = last_login;
}

}

需要的dao：
package cn.zhangzhiyong.dao;
import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

import cn.zhangzhiyong.bean.User;
import cn.zhangzhiyong.util.DBUtil;

public class UserDAO {
//userdao中的save方法
public int save(User user){
int n=-1;
Connection conn=DBUtil.getConnection();//连接对象
PreparedStatement pstmt=null;//语句对象
//下边是s语句
String sql="insert into userss"
+" 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(SQLException e){
e.printStackTrace();
}finally{
DBUtil.closeJDBC(null, pstmt, conn);
}
return n;
}
public User login(String userLogname, String userPwd) {
Connection conn=DBUtil.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
User u=null;
String sql="select id,login,name,passwd,type,status,last_login"
+ " from users where login=? and passwd=?";
try{
pstmt=conn.prepareStatement(sql);
pstmt.setString(1, userLogname);
pstmt.setString(2, userPwd);
rs=pstmt.executeQuery();
if(rs.next()){
u=new User();
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(SQLException e){
e.printStackTrace();
}finally{
DBUtil.closeJDBC(rs, pstmt, conn);
}
return u;
}
public User selectById(int Id) {
User user=new User();
Connection conn=DBUtil.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="select * from userss where id=?";
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(SQLException e){
e.printStackTrace();
}finally{
DBUtil.closeJDBC(rs, pstmt, conn);
}
return user;
}
public List<User> selectAll(){
List<User> list=new ArrayList<User>();
Connection conn=DBUtil.getConnection();
PreparedStatement pstmt=null;
ResultSet rs=null;
String sql="select * from userss order by id desc";
try{
pstmt=conn.prepareStatement(sql);
rs=pstmt.executeQuery();
while(rs.next()){
User user=new User();
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(SQLException e){
e.printStackTrace();
}finally{
DBUtil.closeJDBC(rs, pstmt, conn);
}
return list;
}
//userdao中的update方法
public int update(User users){
int n=-1;
Connection conn=DBUtil.getConnection();//连接对象
PreparedStatement pstmt=null;//语句对象
String sql="update userss"
+ " set login=?,name=?,passwd=123,type=?,status=? where id=?";
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(SQLException e){
e.printStackTrace();
}finally{
DBUtil.closeJDBC(null, pstmt, conn);
}
re