📄 deletestu-1.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="errorpage.jsp" %>
<%@ page import="java.sql.*" %>
<jsp:useBean id="deleteObject" scope="page" class="BeanPage.loginBean"/>
<html>
<head>
<title>Until</title>
</head>
<body>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<p> </p>
<div align="center">
<%
String deleteName = request.getParameter("deleteTextName");
byte name[] = deleteName.getBytes("ISO-8859-1");
deleteName = new String(name);
String deleteNum = request.getParameter("deleteTextNum");
String sqlOne = "select * from stu_login where name ='"+deleteName+"'and number ='"+deleteNum+"'";
ResultSet Rs = deleteObject.executeQuery(sqlOne);
//out.print(Rs);
if(Rs.next()){// "UPDATE stuScore SET "+request.getParameter("subjectN")+"='"+scores+"' WHERE stuNum ='"+studentNu+"'";
//好像在用javaBean不能实现delete SQL语句
//
String sqlTwo = "delete from stu_login where name='"+deleteName+"' and number = '"+deleteNum+"'";
//out.print(sqlTwo);
Connection con;
Statement sql;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}catch(ClassNotFoundException e){}
try {
con=DriverManager.getConnection("jdbc:odbc:login");
sql=con.createStatement();
sql.executeUpdate(sqlTwo);
con.close();
out.print("删除成功!");
}catch(SQLException e){
out.println(e);
}
}else{
out.print("你要删除的学生信息不存在或信息不够详细，请验证");
}
%>
</div>
<p align="center"></p>
<div align="center">
<input name="button" type=button onClick=window.history.go(-1) value=退到前一页>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -