📄 unrepeat.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用
💻 JSP
字号:
<%@ page language="java" pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<%@ 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>当前位置:系统管理&gt;&gt;留言管理&gt;&gt;已回复的留言</TH></TR>
		  <TR>
		    <TD align=right>[<A href="leaveword.jsp">所有留言</A>]&nbsp;&nbsp;[<A href="repeatonly.jsp">已回复的留言</A>]&nbsp;&nbsp;[未回复的留言]&nbsp;&nbsp;[<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 where (Repeater is null)";
			rss=DB2.executeQuery(strSQL);
			if(rss.next()){
				RecCount=rss.getInt("RecCount");
				//String repname=rss.getString("Repeater");
			}
			rss=null;
			TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
			//strSQL="select top "+PageSize+" * from leaveword where Repeater is null";
			strSQL="select top "+PageSize+" * from leaveword where (Repeater is null) and ID not in " 
			+"(select top "+(CurPage-1)*PageSize+" ID from leaveword where Repeater is null)";
			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>
			</TR>
	<%
      while(rss.next()){
 //if(rss.getString("Repeater").length()==0){
      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>
			</TR><% }//} %>
			
	</TBODY>
   </TABLE><br>
   <TABLE align=center style="width:700px;">
    	    <tr><td>&nbsp;&nbsp;</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:gotoPagenorep("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagenorep("+TotalPage+")'>尾页</a>");
    				}
    			}else{
    				if(CurPage==TotalPage){
    					out.println("<a href='#' onclick='javascript:gotoPagenorep(1)'>首页</a> <a href='#' onclick='javascript:gotoPagenorep("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
    				}else{
    					out.println("<a href='#' onclick='javascript:gotoPagenorep(1)'>首页</a> <a href='#' onclick='javascript:gotoPagenorep("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPagenorep("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPagenorep("+TotalPage+")'>尾页</a>");		
    				}
    			}
    			
    		%></TD>
	    	 <td style="margin-top:10px; text-align:left; font-size=14px">
	    	 <%   
	    		out.print("跳转到第");
				out.println("<select size=1 name=\"page\" onChange=\"gotoPagenorep(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>
    		</TR>
    	</TABLE>
</FORM>
</BODY>
</HTML>
⌨️ 快捷键说明

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