room_regnum.jsp
来自「java医院应用包含门诊挂号收费住院等应用比较好用」· JSP 代码 · 共 37 行
JSP
37 行
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
</head>
<jsp:useBean id="db" class="hospital.Dbconn" scope="page"/>
<%
String sql="select * from hospital.register group by roomtype";
String sqll="select count(*) from hospital.register group by roomtype";
ResultSet rs=db.exec(sql);
ResultSet rss=db.exec(sqll);
%>
<body>
<table width="75%" border="0" align="center">
<tr>
<td bgcolor="#9CCFFF">
<div align="center"><font size="2">科室</font></div></td>
<td bgcolor="#9CCFFF">
<div align="center"><font size="2">挂号量</font></div></td>
</tr>
<%
while(rs.next()){
rss.next();
%>
<tr>
<td bgcolor="#9CCFFF">
<div align="center"><font size="2"><%=rs.getString("roomtype")%></font></div></td>
<td bgcolor="#9CCFFF">
<div align="center"><font size="2"><%=rss.getString(1)%></font></div></td>
</tr>
<%}%>
</table>
<p align="center"><font size="2">点击<a href="/hospital/admin.jsp">这里</a>返回主页</font></p>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?