📄 day_clean.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>
<title>医院门诊预约系统——逾期清理及初始化</title>
</head>
<body>
<%
Calendar f = Calendar.getInstance();
int a=f.get(Calendar.DAY_OF_WEEK);
f.add(Calendar.DAY_OF_MONTH,7);
java.util.Date date;
date=f.getTime();
String strdate=date.toLocaleString();
String sub=null;
int j;
for(j=0;j<strdate.length()-1;j++)
{
sub=strdate.substring(j,j+1);
if(sub.equals(" "))
break;
}
strdate=strdate.substring(0,j);
String weekname=null;
switch(a)
{
case 2:
weekname="星期一";
break;
case 3:
weekname="星期二";
break;
case 4:
weekname="星期三";
break;
case 5:
weekname="星期四";
break;
case 6:
weekname="星期五";
break;
case 7:
weekname="星期六";
break;
case 1:
weekname="星期日";
break;
default:
break;
}
String sDBDriver = "sun.jdbc.odbc.JdbcOdbcDriver";
String sConnStr = "jdbc:odbc:HCRS";
Connection Con = null;
Statement Stmt = 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声明*/
Stmt.executeUpdate("delete from Reservation where PeriodName like '%"+weekname+"%'");
Stmt.executeUpdate("update Schedule SET PeriodCount=PeriodMax where PeriodName like '%"+weekname+"%'");
Stmt.executeUpdate("update DateExc SET Abstime='"+strdate+"' where Relatime='"+weekname+"'");
out.print("<br><br><br><center>逾期记录清理完毕！<br><br><br>排班表和时间对应表也已更新！</center>");
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -