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

源码开发语言/平台
当前位置：首页 > 源码/资料 > 数据库系统 > 其他数据库 > 查看源码
adminlyb.jsp
资源名称：08155209833.rar　[点击查看]
上传用户：mkymky1985
上传日期：2014-06-23
资源大小：754k
文件大小：8k
源码类别：

其他数据库

开发平台：

Java

adminlyb.jsp：源码内容
  1. <%@ page language = "java" contentType = "text/html;charset=gb2312"%>
  2. <%@ page import = "java.sql.*" %>
  3. <jsp:useBean id = "sts" scope = "page" class = "wsxk.ConDB" />
  4. <%
  5. int  intPage;
  6. int currentPage = 1;
  7. int PageNumbers = 5;
  8. if(request.getParameter("page")!= null && request.getParameter("page")!="")
  9. {intPage = Integer.parseInt(request.getParameter("page"));
  10. currentPage=intPage;}
  11. else
  12. intPage = 1;
  13. int totalRecord = 0;
  14. ResultSet counters = sts.executeQuery("select count(*) as mesid from message");
  15. if(counters.next())
  16. {
  17. totalRecord = Integer.parseInt(counters.getString("mesid"));
  18. }
  19. %>
  22. <html>
  23. <head>
  24. <meta http-equiv="Content-Type" content="text/html; charset=gb2312">
  25. <link href="_notes/aaa.css" rel="stylesheet" type="text/css">
  26. <style type="text/css">
  27. <!--
  28. @import url("_notes/ccc");
  29. .style1 {color: #FFFFFF}
  30. body,td,th {
  31. color: #FFFFFF;
  32. font-weight: bold;
  33. font-size: 12px;
  34. }
  35. a:link {
  36. color: #FFFFFF;
  37. }
  38. a:visited {
  39. color: #FFFFFF;
  40. }
  41. -->
  42. </style>
  43. </HEAD>
  44. <BODY BGCOLOR=#0D85A6 BACKGROUND="images/bg.gif" >
  46. <br>
  47. <br>
  48. <TABLE WIDTH=750 height="494" BORDER=0 align="center" CELLPADDING=0 CELLSPACING=0>
  49.   <TR>
  50.     <TD> <IMG SRC="images/spacer.gif" WIDTH=231 HEIGHT=1></TD>
  51.     <TD> <IMG SRC="images/spacer.gif" WIDTH=4 HEIGHT=1></TD>
  52.     <TD> <IMG SRC="images/spacer.gif" WIDTH=75 HEIGHT=1></TD>
  53.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  54.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  55.     <TD> <IMG SRC="images/spacer.gif" WIDTH=110 HEIGHT=1></TD>
  56.     <TD> <IMG SRC="images/spacer.gif" WIDTH=105 HEIGHT=1></TD>
  57.     <TD> <IMG SRC="images/spacer.gif" WIDTH=5 HEIGHT=1></TD>
  58.   </TR>
  59.   <TR>
  60.     <TD COLSPAN=4> <IMG SRC="images/temp_01.jpg" WIDTH=420 HEIGHT=15></TD>
  61.     <TD COLSPAN=4> <IMG SRC="images/temp_02.jpg" WIDTH=330 HEIGHT=15></TD>
  62.   </TR>
  63.   <TR>
  64.     <TD COLSPAN=8> <IMG SRC="images/temp_03.jpg" WIDTH=750 HEIGHT=5></TD>
  65.   </TR>
  66.   <TR>
  67.     <TD>
  68.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="226" background="images/left_top.jpg">
  69.         <tr>
  70.           <td width="231" valign="bottom">
  71.             <div align="center">
  72.               <p><br>
  73.               <font color="#2DFFFF" size="5"><strong> </strong></font></p>
  74.               <table width="200" border="1">
  75.                 <tr>
  76.                   <td><div align="center"><strong><a href="adminstudent.jsp">【学生管理】</a></strong></div></td>
  77.                 </tr>
  78.                 <tr>
  79.                   <td><div align="center"><a href="adminteacher.jsp">【教师<strong>管理</strong>】</a></div></td>
  80.                 </tr>
  81.                 <tr>
  82.                   <td><div align="center"><a href="admincourse.jsp">【课程<strong>管理</strong>】</a></div></td>
  83.                 </tr>
  84.               </table>
  85.               <p>  <strong><font color="#2DFFFF" size="5"> </font></strong></p>
  86.             </div>
  87.           </td>
  88.         </tr>
  89.       </table>
  90.     </TD>
  91.     <TD ROWSPAN=2> <IMG SRC="images/temp_05.jpg" WIDTH=4 HEIGHT=455></TD>
  92.     <TD COLSPAN=5 ROWSPAN=2>
  93.       <table width="510" border="0" cellspacing="0" cellpadding="0" height="455" background="images/main_bg.jpg">
  94.         <tr>
  95.           <td width="510">
  96.             <table width="510" border="0" cellspacing="0" cellpadding="0" height="455">
  97.               <tr>
  98.                 <td width="510" height="78">
  99.                   <div align="center"><img src="images/blank_banner.gif" width="468" height="60"></div>
  100.                 </td>
  101.               </tr>
  102.               <tr>
  103.                 <td valign="top">                  <div align="left">
  104.                   <table width="483" height="217" border="0">
  105.                     <tr>
  106.                       <td height="14"><a href="index1.htm">首页</a>&gt;<a href="index3.jsp">后台管理</a>&gt;查看留言</td>
  107.                     </tr>
  108.                     <tr>
  109.                       <td height="16"><span class="style1">分页： 留言总数：<%=totalRecord%> <a href="adminlyb.jsp?page=1">[首页]</a>
  110.                           <%
  111. if(intPage>1 && intPage<((totalRecord+PageNumbers)/PageNumbers))
  112. {
  113. out.print("<a href='adminlyb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
  114. out.print("<a href='adminlyb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
  115. out.print("<a href='adminlyb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
  116. }
  117. if(intPage ==((totalRecord+PageNumbers)/PageNumbers))
  118. out.print("<a href='adminlyb.jsp?page=" + (intPage-1) + "'>[前页]&nbsp;&nbsp;</a>");
  119. if(intPage == 1)
  120. {
  121. out.print("<a href='adminlyb.jsp?page=" + (intPage+1) +"'>[后页]&nbsp;&nbsp;</a>");
  122. out.print("<a href='adminlyb.jsp?page=" + ((totalRecord+PageNumbers)/PageNumbers) + "'>[尾页]</a>");
  123. }
  124. %>
  127.                           页次：<%=currentPage%>/<%=(totalRecord+PageNumbers)/PageNumbers%> <%=PageNumbers%>篇/页</span></td>
  128.                     </tr>
  130.                     <tr>
  131.                       <td></td>
  132.                     </tr>
  133.                     <tr>
  134.                       <td>
  136. <%String strSQL = "select mesid ,stuname ,mescontent from message order by mesid desc  ";
  137. ResultSet rs = sts.executeQuery(strSQL);
  138. int i=0;
  139. int tmpid;
  140. while(rs.next())
  141. {
  143. if(i >= (intPage-1)*PageNumbers && i < intPage*PageNumbers)
  144. {
  145. String stuname = rs.getString("stuname");
  146. String mescontent = rs.getString("mescontent");
  147. tmpid =rs.getInt("mesid");
  148. out.print(stuname);%>同学:
  149. <br><%//out.print(mescontent);
  150. int tmp =0;
  151. for ( int j=0 ; j < mescontent.length();j++)
  152. {
  153. if (mescontent.charAt(j)=='n'||j==mescontent.length()-1)
  154. {out.print("&nbsp;&nbsp;");
  155.           out.print(mescontent.substring(tmp,j+1));
  156.           out.print("<br>");
  158.  tmp = j+1;
  160. }}
  162. %><%out.print("&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a href='adminlyb2.jsp?delpage=" +tmpid + "'>删除</a>");%><br><br><%
  163. //out.print("<TD>□ <a href="wz.jsp?id="+id+"">" + title + "    (" + time + ")" + "</a></td><td></td></tr>");
  164. }
  165. i++;
  166. }
  167. %>
  168. <br></td>
  169.                     </tr>
  170.                   </table>
  171.                 </div></td>
  172.               </tr>
  173.             </table>
  174.           </td>
  175.         </tr>
  176.       </table>
  177.     </TD>
  178.     <TD ROWSPAN=2> <IMG SRC="images/temp_07.jpg" WIDTH=5 HEIGHT=455></TD>
  179.   </TR>
  180.   <TR>
  181.     <TD>
  182.       <table width="231" border="0" cellspacing="0" cellpadding="0" height="229" background="images/left_bottom.jpg">
  183.         <tr>
  184.           <td width="231" height="222" valign="top"><div align="center">
  185.             <p><font color="#2DFFFF" size="5"> </font></p>
  186.               <table width="200" border="1">
  187.                 <tr>
  188.                   <td><div align="center"><a href="admincourse.jsp">【课程分配】</a></div></td>
  189.                 </tr>
  190.                 <tr>
  191.                   <td><div align="center"><a href="adminscore.jsp">【成绩录入】</a></div></td>
  192.                 </tr>
  193.                
  194.               </table>
  195.               <br>
  196.               <br>
  197.               <table width="200" border="0">
  198.                 <tr>
  199.                   <td><div align="center">查看留言</div></td>
  200.                 </tr>
  201.               </table>
  202.               <p align="center"><br>
  203.               <a href="index1.htm" class="ccc">[退出系统]</a></p>
  204.               </div>
  205.           </td>
  206.         </tr>
  207.       </table>
  208.     </TD>
  209.   </TR>
  210.   <TR>
  211.     <TD COLSPAN=8> <IMG SRC="images/temp_09.jpg" WIDTH=750 HEIGHT=5></TD>
  212.   </TR>
  213.   <TR>
  214.     <TD COLSPAN=8> <img src="images/temp_10.jpg" width=752 height=20></TD>
  215.   </TR>
  216. </TABLE>
  217. </BODY>
  218. </HTML>