Javaweb简单的学生管理系统（增删改）

人间忽晚..

于 2024-07-29 14:26:57 发布

阅读量403

点赞数 13

文章标签： java tomcat servlet

本文链接：https://blog.csdn.net/2301_79612384/article/details/140770261

版权

学生servlet

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.util.List;


@WebServlet("/sl")
public class studentListServlet extends HttpServlet {
    private StudentDao studentDao = new StudentDao();

    @Override
    protected void doGet(HttpServletRequest req, HttpServletResponse resp) throws ServletException, IOException {

        try {
            List<Student> list = studentDao.selectAll();
            req.setAttribute("list", list);
            req.getRequestDispatcher("studentList.jsp").forward(req, resp);
        } catch (Exception e) {
            e.printStackTrace();
        }
    }
}s数据库管理层

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

//dao Data Access Object 数据访问对象
public class StudentDao {
    private Connection conn = DBUtil.getConn();

    public List<Student> selectAll() throws Exception {
        String sql = "select * from student";
        Statement st = conn.createStatement();
        ResultSet rs = st.executeQuery(sql);

        List<Student> list = new ArrayList<>();

        while (rs.next()) {
            Student s = rsToStudent(rs);
            list.add(s);
        }
        rs.close();

        return list;

    }
    public void insert(Student st) throws Exception {
        String sql = "insert into student(sname,ssex,sage,sdept) values(?,?,?,?)";
        PreparedStatement ps = conn.prepareStatement(sql);
        ps.setString(1, st.getSname());
        ps.setString(2, st.getSsex());
        ps.setInt(3, st.getSage());
        ps.setString(4, st.getSdept());
        ps.executeUpdate();
    }
    public Student SelectByNo(int sno) throws Exception {
        return null;
    }
    public void update(Student st) throws Exception {
        
    }
    public void delete(String sno) throws Exception {

    }

    private Student rsToStudent(ResultSet rs) throws Exception {
        Student s = new Student();
        s.setSno(rs.getInt("sno"));
        s.setSname(rs.getString("sname"));
        s.setSsex(rs.getString("ssex"));
        s.setSage(rs.getInt("sage"));
        s.setSdept(rs.getString("sdept"));
        return s;
    }
}


数据库连接

import java.sql.Connection;
import java.sql.DriverManager;

public class DBUtil {
    private static Connection conn = null;
    static {
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            String url = "jdbc:mysql://localhost:3306/studb?serverTimezone=UTC&characterEncoding=UTF-8&useSSL=false";
            String username = "root";
            String password = "root";
            conn = DriverManager.getConnection(url, username, password);
        }catch (Exception e) {
            e.printStackTrace();
        }
    }
    public static Connection getConn() {
        return conn;
    }
}

public class Student {
    private int sno;
    private String sname;
    private String ssex;
    private int sage;
    private String sdept;

    public int getSno() {
        return sno;
    }

    public void setSno(int sno) {
        this.sno = sno;
    }

    public String getSname() {
        return sname;
    }

    public void setSname(String sname) {
        this.sname = sname;
    }

    public String getSsex() {
        return ssex;
    }

    public void setSsex(String ssex) {
        this.ssex = ssex;
    }

    public int getSage() {
        return sage;
    }

    public void setSage(int sage) {
        this.sage = sage;
    }

    public String getSdept() {
        return sdept;
    }

    public void setSdept(String sdept) {
        this.sdept = sdept;
    }
}

学生列表
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>学生列表</title>
</head>
<body>

<h1 align="center">学生列表</h1>
<h3 align="center"><a href="addStudent.jsp">添加学生</a></h3>
<table align="center" border="1" width="800px">
    <tr>
        <td>学号</td>
        <td>姓名</td>
        <td>性别</td>
        <td>年龄</td>
        <td>专业</td>
        <td>操作</td>
    </tr>
    <%
        List<Student> list = (List<Student>) request.getAttribute("list");
        for (Student s : list) {
            out.println("<tr>");
            out.println("<td>" + s.getSno() + "</td>");
            out.println("<td>" + s.getSname() + "</td>");
            out.println("<td>" + s.getSsex() + "</td>");
            out.println("<td>" + s.getSage() + "</td>");
            out.println("<td>" + s.getSdept() + "</td>");
            out.println("<td>");
            out.println("<a href='us?sno=" + s.getSno() + "'>修改</a>");
            out.println("<a href='ds?sno=" + s.getSno() + "'>删除</a>");
            out.println("</td>");
            out.println("</tr>");
        }
    %>
</table>
</body>
</html>

添加学生

<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>添加学生</title>
</head>
<body>

<h1>添加学生</h1>
<form action="as" method="post">
    姓名:<input type="text" name="sname"><br>
    性别:<input type="text" name="ssex"><br>
    年龄:<input type="text" name="sage"><br>
    专业:<input type="text" name="sdept"><br>
    <input type="submit" value="添加">
</form>
</body>
</html>

修改学生

<html>
<head>
    <title>修改学生</title>
</head>
<body>
<h1>修改学生</h1>
<%
    Student s = (Student) request.getAttribute("st");
%>
<form action="us" method="post">
    <%-- type="hidden"是一个隐藏输入框，作用是用来传值，不会在页面上显示--%>
    <input type="hidden" name="sno" value="<%=s.getSno()%>">
    姓名:<input type="text" name="sname" value="<%=s.getSname()%>"><br>
    性别:<input type="text" name="ssex" value="<%=s.getSsex()%>"><br>
    年龄:<input type="text" name="sage" value="<%=s.getSage()%>"><br>
    专业:<input type="text" name="sdept" value="<%=s.getSdept()%>"><br>
    <input type="submit" value="修改" >
</form>
</body>
</html>