2024.04.16

学习时间	2h
代码行数	170行
发布博客量	1篇
学习内容	对jsp文件进行了修改和修复

<%@ page contentType="text/html; charset=utf-8" import="java.sql.*" errorPage="error.jsp"%>
<html>
<head>
 <title>添加学生信息</title>
 <link rel="stylesheet" type="text/css" href="css/style.css">
</head>
<body>
<%
 request.setCharacterEncoding("utf-8");
 String id = request.getParameter("id");
 String name = request.getParameter("name");
 String sex = request.getParameter("sex");
 String birthday = request.getParameter("birthday");
 Class.forName("com.mysql.jdbc.Driver");
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8", "root", "123456");
 PreparedStatement stmt = con.prepareStatement("insert into student(id,name,sex,birthday) values(?, ?,?,?)");
 stmt.setString(1, id);
 stmt.setString(2, name);
 stmt.setString(3, sex);
 stmt.setString(4, birthday);
 int i = stmt.executeUpdate();


 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="css/style.css">
</head>
<body>
<%
 request.setCharacterEncoding("utf-8");
 Class.forName("com.mysql.jdbc.Driver");
 Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/demo?useUnicode=true&characterEncoding=utf-8", "root", "123456");
 Statement stmt=con.createStatement();
 String id=request.getParameter("id");
 int i=stmt.executeUpdate("delete from student where id="+id);
 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>