📄 upd_doc_iden.jsp

📁 实现了一个医院门诊预约系统
💻 JSP
字号:
<SCRIPT language="javascript">
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.*"%>

<html>
<head>
<title>医院门诊预约系统--修改医生信息</title>
</head>

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

   if(!isnum(fr.doctorSalry.value)) 
		{
			  alert("个人工资只能由数字构成！");
				fr.doctorSalry.focus();
				return;
		}
		
		 if(!isnum(fr.officeNo.value)) 
		{
			  alert("办公室号只能由数字构成！");
				fr.officeNo.focus();
				return;
		}
  fr.submit();
}

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

<%
    String updno=null;
    updno=request.getParameter("updno");
  /*  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;
 
    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());
    }
    
    
    out.print(updno);
   
  Stmt = Con.createStatement();    /*创建JDBC声明*/ 
  ResultSet RS= Stmt.executeQuery("SELECT DctName,DctSex,DctPic,DctBg,DctPost,DctAchv,DctSal,DctDesc,Doctor.OfficeNo,OfficeLoc FROM Doctor,Office WHERE Office.OfficeNo=Doctor.OfficeNo AND DctNo='"+updno+"' ");
  while (RS.next()) 
  {
 %>
  <a align=right href="admin_log_default.jsp" id="button">返回后台主页</a>
 
 <form name="upddoctor" id="upddoctor" action="upd_doc_succ.jsp" method="post">
 	
 <input type="hidden" name="DctNo" value=<%=updno%>>
 
 <table width="80%" border="2" cellpadding=3 cellspacing=3  align="center">
  <tr>
    <td colspan="2"><center><div id="sheet-head">修改<%=updno%>号医生信息 </div></center></td>
  </tr>
  
   <tr>
    <td width="30%" align=center>个人图片 </td>
    <%String preimg=RS.getString("DctPic");%>
    <td width="70%"><img src="<%=preimg%>">
    	<input type="hidden" name="doctorPreimg" value=<%=preimg%>>
    	<br><input type="file" name="doctorImg"></td>
   </tr>
  
  
  <tr>
    <td width="30%" align=center>医生学历 </td>
    <td width="80%"><input type="text"  size="10" class="text" name="doctorBg" value=<%=RS.getString("DctBg")%>> </td>
  </tr>
  
   <tr>
    <td width="30%" align=center>职位</td>
     <td width="70%">
    	<select name="doctorPost">
    		<option value="" selected="selected">  </option>
        <option value="" selected="selected">  </option>
        <option value="主任医师">主任医师 </option>
        <option value="副主任医师">副主任医师 </option>
         <option value="主治医师">主治医师 </option>
       </select>
       </td>
  </tr>
  
  <tr>
    <td width="30%" align=center>主要成就 </td>
    <td width="20%"><input type="text"  class="text" size="42" name="doctorAchv" value=<%=RS.getString("DctAchv")%>></td>
  </tr>
  
 <tr>
    <td width="30%" align=center>工资 </td>
    <td width="30%"><input type="text"  size="10" class="text" name="doctorSalry" value=<%=RS.getString("DctSal")%>> </td>
  </tr>
 
  <tr>
    <td width="30%" align=center>个人简介 </td>
    <td width="50%"><input type="text"  class="text" size="50" name="doctorDesc" value=<%=RS.getString("DctDesc")%>></td>
  </tr> 
  
   <tr>
    <td width="30%" align=center>办公室号 </td>
    <td width="50%"><input type="text" class="text" size="30" name="officeNo" value=<%=RS.getString("OfficeNo")%>> </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>
💿 文件大小 379 K
👤 上传用户 newyearday
📂 所属分类数据库系统
⌨️ 快捷键说明

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