⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 upd_doc_succ.jsp

📁 实现了一个医院门诊预约系统
💻 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>
<meta http-equiv=refresh content='3; url=list_doctor.jsp'>
<title>医院门诊预约系统--医生查询--修改成功 </title>
</head>

<body>

<% 

    String tdctno=request.getParameter("DctNo");
    
    String timg=request.getParameter("doctorImg");
    if(timg=="")
        timg=request.getParameter("doctorPreimg");
    byte ti[]=timg.getBytes("ISO-8859-1");
    timg=new String(ti);
    
    String tbg=request.getParameter("doctorBg");
    byte tb[]=tbg.getBytes("ISO-8859-1");
    tbg=new String(tb);
   /* out.print(tb);*/
    
    String tpost=request.getParameter("doctorPost");
    byte ps[]=tpost.getBytes("ISO-8859-1");
    tpost=new String(ps);
    
    String tachv=request.getParameter("doctorAchv");
    byte ta[]=tachv.getBytes("ISO-8859-1");
    tachv=new String(ta);
    
    String tsal=request.getParameter("doctorSalry");
    
    String tdesc=request.getParameter("doctorDesc");
    byte ts[]=tdesc.getBytes("ISO-8859-1");
    tdesc=new String(ts);
  /* out.print(tdesc);*/
    
    String tofficeno=request.getParameter("officeNo");
    
   /*String toffice=request.getParameter("OfficeLoc");
    byte tf[]=toffice.getBytes("ISO-8859-1");
    toffice=new String(tf);*/
    
    
%>
    
<%
    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();
  String sql="UPDATE Doctor SET DctPic='"+timg+"',DctBg='"+tbg+"',DctPost='"+tpost+"',DctAchv='"+tachv+"',DctDesc='"+tdesc+"',DctSal='"+tsal+"',OfficeNo='"+tofficeno+"'  WHERE DctNo='"+tdctno+"' ";
  Stmt.executeUpdate(sql);
    
  out.print("<center>修改医生信息成功成功！</center>");
  
 %>
 
 <br><center>3秒后页面自动跳转医生信息列表，你可查看你新修改的医生信息信息！</center>
  
 </body>
</html>

⌨️ 快捷键说明

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