合集

随笔分类

随笔档案

阅读排行榜

评论排行榜

1. 2023.7.3(1)

最新评论

1. Re:2023.7.3
很好很好
--杳无音讯

每日总结54

合集 - 大二日报(66)

1.每日总结12024-03-11 2.每日总结22024-03-11 3.每日总结32024-03-11 4.每日总结42024-03-11 5.每日总结52024-03-19 6.每日总结62024-03-19 7.每日总结72024-03-19 8.每日总结82024-03-19 9.每日总结92024-03-19 10.每日总结102024-03-19 11.每日总结112024-03-28 12.每日总结122024-03-28 13.每日总结132024-03-28 14.每日总结142024-03-28 15.每日总结152024-03-28 16.每日总结162024-03-28 17.每日总结172024-03-28 18.每日总结182024-04-02 19.每日总结192024-04-02 20.每日总结202024-04-02 21.每日总结212024-04-16 22.每日总结222024-04-16 23.每日总结232024-04-16 24.每日总结242024-04-16 25.每日总结252024-04-16 26.每日总结262024-04-16 27.每日总结272024-04-16 28.每日总结282024-04-16 29.每日总结292024-04-16 30.每日总结302024-04-16 31.每日总结322024-04-23 32.每日总结312024-04-23 33.每日总结332024-04-23 34.每日总结342024-04-23 35.每日总结352024-04-23 36.每日总结412024-05-22 37.每日总结422024-05-22 38.每日总结442024-05-22 39.每日总结462024-05-22 40.每日总结472024-05-22 41.构建之法读后感022024-05-22 42.构建之法读后感032024-05-22 43.梦断代码读后感012024-05-09 44.梦断代码读后感022024-05-10 45.梦断代码读后感032024-05-17 46.构建之法读后感012024-05-17 47.每日总结392024-05-17 48.每日总结402024-05-17 49.每日总结452024-05-22 50.每日总结482024-05-23 51.每日总结492024-05-24 52.每日总结502024-05-27 53.每日总结512024-05-28 54.每日总结522024-05-29 55.每日总结532024-05-31

56.每日总结542024-06-03

57.每日总结552024-06-04 58.每日总结562024-06-05 59.每日总结572024-06-06 60.每日总结582024-06-07 61.每日总结602024-06-11 62.每日总结612024-06-12 63.每日总结64（事后诸葛亮会议）2024-06-13 64.每日总结63（关于课程个人总结）2024-06-12 65.第一阶段冲刺个人分工2024-04-27 66.每日总结622024-06-12

今天完成了一个webapp的实验以及项目

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <title>新增学生</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<h1>新增学生</h1>
<form action="addsave.jsp" method="post">
    <label>学号:</label><input type="text" name="id" required><br>
    <label>姓名:</label><input type="text" name="name" required><br>
    <label>性别:</label><input type="text" name="gender" required><br>
    <label>生日:</label><input type="date" name="birthdate" required><br>
    <input type="submit" value="提交">
</form>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("utf-8");%>
<!DOCTYPE html>
<html>
<head>
    <title>添加结果</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<%
    int id = Integer.parseInt(request.getParameter("id"));
    String name = request.getParameter("name");
    String gender = request.getParameter("gender");
    String birthdate = request.getParameter("birthdate");

    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/students?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "web", "123456");
        String sql = "INSERT INTO students (id, name, gender, birthdate) VALUES (?, ?, ?, ?)";
        pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, id);
        pstmt.setString(2, name);
        pstmt.setString(3, gender);
        pstmt.setDate(4, Date.valueOf(birthdate));
        int result = pstmt.executeUpdate();
        if (result > 0) {
            out.println("添加成功！");
        } else {
            out.println("添加失败！");
        }
    } catch (Exception e) {
        response.sendRedirect("error.jsp?msg=" + e.getMessage());
    } finally {
        try {
            if (pstmt != null) pstmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>
<a href="index.jsp">返回首页</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("utf-8");%>
<!DOCTYPE html>
<html>
<head>
    <title>删除结果</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<%
    int id = Integer.parseInt(request.getParameter("id"));

    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/students?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "web", "123456");
        String sql = "DELETE FROM students WHERE id=?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, id);
        int result = pstmt.executeUpdate();
        if (result > 0) {
            out.println("删除成功！");
        } else {
            out.println("删除失败！");
        }
    } catch (Exception e) {
        response.sendRedirect("error.jsp?msg=" + e.getMessage());
    } finally {
        try {
            if (pstmt != null) pstmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>
<a href="index.jsp">返回首页</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<!DOCTYPE html>
<html>
<head>
    <title>编辑学生</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<h1>编辑学生</h1>
<%
    int id = Integer.parseInt(request.getParameter("id"));
    Connection conn = null;
    PreparedStatement pstmt = null;
    ResultSet rs = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/students?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "web", "123456");
        String sql = "SELECT * FROM students WHERE id=?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setInt(1, id);
        rs = pstmt.executeQuery();
        if (rs.next()) {
            String name = rs.getString("name");
            String gender = rs.getString("gender");
            Date birthdate = rs.getDate("birthdate");
%>
<form action="editsave.jsp" method="post">
    <input type="hidden" name="id" value="<%= id %>">
    <label>姓名:</label><input type="text" name="name" value="<%= name %>" required><br>
    <label>性别:</label><input type="text" name="gender" value="<%= gender %>" required><br>
    <label>生日:</label><input type="date" name="birthdate" value="<%= birthdate %>" required><br>
    <input type="submit" value="提交">
</form>
<%
        } else {
            out.println("未找到学生信息");
        }
    } catch (Exception e) {
        response.sendRedirect("error.jsp?msg=" + e.getMessage());
    } finally {
        try {
            if (rs != null) rs.close();
            if (pstmt != null) pstmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("utf-8");%>
<!DOCTYPE html>
<html>
<head>
    <title>修改结果</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<%
    int id = Integer.parseInt(request.getParameter("id"));
    String name = request.getParameter("name");
    String gender = request.getParameter("gender");
    String birthdate = request.getParameter("birthdate");

    Connection conn = null;
    PreparedStatement pstmt = null;
    try {
        Class.forName("com.mysql.cj.jdbc.Driver");
        conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/students?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "web", "123456");
        String sql = "UPDATE students SET name=?, gender=?, birthdate=? WHERE id=?";
        pstmt = conn.prepareStatement(sql);
        pstmt.setString(1, name);
        pstmt.setString(2, gender);
        pstmt.setDate(3, Date.valueOf(birthdate));
        pstmt.setInt(4, id);
        int result = pstmt.executeUpdate();
        if (result > 0) {
            out.println("修改成功！");
        } else {
            out.println("修改失败！");
        }
    } catch (Exception e) {
        response.sendRedirect("error.jsp?msg=" + e.getMessage());
    } finally {
        try {
            if (pstmt != null) pstmt.close();
            if (conn != null) conn.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>
<a href="index.jsp">返回首页</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<!DOCTYPE html>
<html>
<head>
    <title>错误页面</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<h1>发生错误</h1>
<p><%= request.getParameter("msg") %></p>
<a href="index.jsp">返回首页</a>
</body>
</html>

<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%>
<%@ page import="java.sql.*" %>
<%request.setCharacterEncoding("utf-8");%>
<!DOCTYPE html>
<html>
<head>
    <title>学生管理系统</title>
    <link rel="stylesheet" type="text/css" href="css/styles.css">
</head>
<body>
<h1>学生列表</h1>
<a href="add.jsp">新增学生</a>
<table border="1">
    <tr>
        <th>学号</th>
        <th>姓名</th>
        <th>性别</th>
        <th>生日</th>
        <th>操作</th>
    </tr>
    <%
        Connection conn = null;
        Statement stmt = null;
        ResultSet rs = null;
        try {
            Class.forName("com.mysql.cj.jdbc.Driver");
            conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/students?useUnicode=true&characterEncoding=UTF-8&serverTimezone=UTC", "web", "123456");
            stmt = conn.createStatement();
            rs = stmt.executeQuery("SELECT * FROM students");
            while (rs.next()) {
                int id = rs.getInt("id");
                String name = rs.getString("name");
                String gender = rs.getString("gender");
                Date birthdate = rs.getDate("birthdate");
    %>
    <tr>
        <td><%= id %></td>
        <td><%= name %></td>
        <td><%= gender %></td>
        <td><%= birthdate %></td>
        <td>
            <a href="edit.jsp?id=<%= id %>">编辑</a>
            <a href="del.jsp?id=<%= id %>">删除</a>
        </td>
    </tr>
    <%
            }
        } catch (Exception e) {
            response.sendRedirect("error.jsp?msg=" + e.getMessage());
        } finally {
            try {
                if (rs != null) rs.close();
                if (stmt != null) stmt.close();
                if (conn != null) conn.close();
            } catch (SQLException e) {
                e.printStackTrace();
            }
        }
    %>
</table>
</body>
</html>

posted on 2024-06-03 23:34 淮竹i 阅读(7) 评论(0) 编辑收藏举报

刷新页面返回顶部

登录后才能查看或发表评论，立即登录或者逛逛博客园首页

相关博文：

· 家庭记账本（七）

· 每日总结61

· 2024/6/8 日程练习

· 每日总结5

· 2023/5/26总结

阅读排行：
· 震惊！C++程序真的从main开始吗？99%的程序员都答错了
· 别再用vector＜bool＞了！Google高级工程师：这可能是STL最大的设计失误
· 单元测试从入门到精通
· 【硬核科普】Trae如何「偷看」你的代码？零基础破解AI编程运行原理
· 上周热点回顾（3.3-3.9）

导航

搜索

常用链接

合集

随笔分类

随笔档案

阅读排行榜

评论排行榜

推荐排行榜

最新评论