📄 dct_schedule.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
{
//out.print(DctNo);
String weekdate=request.getParameter("weekdate");
byte[] tmpbyte=weekdate.getBytes("8859_1");
weekdate=new String(tmpbyte,"gb2312");
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
String driver = "jdbc:odbc:HCRS";
Connection conn = DriverManager.getConnection(driver,"sa","605605");
Statement stmt = conn.createStatement();
String sql1=null;
ResultSet rs1=null;
sql1="select Abstime from DateExc where Relatime like '"+weekdate+"'";
rs1=stmt.executeQuery(sql1);
rs1.next();
String Abstime = rs1.getString("Abstime");
Abstime = Abstime.substring(0,10);
String sql=null;
ResultSet rs=null;
sql="select PeriodName,PeriodState,PeriodCount,PeriodMax from Schedule where DctNo='"+DctNo+"' and PeriodName like '"+weekdate+"%'order by PeriodNo";
rs=stmt.executeQuery(sql);
boolean hasrow= false ;
%>
<div align="center"><h3>我的排班表 <%=Abstime%><%=weekdate%></h3></div>
<div align="center" >
<table border='1'>
<tr>
<td align="center">时段 </td><td>是否上班(Y/N)</td><td>剩余可预约人数 </td><td>最大可预约人数 </td>
</tr>
<%
while(rs.next())
{
hasrow= true;
String PeriodName = rs.getString("PeriodName");
PeriodName=PeriodName.substring(3);
String PeriodState = rs.getString("PeriodState");
String state=new String("Y");
if(PeriodState.equals(state)==true)
PeriodState=new String("是");
else
PeriodState=new String("否");
String PeriodCount = rs.getString("PeriodCount");
String PeriodMax = rs.getString("PeriodMax");
%>
<tr>
<td> <%=PeriodName%> </td>
<td> <%=PeriodState%> </td>
<td> <%=PeriodCount%> </td>
<td> <%=PeriodMax%> </td>
</tr>
<%
}
%>
</table>
</div>
<%
if(!hasrow)
{%>
<p>对不起,暂时没有您要的信息@_@</p>
<%}
rs.close();
}
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -