📄 mainbody.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" %><%@ page import="jasp.buildin.*, jasp.vbs.*, jasp.util.*" %><%@ page extends="jasp.servlet.JspBase" %><% try { jspinit(request,response,application,out,"jasp0");%><% Session.setCodePage(936); String username = ""; jasp.adodb.Recordset rs = null; String sql = ""; variant a = new variant(); int n = 0; int m = 0; int i = 0;%><%@ include file="../include/connect.jsp" %><% username = checkstr(new variant(Request.QueryString("Username")));%><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></head><body oncontextmenu="window.event.returnValue=false" onselectstart="return false"><table width="480" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="276" height="93" valign="top"><TABLE cellSpacing=0 cellPadding=0 width="98%" border=0> <TBODY> <TR> <TD width="81%" height="23" align=left class="orange2_b" style="HEIGHT: 24px; BORDER-BOTTOM: #cecfce 1px dotted"> <img src="../Images/Hompy/bbs_ic017.gif" width="16" height="16" align="absmiddle"> 最新文章：</TD> <TD width="19%" height="23" align=left class="orange2_b" style="HEIGHT: 24px; BORDER-BOTTOM: #cecfce 1px dotted"><a href="article_index.jsp?username=<%= username %>" target="_parent"><img src="../Images/Hompy/more.gif" width="41" height="11" border="0" align="absmiddle"></a></TD> </TR> <TR> <TD height="59" colspan="2" style="PADDING-TOP:3px;BORDER-BOTTOM: #cecfce 1px dotted" valign="top"> <% rs = new jasp.adodb.Recordset(); sql = "select TOP 3 * from iisALLArticle where Username='" + username + "' order by ArticleID DESC"; rs.Open(sql, cn, 1, 1); if (rs.getEOF() || rs.getBOF()) { Response.Write("暂无文章"); } else { while (!(rs.getEOF())) {%> <table width="264" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="18" height="18" align="center"><img src="../Images/Hompy/bbs_ic073.gif" width="16" height="16"></td> <td width="182"><a href="article_index.jsp?resurl=articleview.jsp?articleID=<%= rs.getItem("ArticleID").getValue() %>&username=<%= rs.getItem("Username").getValue() %>&groupid=<%= rs.getItem("GroupID").getValue() %>" target="_parent" title="<%= rs.getItem("Topic").getValue() %>"><% a.set(rs.getItem("Topic").getValue()); if (vb.Len(a) > 15) { a.set(vb.Left(a.toString(), 15.0) + ".."); } Response.Write("" + a + "");%></a></td> <td width="64" align="right"><SPAN style="FONT-SIZE: 11px; COLOR: #666666"><SPAN><%= vb.Left(rs.getItem("Posttime").getValue().toString(), 8.0) %></span></span></td> </tr> </table><% rs.MoveNext(); } } rs.Close();%> </TD> </TR> </TBODY> </TABLE></td> <td width="204" valign="top"><TABLE cellSpacing=0 cellPadding=0 width="100%" border=0> <TBODY> <TR> <TD height="23" colSpan=2 align=left class="orange2_b"><img src="../Images/Hompy/bbs_ic037.gif" width="16" height="16" align="absmiddle"> 最新统计：</TD> </TR> <TR bgColor=#f3f3f3> <TD class=list3 align=left width="50%" height=20> <img src="../Images/Hompy/dot_2.gif" width="4" height="7" border="0"> <a href="article_index.jsp?username=<%= username %>" target="_parent">博客： <% sql = "select * from iisALLArticle where Username='" + username + "'"; rs.setCursorLocation(3); rs.Open(sql, cn, 1, 1); Response.Write("<SPAN style='FONT-SIZE: 11px; COLOR: #ff6600'><SPAN>" + vb.CStr(rs.getRecordCount()) + "</span></span>"); rs.Close(); sql = "select * from iisALLArticle where Username='" + username + "' and DATEDIFF(day,Posttime,getdate())<3"; rs.Open(sql, cn, 1, 1); if (!(rs.getEOF())) { Response.Write(" <img src='../Images/Hompy/ico_new.gif' width='10' height='8' border='0' align='absmiddle'>"); } rs.Close();%> </a> </TD> <TD class=list3 align=left width="50%" height=20> <img src="../Images/Hompy/dot_2.gif" width="4" height="7" border="0"> <a href="photo_index.jsp?username=<%= username %>" target="_parent">相册： <% sql = "select * from iisALLPhoto where Username='" + username + "'"; rs.setCursorLocation(3); rs.Open(sql, cn, 1, 1); Response.Write("<SPAN style='FONT-SIZE: 11px; COLOR: #ff6600'><SPAN>" + vb.CStr(rs.getRecordCount()) + "</span></span>"); rs.Close(); sql = "select * from iisALLPhoto where Username='" + username + "' and DATEDIFF(day,Posttime,getdate())<3"; rs.Open(sql, cn, 1, 1); if (!(rs.getEOF())) { Response.Write(" <img src='../Images/Hompy/ico_new.gif' width='10' height='8' border='0' align='absmiddle'>"); } rs.Close();%> </a></TD> </TR> <TR bgColor=#f3f3f3> <TD class=list3 align=left height=20> <img src="../Images/Hompy/dot_2.gif" width="4" height="7" border="0"> <A href="tt_index.jsp?username=<%= username %>" target="_parent">拍贴： <% sql = "select * from iisALLTT where Username='" + username + "'"; rs.setCursorLocation(3); rs.Open(sql, cn, 1, 1); Response.Write("<SPAN style='FONT-SIZE: 11px; COLOR: #ff6600'><SPAN>" + vb.CStr(rs.getRecordCount()) + "</span></span>"); rs.Close(); sql = "select * from iisALLTT where Username='" + username + "' and DATEDIFF(day,Posttime,getdate())<3"; rs.Open(sql, cn, 1, 1); if (!(rs.getEOF())) { Response.Write(" <img src='../Images/Hompy/ico_new.gif' width='10' height='8' border='0' align='absmiddle'>"); } rs.Close();%> </A></TD> <TD class=list3 align=left height=20> <img src="../Images/Hompy/dot_2.gif" width="4" height="7" border="0"> <a href="vshow_index.jsp?username=<%= username %>" target="_parent">视频： <% sql = "select * from iisALLVideo where Username='" + username + "'"; rs.setCursorLocation(3); rs.Open(sql, cn, 1, 1); Response.Write("<SPAN style='FONT-SIZE: 11px; COLOR: #ff6600'><SPAN>" + vb.CStr(rs.getRecordCount()) + "</span></span>"); rs.Close(); sql = "select * from iisALLVideo where Username='" + username + "' and DATEDIFF(day,Posttime,getdate())<3"; rs.Open(sql, cn, 1, 1); if (!(rs.getEOF())) { Response.Write(" <img src='../Images/Hompy/ico_new.gif' width='10' height='8' border='0' align='absmiddle'>"); } rs.Close();%> </a></TD> </TR> <TR bgColor=#f3f3f3> <TD class=list4 align=left height=20> <img src="../Images/Hompy/dot_2.gif" width="4" height="7" border="0"> <a href="message_index.jsp?username=<%= username %>" target="_parent">留言： <% sql = "select * from iisALLMessage where Username='" + username + "'"; rs.setCursorLocation(3); rs.Open(sql, cn, 1, 1); Response.Write("<SPAN style='FONT-SIZE: 11px; COLOR: #ff6600'><SPAN>" + vb.CStr(rs.getRecordCount()) + "</span></span>"); rs.Close(); sql = "select * from iisALLMessage where Username='" + username + "' and DATEDIFF(day,Posttime,getdate())<3"; rs.Open(sql, cn, 1, 1); if (!(rs.getEOF())) { Response.Write(" <img src='../Images/Hompy/ico_new.gif' width='10' height='8' border='0' align='absmiddle'>"); } rs.Close();%> </a></TD> <TD class=list4 align=left height=20> </TD> </TR> </TBODY> </TABLE></td> </tr> <tr> <td height="90" colspan="2"><table width="480" height="206" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="290" height="206"> <IFRAME name=video_i marginWidth=0 marginHeight=0 src="video_i.jsp?Username=<%= username %>" frameBorder=0 width=290 height=206></IFRAME> </td> <td width="190" bgcolor="#f7f7f7" valign="top" align="center"><table width="95%" border="0" cellspacing="0" cellpadding="0"> <tr> <td width="70%" height="21" class="orange2_b" style="HEIGHT: 24px; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"> 最新视频 </td> <td width="30%" class="orange2_b" style="HEIGHT: 24px; BORDER-BOTTOM: #cecfce 1px dotted; BACKGROUND-COLOR: #f7f7f7"><a href="vshow_index.jsp?username=<%= username %>" target="_parent"><img src="../Images/Hompy/more.gif" width="41" height="11" border="0" align="absmiddle"></a></td> </tr> </table> <table width="95%" height="57" border="0" cellpadding="0" cellspacing="0"> <tr><td height="5"></td></tr> <tr> <% sql = "select Top 6 * from iisALLVideo where Username='" + username + "' and audit=1 Order By VideoID DESC"; rs.Open(sql, cn, 1, 1); if (rs.getEOF() || rs.getBOF()) { Response.Write("暂无视频！"); } else { n = 1; m = 2; while(!(rs.getEOF())) {%> <td height="57" style="PADDING-LEFT: 10px"> <table width="70" height="50" border="0" cellpadding="0" cellspacing="0"> <tr> <td style="BORDER-RIGHT: #cecfce 1px solid; BORDER-TOP: #cecfce 1px solid; BORDER-LEFT: #cecfce 1px solid; WIDTH: 70px; BORDER-BOTTOM: #cecfce 1px solid; HEIGHT: 50px; BACKGROUND-COLOR: #ffffff; TEXT-ALIGN: center"><a href="flvplayer1.swf?server=<%= rs.getItem("Server").getValue() %>&username=<%= rs.getItem("Username").getValue() %>&file=<%= rs.getItem("filename").getValue() %>" target="video_i"><img src="../Videoimage/<%= rs.getItem("filename").getValue() %>.jpg" width="70" height="50" border="0" alt="<%= rs.getItem("Topic").getValue() %>"></a></td> </tr> </table></td><% if (n == m) { Response.Write("</tr><tr>"); n = 1; } else { n = n + 1; } rs.MoveNext(); i = i + 1; } rs.Close(); rs = (jasp.adodb.Recordset)null; }%> </tr> </table></td> </tr> </table></td> </tr> <tr> <td height="28" colspan="2" valign="bottom"> <table width="480" height="24" border="0" cellpadding="0" cellspacing="0"> <tr> <td width="19%" bgcolor="#F0F0F0" align="center" class="orange2_b"><img src="../Images/Hompy/bbs_ic020.gif" width="16" height="16" align="absmiddle"> 好友留言</td> <td width="68%" bgcolor="#F0F0F0"><table width="300" border="0" cellspacing="0" cellpadding="0"> <tr> <td bgcolor="#FFFFFF"> </td> </tr> </table></td> <td width="13%" bgcolor="#F0F0F0"><a href="message_index.jsp?username=<%= username %>" target="_parent"><img src="../Images/Hompy/more.gif" width="41" height="11" border="0"></a></td> </tr> </table></td> </tr> <tr> <td colspan="2" style="PADDING-TOP: 3px"><IFRAME name=Articlelist_Frame marginWidth=0 marginHeight=0 src="messagelist_i.jsp?username=<%= username %>" frameBorder=0 width=480 height=110></IFRAME></td> </tr></table></body></html><% End(); } catch(Exception ex) { printStackTrace(ex); } %>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -