📄 upd_schedule.jsp

📁 实现了一个医院门诊预约系统
💻 JSP
字号:
<SCRIPT language="javascript">
function backward()
{
      history.back();
}
function backward()
{
      history.back();
}
</SCRIPT>

<%@ 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.*"%>

<script language="JavaScript">
	
function check()
{     //该javascript函数是用来验证表单格式的正确性的
	 fr = document.updschedule;

   if(!isstate(fr.PeriodState.value)) 
		{
			  alert("可预约状态只能由y或n表示");
				fr.PeriodState.focus();
				return;
		}
		
		fr.submit();
		 
}

function isstate(theStr)//是否是数字
{
	var flag = false;
	var len = theStr.length;
	for(var i = 0; i < len; i++) 
	{
		if((theStr.charAt(i)=='Y') ||(theStr.charAt(i)=='y')||(theStr.charAt(i)=='n')|| (theStr.charAt(i)=='N'))
			flag = true;
	}
	return flag;
}
	
</script>



<html>
<head>
<title>医院门诊预约系统--排班表查询--修改排班表</title>
</head>


<%
    String updno=null;
    updno=request.getParameter("DctNo");
    /*out.print(updno);*/
    
    String periodno=null;
    periodno=request.getParameter("PeriodNo");
    /*out.print(periodno);*/
    
    
  /*  if(updno==null)
    {
    StringBuffer url = request.getRequestURL(); 
    if (request.getQueryString() != null) 
    { 
      url.append('?');
      url.append(request.getQueryString()); 
    }
  
    updno=url.toString();
    updno=updno.substring(62);
    }*/

    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声明*/ 
 RS= Stmt.executeQuery("SELECT PeriodNo,Doctor.DctNo,Doctor.DctName,PeriodName,PeriodState,PeriodCount,Schedule.PeriodMax FROM Schedule,Doctor WHERE Schedule.DctNo=Doctor.DctNo AND Schedule.DctNo='"+updno+"' AND Schedule.PeriodNo='"+periodno+"'"); 
  while (RS.next()) 
  {
 %>
 <a align=right href="admin_log_default.jsp" id="button">返回后台主页</a>
 
 <form name="updschedule" id="updschedule" action="upd_schedule_succ.jsp" method="post">
 	
 <input type="hidden" name="DctNo" value=<%=updno%>>
  <input type="hidden" name="PeriodNo" value=<%=periodno%>>
 
 
 <table width="80%" border="2" cellpadding=3 cellspacing=3  align="center">
  <tr>
    <td colspan="2"><center><div id="sheet-head">修改<%=updno%>号医生时间段号为<%=periodno%>信息 </div></center></td>
  </tr>
  
   <tr>
    <td width="30%" align=center>时间段号 </td>
    <td width="80%"><%=RS.getString("PeriodNo")%> </td>
  </tr>
  
   <tr>
    <td width="30%" align=center>医生号 </td>
    <td width="80%"><%=RS.getString("DctNo")%> </td>
  </tr>
  
   <tr>
    <td width="30%" align=center>医生姓名 </td>
    <td width="80%"><%=RS.getString("DctName")%> </td>
  </tr>
  
   <tr>
    <td width="30%" align=center>具体时间 </td>
    <td width="80%"><%=RS.getString("PeriodName")%> </td>
  </tr>
  
  <tr>
    <td width="30%" align=center>是否可预约</td>
    <td width="80%"><input type="text"  size="10" class="text" name="PeriodState" value=<%=RS.getString("PeriodState")%>> </td>
  </tr>
  
   <tr>
    <td width="30%" align=center>最大的可预约人数 </td>
    <td width="80%"><%=RS.getString("PeriodMax")%> </td>
  </tr>
  
    <td colspan="2"><center><input type="button" id="button" class="button" value="修改" onClick="check()">
    &nbsp;&nbsp;&nbsp;<input type="reset" id="reset" class="reset" value="重置">
    &nbsp;&nbsp;&nbsp;<input type="button" id="button" class="button" onClick="backward()" value="返回上一步">
    </center></td>
 </table>
</form>
<%
}
%>


</body>
</html>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -