📄 articlelist.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); variant sortid = new variant(); int i = 0; String sqlfiltrate = ""; int maxperpage = 0; jasp.adodb.Recordset rs = null; String sql = ""; int totalput = 0; /* initialize variables. */ username = new variant(); groupid = 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.Redirect("../default.jsp"); }%><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 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="86%" class="orange2_b">文章列表</td><% if (Session.getItem("username").equals(username)) {%> <td width="14%"><a href="articlewrite.jsp?username=<%= Request.QueryString("username").getValue() %>"><img src="../Images/Hompy/w_note.gif" width="62" height="19" border="0"></a></td><% }%> </tr> </table></TD> </TR> <TR> <TD height=12><div align="center"> <% groupid.set(Request.QueryString("GroupID").getValue()); if (groupid.equals(new variant(""))) { sqlfiltrate = "select * from iisALLArticle where Username='" + username + "' order by ArticleID DESC"; } else { sqlfiltrate = "select * from iisALLArticle where Username='" + username + "' and GroupID=" + groupid + " order by ArticleID DESC"; } if (!(vb.IsEmpty(Request.getItem("page")))) { currentpage = vb.CInt(Request.getItem("page")); } else { currentpage = 1; } maxperpage = 10; rs = new jasp.adodb.Recordset(); sql = "" + sqlfiltrate + ""; rs.setCursorLocation(3); rs.Open(sql, cn, 1, 1); //i=rs.recordcount 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="39%" height="45" border="0" cellpadding="0" cellspacing="0"> <tr> <td><TABLE width="206"> <TBODY> <FORM name=form onSubmit="return false;" method=get target=_self> <TR> <TD><SELECT name=selsearchType> <option value="wpname">标题</option> <option value="title">内容</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 { totalput = rs.getRecordCount(); rs.Move((currentpage - 1) * maxperpage); rs.setPageSize(maxperpage); mpage = rs.getPageCount(); //得到总页数%> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <TR> <td align="center" style="HEIGHT: 24px;BORDER-TOP: #cecfce 1px solid; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"><table width="468" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="42" align="center">编号</td> <td width="225" align="center">标题</td> <td width="110" align="center">发布时间</td> <td width="46" align="center">点击</td><% if (Session.getItem("Username").equals(username)) {%> <td width="46" align="center">操作</td><% }%> </tr> </table></td> </TR></table> <table width="468" border="0" cellspacing="0" cellpadding="0"><% i = 1; while(!(rs.getEOF() || i > maxperpage)) {%> <tr> <td width="42" height=25 align=center><SPAN style="FONT-SIZE: 11px; COLOR: #666666"><SPAN><%= i %></span></span></td> <td width="225" style="PADDING-BOTTOM: 5px; PADDING-TOP: 5px" height=25><a href="articleview.jsp?ArticleID=<%= rs.getItem("ArticleID").getValue() %>&Username=<%= rs.getItem("Username").getValue() %>&GroupID=<%= rs.getItem("GroupID").getValue() %>"><%= rs.getItem("Topic").getValue() %></a> <% if (vb.DateDiff("d", rs.getItem("Posttime").getValue().toDate(), vb.Now()) < 3.0) { Response.Write(" <img src='../Images/Hompy/ico_new.gif' width='10' height='8' border='0' align='absmiddle'>"); }%> </td> <td width="108"><SPAN style="FONT-SIZE: 11px; COLOR: #666666"><SPAN><%= rs.getItem("Posttime").getValue() %></span></span></td> <td width="44" align=center><SPAN style="FONT-SIZE: 11px; COLOR: #ff6600"><SPAN><%= rs.getItem("Hit").getValue() %></span></span></td><% if (Session.getItem("Username").equals(username)) {%> <td width="49" align=center><a href="articleedit.jsp?articleid=<%= rs.getItem("ArticleID").getValue() %>"><img src="../Images/Hompy/icon_edit.gif" width="16" height="16" border="0" alt="编辑"></a> <a href="javascript:if(ask('真的要删除吗？')) location.href='articledel.jsp?articleid=<%= rs.getItem("ArticleID").getValue() %>';"><img src="../Images/Hompy/icon_del.gif" width="16" height="16" border="0" alt="删除"></a></td><% }%> </tr> <tr> <td colspan="5" align="center" style="HEIGHT: 1px; BORDER-BOTTOM: #cecfce 1px dotted"><img name="" src="" width="1" height="1" alt=""></td> </tr><% rs.MoveNext(); i = i + 1; } } rs.Close(); rs = (jasp.adodb.Recordset)null;%> </table> </div></TD> </TR> <TR> <td align="center" style="HEIGHT: 4px; BORDER-BOTTOM: #cecfce 1px solid; BACKGROUND-COLOR: #f7f7f7"><img src="" width="4" height="4" alt=""></td> </TR> <TR> <TR> <TD align="center"> <table width="100%" height="30" border="0" cellpadding="0" cellspacing="0"> <tr> <td height="30" align="center" style="FONT-SIZE: 11px"> <% Page();%> </td> </tr></table> <table width="39%" border="0" cellspacing="0" cellpadding="0"> <tr> <td><table width="39%" height="28" border="0" cellpadding="0" cellspacing="0"> <tr> <td><TABLE width="206"> <TBODY> <FORM name=form onSubmit="return false;" method=get target=_self> <TR> <TD><SELECT name=selsearchType> <option value="wpname">标题</option> <option value="title">内容</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></td> </tr></table></TD></TR> <TR> </TBODY></TABLE></body></html><%! variant username; variant groupid; 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=articlelist.jsp?username="); Response.Write(username); Response.Write("&groupid="); Response.Write(groupid); 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=articlelist.jsp?username="); Response.Write(username); Response.Write("&groupid="); Response.Write(groupid); 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=articlelist.jsp?username="); Response.Write(username); Response.Write("&groupid="); Response.Write(groupid); 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=articlelist.jsp?username="); Response.Write(username); Response.Write("&groupid="); Response.Write(groupid); 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 + -