JavaWeb-05-JSP规范-05-在线考试管理系统02-试题信息管理

用户信息管理模块传送门：用户信息管理模块

1.目标

试题信息管理模块

2.功能实现

1. 添加试题信息
2. 查询试题信息
3. 更新试题信息
4. 删除试题信息

3.准备工作

3.1创建试题信息表(t_question.frm)

drop table if exists t_question;
create table t_question(
	questionId int primary key auto_increment,#题目编号
    subject varchar(255),#题目	1+1=?
    optionA varchar(20), #选项A	1
    optionB varchar(20), #选项B	4
    optionC varchar(20), #选项C	2
    optionD varchar(20), #选项D	5
	answer  char(1)		 #正确答案  C
);
insert into t_question(subject,optionA,optionB,optionC,optionD,answer) value('1+1=?','1','4','2','5','C');
select * from t_question;

3.2创建试题信息表对应实体类

package com.tsccg.entity;

/**
 * @Author: TSCCG
 * @Date: 2021/08/23 22:59
 * 试题信息表对应实体类
 */
public class Question {
    private Integer questionId;
    private String subject;
    private String optionA;
    private String optionB;
    private String optionC;
    private String optionD;
    private String answer;

    /**
     * 无参构造
     */
    public Question() {
    }

    /**
     * 有参构造
     * @param questionId 题目编号
     * @param subject 题目
     * @param optionA 选项A
     * @param optionB 选项B
     * @param optionC 选项C
     * @param optionD 选项D
     * @param answer 正确答案
     */
    public Question(Integer questionId, String subject, String optionA,
                    String optionB, String optionC, String optionD, String answer) {
        this.questionId = questionId;
        this.subject = subject;
        this.optionA = optionA;
        this.optionB = optionB;
        this.optionC = optionC;
        this.optionD = optionD;
        this.answer = answer;
    }

    public Integer getQuestionId() {
        return questionId;
    }

    public void setQuestionId(Integer questionId) {
        this.questionId = questionId;
    }

    public String getSubject() {
        return subject;
    }

    public void setSubject(String subject) {
        this.subject = subject;
    }

    public String getOptionA() {
        return optionA;
    }

    public void setOptionA(String optionA) {
        this.optionA = optionA;
    }

    public String getOptionB() {
        return optionB;
    }

    public void setOptionB(String optionB) {
        this.optionB = optionB;
    }

    public String getOptionC() {
        return optionC;
    }

    public void setOptionC(String optionC) {
        this.optionC = optionC;
    }

    public String getOptionD() {
        return optionD;
    }

    public void setOptionD(String optionD) {
        this.optionD = optionD;
    }

    public String getAnswer() {
        return answer;
    }

    public void setAnswer(String answer) {
        this.answer = answer;
    }
}

3.3JdbcUtil工具类

package com.tsccg.util;

import java.sql.*;
import java.util.ResourceBundle;

/**
 * @Author: TSCCG
 * @Date: 2021/08/14 15:32
 * JDBC工具类
 * 1.注册驱动*
 * 2.获取连接*
 * 3.获取预编译的数据库操作对象
 * 4.执行sql
 * 5.处理查询结果集
 * 6.关闭资源*
 */
public class JdbcUtil {
    /**
     * 创建资源绑定器对象
     */
    private static final ResourceBundle BUNDLE = ResourceBundle.getBundle("JDBC");
    //1.注册驱动
    static {
        try {
            Class.forName(BUNDLE.getString("driverName"));
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
    }
    /**
     * 2.获取连接
     * @return 返回连接对象
     * @throws SQLException 将SQLException异常上抛
     */
    public static Connection connect() throws SQLException {
        return DriverManager.getConnection(BUNDLE.getString("url"),
                BUNDLE.getString("user"),BUNDLE.getString("password"));
    }

    /**
     * 6.释放资源
     * @param conn 连接对象
     * @param stmt 数据库操作对象
     * @param rs 查询结果集对象
     */
    public static void closeAll(Connection conn, Statement stmt, ResultSet rs) {
        if(rs != null) {
            try {
                rs.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
        if(stmt != null) {
            try {
                stmt.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }

        if(conn != null) {
            try {
                conn.close();
            } catch (SQLException throwables) {
                throwables.printStackTrace();
            }
        }
    }
}

4.添加试题信息

4.1搭建前台页面【question_add】

在web目录下创建question_add.html文件

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>添加试题信息</title>
    <style type="text/css">
        * {
            font-size: 20px;
        }
        h2 {
            color: green;
            font-size: 40px;
        }
    </style>
</head>
<body>
<center>
    <form action="http://localhost:8080/MyWeb/question/add" method="GET">
    <h2>添加试题信息</h2>
    <table border="1" cellpadding="0" cellspacing="0">
        <!-- 题目  -->
        <tr>
            <td>题目：</td>
            <td><input type="text" name="subject"></td>
        </tr>
        <!-- 选项A  -->
        <tr>
            <td>选项A：</td>
            <td><input type="text" name="optionA"></td>
        </tr>
        <!-- 选项B  -->
        <tr>
            <td>选项B：</td>
            <td><input type="text" name="optionB"></td>
        </tr>
        <!-- 选项C  -->
        <tr>
            <td>选项C：</td>
            <td><input type="text" name="optionC"></td>
        </tr>
        <!-- 选项D  -->
        <tr>
            <td>选项D：</td>
            <td><input type="text" name="optionD"></td>
        </tr>
        <!-- 正确答案  -->   
        <tr>
            <td>正确答案：</td>
            <td>
                <label>
                    <input type="radio" name="answer" value="A">A
                </label> 
                <label>
                    <input type="radio" name="answer" value="B">B
                </label> 
                <label>
                    <input type="radio" name="answer" value="C">C
                </label> 
                <label>
                    <input type="radio" name="answer" value="D">D
                </label> 
            </td>
        </tr>
        <!-- 提交  -->
        <tr>
            <td><input type="submit" value="添加试题"></td>
            <td><input type="reset" value="重置"></td>
        </tr>
    </table>
</form>
</center>
</body>
</html>

4.2编写Dao类【QuestionDao】

此类的主要作用是通过JDBC连接数据库，对数据库表的数据进行操作。

这里先实现添加功能。

package com.tsccg.dao;

import com.tsccg.entity.Question;
import com.tsccg.util.JdbcUtil;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.SQLException;

/**
 * @Author: TSCCG
 * @Date: 2021/08/23 23:32
 * 通过jdbc连接数据库,对t_question表中数据进行操作
 */
public class QuestionDao {
    /**
     * 1.添加试题信息
     * @param question 试题信息表对应实体类的实例对象
     * @return 返回添加结果,成功返回true,失败返回false
     */
    public boolean questionAdd(Question question) {
        Connection conn = null;
        PreparedStatement ps = null;
        boolean result = false;
        try {
            conn = JdbcUtil.connect();
            String sql = "insert into t_question(subject,optionA,optionB,optionC,optionD,answer) vlaue(?,?,?,?,?,?)";
            //获取预编译的数据库操作对象
            ps = conn.prepareStatement(sql);
            ps.setString(1,question.getSubject());
            ps.setString(2,question.getOptionA());
            ps.setString(3,question.getOptionB());
            ps.setString(4,question.getOptionC());
            ps.setString(5,question.getOptionD());
            ps.setString(6,question.getAnswer());
            //如果插入成功，那么ps.executeUpdate()返回的值一定大于0
            if (ps.executeUpdate() > 0) {
                result = true;
            }
        } catch(SQLException e) {
            e.printStackTrace();
        } finally {
            JdbcUtil.closeAll(conn,ps,null);
        }
        return result;
    }
}

4.3编写Servlet接口实现类【QuestionAddServlet】

package com.tsccg.controller;

import com.tsccg.dao.QuestionDao;
import com.tsccg.entity.Question;

import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import java.io.IOException;

/**
 * @Author: TSCCG
 * @Date: 2021/08/24 00:05
 * 实现添加试题信息功能
 */
public class QuestionAddServlet extends HttpServlet {
    @Override
    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        //1.定义
        String subject,optionA,optionB,optionC,optionD,answer;
        Question question = null;
        QuestionDao dao = new QuestionDao();
        //2.通过请求对象获取请求头中请求参数，也就是试题信息
        subject = request.getParameter("subject");
        optionA = request.getParameter("optionA");
        optionB = request.getParameter("optionB");
        optionC = request.getParameter("optionC");
        optionD = request.getParameter("optionD");
        answer = request.getParameter("answer");
        //将试题信息放入实体类对象中
        question = new Question(null,subject,optionA,optionB,optionC,optionD,answer);
        //3.调用Dao类，将试题信息传进去，然后将insert命令推送到数据库服务器，返回执行结果
        boolean result = dao.questionAdd(question);
        //4.通过请求转发，向Tomcat请求调用info.jsp，将处理结果写入响应体
        if (result) {
            request.setAttribute("info","试题添加成功");
        } else {
            request.setAttribute("info","试题添加失败");
        }
        request.getRequestDispatcher("/info.jsp").forward(request,response);
    }
}

4.4编写JSP文件【info.jsp】

在web目录下新建info.jsp

<%@ page import="static java.awt.SystemColor.info" %><%--
  Created by IntelliJ IDEA.
  User: Admin
  Date: 2021/8/24
  Time: 0:39
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>结果</title>
</head>
<body>
    <center>
        <%
            //从当前请求作用域对象中读取处理信息
            String result = (String)request.getAttribute("info");
        %>
        <%--展示处理信息--%>
        <font style="font-size: 30px" color="red">
            <%=result%>
        </font>
    </center>
</body>
</html>

4.5在导航页的菜单栏添加试题信息添加链接

<!DOCTYPE html>
<html lang="en">
<head>
    <meta charset="UTF-8">
    <title>left</title>
</head>
<body>
    <ul>
        <li>用户信息管理
            <ol>
                <li><a href="/MyWeb/user_add.html" target="right">用户信息注册</a></li>
                <li><a href="/MyWeb/user/find" target="right">用户信息查询</a></li>
            </ol>
        </li>
        <li>试题信息管理
            <ol>
                <li><a href="/MyWeb/question_add.html" target="right">试题信息添加</a></li>
                <li><a href="/MyWeb/question/find" target="right">试题信息查询</a></li>
            </ol>
        </li>
        <li>考试管理</li>
    </ul>
</body>
</html>

4.6测试添加试题信息功能