📄 messagelist.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %><%@ page isThreadSafe="false" %><%@ page import="jasp.buildin.*, jasp.vbs.*, jasp.util.*" %><%@ page extends="jasp.servlet.JspBase" %><% try { jspinit(request,response,application,out,"jasp0");%><% Session.setCodePage(936); jasp.adodb.Recordset rs = null; String sql = ""; int maxperpage = 0; int totalput = 0; //得到总页数 int i = 0; jasp.adodb.Recordset rs_userpic = null; jasp.adodb.Recordset rs_remessage = null; /* initialize variables. */ username = new variant(); currentpage = 0; mpage = 0; /* initialize variable end */ %><%@ include file="../include/connect.jsp" %><% username.set(checkstr(new variant(Request.QueryString("Username")))); if (username.equals(new variant(""))) { Response.End(); }%><html><head><META http-equiv="Content-Type" content="text/html; charset=gb2312"><LINK href="../CSS/Hompy/hompy.css" type=text/css rel=stylesheet><title></title><script language="JavaScript"><!--function trim(str) { return str.replace(/(^[\s]*)|([\s]*$)/g, "");}function formcheck() { if(addmessage.content.value =="" || trim(addmessage.content.value)=="") { alert("留言不能为空！"); addmessage.content.focus(); return false; }}function formcheck1(frmName) { if(frmName.content.value =="" || trim(frmName.content.value) =="") { alert("回复不能为空！"); frmName.content.focus(); return false; }}function ask(msg) { if( msg=='' ) { msg='真的要这样做吗？'; } if (confirm(msg)) { return true; } else { return false; }}//--></script></head><body oncontextmenu="window.event.returnValue=false" onselectstart="return false"><TABLE cellSpacing=0 cellPadding=0 width=473 border=0> <TBODY> <tr> <TD height=29 align="center"><table width="97%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="14%" class="orange2_b">留言列表</td> <td width="65%" style="PADDING-RIGHT: 10px"> </td> <td width="21%" align="right"> </td> </tr> </table> </TD> </tr> <TR> <TD height=108 align="center" valign="top"> <table width="97%" height="105" border="0" cellpadding="0" cellspacing="0"> <form name="addmessage" action="addmessage.jsp?Username=<%= username %>" method="Post" onSubmit="return formcheck();"> <INPUT type=hidden value=<%= Session.getItem("Username") %> name=MUser> <tr> <td width="22%" height="76" align="center" style="HEIGHT: 50px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px solid; BACKGROUND-COLOR: #f7f7f7"> <TABLE cellSpacing=1 cellPadding=3 align=center bgColor=#cccccc border=0> <TBODY> <TR> <TD align=middle bgColor=#ffffff><% if (Session.getItem("Userpic").equals(new variant("")) || Session.getItem("Userpic").equals(new variant("user_photo.gif"))) { Response.Write("<img src='../Userpic/showimg.gif' width='77' height='60' alt='我的形象！'>"); } else { Response.Write("<img src='../Userpic/" + Session.getItem("username") + "/" + Session.getItem("userpic") + "' width='80' height='60' alt='我的形象！'>"); }%></TD> </TR></TBODY></TABLE></td> <td width="78%" style="HEIGHT: 50px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px solid; BACKGROUND-COLOR: #f7f7f7"><% if (Session.getItem("username").equals(new variant(""))) { Response.Write("<textarea style='WIDTH: 355px; HEIGHT: 60px' name='content' readonly>请登录后留言！</textarea>"); } else { Response.Write("<textarea style='WIDTH: 355px; HEIGHT: 60px' name='content'></textarea>"); }%> </td> </tr> <tr> <td height="25" colspan="2" align="right"><input name="silence" type="checkbox" value="1"> 悄悄话 <% if (Session.getItem("username").equals(new variant(""))) { Response.Write("<IMG src='../Images/Hompy/btn_message.gif' width='39' height='18' align='absmiddle'>"); } else { Response.Write("<INPUT Type='image' src='../Images/Hompy/btn_message.gif' width='39' height='18' align='absmiddle'>"); }%></td> </tr> </form> </table> </TD> </TR> <TR> <TD height=24><div align="center"><% username.set(Request.QueryString("username").getValue()); rs = new jasp.adodb.Recordset(); sql = "select * from iisALLMessage where Username='" + username + "' Order By MessageID DESC"; if (!(vb.IsEmpty(Request.getItem("page")))) { currentpage = vb.CInt(Request.getItem("page")); } else { currentpage = 1; } maxperpage = 6; rs.Open(sql, cn, 1, 1); totalput = rs.getRecordCount(); //rs.move (currentPage-1)*MaxPerPage rs.setPageSize(maxperpage); mpage = rs.getPageCount(); i = rs.getRecordCount(); if (rs.getEOF() || rs.getBOF()) {%><table width="97%" border="0" cellpadding="0" cellspacing="0"> <tr> <td style="HEIGHT: 3px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"><img src="" width="3" height="3" alt=""></td> </tr> <tr> <td></td> </tr> <tr> <td height="108" align="center">暂无留言！</td> </tr> <tr> <td height="1" style="BORDER-BOTTOM: #cecfce 1px solid;"><img name="" src="" width="1" height="1" alt=""> </td> </tr></table><table width="46%" height="45" border="0" cellpadding="0" cellspacing="0"> <tr> <td><TABLE width="225" height="26"> <TBODY> <FORM name=form onSubmit="return false;" method=get target=_self> <TR> <TD><SELECT name=selsearchType> <option value="wpname">留言者</option> </SELECT> <INPUT maxLength=35 size=15 name=searchTxt> <img src="../Images/Hompy/search_b.gif" align="absmiddle"></TD> </TR> </FORM> </TABLE></td> </tr></table><% Response.End(); } else { while (!(rs.getEOF()) || rs.getBOF()) {%> <table width="97%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="82%" style="PADDING-LEFT: 5px; HEIGHT: 24px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"> <img src="../Images/Hompy/ico_no.gif" width="13" height="5"> <SPAN style="FONT: 9px verdana; LETTER-SPACING: -1px"> </SPAN><span style="FONT: 9px verdana; LETTER-SPACING: -1px"><%= i %></span> <a class=popmenu href="hompy.jsp?username=<%= rs.getItem("MUser").getValue() %>" target="_blank"><%= rs.getItem("MUser").getValue() %></a> <img src="../Images/Hompy/icon_guest.gif" width="14" height="11"> <SPAN style="FONT: 9px verdana; COLOR: #7f7f7f; LETTER-SPACING: -1px"><%= rs.getItem("Posttime").getValue() %></SPAN> </td> <td align="center" width="18%" style="HEIGHT: 24px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"><table width="70" height="22" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="70" align="right"><% if (Session.getItem("Username").equals(username)) {%><a class="orange" href="javascript:if(ask('真的要删除吗？')) location.href='messagedel.jsp?messageid=<%= rs.getItem("MessageID").getValue() %>';">删除</a><% }%></td> </tr> </table></td> </tr> <tr> <td height="51" colspan="2"><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="22%" height="74" align="center" valign="top" style="PADDING-TOP: 4px"> <TABLE cellSpacing=1 cellPadding=3 align=center bgColor=#cccccc border=0> <TBODY> <TR> <TD align=middle bgColor=#ffffff><% rs_userpic = new jasp.adodb.Recordset(); sql = "select * from iisALLUser where Username='" + rs.getItem("Muser").getValue() + "'"; rs_userpic.Open(sql, cn, 1, 1); if (rs_userpic.getItem("Userpic").getValue().equals(new variant("user_photo.gif"))) { Response.Write("<img src='../Userpic/showimg.gif' width='77' height='60'>"); } else { Response.Write("<img src='../Userpic/" + rs_userpic.getItem("Username").getValue() + "/" + rs_userpic.getItem("Userpic").getValue() + "'' width='80' height='60'>"); } rs_userpic.Close(); rs_userpic = (jasp.adodb.Recordset)null;%></TD> </TR></TBODY></TABLE></td> <td width="78%" style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; PADDING-TOP: 5px; PADDING-BOTTOM: 20px; word-break:break-all"><%= rs.getItem("Content").getValue() %></td> </tr> </table></td> </tr> <tr> <td height="28" colspan="2" style="BACKGROUND-COLOR: #f7f7f7" align="center"><% rs_remessage = new jasp.adodb.Recordset(); sql = "select * from iisALLReMessage where MessageID=" + rs.getItem("MessageID").getValue() + ""; rs_remessage.Open(sql, cn, 1, 1); while (!(rs_remessage.getEOF())) {%><A name=<%= rs.getItem("MessageID").getValue() %>></A><TABLE width="100%" height="24" border=0 cellPadding=0 cellSpacing=0> <TBODY> <TR> <TD style="PADDING-LEFT: 10px; PADDING-RIGHT: 10px; word-break:break-all"><a class="popmenu" href="#"><%= rs_remessage.getItem("Username").getValue() %></a>：<%= rs_remessage.getItem("Content").getValue() %> <SPAN style="FONT: 9px verdana; COLOR: #7f7f7f; LETTER-SPACING: -1px"> (<%= rs_remessage.getItem("Posttime").getValue() %>)</SPAN></TD> </TR> </TBODY> </TABLE><% rs_remessage.MoveNext(); } rs_remessage.Close(); rs_remessage = (jasp.adodb.Recordset)null;%><% if (Session.getItem("Username").equals(username)) {%><TABLE width="81%" height="18" border=0 cellPadding=0 cellSpacing=0> <form name="remessage<%= i %>" action="remessage.jsp?Username=<%= username %>" method="post" onSubmit="return formcheck1(remessage<%= i %>);"> <INPUT type=hidden value=<%= rs.getItem("MessageID").getValue() %> name=messageid> <TBODY> <TR> <TD width="12%" height=18> <div align="center">回复：</div></TD> <TD width="72%"><INPUT style="WIDTH: 260px" name="content"></TD> <TD width="16%"><INPUT Type="image" src="../Images/Hompy/btn_remessage.gif" width="39" height="18" align="absmiddle"></TD> </TR> </TBODY> </form> </TABLE><% }%> </td> </tr> <tr> <td colspan="2"> </td> </tr> </table><% rs.MoveNext(); i = i - 1; } } rs.Close(); rs = (jasp.adodb.Recordset)null;%><table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td align="center" style="FONT-SIZE: 11px"><% Page();%> </td> </tr></table> <table width="46%" height="45" border="0" cellpadding="0" cellspacing="0"> <tr> <td><TABLE width="225" height="26"> <TBODY> <FORM name=form onSubmit="return false;" method=get target=_self> <TR> <TD><SELECT name=selsearchType> <option value="wpname">留言者</option> </SELECT> <INPUT maxLength=35 size=15 name=searchTxt> <img src="../Images/Hompy/search_b.gif" align="absmiddle"></TD> </TR> </FORM> </TABLE></td> </tr></table> </div></TD> </TR> </TBODY></TABLE></body></html><%! variant username; int currentpage; //得到每页数 int mpage; public void Page() throws Exception { int pageno = 0; int pp = 0; int pno = 0; int p = 0; pageno = currentpage; if (vb.IsEmpty(pageno) || vb.CInt(pageno) < 1 || vb.CInt(pageno) > mpage) { pageno = 1; } Response.Write(" "); if (vb.CInt(pageno) > 1) { Response.Write("<a href=messagelist.jsp?username="); Response.Write(username); Response.Write("&page="); Response.Write(pageno - 1); Response.Write(">"); } Response.Write("<img src=\"../Images/Hompy/K_play_middle_pre.gif\" border=\"0\" align=\"absmiddle\"> </a> "); pp = vb.CInt(pageno) - 3; if (pp < 1) { pp = 1; } for(pno = pp; pno <= mpage; pno += 1){ p = p + 1; if (pno == vb.CInt(pageno)) { Response.Write(" <strong><font color=\"#FF0000\">"); Response.Write(pno); Response.Write("</font></strong> "); } else { Response.Write(" <a href=messagelist.jsp?username="); Response.Write(username); Response.Write("&page="); Response.Write(pno); Response.Write("><u>"); Response.Write(pno); Response.Write("</u></a> "); } Response.Write(" "); if (p >= 7) { if(true) break; } } Response.Write(" "); if (vb.CInt(pageno) < mpage) { Response.Write("<a href=messagelist.jsp?username="); Response.Write(username); Response.Write("&page="); Response.Write(pageno + 1); Response.Write(">"); } Response.Write("<img src=\"../Images/Hompy/K_play_middle_next.gif\" border=\"0\" align=\"absmiddle\"></a> <a href=messagelist.jsp?username="); Response.Write(username); Response.Write("&page="); Response.Write(mpage); Response.Write(">\n"); Response.Write("</a> "); }%> <% End(); } catch(Exception ex) { printStackTrace(ex); } %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -