2023年5月12日(软件工程日报)

今日完成web相关实验3

过程较为顺利

复制代码
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="error.jsp"%>
<html>
<head>
    <title>添加图书信息</title>
    <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<form action="addsave.jsp" method="post">
    <h2>添加图书信息</h2>
    <table style="width: 50%">
        <tr>
            <th width="30%">学号：</th>
            <td width="70%"><input name="number" type="text"></td>
        </tr>
        <tr>
            <th>性名：</th>
            <td><input name="username" type="text"></td>
        </tr>
        <tr>
            <th>性别：</th>
            <td><input name="sex" type="text">元</td>
        </tr>
        <tr>
            <td colspan="2"><input type="submit" name="submit" value="添加"> <input type="reset" value="重置"></td>
        </tr>
    </table>
</form>

</body>
</html>
复制代码
复制代码
<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="error.jsp"%>
<html>
<head>
    <title>添加图书信息</title>
    <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<%
    request.setCharacterEncoding("utf-8");
    String number = request.getParameter("number");
    String username = request.getParameter("username");
    String sex = request.getParameter("sex");
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/judge1?useUnicode=true&characterEncoding=utf-8", "root", "123456");
    Statement stmt = con.createStatement();
    String sql = "insert into 学生数据(学号,姓名,性别) values('" + number + "','" + username + "'," + sex + ")";

    int i = stmt.executeUpdate(sql);
    if (i == 1) {
        out.println("<h2>添加成功！</h2><br/>");
        out.println("<a href='index.jsp'>返回首页</a>");
    } else {
        out.println("<h2>添加失败！</h2><br/>");
        out.println("<a href='add.jsp'>重新添加</a>");
    }
    stmt.close();
    con.close();

%>
</body>
</html>
复制代码
复制代码
<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" pageEncoding="utf-8"%>
<html>
<head>
  <title>删除图书信息</title>
  <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<%
  request.setCharacterEncoding("utf-8");
  Class.forName("com.mysql.jdbc.Driver");
  Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/judge1?useUnicode=true&characterEncoding=utf-8", "root", "123456");
  Statement stmt=con.createStatement();
  String number=request.getParameter("id");
  int i=stmt.executeUpdate("delete from 学生数据 where 学号="+number);
  if(i==1)
  {
    out.println("<h2>删除成功！</h2><br/>");
  }
  else
  {
    out.println("<h2>删除失败！</h2><br/>");
  }
  out.println("<a href='index.jsp'>返回首页</a>");
  stmt.close();
  con.close();

%>
</body>
</html>
复制代码
复制代码
<%@ page import="java.sql.*" pageEncoding="utf-8" errorPage="error.jsp"%>
<html>
<head>
    <title>修改图书信息</title>
    <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<%
    request.setCharacterEncoding("utf-8");
    String username = request.getParameter("id");
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/judge1?useUnicode=true&characterEncoding=utf-8", "root", "123456");
    PreparedStatement stmt = con.prepareStatement("select * from 学生数据 where 学号=?");
    stmt.setString(1, username);
    ResultSet rs = stmt.executeQuery();

    rs.next();
%>
<form action="editsave.jsp" method="post">
    <h2>修改学生信息</h2>
    <table style="width:50%">
        <tr>
            <th width="30%">学号：</th>
            <td width="70%"><input name="number" type="text"
                                   value="<%=rs.getString(1)%>"></td>
        </tr>
        <tr>
            <th>姓名：</th>
            <td><input name="username" type="text"
                       value="<%=rs.getString(2)%>"></td>
        </tr>
        <tr>
            <th>性别：</th>
            <td><input name="sex" type="text"
                       value="<%=rs.getString(3)%>"></td>
        </tr>
        <tr>
            <td colspan="2"><input type="hidden" name="id" value="<%=username%>">
                <input type="submit" value="修改"> <input type="reset"
                                                          value="重置"></td>
        </tr>
    </table>
</form>
<%
    rs.close();
    stmt.close();
    con.close();
%>
</body>
</html>
复制代码
复制代码
<%@ page import="java.sql.*" pageEncoding="utf-8" errorPage="error.jsp"%>
<html>
<head>
  <title>修改完成</title>
  <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<%
  request.setCharacterEncoding("utf-8");
  String username = request.getParameter("username");
  String number = request.getParameter("number");
  String sex = request.getParameter("sex");
  Class.forName("com.mysql.jdbc.Driver");
  Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/judge1?useUnicode=true&characterEncoding=utf-8", "root", "123456");
  Statement stmt = con.createStatement();
  String sql = "update 学生数据 set 姓名='" + username + "',性别=" + sex
          + " where 学号=" + number;

  int i = stmt.executeUpdate(sql);
  if (i == 1) {
    out.println("<h2>修改成功！</h2><br/>");
    out.println("<a href='index.jsp'>返回首页</a>");
  } else {
    out.println("<h2>修改失败！</h2><br/>");
    out.println("<a href='edit.jsp?id='" + username + ">重新添加</a>");
  }
  stmt.close();
  con.close();
%>
</body>
</html>
复制代码
复制代码
<%@ page import="java.sql.*" pageEncoding="utf-8" errorPage="error.jsp"%>
<html>
<head>
  <title>修改完成</title>
  <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<%
  request.setCharacterEncoding("utf-8");
  String username = request.getParameter("username");
  String number = request.getParameter("number");
  String sex = request.getParameter("sex");
  Class.forName("com.mysql.jdbc.Driver");
  Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/judge1?useUnicode=true&characterEncoding=utf-8", "root", "123456");
  Statement stmt = con.createStatement();
  String sql = "update 学生数据 set 姓名='" + username + "',性别=" + sex
          + " where 学号=" + number;

  int i = stmt.executeUpdate(sql);
  if (i == 1) {
    out.println("<h2>修改成功！</h2><br/>");
    out.println("<a href='index.jsp'>返回首页</a>");
  } else {
    out.println("<h2>修改失败！</h2><br/>");
    out.println("<a href='edit.jsp?id='" + username + ">重新添加</a>");
  }
  stmt.close();
  con.close();
%>
</body>
</html>
复制代码
复制代码
<%@ page language="java" import="java.sql.*" pageEncoding="utf-8"%>
<%@ page errorPage="error.jsp"%>
<html>
<head>
  <title>学生管理系统</title>
  <link rel="stylesheet" type="text/css" href="./style.css">
</head>
<body>
<h1>学生管理系统</h1>
<a href="add.jsp">添加学生信息</a>
<br />
<br />
<table style="width: 50%;">
  <tr>
    <th>学号</th>
    <th>姓名</th>
    <th>性别</th>
    <th>管理</th>
  </tr>
  <%
    Class.forName("com.mysql.jdbc.Driver");
    Connection con = DriverManager.getConnection("jdbc:mysql://127.0.0.1:3306/judge1?useUnicode=true&characterEncoding=utf-8", "root", "123456");
    Statement stmt = con.createStatement();
    ResultSet rs = stmt.executeQuery("select * from 学生数据");
    while (rs.next()) {
      String number = rs.getString(1);
      out.println("<tr><td>" + rs.getString(1) + "</td><td>" + rs.getString(2) + "</td><td>"
              + rs.getString(3) + "</td><td><a href='edit.jsp?id=" + number
              + "'>修改</a>&nbsp;<a href='del.jsp?id=" + number + "'>删除</a></td></tr>");
    }
    rs.close();
    stmt.close();
    con.close();
  %>

</table>
<br />
<hr />
<div style="text-align: center; width: 100%; font-size: 12px; color: #333;">
  &copy;版权所有：石家庄铁道大学信息科学与技术学院&nbsp;&nbsp;<a href="Lab03.png" target="_blank">网站地图</a>
</div>
</body>
</html>
复制代码
复制代码
body {
    text-align: center;
}

table {
    width: 400px;
    border: 1px solid #696969;
    border-collapse: collapse;
    margin:0 auto;
}
th {
    border: 1px solid #696969;
    background-color: #FFF8DC;
}
td {
    text-align: center;
    border: 1px solid #696969;
    height: 50px;
    background-color: #E0FFFF;
}
input {
    font-size: 20px;
}
复制代码

 

posted @   摆烂达人  阅读(16)  评论(0)  编辑  收藏  举报
相关博文：
· 2023年5月13日(软件工程日报)
· 大三每日总结
· 5.26号今日总结
· 五月十二日
· 5.12号今日总结
阅读排行：
· 阿里最新开源QwQ-32B，效果媲美deepseek-r1满血版，部署成本又又又降低了！
· SQL Server 2025 AI相关能力初探
· AI编程工具终极对决：字节Trae VS Cursor，谁才是开发者新宠？
· 开源Multi-agent AI智能体框架aevatar.ai，欢迎大家贡献代码
· Manus重磅发布：全球首款通用AI代理技术深度解析与实战指南
点击右上角即可分享
微信分享提示
AI IDE Trae