📄 0200.htm
字号:
totalpages=(int)(count/pagesize); <br>
if(count>totalpages*pagesize) totalpages++; <br>
st=""+ <br>
" <TABLE align=center border=0 cellPadding=0 cellSpacing= <br>
0 width=\"95%\"> "+ <br>
" <TBODY> <TR> <TD align=middle bgColor=#97badd width=\"1 <br>
00%\"><FONT color=#ff0000>"+ <br>
" 共 "+totalpages+" 页，"+count+" <br>
条. "+" 当前页: "+pages+ <br>
" </FONT></TD></TR></TBODY></TABLE><BR> "; <br>
<br>
out.print(st); <br>
<br>
//out.print(" 共 "+totalpages+" 页，"+ <br>
count+" 条. "+" 当前页: "+pages+"<br>"); <br>
<br>
st=" <center> "+ <br>
" <TABLE border=0 cellPadding=2 cellSpacing=1 width=\"95%\"> "+ <br>
" <TBODY> "+ <br>
" <TR> "+ <br>
" <TD align=middle bgColor=#6699cc width=\"55%\"><FONT "+ <br>
" color=#ffffff>留言主题</FONT></TD> "+ <br>
" <TD align=middle bgColor=#6699cc width=50><FONT "+ <br>
" color=#ffffff>回应数</FONT></TD> "+ <br>
" <TD align=middle bgColor=#6699cc width=40><FONT "+ <br>
" color=#ffffff>点击数</FONT></TD> "+ <br>
" <TD align=middle bgColor=#6699cc width=100><FONT "+ <br>
" color=#ffffff>作者名</FONT></TD> "+ <br>
" <TD align=middle bgColor=#6699cc width=140><FONT "+ <br>
" color=#ffffff>发表/回应时间</FONT></TD></TR> "; <br>
out.print(st); <br>
<br>
if(count > 0 ) <br>
{ <br>
ResultSet rs = testInq.executeQuery(inqsql); <br>
ResultSetMetaData metaData = rs.getMetaData(); <br>
<br>
int i; <br>
// 跳过pages -1 页,使cursor指向pages并准备显示 <br>
for(i=1;i<=(pages - 1)*pagesize;i++) rs.next(); <br>
//显示第pages页开始 <br>
String linestr=""; <br>
for(i=1;i<=pagesize;i++) <br>
if(rs.next()) <br>
{ <br>
lw_title=rs.getString("lw_title"); <br>
answer_num=rs.getInt("answer_num"); <br>
click_num=rs.getInt("click_num"); <br>
lw_author=rs.getString("lw_author"); <br>
lw_time=rs.getString("lw_time"); <br>
st=lw_time.substring(0,4)+"-"+lw_time.substring(4,6)+"-" <br>
+lw_time.substring(6,8)+":"+ <br>
lw_time.substring(8,10)+":"+lw_time.substring(10,12)+ <br>
":"+lw_time.substring(12,14); <br>
lw_ico=rs.getString("expression"); <br>
author_email=rs.getString("author_email"); <br>
lw_class1=rs.getString("lw_class1"); <br>
lw_class2=rs.getString("lw_class2"); <br>
llink="reply.jsp?lw_class1="+lw_class1+"&lw_class2="+lw_ <br>
class2+"&zt_time="+lw_time+ <br>
"&zt_author="+author_email; <br>
linestr=" <TR bgColor=#d5e8fd> \n" + <br>
" <TD bgColor=#d5e8fd><IMG src=\""+lw_ico+".gif\ <br>
"><A "+ <br>
" href=\""+llink+" \">"+lw_title+"</A></TD> "+ <br>
" <TD align=middle>["+answer_num+"]</TD>"+ <br>
" <TD align=middle>"+click_num+"</TD>"+ <br>
" <TD align=middle><A href=\"mailto:"+author_ema <br>
il+"\">"+lw_author+"</A></TD>"+ <br>
" <TD align=middle>"+st+"</TD></TR>"; <br>
<br>
out.println(linestr); <br>
<br>
} <br>
rs.close(); <br>
//显示第pages页结束 <br>
st="</TBODY></TABLE><BR>"; <br>
out.print(st); <br>
<br>
int iFirst=1,iLast=totalpages,iPre,iNext; <br>
if(pages<=1) iPre=1; <br>
else iPre=pages - 1; <br>
<br>
if(pages>=totalpages) iNext=totalpages; <br>
else iNext=pages + 1; <br>
<br>
int n=(int)(count/pagesize); <br>
if(n*pagesize<count) n++; <br>
if(n>1) <br>
{ <br>
//for(i=1;i<=n;i++) out.print("<a href=inquire.jsp?pages= <br>
"+i+">"+i+" </a>"); <br>
//out.print("<HR align=center noShade SIZE=1 width=\"95%\ <br>
">"); <br>
String lt1="返回主页",lt2="第一页",lt3="上一页",lt4="下一 <br>
页",lt5="最后一页",lt6=""; <br>
lt6="<a href=http://www.zj.hn.cn>"+ lt1 + " </ <br>
a>"+ <br>
lurlt + "pages="+iFirst+"><FONT color=red>"+lt2+"&nbs <br>
p; </a>"+ <br>
lurlt + "pages="+iPre+"><FONT color=red>"+lt3+" <br>
</a>" + <br>
lurlt + "pages="+iNext+"><FONT color=red>"+lt4+" <br>
; </a>" + <br>
lurlt + "pages="+iLast+"><FONT color=red>"+lt5+" <br>
; </a>"; <br>
st=""+ <br>
" <TABLE align=center border=0 cellPadding=0 cellSpacing= <br>
0 width=\"95%\"> "+ <br>
" <TBODY> <TR> <TD align=middle bgColor=#97badd width=\"1 <br>
00%\"><FONT color=#ff0000>"+ <br>
lt6+ <br>
" </FONT></TD></TR></TBODY></TABLE><BR> "; <br>
<br>
out.print(st); <br>
<br>
} <br>
<br>
} <br>
} catch (Exception e) { out.println("error: "+e); } <br>
} <br>
<br>
<br>
%> <br>
<br>
<br>
<% <br>
//留言板界面尾部 <br>
String lbottom=""; <br>
lbottom=lbottom+ <br>
" \n"+ <br>
" <FORM action=guestbook.jsp method=post name=sign> \n"+ <br>
" <INPUT name=gbname type=hidden value=cnzjj_gt> \n"+ <br>
" <INPUT name=pages type=hidden value=1> \n"+ <br>
" <TABLE bgColor=#d5e8fd border=0 cellSpacing=1 width=\"95%\"> \n"+ <br>
<br>
" <TBODY> \n"+ <br>
" <TR> \n"+ <br>
" <TD align=middle bgColor=#e6e6fa colSpan=2 noWrap><STRONG><FONT <br>
color=blue \n"+ <br>
" face=楷体_GB2312 size=5>发 表 意 见</FONT></STRONG> &nbs <br>
p; [加*的内容必须填写] </TD></TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD noWrap width=\"45%\"> \n"+ <br>
" <DIV align=left> \n"+ <br>
" <TABLE bgColor=#d5e8fd border=0 cellSpacing=1 width=\"100%\"> <br>
\n"+ <br>
" <TBODY> \n"+ <br>
" <TR> \n"+ <br>
" <TD noWrap width=\"100%\">*留言主题：<INPUT maxLength=40 n <br>
ame=lw_title \n"+ <br>
" size=36></TD></TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD noWrap width=\"100%\">*网上大名：<INPUT maxLength=18 n <br>
ame=lw_author \n"+ <br>
" size=36></TD></TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD noWrap width=\"100%\"> 主页标题：<INPUT maxLength <br>
=40 name=pagetitle \n"+ <br>
" size=36></TD></TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD noWrap width=\"100%\"> 主页地址：<INPUT maxLength <br>
=255 name=author_http \n"+ <br>
" size=36></TD></TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD noWrap width=\"100%\">*电子邮件：<INPUT maxLength=40 n <br>
ame=author_email \n"+ <br>
" size=36></TD></TR></TBODY></TABLE></DIV></TD> \n"+ <br>
" <TD noWrap vAlign=top width=\"55%\"> \n"+ <br>
" <DIV align=left> \n"+ <br>
" <TABLE bgColor=#b6d7fc border=0 cellSpacing=1 width=\"100%\"> <br>
\n"+ <br>
" <TBODY> \n"+ <br>
" <TR> \n"+ <br>
" <TD width=\"100%\">请在下面填写你的留言：</TD></TR> \n"+ <br>
<br>
" <TR> \n"+ <br>
" <TD width=\"100%\"><TEXTAREA cols=50 name=lw_content rows= <br>
7></TEXTAREA></TD></TR></TBODY></TABLE></DIV></TD></TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD bgColor=#fbf7ea colSpan=2 noWrap>表情\n"+ <br>
" <INPUT name=gifface type=radio value=1 checked><IMG \n"+ <br>
" alt=\"1.gif (152 bytes)\" height=15 src=\"1.gif\" width=15> <I <br>
NPUT \n"+ <br>
" name=gifface type=radio value=2><IMG alt=\"2.gif (174 bytes)\" <br>
height=15 \n"+ <br>
" src=\"2.gif\" width=15> <INPUT name=gifface type=radio value=3 <br>
><IMG \n"+ <br>
" alt=\"3.gif (147 bytes)\" height=15 src=\"3.gif\" width=15> <I <br>
NPUT \n"+ <br>
" name=gifface type=radio value=4><IMG alt=\"4.gif (172 bytes)\" <br>
height=15 \n"+ <br>
" src=\"4.gif\" width=15> <INPUT name=gifface type=radio value=5 <br>
><IMG \n"+ <br>
" alt=\"5.gif (118 bytes)\" height=15 src=\"5.gif\" width=15> <I <br>
NPUT \n"+ <br>
" name=gifface type=radio value=6><IMG alt=\"6.gif (180 bytes)\" <br>
height=15 \n"+ <br>
" src=\"6.gif\" width=15> <INPUT name=gifface type=radio value=7 <br>
><IMG \n"+ <br>
" alt=\"7.gif (180 bytes)\" height=15 src=\"7.gif\" width=15> <I <br>
NPUT \n"+ <br>
" name=gifface type=radio value=8><IMG alt=\"8.gif (96 bytes)\" <br>
height=15 \n"+ <br>
" src=\"8.gif\" width=15> <INPUT name=gifface type=radio value=9 <br>
><IMG \n"+ <br>
" alt=\"9.gif (162 bytes)\" height=15 src=\"9.gif\" width=15> <I <br>
NPUT \n"+ <br>
" name=gifface type=radio value=10><IMG alt=\"10.gif (113 bytes) <br>
\" height=15 \n"+ <br>
" src=\"10.gif\" width=15> <INPUT name=gifface type=radio value= <br>
11><IMG \n"+ <br>
" alt=\"11.gif (93 bytes)\" height=15 src=\"11.gif\" width=15> < <br>
INPUT \n"+ <br>
" name=gifface type=radio value=12> <IMG alt=\"12.gif (149 bytes <br>
)\" height=14 \n"+ <br>
" src=\"12.gif\" width=15> \n"+ <br>
" <INPUT \n"+ <br>
" name=gifface type=radio value=13> <IMG alt=\"13.gif (149 bytes <br>
)\" height=14 \n"+ <br>
" src=\"13.gif\" width=15> \n"+ <br>
" <INPUT \n"+ <br>
" name=gifface type=radio value=14> <IMG alt=\"14.gif (149 bytes <br>
)\" height=14 \n"+ <br>
" src=\"14.gif\" width=15> \n"+ <br>
" <INPUT \n"+ <br>
" name=gifface type=radio value=15> <IMG alt=\"15.gif (149 bytes <br>
)\" height=14 \n"+ <br>
" src=\"15.gif\" width=15> \n"+ <br>
" <INPUT \n"+ <br>
" name=gifface type=radio value=16> <IMG alt=\"16.gif (149 bytes <br>
)\" height=14 \n"+ <br>
" src=\"16.gif\" width=15> </TD> \n"+ <br>
" </TR> \n"+ <br>
" <TR> \n"+ <br>
" <TD align=middle colSpan=2 noWrap><INPUT name=cmdGO onclick=\"re <br>
turn ValidInput()\" type=submit value=\"提 交\"> \n"+ <br>
<br>
" <INPUT name=cmdPrev onclick=\"return ValidInput()\" type=submit valu <br>
e=\"预 览\"> \n"+ <br>
" <INPUT name=cmdCancel type=reset value=\"重 写\"> <INPU <br>
T name=cmdBack onclick=javascript:history.go(-1) type=button value=\"返 <br>
回\"> \n"+ <br>
" </TD></TR></TBODY></TABLE></FORM></CENTER></DIV> "; <br>
out.print(lbottom); <br>
<br>
%> <br>
<br>
</body></html><br>
</table>
<p align="center"><script src="../../2.js"></script></a>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -