📄 del_doc_succ.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@ page info="database handler"%>
<%@ page import="java.io.*"%>
<%@ page import="java.util.*"%>
<%@ page import="java.sql.*"%>
<%@ page import="javax.servlet.*"%>
<%@ page import="javax.servlet.http.*"%>
<html>
<head>
<meta http-equiv=refresh content='3; url=ser_doctor.jsp'>
<title>医院门诊预约系统--医生查询——删除成功 </title>
</head>
<body>
<%
String dctno=request.getParameter("DctNo");
out.print(dctno);
String chioce=request.getParameter("Choice");
out.print(chioce);
if(chioce.equals("Y")||chioce.equals("y"))
{
/*out.print(dctno);*/
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:HCRS";
Connection Con = null;
Statement Stmt = null;
ResultSet RS=null;
try
{
Class.forName(sDBDriver);
}
catch(java.lang.ClassNotFoundException e)
{
out.print("Connect to Database error: " + e.getMessage());
}
try
{
Con = DriverManager.getConnection(sConnStr);
}
catch(SQLException e)
{
out.print(e.toString());
}
Stmt = Con.createStatement(); /*创建JDBC声明*/
String sql="delete from Reservation where DctNo='"+dctno+"'";
Stmt.executeUpdate(sql);
sql="delete from Schedule where DctNo='"+dctno+"'";
Stmt.executeUpdate(sql);
sql="delete from Doctor where DctNo='"+dctno+"'";
Stmt.executeUpdate(sql);
out.print("<center>医生删除成功！</center>");
%>
<br><br><center>3秒后页面自动跳到查询医生页！</center>
<%
}
else
{ response.sendRedirect("ser_doctor.jsp"); }
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -