📄 lookup.jsp

📁 《jsp网站开发技术》中的源代码(清华大学出版社)

💻 JSP

字号:

<%@ page language="java"%>
<%@ page import="java.sql.*"%>
<jsp:useBean id="DBBean" scope="session" class="guestbook.guestbook"/>
<%! String name,email,url,words,time,sql;%>
<html>
<body>
<a name=top><h2 align=center>查看留言簿的所有记录</h2></a>

<% //记录总的条数
ResultSet RScount =DBBean.executeQuery("SELECT * FROM guestbook");
int i=0;
while(RScount.next()){
i++;
}
%>
<B>现在有<font color=red><%=i%></font>条留言(你写了吗?).</B> 
<% 
RScount.close();
i=0; 
%>

<p></p>
<% 
ResultSet RS = DBBean.executeQuery("SELECT * FROM guestbook");
int j=0;//记录当前的条数
while (RS.next()){
name= RS.getString("Name");
email= RS.getString("Email");
url=RS.getString("Url");
words=RS.getString("Words");
time=RS.getString("postime");
j++;
%>

第<font color=red><%=j%></font>条记录
<br>发表时间:<% out.println(time);%><br>
<table border=1 width=80%>
<tr>
<td width=30%>昵称:</td><td width=70%><%=name%>
</tr>
<tr>
<td width=30%>Email Address:</td><td width=70%><a href="mailto:<%= email %>"><%= email %></a></td>
</tr>
<tr>
<td width=30%>个人主页:</td><td width=70%><a href="<%= url %>"><%= url %></a></td>
</tr>
<tr>
<td width=30%>留言内容:</td><td width=70%><%= words %></td>
</tr>
</table>
<br>
<%
}
RS.close();
%> 
<h3 align=right><b><a href="./lookup.jsp#top">回到顶部</a></b></h3>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C

搜索代码 Ctrl + F

全屏模式 F11

切换主题 Ctrl + Shift + D

显示快捷键 ?

增大字号 Ctrl + =

减小字号 Ctrl + -