index.jsp
来自「java医院应用包含门诊挂号收费住院等应用比较好用」· JSP 代码 · 共 62 行
JSP
62 行
<%@ 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 sql1="select * from hospital.notice group by id";
ResultSet rs1=db.exec(sql1);
String sql2="select * from hospital.news group by id";
ResultSet rs2=db.exec(sql2);
%>
<body>
<table width="75%" border="0" align="center">
<tr>
<td><img src="/hospital/pic/pic.jpg" width="784" height="101"></td>
</tr>
<tr bgcolor="#9CCFFF">
<td bgcolor="#9CCFFF"><font size="2">院内通知:</font></td>
</tr>
<%rs1.last();%>
<tr bgcolor="#E8F7FF">
<td bgcolor="#E8F7FF"><font size="2"><%=rs1.getString("content")%></font></td>
</tr>
<tr>
<td align="center" > </td>
</tr>
<tr bgcolor="#9CCFFF">
<td bgcolor="#9CCFFF"><font size="2">院内新闻:</font></td>
</tr>
<%
rs2.afterLast();
int i=5;
while (i>0 && rs2.previous()){
i--;
%>
<tr bgcolor="#E8F7FF">
<td bgcolor="#E8F7FF"><font size="2"><a href="/hospital/news_view.jsp?id=<%=rs2.getString("id")%>"><%=rs2.getString("title")%></a></font></td>
</tr>
<%}%>
<tr bgcolor="#E8F7FF">
<td bgcolor="#E8F7FF">
<form name="form1" method="post" action="/servlet/Login">
<jsp:include page="/hospital/ins/index_login.jsp"/>
</form>
</td>
</tr>
</table>
<p> </p><table width="75%" border="0" align="center">
<tr>
<td bgcolor="#E8F7FF">
<p align="center"> </p>
<p align="center">
<jsp:include page="/hospital/ins/ins_1.jsp"/></p>
<p align="center"> </p></td>
</tr>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?