开通博客赚积分
发布资源赚积分
分类

源码开发语言/平台
当前位置：首页 > 源码/资料 > Internet/网络编程 > WEB源码(ASP,PHP,...) > 查看源码
add_all_slly.jsp
资源名称：zyp.rar　[点击查看]
上传用户：zdly666
上传日期：2022-08-09
资源大小：6511k
文件大小：8k
源码类别：

WEB源码(ASP,PHP,...)

开发平台：

JavaScript

add_all_slly.jsp：源码内容
  1. <%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*" errorPage="" %>
  2. <%@ include file="conn.jsp"%>
  3. <% 
  5. String condition="select * from manage";
  6. rs=stmt.executeQuery(condition);
  7. rs.next();
  8. %>
  9. <html>
  10. <head>
  11. <link rel="stylesheet" href="style.css" type="text/css">
  12. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  13. <title><%=rs.getString("title")%></title>
  14. <link href="style.css" rel="stylesheet" type="text/css">
  15. <style type="text/css">
  16. <!--
  17. .style1 {font-family: "宋体"}
  18. .style2 {font-size: 9px}
  19. .style3 {color: #9999CC; text-decoration: none; font-family: "宋体";}
  20. .style4 {font-size: 9pt}
  21. .style5 {color: #999999}
  22. .style6 {font-family: "宋体"; color: #999999; }
  23. .style7 {color: #FF0000}
  24. .style8 {font-family: Tahoma}
  25. a.rights:link {
  26. COLOR: #000000;
  27. TEXT-DECORATION: none;
  29. }
  30. a.rights:visited {
  31. COLOR: #000000;
  32. TEXT-DECORATION: none;
  34. }
  35. a.rights:hover {
  36. COLOR: #FF0000;  
  37. TEXT-DECORATION: none;
  39. }
  40. .style9 {
  41. font-size: 9pt;
  42. color: #FF0000;
  43. font-weight: bold;
  44. }
  45. -->
  46. </style>
  47. </head>
  49. <body background="img/beijing.gif" text="#000000" leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">
  50. <table width="650" border="0" align="center" cellpadding="0" cellspacing="0" class="tittle0">
  51.   <tr>
  52.     <td width="389" align="center" valign="middle"><img src="img/toplogo11.gif" width="389" height="150"></td>
  53.     <td width="66" background="img/toplogobg.jpg">&nbsp;</td>
  54.     <td width="195"><img src="img/toplogo2.jpg" width="203" height="150"></td>
  55.   </tr>
  56. </table>
  57. <table width="650" border="0" align="center" cellpadding="0" cellspacing="0" class="tittle1">
  58.   <tr>
  59.     <td height="26" background="img/bg.gif"><table width="100%" height="15" border="0" cellpadding="0" cellspacing="0">
  60.       <tr align="center">
  61.         <td class="font0"><span class="font0">版主：</span><font color="#006699"><%=rs.getString("adminname")%></font></td>
  62.         <td class="font0"><a href="login.jsp">管理员登陆</a> </td>
  63.         <td class="font0"><a href="Index.jsp" class="font0">个人简介</a>　 <a href="add.jsp" class="font0"> </a></td>
  64.         <td class="font0"><a href="add.jsp" class="font0">给我留言</a></td>
  65.         <td class="font0"> <font color="#000099"> <span> <a href="news.jsp" class="font0">新闻系统</a></span><font color="#000099">　</font><font color="#000099">　</font></font></td>
  66.         <td class="font0"><font color="#000099"><a href="Picture1.jsp"  class="font0">个人相册</a></font></td>
  67.       </tr>
  68.     </table></td>
  69.   </tr>
  70. </table>
  71. <p>
  72. </p>
  73. <% 
  75. String condition2="select * from users order by id DESC";
  76. rs=stmt.executeQuery(condition2);
  77. int intPageSize; 
  78. int intRowCount; 
  79. int intPageCount; 
  80. int intPage; 
  81. String strPage;
  82. int i;
  83. intPageSize = 8;
  84. strPage = request.getParameter("page");
  85. if(strPage==null){
  86. intPage = 1;
  87. }
  88. else
  89. {
  90. intPage = Integer.parseInt(strPage);
  91. if(intPage<1){ intPage = 1;}
  92. }
  93. rs.last(); 
  94. intRowCount = rs.getRow(); 
  95. intPageCount =(intRowCount+intPageSize-1) / intPageSize;
  96. if(intPage>intPageCount) intPage = intPageCount;
  97. if(intPageCount>0){
  98. rs.absolute((intPage-1) * intPageSize+1); 
  99. i = 0; 
  100. while(i< intPageSize && !rs.isAfterLast())
  102. {
  103. String MessageID=rs.getString("id");
  104. String name=rs.getString("name");
  105. String content=rs.getString("content");
  106. String qq=rs.getString("qq");
  107. String email=rs.getString("email");
  108. String http=rs.getString("http");
  109. String time=rs.getString("time");
  110. String ip=rs.getString("ip");
  111. String sex=rs.getString("sex");
  112. String recontent=rs.getString("recontent");
  113. %>
  115. <table width="650" border="0" cellspacing="0" cellpadding="0" align="center" style="word-break:break-all">
  117.   <tr> 
  118.     <td width="81" height="10"><img src="img/top1.gif" width="81" height="22"></td>
  119.     <td width="575" background="img/top2.gif">&nbsp;</td>
  120.     <td width="1"><img src="img/top3.gif" width="47" height="22"></td>
  121.   </tr>
  122.   <tr> 
  123.     <td colspan="3" align="center" bgcolor="#FFFFFF" class="tittle2"><table width="100%" height="28" border="0" cellpadding="0" cellspacing="0" background="img/bg.gif" class="tittle3">
  124.         <tr> 
  125.           <td width="4%" align="center"><img src="img/topicnew.gif" width="16" height="18"></td>
  126.           <td width="39%"><span class="style2"><span class="style4"><span class="style7"><%=name%><span style="font-family: &quot;??&quot;;" #invalid_attr_id="none"></span></span><span class="style3">留言于</span><font color="#000099"><font color="#FF0000"><%=time%>&nbsp;&nbsp;</font></font></span></span></td>
  127.           <td width="39%"><span class="style4"><font color="#000099">IP:</font><font color="#FF0000"><%=rs.getString("ip")%></font></span></td>
  128.           <td width="3%"><a href="<%=http%>" target="_blank"><img src="img/icon_homepage.gif" alt="<%=name%>的主页" width="16" height="16" border="0"></a></td>
  129.           <td width="3%"><a href="http://search.tencent.com/cgi-bin/friend/user_show_info?ln=<%=qq%>" target="_blank"><img src="img/icon_editor_oicq.gif" alt="<%=name%>的QQ是：<%=qq%>" width="16" height="16" border="0"></a></td>
  130.           <td width="3%"><a href="mailto:<%=email%>"><img src="img/icon_email.gif" alt="<%=name%>的Email是：<%=email%>" width="16" height="16" border="0"></a></td>
  131.           <td width="3%"><a href="add_return_ly.jsp?id=<%=MessageID%>"><img src="img/icon_reply_topic.gif" width="16" height="16" border="0" alt="回复该留言[只有版主才有的权利]"></a></td>
  132.           <td width="3%"><a href="add_edit.jsp?id=<%=MessageID%>"><img src="img/icon_edit_topic.gif" width="16" height="16" border="0" alt="编辑该留言[只有版主才有的权利]"></a></td>
  133.           <td width="3%"><a href="add_delete.jsp?id=<%=MessageID%>"><img src="img/icon_delete_reply.gif" alt="删除该留言[只有版主才有的权利]" width="16" height="16" border="0"></a></td>
  134.         </tr>
  135.         <tr></tr>
  136.       </table>
  137.       <table width="100%" border="0" cellspacing="0" cellpadding="0">
  138.         <tr> 
  139.           <td width="100" height="92" align="center" valign="top"> <table width="100%" border="0" cellspacing="3" cellpadding="0">
  140.             <tr>
  141.               <td align="center"><img src="img/<%=sex%>.gif"></td>
  142.             </tr>
  143.             <tr>
  144.               <td align="center"><span class="style4"><%=name%></span></td>
  145.             </tr>
  146.           </table></td>
  147.           <td width="423"><span class="style4"><%=content %></span></td>
  148.         </tr>
  149.         <tr align="center"> 
  150.           <td colspan="2" valign="top"><img src="images/bg_4.gif" width="100%" height="1"></td>
  151.         </tr>
  152.         <tr> 
  153.           <td colspan="2" height="20"><font color="#006699"> 　<img src="img/locktop.gif" width="15" height="15" align="absmiddle"></font><span class="font0"><span class="style1">版主回复：<span class="style6"></span></span><span class="style5"><%=recontent%></span></span></td>
  154.         </tr>
  155.       </table></td>
  156.   </tr>
  158. </table>
  159. <table border="0" width="650" cellspacing="0" cellpadding="0" height="7" align="center">
  160.   <tr> 
  161.     <td width="2%" align="center"><img src="img/end1.gif" width="12" height="14"></td>
  162.     <td width="89%" align="center" background="img/end2.gif"></td>
  163.     <td width="9%" align="center"><img src="img/end3.gif" width="65" height="14"></td>
  164.   </tr>
  165.  
  166. </table>
  167. <p> 
  168.   <% 
  169.   
  170. rs.next(); 
  171.    i++; 
  172.   } 
  173.   }
  174. rs.close();
  175. stmt.close(); 
  176. conn.close();
  177. %>
  178. </p>
  179. <p>  
  181. </p>
  182. <table width="650" border="0" align="center" cellpadding="0" cellspacing="1" class="tittle0">
  183.   <tr>
  184.     <td height="28" align="center" background="img/bg.gif" class="font0 style1">当前显示第<span class="style7"> <%=intPage%></span> 页&nbsp;&nbsp; 共 <%=intPageCount%> 页 &nbsp;&nbsp;&nbsp;&nbsp;导航：<a href="add_all_slly.jsp?page=1" class="font0">首页</a>
  185.       <%if(intPage>1){%>
  186.       <a href="add_all_slly.jsp?page=<%=intPage-1%>" class="font0">上一页</a>
  187.       <%}else{%>
  188. 上一页
  189. <%
  190.   }%>
  191.  
  192. <%if(intPage<intPageCount){%>
  193. <a href="add_all_slly.jsp?page=<%=intPage+1%>" class="font0">下一页</a>
  194. <%}else{%>
  195. 下一页
  196. <%
  197.   }%>
  198. <a href="add_all_slly.jsp?page=<%=intPageCount%>" class="font0">尾页</a> </td>
  199.   </tr>
  200. </table>
  201. <table width="650" border="0" align="center" cellpadding="0" cellspacing="0">
  203.   <tr>
  204.     <td align="center"><p class="style4 style8"><a href="http://jorwoo.yeah.net" target="_blank" class="rights">周亚平</a>&nbsp;&nbsp; 版权所有 <br>
  205. 程序设计：周亚平&nbsp;&nbsp; E-mail: <a href="mailto:zhouyaping1986@126.com" class="rights">zhouyaping1986@126.com</a><br>
  206. QQ:153589840</p>    </td>
  207.   </tr>
  208. </table>