📄 leaveword.jsp
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ page import="java.util.*"%>
<%@ page import="java.text.*"%>
<jsp:useBean id="DB2" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<HTML>
<head>
<script language=javascript src="../function/admin.js"></script>
<link rel="stylesheet" type="text/css" href="../css/admin.css">
</head>
<BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<br>
<TABLE class=navi cellSpacing=1 align=center border=0>
<TBODY>
<TR>
<TH colSpan=2>当前位置:系统管理>>留言管理>>所有留言</TH></TR>
<TR>
<TD align=right>[所有留言] [<A href="repeatonly.jsp">已回复的留言</A>] [<A href="unrepeat.jsp">未回复的留言</A>] [<A href="index.jsp">回首页</A>]</TD></TR>
</TBODY>
</TABLE>
<%
int PageSize=10;
int CurPage=1;
int TotalPage=0;
int RecCount=0;
if(request.getParameter("page")!=null){
CurPage=Integer.parseInt(request.getParameter("page"));}
ResultSet rss=null;
try{
String strSQL="select count(*) as RecCount from leaveword";
rss=DB2.executeQuery(strSQL);
if(rss.next()){
RecCount=rss.getInt("RecCount");
}
rss=null;
TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
strSQL="select top "+PageSize+" * from leaveword where ID not in " +
"(select top "+(CurPage-1)*PageSize+" ID from leaveword)";
rss=DB2.executeQuery(strSQL);
//rs.next();
//out.print(rs.getString("ID"));
}
catch(Exception e){
out.println(e.toString());
}
%>
<FORM name=checkform action=leaveword_del.jsp method=post>
<TABLE class=list cellSpacing=1 align=center border=0>
<TBODY>
<TR>
<TH width="4%">ID</TH>
<TH width="7%">留言者ID</TH>
<TH width="8%">留言者姓名</TH>
<TH width="10%">留言时间</TH>
<TH width="15%">留言内容</TH>
<TH width="13%">留言标题</TH>
<TH width="7%">回复人</TH>
<TH width="15%">回复内容</TH>
<TH width="10%">回复时间</TH>
<TH width="6%">回复</TH>
<TH width="6%">操作</TH>
</TR>
<%
while(rss.next()){
Integer id1=rss.getInt("ID");
Integer id2=rss.getInt("UserID");
String name=rss.getString("LeaverName");
java.util.Date sendtime=rss.getDate("LeaverTime");
SimpleDateFormat formatter = new SimpleDateFormat("yyyy-MM-dd");
String dateString = formatter.format(sendtime);
%>
<TR align=center>
<TD><%=id1 %></TD>
<TD><%=id2%></TD>
<TD><%=name%></TD>
<TD><%=dateString%></TD>
<TD><TEXTAREA name=bookcon cols=13><%=rss.getString("Context")%></TEXTAREA></TD>
<TD><%=rss.getString("LeaverTitle") %></TD>
<TD><%=rss.getString("Repeater") %></TD>
<TD><TEXTAREA name=bookcon cols=13><%=rss.getString("RepeatCon")%></TEXTAREA></TD>
<TD><%=rss.getString("RepeatTime") %></TD>
<td><A href="repeat.jsp?ID=<%=id1 %>">回复</A></td>
<td><input type=checkbox name="check<%=id1%>" value=<%=id1%>></td>
</TR><% } %>
</TBODY>
</TABLE><br>
<TABLE align=center style="width:700px;">
<tr><td> </td></tr>
<TR>
<TD style="margin-top:30px; text-align:center; font-size:14px; ">
<%
if(CurPage==1){
if(CurPage==TotalPage){
out.println("首页 上一页 下一页 尾页");
}else{
out.println("首页 上一页 <a href='#' onclick='javascript:gotoPageleave("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPageleave("+TotalPage+")'>尾页</a>");
}
}else{
if(CurPage==TotalPage){
out.println("<a href='#' onclick='javascript:gotoPageleave(1)'>首页</a> <a href='#' onclick='javascript:gotoPageleave("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
}else{
out.println("<a href='#' onclick='javascript:gotoPageleave(1)'>首页</a> <a href='#' onclick='javascript:gotoPageleave("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPageleave("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPageleave("+TotalPage+")'>尾页</a>");
}
}
%></TD>
<td style="margin-top:10px; text-align:center; font-size=14px">
<%
out.print("跳转到第");
out.println("<select size=1 name=\"page\" onChange=\"gotoPageleave(this.value)\">");
for(int i=1;i<=TotalPage;i++)
{
String selectAdd=(i==CurPage)?" selected":"";
out.println("<option value='"+i+"' "+selectAdd+"> "+i+" </option>");
}
out.println("</select>");
out.print("页");
%></td>
<td> </td>
<td style="margin-top:10px text-align:center "> <input type="button" name="Submit" value="全选" onclick="check()" /> <input type="button" name="Submit" value="反选" onclick="checkfan()" /> </td>
<td >
<input type="button" name="delete" value="删除选中项" style="margin-top:0px" onClick="return leavedele();">
</td>
</TR>
</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -