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> <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;"> ©版权所有：石家庄铁道大学信息科学与技术学院 <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; }
