📄 orders_no.jsp

📁 此小软件实现了小型超市的进销存系统,它展示了小型超市的进货和销售,还有库存的各种技术!
💻 JSP
字号:
<%@ page contentType="text/html; charset=gb2312" errorPage="" %>
<jsp:useBean id="DBConn" scope="page" class="jspeshop.DBConn"/>
<jsp:useBean id="PageCt" scope="page" class="jspeshop.PageCt"/>

<%@ page import="java.sql.*" %>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../style.css">
<title>未发货记录</title>
<style type="text/css">
<!--
.style2 {color: #FFFFFF}
-->
</style>
</head>

<body>

<p>&nbsp;</p>
<p>&nbsp;</p>
<%
String orderid="";
String sql="";
String realname="";
String phone="";
String ordate="";
String status="";
int count=0;
if(session.getAttribute("name")==null){
  System.out.println("没有登录");
response.sendRedirect("index.jsp");
}else{

  Connection con =DBConn.GetConn();
  Statement st = con.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_READ_ONLY);
  sql="select count(*) from Order_s where STATUS ='尚未处理'";
  ResultSet rs=st.executeQuery(sql);

  System.out.println("查询完毕");
  long data_num=0;
  if (rs.next())
  {
  data_num=rs.getLong(1);
  }
   System.out.println("个数"+data_num);
  long Current_Page=1;
  String currentpage=(String)request.getParameter("currentpage");
  if(currentpage!=null&&!currentpage.equals("")){
    Current_Page=Integer.parseInt(request.getParameter("currentpage"));

  }
  String Query_Page=(String)request.getParameter("Query_Page");

  if(Query_Page!=null&&Query_Page.equals("")){
    Current_Page=Integer.parseInt(request.getParameter("Query_Page"))-1;

  }
  PageCt.Init(Current_Page,data_num);
  long start=PageCt.getStart();
 
  long end=PageCt.getEnd();
  
  //查询记录
  
  sql="select * from Order_s where STATUS ='尚未处理' order by DATE desc";
  ResultSet rs2=st.executeQuery(sql);
   System.out.println("商品查询完毕11111111");
  long i=0;
  while (i<start&&rs2.next()){
     System.out.println("跳过");
    System.out.println(i);
    i++;
  }
  %>
<table width="654" height="56" border="0" cellspacing="1" bgcolor="#000000">
  <tr bgcolor="#336699">
    <td width="109" height="28"><div align="center" class="style2">订单号</div></td>
    <td width="74"><div align="center" class="style2">姓名</div></td>
    <td width="74"><div align="center" class="style2">电话</div></td>
    <td width="121"><div align="center" class="style2">订单日期</div></td>
    <td width="90"><div align="center" class="style2">状态</div></td>
    <td colspan="2"><div align="center" class="style2">操作</div></td>
  </tr>
  <%
    while (rs2.next()&&(i<end))
    {
   
      orderid=rs2.getString("ORDER_ID");
      realname=rs2.getString("REALNAME");
      phone=rs2.getString("PHONE");
      ordate=rs2.getString ("DATE");
      status=rs2.getString("STATUS");

      %>
  <tr bgcolor="eeeeee">
    <td height="22"><%=orderid%></td>
    <td><%=realname%></td>
    <td><%=phone%></td>
    <td><%=ordate%></td>
    <td><%=status%></td>
    <td width="80"><a href="ordersone.jsp?orderid=<%=orderid%>">查看</a></td>
    <td width="84"><a href="orders_edit.jsp?orderid=<%=orderid%>">改为已发货</a></td>
  </tr>
  <%
        i++;
        }

        %>
       
</table>
<form method="GET" action="orders_no.jsp">
<table width="396" height="27" border="0">
   <tr>
  <td width="71" height="23" align="center" valign="bottom">共<%=PageCt.getTotalnum() %>条</td>
  <td width="92" align="center" valign="bottom"><%=PageCt.getCurpage() %>/<%=PageCt.getTotalpage() %>页</td>
   <td width="86" align="center" valign="bottom"><a href=orders_no.jsp?currentpage=<%=PageCt.getPrepage() %>>上页</a></td>
   <td width="129" align="center" valign="bottom"><a href=orders_no.jsp?currentpage=<%=PageCt.getNextpage() %>>下页</a></td>

</tr>
 
</table>
</form>
<p>&nbsp;</p>
<p>&nbsp;</p>
</body>
</html>
<%
} %>
⌨️ 快捷键说明

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