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

📄 add_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=ser_doctor.jsp'>
</head>
<body>

<%
    
    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声明*/ 
  
%>
  
<%
    
    String dno=request.getParameter("doctorNo");
    
  
    
    String dname=request.getParameter("doctorName");
    byte dn[]=dname.getBytes("ISO-8859-1");
    dname=new String(dn);
    
   
    String dimg=request.getParameter("doctorImg");
    byte di[]=dimg.getBytes("ISO-8859-1");
    dimg=new String(di);
    
    
    String dsex=request.getParameter("doctorSex");
    String dbir=request.getParameter("doctorBir");
    
    
    String dbg=request.getParameter("doctorBg");
    byte dg[]=dbg.getBytes("ISO-8859-1");
    dbg=new String(dg);
    
    
    String dpost=request.getParameter("doctorPost");
    byte dp[]=dpost.getBytes("ISO-8859-1");
    dpost=new String(dp);
    
    String dachv=request.getParameter("doctorAchv");
    byte dac[]=dachv.getBytes("ISO-8859-1");
    dachv=new String(dac);
    
    String dsal=request.getParameter("doctorSal");
    String ddeptno=request.getParameter("doctorDeptNo");
    String dofficeno=request.getParameter("doctorOffNo");
 
    String ddesc=request.getParameter("doctorDesc");
    byte dde[]=ddesc.getBytes("ISO-8859-1");
    ddesc=new String(dde);
    
    String dpw="12345678";
    
   String sql="INSERT INTO Doctor(DctNo,DctName,DctPw,DctPic,DctSex,DctBirth,DctBg,DctPost,DctAchv,DctSal,DeptNo,DctDesc,OfficeNo) VALUES('"+dno+"','"+dname+"','"+dpw+"','"+dimg+"','"+dsex+"','"+dbir+"','"+dbg+"','"+dpost+"','"+dachv+"','"+dsal+"','"+ddeptno+"','"+ddesc+"','"+dofficeno+"') ";
   Stmt.executeUpdate(sql);                   
   out.print("<center>医生信息添加成功！</center>");
     
%>
<br><br><center>3秒后页面自动会查询医生页，你可查看你新添加的医生信息！</center>  

</body>
</html>

⌨️ 快捷键说明

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