📄 managermessage.jsp

📁 新闻系统 1
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312"%>
<%@page import="
java.sql.*,
javax.sql.*,
javax.naming.*,
com.aheadedu.fen.bean.*,
com.aheadedu.fen.service.*"
%>
<%!
	public String outDB(String str){
	String string=null;
	try{
	
	string=new String(str.getBytes("utf-8"),"utf-8");
		}catch(Exception e){}
		return string;
	}
%>	
<%
String username=(String)session.getAttribute("username");
if(username==null || username.equals("")){
%>
<script language="javascript">
	location='../index.jsp';
</script>
<%
}
%>	
<html>
<head>
<title>留言管理</title>
<script language="javascript" src="admin.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
.STYLE6 {color: #666666; font-weight: bold; font-size: 14px; }
-->
</style>
	<%
	
		NewsService ns=new NewsService("jdbc/news");
		Connection con=ns.getCon();
		Statement stmt=con.createStatement();
		Statement stmt1=con.createStatement();
		
		//////////////////////////////////////////
		  String sql1="SELECT count(*) FROM message";
		  ResultSet rs0 = stmt1.executeQuery(sql1);
		  rs0.next();
		  int resultCount= rs0.getInt(1);
		  int pageresult=12;
		   if(resultCount<pageresult){
		  	pageresult=resultCount;
			}
		  int pageCount=0;
		  if(resultCount==0){
		  		pageCount=0;
		  }else{
		  if ((resultCount % pageresult) ==0){
		  	 pageCount = resultCount / pageresult;
		  }else{
		  	pageCount = resultCount / pageresult +1;
		  }
		  }
		 // int page=0;
		 String pageInt= request.getParameter("pageActive");//获得访问页面的页码
		 //判断  假如 pageInt = null 我们就让pageInt =1
		 
		 if (pageInt == null || pageInt.equals("")){
		 	pageInt = "1";
		 }
		 int pageActive = 0;
		 try{
		  pageActive=Integer.parseInt(pageInt);
		  }catch(Exception ex){
		  pageActive =1;
		  }
		  
		   //判断页码
		 if (pageActive <= 0){
		 	pageActive = 1;
		 }else if(pageActive>pageCount) {
		 		pageActive=pageCount;
		 	}
		 
		 
		  int beginResult=0;
		  beginResult = (pageActive-1) * pageresult;
		/////////////////////////////////  
		  
		
		
		
		
		ResultSet rs=stmt.executeQuery("select * from message order by time desc limit "+beginResult+","+pageresult);

	%>
<style type="text/css">
<!--
.STYLE6 {color: #666666; font-weight: bold; font-size: 14px; }
body {
	margin-left: 0px;
	margin-top: 0px;
	margin-right: 0px;
	margin-bottom: 0px;
}
.STYLE9 {
	font-size: 16px;
	font-weight: bold;
}
.STYLE12 {font-size: 12px}
-->
</style>
<table width="447" height="71" border="0" align="center" cellpadding="3" cellspacing="1" bordercolor="#000000" bgcolor="#999999">
  <tr>
    <td height="37" colspan="4" bgcolor="#E9F2F7"><div align="center" class="STYLE9">留言管理</div></td>
  </tr>
  <tr>
    <td width="42%" height="37" bgcolor="#E9F2F7"><div align="center" class="STYLE6">标题</div></td>
    <td width="16%" bgcolor="#E9F2F7"><div align="center" class="STYLE6">留言人</div></td>
    <td width="22%" bgcolor="#E9F2F7"><div align="center" class="STYLE6">留言时间</div></td>
    <td width="18%" bgcolor="#E9F2F7"><div align="center" class="STYLE6">操作</div></td>
  </tr>
  <%
	String title="";
	String time="";
	String name="";
	while(rs.next()){	
	time=rs.getString("time");
	name=rs.getString("name");
	if(time!=null)
	time=time.substring(2,10);
	title=rs.getString("title")+"";
	title = outDB(title);
	if(title.length()>14){
	title=title.substring(0,14)+"...";
	}

%>
  <tr>
    <td height="19" bgcolor="#FFFFFF"><span class="STYLE12"><%=title%></span></td>
    <td bgcolor="#FFFFFF"><span class="STYLE12"><%=name%></span></td>
    <td align="center" valign="middle" bgcolor="#FFFFFF"><div align="center" class="STYLE12"><%=time%></div></td>
    <td align="center" valign="middle" bgcolor="#FFFFFF"><span class="STYLE12">[<a href="javascript:delMsg(<%=rs.getString("id")%>)">删除</a>]</span></td>
  </tr>
<%
	}
	%>
  <tr>
    <td colspan="4" bgcolor="#E9F2F7"><div align="center">
	
	  <div align="right">
	    <%
    	if (pageActive==1){
    	%>

    	<%
    }else{
    	%>
    	[<a href="managermessage.jsp?pageActive=1">第一页</a>]
    	
    	[<a href="managermessage.jsp?pageActive=<%=pageActive-1%>">上一页</a>]
    	<%
    	
    	}
    	
    	if(pageActive == pageCount ){
    	%>

    	<%
    }else{
    	
    	%>
    	
    	
    	[<a href="managermessage.jsp?pageActive=<%=pageActive+1%>">下一页</a>]
    	[<a href="managermessage.jsp?pageActive=<%=pageCount%>">尾页</a>]
    	
    	
    	<%
    	}
    	
    	%>
    	
    	总共<%=resultCount%>条纪录   共<%=pageCount%>页</div></td>
	
<td width="2%"></td>
  </tr>
</table>
  <%
	stmt.close();
	con.close();
%>
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -