数据库访问

package beans;

import java.sql.Connection;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.util.List;

public class sqlOp {
    public int insert(Student ss) throws SQLException, ClassNotFoundException {
        ConnectDbase db = new ConnectDbase();
        Connection conn = db.getCon();
        String sql = "Insert into stu(xh,xm,cj) values(?,?,?)";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, ss.getXh());
        pstmt.setString(2, ss.getXm());
        pstmt.setDouble(3, ss.getCj());
        int n = pstmt.executeUpdate();
        db.close();
        return n;
    }

    public int insert(List<Student> list) throws SQLException, ClassNotFoundException {
        for (int i = 0; i < list.size(); i++) {
            insert(list.get(i));
        }
        return 0;
    }

    public int delete(Student s) throws SQLException {
        ConnectDbase db = new ConnectDbase();
        Connection conn = null;
        try {
            conn = db.getCon();
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }
        String sql = "delete from stu where xh=?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, s.getXh());
        int n = pstmt.executeUpdate();
        db.close();
        return n;
    }

    public int update(Student s) throws SQLException, ClassNotFoundException {
        ConnectDbase db = new ConnectDbase();
        Connection conn = db.getCon();
        String sql = "update stu set xm=?,cj=? where xh=?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, s.getXm());
        pstmt.setDouble(2, s.getCj());
        pstmt.setInt(3, s.getXh());
        int n = pstmt.executeUpdate();
        db.close();
        return n;
    }

    public Student queryById(int xh) throws SQLException, ClassNotFoundException {
        ConnectDbase db = new ConnectDbase();
        Connection conn = db.getCon();
        Student user = null;
        String sql = "select * from stu where xh=?";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, xh);
        ResultSet rs = pstmt.executeQuery();
        if (rs.next()) {
            user = new Student();
            user.setXh(rs.getInt(1));
            user.setXm(rs.getString(2));
            user.setCj(rs.getDouble(3));
        }
        db.close();
        return user;
    }

    public List<Student> queryAll() throws SQLException, ClassNotFoundException {
        ConnectDbase db = new ConnectDbase();
        Connection conn = db.getCon();
        List<Student> list = new ArrayList<Student>();
        String sql = "select * from stu ";
        PreparedStatement pstmt = conn.prepareStatement(sql);
        ResultSet rs = pstmt.executeQuery();
        while (rs.next()) {
            Student user = new Student();
            user.setXh(rs.getInt(1));
            user.setXm(rs.getString(2));
            user.setCj(rs.getDouble(3));
            list.add(user);
        }
        db.close();
        return list;
    }
}

package servlets;

import beans.Student;
import beans.sqlOp;

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 java.io.IOException;
import java.sql.SQLException;

@WebServlet(name = "Delete", urlPatterns = "/delete")
public class Delete extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        request.setCharacterEncoding("utf-8");
        response.setCharacterEncoding("utf-8");
        int xh = Integer.parseInt(request.getParameter("xh"));
        Student ss = new Student(xh);
        sqlOp op = new sqlOp();
        try {
            int n = op.delete(ss);
            if(n>=1){
                request.getRequestDispatcher("success.jsp").forward(request,response);
            }
            else
                request.getRequestDispatcher("error.jsp").forward(request,response);
        } catch (SQLException e) {
            e.printStackTrace();
        }

    }

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

    }
}

package servlets;

import beans.Student;
import beans.sqlOp;

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 java.io.IOException;
import java.sql.SQLException;
import java.util.List;

@WebServlet(name = "queryAll", urlPatterns = "/queryAll")
public class queryAll extends HttpServlet {
    protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        int x = Integer.parseInt(request.getParameter("xh"));
        try {
            Student ss = new sqlOp().queryById(x);
            request.setAttribute("quaryById",ss);
            request.getRequestDispatcher("queryById.jsp").forward(request,response);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }

    }

    protected void doGet(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
        List<Student> students = null;
        try {
            students = new sqlOp().queryAll();
            request.setAttribute("studentsList", students);
            request.getRequestDispatcher("studentsList.jsp").forward(request, response);
        } catch (SQLException e) {
            e.printStackTrace();
        } catch (ClassNotFoundException e) {
            e.printStackTrace();
        }


    }
}

<%@ page import="beans.Student" %>
<%@ page import="java.util.List" %><%--
  Created by IntelliJ IDEA.
  User: acer
  Date: 2019/5/30
  Time: 15:52
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>所有学生信息显示页面</title>
</head>
<body>
<table border="1" cellspacing="0px" cellpadding="10px">
    <caption>学生信息</caption>
    <tr>
        <th>学号</th>
        <th>姓名</th>
        <th>成绩</th>
    </tr>
    <%
        List<Student> studentsList = (List<Student>) request.getAttribute("studentsList");
        for (Student stu : studentsList) {

    %>
    <tr>
        <td><%= stu.getXh() %></td>
        <td><%= stu.getXm() %></td>
        <td><%= stu.getCj() %></td>
    </tr>
    <%
        }
    %>
</table>
</body>
</html>