📄 huajia.jsp
字号:
<%@ 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">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>无标题文档</title>
<style type="text/css">
<!--
body {
background-color: #93A070;
}
-->
</style>
<link href="css.css" rel="stylesheet" type="text/css" />
<style type="text/css">
<!--
.STYLE6 {
font-size: 14px;
font-weight: bold;
}
-->
</style>
<jsp:useBean id="myCon" scope="page" class="MyWeb.db.DBManager" />
<script type="text/JavaScript">
<!--
function MM_goToURL() { //v3.0
var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}
//-->
</script>
</head>
<body>
<table width="600" border="0" align="center">
<tr>
<td height="56" background="pic/sf.jpg">
</td>
</tr>
<tr>
<td height="120">
<form id="form1" name="form1" method="post" action="">
<table width="100%" border="1">
<tr>
<td height="60" align="center" valign="middle">
<span class="STYLE6">输入病人编号 <label>
<input name="PID" type="text" value="" size="10" />
</label> </span>
</td>
<td align="center" valign="middle">
<span class="STYLE6">输入病人姓名 <label>
<input name="Pname" type="text" value="" size="10" />
</label> </span>
</td>
</tr>
<tr>
<td height="60" align="center" valign="middle">
<label>
<input name="Pname" type="submit" class="STYLE6" id="Pname"
value="提交" />
</label>
</td>
<td align="center" valign="middle">
<input name="testarea" type="button" class="STYLE6" id="rest"
onclick="MM_goToURL('parent','main.jsp');return document.MM_returnValue"
value="返回" />
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<hr />
<table>
<%
String PID = request.getParameter("PID");
//String hjzl = request.getParameter("hjzl");
//String hjmc = request.getParameter("hjmc");
//String hjjg = request.getParameter("hjjg");
//String hjlx = request.getParameter("hjlx");
//Pn = new String(Pn.getBytes("ISO-8859-1"));
//System.out.println(Pn);
String sql = null;
java.sql.ResultSet rs = null;
sql = "select * from huajiasf where PID='" + PID + "'";
rs = myCon.executeQuery(sql);
//String str=rs.getString("Pname");
//System.out.println(str);
%>
<%
out
.println("<table width=\"550\"border=\"1\" align=\"center\" border=\"1\">");
out.println("<tr><td>病人姓名<td>收费种类<td>收费类型<td>名称<td>价格(单位:元)</tr>");
while (rs.next()) {
out.println("<tr><td>" + rs.getString(1) + "<td>"
+ rs.getString(5) + "<td>" + rs.getString(6) + "<td>"
+ rs.getString(7) + "<td>" + rs.getInt(8) + "</tr>");
}
//out.println("<tr><td>合计：</td><td></td>");
out.println("</table>");
%>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -