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

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

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

开发平台：

JavaScript

news_all.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>新闻删除</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 art order by art_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("art_id");
  104. String author=rs.getString("author");
  105. String art_content=rs.getString("art_content");
  106. String tel=rs.getString("tel");
  107. String art_headline=rs.getString("art_headline");
  108. %>
  110. <table width="650" border="0" cellspacing="0" cellpadding="0" align="center" style="word-break:break-all">
  112.   <tr> 
  113.     <td width="81" height="10"><img src="img/top1.gif" width="81" height="22"></td>
  114.     <td width="575" background="img/top2.gif">&nbsp;</td>
  115.     <td width="1"><img src="img/top3.gif" width="47" height="22"></td>
  116.   </tr>
  117.   <tr> 
  118.     <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">
  119.         <tr> 
  120.           <td width="9%" align="center"><img src="img/topicnew.gif" width="16" height="18"></td>
  121.           <td width="70%"><span class="style2"><span class="style4"><span class="style7" align="left"><%=author%><span style="font-family: &quot;??&quot;;" #invalid_attr_id="none"></span></span><span class="style3">发表的新闻</span><font color="#000099"><font color="#FF0000">&nbsp;&nbsp;</font></font></span></span></td>
  122.           
  123.           
  124.           <td width="10%"><a href="news_edit.jsp?id=<%=MessageID%>"><img src="img/icon_edit_topic.gif" width="16" height="16" border="0" alt="编辑该留言[只有版主才有的权利]"></a></td>
  125.           <td width="11%"><a href="news_del.jsp?id=<%=MessageID%>"><img src="img/icon_delete_reply.gif" alt="删除该留言[只有版主才有的权利]" width="16" height="16" border="0"></a></td>
  126.         </tr>
  127.         <tr></tr>
  128.       </table>
  129.       <table width="100%" border="0" cellspacing="0" cellpadding="0">
  130.         <tr> 
  131.           <td width="100" height="92" align="center" valign="top"> <table width="100%" border="0" cellspacing="3" cellpadding="0">
  132.             <tr>
  133.               <td align="center"><span class="style4">题目：<%=art_headline%></span></td>
  134.             </tr>
  135.             <tr>
  136.               <td align="center"><span class="style4">电话：<%=tel%></span></td>
  137.             </tr>
  138.           </table></td>
  139.           <td width="423"><span class="style4"><%=art_content %></span></td>
  140.         </tr>
  141.         <tr align="center"> 
  142.           <td colspan="2" valign="top"><img src="images/bg_4.gif" width="100%" height="1"></td>
  143.         </tr>
  144.         
  145.       </table></td>
  146.   </tr>
  148. </table>
  149. <table border="0" width="650" cellspacing="0" cellpadding="0" height="7" align="center">
  150.   <tr> 
  151.     <td width="2%" align="center"><img src="img/end1.gif" width="12" height="14"></td>
  152.     <td width="89%" align="center" background="img/end2.gif"></td>
  153.     <td width="9%" align="center"><img src="img/end3.gif" width="65" height="14"></td>
  154.   </tr>
  155.  
  156. </table>
  157. <p> 
  158.   <% 
  159.   
  160. rs.next(); 
  161.    i++; 
  162.   } 
  163.   }
  164. rs.close();
  165. stmt.close(); 
  166. conn.close();
  167. %>
  168. </p>
  169. <p>  
  171. </p>
  172. <table width="650" border="0" align="center" cellpadding="0" cellspacing="1" class="tittle0">
  173.   <tr>
  174.     <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="news_all.jsp?page=1" class="font0">首页</a>
  175.       <%if(intPage>1){%>
  176.       <a href="news_all.jsp?page=<%=intPage-1%>" class="font0">上一页</a>
  177.       <%}else{%>
  178. 上一页
  179. <%
  180.   }%>
  181.  
  182. <%if(intPage<intPageCount){%>
  183. <a href="news_all.jsp?page=<%=intPage+1%>" class="font0">下一页</a>
  184. <%}else{%>
  185. 下一页
  186. <%
  187.   }%>
  188. <a href="news_all.jsp?page=<%=intPageCount%>" class="font0">尾页</a> </td>
  189.   </tr>
  190. </table>
  191. <table width="650" border="0" align="center" cellpadding="0" cellspacing="0">
  193.   <tr>
  194.     <td align="center"><p class="style4 style8"><a href="http://jorwoo.yeah.net" target="_blank" class="rights">周亚平</a>&nbsp;&nbsp; 版权所有 <br>
  195. 程序设计：周亚平&nbsp;&nbsp; E-mail: <a href="mailto:zhouyaping1986@126.com" class="rights">zhouyaping1986@126.com</a><br>
  196. QQ:153589840</p>    </td>
  197.   </tr>
  198. </table>