selectdate.jsp
来自「服务器tomcat 数据库mysql Hospital Managemen」· JSP 代码 · 共 438 行 · 第 1/2 页
JSP
438 行
<!--SubButton4-->
instruction of the software </a> |
<!--SubButton4.Content.End-->
<!--SubButton5.Content.Begin-->
<!--SubButton5.Front-->
<!--Something Here-->
<!--SubButton5.Link-->
<!--Something Here-->
<!--SubButton5-->
<!--Something Here-->
</a>
<!--SubButton5.Back-->
<!--Something Here-->
<!--SubButton5.Content.End-->
<!--SubButton6.Content.Begin-->
<!--SubButton6.Front-->
<!--Something Here-->
<!--SubButton6.Link-->
<!--Something Here-->
<!--SubButton6-->
<!--Something Here-->
</a>
<!--SubButton6.Back-->
<!--Something Here-->
<!--SubButton6.Content.End-->
<!--SubButton7.Content.Begin-->
<!--SubButton7.Front-->
<!--Something Here-->
<!--SubButton7.Link-->
<!--Something Here-->
<!--SubButton7-->
<!--Something Here-->
</a>
<!--SubButton7.Back-->
<!--Something Here-->
<!--SubButton7.Content.End-->
<!--SubButton8.Content.Begin-->
<!--SubButton8.Front-->
<!--Something Here-->
<!--SubButton8.Link-->
<!--Something Here-->
<!--SubButton8-->
<!--Something Here-->
</a>
<!--SubButton8.Back-->
<!--Something Here-->
<!--SubButton8.Content.End-->
<!--SubButton9.Content.Begin-->
<!--SubButton9.Front-->
<!--Something Here-->
<!--SubButton9.Link-->
<!--Something Here-->
<!--SubButton9-->
<!--Something Here-->
</a>
<!--SubButton9.Back-->
<!--Something Here-->
<!--SubButton9.Content.End-->
<!--SubButton10.Content.Begin-->
<!--SubButton10.Front-->
<!--Something Here-->
<!--SubButton10.Link-->
<!--Something Here-->
<!--SubButton10-->
<!--Something Here-->
</a>
<!--SubButton10.Back-->
<!--Something Here-->
<!--SubButton10.Content.End-->
</td>
</tr>
<tr>
<td bgcolor="#000000"><img src="../images/Spacer.gif" width="1" height="1"></td>
</tr>
<tr>
<td><div align="right">
<!--SubPage.Begin-->
<!--Something Here-->
<!--SubPage.End-->
</div></td>
</tr>
<!--大家在这里面做修改-->
<tr>
<td height="128"><!--TODO-->
<!--TODO-->
<!--Something Here-->
<!--Page.Content.End-->
<table width="100%" height="100%" border="1">
<tr>
<td width="25%"><div id="sectionLinks">
<h3>Section Links</h3>
<ul>
<li><a href="#">Section Link</a></li>
<li><a href="#">Section Link</a></li>
<li><a href="#">Section Link</a></li>
<li><a href="#">Section Link</a></li>
<li><a href="#">Section Link</a></li>
<li><a href="#">Section Link</a></li>
</ul>
</div>
</td>
<td width="53%">
<!--中间内容插入 TODO-->
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
<%!
Connection con=null;
int iId=0;
String sDate=null;
String selectquery=null;
%>
<table width="94%" border="1" cellpadding="0" cellspacing="0>
<tr bgcolor="#FFFF99">
<td width="22%"> Id</td>
<td width="57%"> Date</td>
<td width="11%"> </td>
<td width="10%"> </td>
</tr>
<%
try
{
Class.forName("com.mysql.jdbc.Driver");//My SQL diver to connect to MySQL database
con=DriverManager.getConnection("jdbc:mysql:///lenovo_db?user=root&password=amethyst");
Statement stmt=con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
String sql="select * from book order by id";
ResultSet rs=stmt.executeQuery(sql);
while(rs.next())
{
iId=rs.getInt(2);
sDate=rs.getString(3);
%>
<tr bgcolor="#E4EDFB">
<td height="329" ><%=iId%></td>
<td><%=sDate%></td>
<td><a href="DeleteDate.jsp?Id=<%=iId%>">Delete</a></td>
<td><a href="EditDate.jsp?Id=<%=iId%>">Edit</a></td>
</tr>
<%
}
rs.close();
stmt.close();
}
catch(Exception ex)
{
System.out.println(ex);
}
%>
<tr bgcolor="#E4EDFB">
<td height="80" colspan="5"><a href="InsertDate.html">Book More Doctor</a></td>
</tr>
</table>
<!--中间内容插入 TODO-->
<p> </p></td>
<td width="22%"><div class="relatedLinks">
<h3>Related Link Category</h3>
<ul>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
<li><a href="#">Related Link</a></li>
</ul>
</div>
</td>
</tr>
</table></td>
</tr>
</table>
<!--大家在这里面做修改-->
<!--IndexPage.Content.End-->
<table width="90%" border="0" cellspacing="0" cellpadding="0" align="center" height="1">
<tr>
<td bgcolor="#000000"></td>
</tr>
</table>
<!--说明-->
<table width="90%" border="0" cellspacing="0" cellpadding="4" align="center">
<tr>
<td><p align="center">
<!--Your Company Name-->
Lenovo Group
<!--TCopyRight-->
copyright
@2006<br>
<!--TTelephone-->
<!--Telephone-->
<!--TEMail-->
<!--EMail-->
<A HREF='mailto:
'> Email:ivywjhua@gmail.com </A></p></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<!--内容-->
<!--底条-->
<table width="778" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td><img src="images/index_bottom.gif" width="778" height="50"></td>
</tr>
</table>
<!--底条-->
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?