?? message_view.jsp
字號(hào):
<%@ page contentType="text/html;charset=gb2312" %>
<%@ page import="shopbean.ConnDB" %>
<%@ page import="java.sql.*" %>
<%
ConnDB conn=new ConnDB();
try
{
String sql="select c_header,c_name,new_time,new_message,re_time,re_message from idea";
ResultSet rs = conn.doQuery(sql);
if(rs.next())
{
%>
<style type="text/css">
<!--
.STYLE1 {font-size: 12px;}
.STYLE2{font-size: 14px}
-->
</style>
<center>
<table width="782" border="1" bordercolor="#99CCFF" cellpadding="0" cellspacing="0" style="border-collapse:collapse">
<!--DWLayoutTable-->
<tr>
<td height="48" colspan="2" align="center"><span class="STYLE2">Easy Buy Online 意見(jiàn)與建議 </span></td>
</tr>
<%
String str=(String)request.getParameter("page");
if(str==null)
{
str="0";
}
int pagesize=5;
rs.last();
int recordCount=rs.getRow();
int maxPage=0;
maxPage=(recordCount%pagesize==0)?(recordCount/pagesize):(recordCount/pagesize+1);
int currentPage=Integer.parseInt(str);
if(currentPage<1)
{
currentPage=1;
}
else
{
if(currentPage>maxPage)
{
currentPage=maxPage;
}
}
rs.absolute((currentPage-1)*pagesize+1);
for(int i=1;i<=pagesize;i++)
{
%>
<tr>
<td width="127" rowspan="4" align="center"><p><img src="<%= rs.getString("c_header") %>" width="50" height="50"></p></td>
<td width="619" height="20" align="right" bgcolor="#99CCFF"> <span class="STYLE1">[留言者] <%= rs.getString("c_name") %> [留言時(shí)間] <%= rs.getString("new_time") %></span> </td>
</tr>
<tr>
<td width="619" height="45"><span class="STYLE1"> [留言] <span class="STYLE2"><%= rs.getString("new_message") %></span></span></td>
</tr>
<tr>
<td width="619" height="20" align="right"><span class="STYLE1">[回復(fù)者] 管理員 [留言時(shí)間] <%= rs.getString("re_time") %> </span></td>
</tr>
<tr>
<td height="45"><span class="STYLE1"> <span class="STYLE1">[回復(fù)]</span> <span class="STYLE2"><%= rs.getString("re_message") %></span></span></td>
</tr>
<%
try
{
if(!rs.next()){break;}
}catch(Exception e){}
}
%>
<tr>
<td height="30" colspan="2"><p align="center" class="STYLE1">共 <span class="STYLE1"><%= recordCount %></span> 個(gè)記錄,分<span class="STYLE1"> <%= maxPage %> </span>顯示,當(dāng)前頁(yè)<strong>:</strong> 第 <span class="STYLE1"><%= currentPage %> </span>頁(yè)
<%
for(int j=1;j<=maxPage;j++)
{
out.print(" <a href='message.jsp?page="+j+"'>"+j+"</a>");
}
}
else
{
out.print("<HTML><BODY bgcolor='#FFFFFF'><center><font size=4pt color='red'>" + "沒(méi)有數(shù)據(jù)......" + "</font></center></body></html>");
}
}
catch(Exception e){}
conn.closeConnection();
%>
</p></td>
</tr>
</table>
</center>
?? 快捷鍵說(shuō)明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號(hào)
Ctrl + =
減小字號(hào)
Ctrl + -