00675d28091d00171e8bdfdf825d5f86

来自「实习的时候做的数字校园系统」· 代码 · 共 53 行

TXT
53
字号

<%@ page import="java.sql.*"%>
<%@ page import="com.szxy.datasource.DBConnection"%>

<%@ page language="java" contentType="text/html; charset=GBK"
    pageEncoding="GBK"%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<title>Insert title here</title>
</head>
<body>
<% 
int count=0;
//以try开始
try
{ 

 //建一个数据库连接
Connection con = DBConnection.getConnection();
Statement stmt;
String test_id =request.getParameter("test_id");
test_id=new String (test_id.getBytes("ISO-8859-1"),"GBK");

stmt = con.createStatement();
//增加新记录
String sql="DELETE FROM newstudent WHERE testid='"+test_id+"'";

 count=stmt.executeUpdate(sql);


//关闭数据库连结
stmt.close();
con.close();
}

//捕获错误信息
catch (Exception e) {out.println(e.getMessage());}

 %>

<script language="javascript">
if (<%=count%> == 1)
alert("删除成功!");
else
alert("删除失败!");
window.location.href("selectstudent1.jsp");
</script>


</body>
</html>

⌨️ 快捷键说明

复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?