📄 theshanchu.jsp
字号:
<%@ page contentType="text/html;charset=GB2312" %>
<%@ page import="java.sql.*" %>
<HTML>
<BODY background="background.jpg" ><Font size=4>
<% //获取提交的学号：
String number=request.getParameter("number");
if(number==null)
{
number="";
}
byte b[]=number.getBytes("ISO-8859-1");
number=new String(b);
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:student");
sql=con.createStatement();
//删除操作：
String deleteAll="DELETE FROM student WHERE sno"+" = "+"'"+number+"'";
sql.executeUpdate(deleteAll);
%>
<p align=center> <font size=6 color=red>您的操作成功！</font>
<hr width="85%" color=navy />
<P>数据库删除后的数据记录是：
<table width="760" border="1" align="center" >
<tr height="22" bgcolor="#99CCFF">
<td width="30%" align="center">学号</td>
<td width="10%" align="center">姓名</td>
<td width="10%" align="center">性别</td>
<td width="15%" align="center">专业</td>
<td width="5%" align="center">高数</td>
<td width="5%" align="center">C语言</td>
<td width="5%" align="center">JAVA</td>
<td width="5%" align="center">JSP</td>
<td width="5%" align="center">英语</td>
</tr>
<%
rs=sql.executeQuery("SELECT * FROM student");
while(rs.next())
{
String sno = rs.getString("sno");
String name = rs.getString("name");
String sex = rs.getString("sex");
String zhuanye = rs.getString("zhuanye");
String chinese = rs.getString("gaoshu");
String maths = rs.getString("Cyuyan");
String physics = rs.getString("JAVA");
String chemistry = rs.getString("JSP");
String chemistry = rs.getString("English");
out.println("<tr>");
out.println("<td align=center>"+sno+"</td>");
out.println("<td align=center>"+name+"</td>");
out.println("<td align=center>"+sex+"</td>");
out.println("<td align=center>"+zhuanye+"</td>");
out.println("<td align=center>"+gaoshu+"</td>");
out.println("<td align=center>"+Cyuyan+"</td>");
out.println("<td align=center>"+JAVA+"</td>");
out.println("<td align=center>"+JSP+"</td>");
out.println("<td align=center>"+English+"</td>");
out.println("</tr>");
}
out.print("</Table>");
con.close();
}
catch(SQLException event)
{out.print(""+event);
}
%>
</font>
<font size=2>
<p align=right>
<a href="tianjia.jsp">添加学生信息</a> |
<a href="shanchu.jsp">删除学生信息</a> |
<a href="xiugai.jsp">修改学生信息</a> |
<a href="main.jsp">返回首页>></a>
</FONT>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -