📄 adminly.jsp
字号:
<%@ page contentType="text/html; charset=gb2312" language="java" import="java.sql.*,java.lang.Math.*"%>
<%@ include file="inc/config.jsp"%>
<%@ include file="inc/style.jsp"%>
<%@ include file="session.jsp"%>
<%
/*******************************************************************
* *
* 梦想年华 JSP 版留言本 *
* *
* 版权所有: wsp.hniuca.net *
* ` CopyRight 2005-2006 DreamTime All Rights Reserved *
* *
* 程序制作: [梦想年华] *
* Email:fanwsp@126.com *
* QQ:122142023 *
* HomePage:http://wsp.hniuca.net *
* *
* 郑重申明：该程序仅提个人用户免费使用,未经本人同意， *
* 严禁用于商业用途！ *
* *
*********************************************************************/
%>
<html>
<head>
<title><%=LybTitle%></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<SCRIPT src="inc/ubbcode.js"></SCRIPT>
<SCRIPT src="inc/post.js"></SCRIPT>
</head>
<body>
<%=TopInfo(true)%>
<a name="ly"></a>
<table border="0" align="center" width="778">
<tr>
<td valign="top"><table width="100%" height="23%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="176" align="left" valign="top">
<table width="640" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="69" valign="top">
<%
try{
request.setCharacterEncoding("gb2312"); //设置编码方式为gb2312
sql="select * from guestbook order by ID DESC";
rs = stmt.executeQuery(sql);
}catch(SQLException e){
//out.println(e.getMessage());
session.setAttribute("error",error2);
session.setAttribute("url",sPage);
response.sendRedirect("error.jsp");
return;
}
//如果表中没有任何记录，刚给出提示信息
if (!rs.next()){
out.println("<table width=\"100%\" border=\"1\" align=\"center\"><tr height=\"25\"><td background=\"images/bg.gif\">");
out.println("<div align=\"center\" class=\"info\">暂时还没有任何留言！</div></td></tr></table>");
return;
}
//取得待显示页码，做为当前页码
strPage = request.getParameter("intPage");
try {
if(strPage == null || strPage.equals("")) intPage = 1;
else intPage = Integer.parseInt(request.getParameter("intPage")); //将字符串转换成整型
}catch(java.lang.NumberFormatException e){
intPage = 1;
}
//获取记录总数
rs.last();
intRowCount = rs.getRow();
//记算总页数
if(intRowCount % intPageSize == 0) intPageCount = intRowCount/intPageSize;
else intPageCount = (int)Math.floor(intRowCount/intPageSize)+1;
if(intPageCount == 0) intPageCount = 1;
if(intPage < 1) intPage = 1;
if(intPage > intPageCount) intPage = intPageCount;
//将记录指针定位到待显示页的第一条记录上
rs.absolute((intPage-1) * intPageSize+1);
NO = intRowCount - (intPage-1)*intPageSize;
i = 0;
while(i < intPageSize && !rs.isAfterLast()){
//读留言信息
int ID=rs.getInt("ID");
String Name=rs.getString("Name");
String QQ=rs.getString("QQ");
String Mail=rs.getString("Mail");
String ComeFrom=rs.getString("ComeFrom");
String Time=rs.getString("UpdateTime");
String Title=rs.getString("Title");
String Sex=rs.getString("Sex");
String Face=rs.getString("Face");
String Content=rs.getString("Content");
String ReContent=rs.getString("ReContent");
String ReTime=rs.getString("ReTime");
String IP=rs.getString("IP");
String EditTime=rs.getString("EditTime");
boolean Secret=StringToBoolean(rs.getString("Secret"));
boolean Validate=StringToBoolean(rs.getString("Validate"));
%>
<br>
<table width="100%" border="1" align="center" cellpadding="4" cellspacing="1">
<tr class="chinese" height="25">
<td height="25" background="images/bg<%=LybSkin%>.gif"><div align="left" class="info"> <%=NO%>
<%if(isValidate)
{
if(Validate) out.println(" 已 审 核");
else out.println(" 未 审 核 [<a href=\"validate.jsp?id="+ID+"\">通过审核</a>]");
}
%>
</div></td>
<td width="4%" height="25" colspan="-2" background="images/bg<%=LybSkin%>.gif"><div align="right"><a href="#top" title="回到顶部"><img src="images/top.gif" width="15" height="15" border="0"></a></div></td>
</tr>
<tr class="chinese" height="25">
<td height="25" colspan="2"> 留言者： <%=Name%> 来自：<%=ComeFrom%> IP：<%=IP%>
[<a href="lockip.jsp?ip=<%=IP%>&do=lock">封IP</a>] [<a href="lockip.jsp?ip=<%=IP%>&do=unlock">解IP</a>]</td>
</tr>
<tr class="chinese" height="25">
<td height="80" colspan="2" valign="middle"><div align="center"></div>
<% if(EditTime!= null && !EditTime.equals(""))
{
String EditContent = Content + "<br><br><div class=\"info\"> ";
EditContent += EditInfo + " 编辑时间：" + EditTime + "</div>";
out.println(EditContent);
}
else
{
out.println(Content);
}
%></td>
</tr>
<tr class="chinese">
<td height="40" colspan="2" valign="middle">
<% if (ReContent == null || ReContent.equals("")) out.println(NoReplyInfo);
else
{
String Reply = ReplyInfo + "：<br><br>" + ReContent + "<br><br><div class=\"info\">";
Reply += " " + ReplyInfo1 + ReTime + "</div>";
out.println(Reply);
}
%></td>
</tr>
<tr valign="bottom" height="27">
<td background="images/bg<%=LybSkin%>.gif" height="25" colspan="2">
<div align="left"><span class="info"> 发 表 于： <%=Time%>
<%
out.print("[<a href=\"javascript:go('delly.jsp?id="+ID+"','您确定要删除?')\">删除</a>]");
out.print(" [<a href=\"editly.jsp?id="+ID+"\">编辑</a>] [<a href=\"replyly.jsp?id="+ID+"\">回复</a>]");
%>
</span></div>
</td>
</tr>
</table>
<%
rs.next();
i++;
NO--;
//读取留言信息结束
}
out.println("<br><div class=\"info\"> ");
if(isValidate) out.println("[<a href=\"validate.jsp?id=all\">审核通过全部留言</a>] ");
out.println("[<a href=\"javascript:go('delly.jsp?id=all','该操作将删除所有留言，请谨慎操作？')\">删除所有留言</a>] ");
out.println("[<a href=\"lockiplist.jsp\" target=\"_blank\">被封IP地址列表</a>]");
out.println("</div>");
out.println(Page(sPage));
%>
</td>
</tr>
</table></td>
</tr>
</table>
</table>
<% out.println(BottomInfo());
rs.close();
stmt.close();
DBConn.close();
%>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -