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