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 + -
显示快捷键?