prtestdb.jsp

来自「服务器tomcat 数据库mysql Hospital Managemen」· JSP 代码 · 共 58 行

JSP
58
字号

<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<jsp:useBean id="db" class="mysql.msdb" scope="page"></jsp:useBean>
<%@ page language="java" import="java.sql.*, java.util.*" %>
<%! 
      int patient_id=0;
	  String patient_name=null;
	  String patient_sex=null;
	  String patient_add=null;
	  int patient_tel=0;
	  String patient_his=null;
	  int patient_age=0;
	  String patient_appearance=null;
	  String patient_allergenic=null;
 %>
<head>
<!-- Copyright 2005 E-9 BBS System, Inc. All rights reserved. -->
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
</head>
<body>
<%

    try{
           patient_id=Integer.parseInt(request.getParameter("patient_id"));
	       patient_name=request.getParameter("patient_name");
		   patient_sex=request.getParameter("patient_sex");
		   patient_add=request.getParameter("patient_add");
		   patient_tel=Integer.parseInt(request.getParameter("patient_tel"));
		   patient_his=request.getParameter("patient_his");
		   patient_age=Integer.parseInt(request.getParameter("patient_age"));
		   patient_appearance=request.getParameter("patient_app");
		   patient_allergenic=request.getParameter("patient_all");
      out.print(patient_allergenic);
db.execute("insert into patient  values("+patient_id +",'"+patient_name+"','"+patient_sex+"','"+patient_add+"',"+patient_tel+",'"+patient_his+
"',"+patient_age+",'"+patient_appearance+"','"+patient_allergenic+"')");


out.println("insert into patient  values("+patient_id +","+patient_name+","+patient_sex+","+patient_add+","+patient_tel+","+patient_his+
","+patient_age+","+patient_appearance+","+patient_allergenic+")");
//db.executeUpdate(sql);
%>
<% 
           
         }
  catch(Exception ex)
     {	
	 
   System.out.println(ex);
      }
 %>

<a> Inserted a row into db!</a>
</body>
</html>

⌨️ 快捷键说明

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