📄 del_2.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY >
<%!
boolean query(String number) //查询是否有学号是number的学生
{
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException e) {}
try{
con=DriverManager.getConnection("jdbc:odbc:test","sa","123456");
sql=con.createStatement();
String condition="SELECT * FROM students where number = "+ "'"+number+"'" ;
rs=sql.executeQuery(condition);
int num=0;
while(rs.next()) num++ ;
con.close();
if(num>0)
return true;
else
return false ;
}
catch(SQLException e)
{ return false; }
}
%>
<%!
String del(String number) //删除学号是number的学生
{
if(query(number))
{
Connection con=null;
Statement sql=null;
ResultSet rs=null;
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
}
catch(ClassNotFoundException event)
{}
try{
con=DriverManager.getConnection("jdbc:odbc:grade");
sql=con.createStatement();
//删除操作
String deleteALL="DELETE FROM students WHERE number"+" = "+"'"+number+"'";
sql.executeUpdate(deleteALL);
con.close();
return "删除成功";
}
catch(SQLException event)
{
return "删除失败" ;
}
}
else
return "没有这个学号";
}
%>
<% //获取提交的学号:
String number=request.getParameter("number");
number=number.trim();
if(number==null)
{
number="";
}
byte b[]=number.getBytes("ISO-8859-1");
number=new String(b);
%>
<%
if(del(number).equals("删除成功"))
session.setAttribute("del", "删除成功");
else
if(del(number).equals("删除失败"))
session.setAttribute("del","删除失败");
else
session.setAttribute("del","没有这个学号");
response.sendRedirect("del_1.jsp");
%>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -