📄 dct_set_state.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%@page pageEncoding="gb2312"%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312"/>
<title>我的预约患者</title>
</head>
<body>
<%
String DctNo=(String)session.getValue("DctNo");
if(DctNo==null||DctNo=="")
{%>
<div align="center"><p>对不起，您还没有登陆 </p></div>
<div align="center"><p><a href="dct_log_default.jsp">返回登陆页 </a></p></div>
<%}
else
{
String RsvNo=request.getParameter("RsvNo");
String weekdate=request.getParameter("weekdate");
//out.print(RsvNo);
//out.print(weekdate);
//out.print(DctNo);
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driver = "jdbc:odbc:HCRS";
Connection conn = DriverManager.getConnection(driver,"sa","605605");
Statement stmt = conn.createStatement();
String sql=null;
ResultSet rs=null;
if(RsvNo!=null)
{
sql="update Reservation set RsvState ='Y' where RsvNo ='"+RsvNo+"'";
}
else if(weekdate!=null)
{
byte[] tmpbyte=weekdate.getBytes("8859_1");
weekdate=new String(tmpbyte,"gb2312");
sql="update Reservation set RsvState ='Y' where DctNo = '"+DctNo+"' and PeriodName like '"+weekdate+"%'";
}
stmt.executeUpdate(sql);
%>
<SCRIPT language="javascript">alert("修改成功，跳转到您的主页面");self.location="dct_index.jsp"</SCRIPT>
<%}%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -