adminstudent5.jsp
上传用户:mkymky1985
上传日期:2014-06-23
资源大小:754k
文件大小:1k
- <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
- <%@ page import = "java.sql.*, java.io.*" %>
- <jsp:useBean id="sts" scope="page" class="wsxk.ConDB"/>
- <%
- String strid = new String (request.getParameter("delpage"));
- System.out.println (strid);
- int temp = 0;
- //int id = Integer.parseInt(strid);
- //System.out.println (id);
- String sql1 = "select * from sc where stuid = '"+strid+"'";
- ResultSet rs1 = sts.executeQuery(sql1);
- while (rs1.next())
- {temp =1;
- }
- rs1.close();
- if (temp==1)
- response.sendRedirect("adminstudentdelerr.htm");
- else
- {String sql = "delete from student where stuid = '"+strid+"'";
- ResultSet rs = sts.executeQuery(sql);}
- %>
- <html>
- <head>
- <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
- <meta HTTP-EQUIV=REFRESH CONTENT="10; URL=adminstudent.jsp">
- <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
- <style type="text/css">
- <!--
- @import url("_notes/ccc");
- body,td,th {
- font-size: 12px;
- color: #FFFFFF;
- font-weight: bold;
- }
- .style1 {color: #000000}
- -->
- </style>
- </HEAD>
- <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
- <div align="center">
- <p align="left"> <br>
- 该信息已被删除,本页将于10秒内自动<a href="adminstudent.jsp" class="style1">返回学生管理页面</a> </p>
- <p><br>
- <img src="images/qa.jpg" width="640" height="427"></p>
- </div>
- </BODY>
- </HTML>