📄 do_list.jsp

📁 java + sqlserver2000编写的一个网上购书系统,实现了一些基本的功能,但对于初学者来说这个系统已经足以起到帮助作用
💻 JSP
字号:
<%@ page language="java"  pageEncoding="GB2312"%>
<%@ page import="java.sql.*" %>
<jsp:useBean id="DBorder" scope="page" class="ConnBean.conn"/>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <title>My JSP 'orderlist.jsp' starting page</title>
	<script language=javascript src="../function/admin.js"></script>
    <link rel="stylesheet" type="text/css" href="../css/admin.css">
  </head>
<% 
		int PageSize=10;
  		int CurPage=1;
  		int TotalPage=0;
  		int RecCount=0;
  		if(request.getParameter("page")!=null){
  			CurPage=Integer.parseInt(request.getParameter("page"));}
  			ResultSet rs1=null;
		try{
			String strSQL="select count(*) as RecCount from userorderlist where OrderlistState='已处理' ";
			rs1=DBorder.executeQuery(strSQL);
			if(rs1.next()){
				RecCount=rs1.getInt("RecCount");
			}
			rs1=null;
			TotalPage=RecCount/PageSize+(RecCount%PageSize==0?0:1);
			strSQL="select top "+PageSize+" * from userorderlist where OrderlistState='已处理' and OrderlistNo not in " +
			"(select top "+(CurPage-1)*PageSize+" OrderlistNo from userorderlist where OrderlistState='已处理')";
			rs1=DBorder.executeQuery(strSQL);
			//rs.next();
			//out.print(rs.getString("ID"));
  		}
  		catch(Exception e){
  			out.println(e.toString());
  		}
	%>  
<BODY leftMargin=0 topMargin=0 BGCOLOR="#FFCCCC">
<TABLE class=navi cellSpacing=1 align=center border=0>
	  <TBODY>
		  <TR>
		    <TH colSpan=2>当前位置：系统管理&gt;&gt;订单管理</TH>
		  </TR>
		  <TR>
		    <TD align=right>[<A href="orderlist.jsp">所有订单</A>]&nbsp;&nbsp;[已处理订单]&nbsp;&nbsp;[<A href="undo_list.jsp">未处理订单</A>]&nbsp;&nbsp;[<A href="que_list.jsp">缺货订单</A>]&nbsp;&nbsp;[<A href="index.jsp">回首页</A>]</TD></TR>
	 </TBODY>
</TABLE>
<BR>
<FORM name=delform action= method=post>
	<TABLE class=list cellSpacing=1 align=center> 
		  <TBODY>
			  <TR>
				    <TH>订单号</TH>
				    <TH>用户实名</TH>
				    <TH>总金额</TH>
				    <TH>订单状态</TH>
				    <TH>下单日期</TH>
				    <TH>订单详情</TH>				    
				    <TH>操作</TH>
			  </TR>
    <%
   		while(rs1.next()){
   		String listid=rs1.getString("OrderlistNo");	
    %>
			  <TR align=center>
				    <TD><A href="orderlist2.jsp?ID=<%=listid%>"><%=listid %></A></TD>
				    <TD><%=rs1.getString("RealName") %></TD>
				    <TD><%=rs1.getString("TotalPrice") %></TD>
				    <TD><SPAN class=red><%=rs1.getString("OrderlistState") %></SPAN></TD>
				    <TD><%=rs1.getString("SubmitTime") %></TD>
				    <TD><A href="orderlist2.jsp?ID=<%=listid %>"><%=rs1.getString("Allinfo") %></A></TD>
				    <TD><A href="javascript:uplist(<%=listid%>);">[修&nbsp;改]</A> <A href="javascript:listdel(<%=listid %>);">[删&nbsp;除]</A> <A href="sendmess.jsp?ID=<%=listid %>">[发短信]</A> <A href="" target=_blank>[打&nbsp;印]</A> </TD>
			  </TR>
	<% }  %>
		 </TBODY>
	 </TABLE>
	 <br>
    
  <TABLE align=center style="width:700px;">
    	   
    		<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:gotoPageorder("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPageorder("+TotalPage+")'>尾页</a>");
    				}
    			}else{
    				if(CurPage==TotalPage){
    					out.println("<a href='#' onclick='javascript:gotoPageorder(1)'>首页</a> <a href='#' onclick='javascript:gotoPageorder("+(CurPage-1)+")'> 上一页</a> 下一页 尾页");
    				}else{
    					out.println("<a href='#' onclick='javascript:gotoPageorder(1)'>首页</a> <a href='#' onclick='javascript:gotoPageorder("+(CurPage-1)+")'> 上一页</a> <a href='#' onclick='javascript:gotoPageorder("+(CurPage+1)+")'>下一页</a> <a href='#' onclick='javascript:gotoPageorder("+TotalPage+")'>尾页</a>");		
    				}
    			}
    			
    		%></TD>
	    	 <td align=left style="margin-top:10px; text-align:center; font-size=14px">
	    	 <%   
	    		out.print("跳转到第");
				out.println("<select size=1 name=\"page\" onChange=\"gotoPageorder(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 + -