📄 displayallschedule.jsp

📁 运输模块代码
💻 JSP
字号:
<%--
  Created by IntelliJ IDEA.
  User: Ligang Wu
  Date: 2006-5-30
  Time: 22:00:22
  To change this template use File | Settings | File Templates.
--%>
<%@page contentType="text/html;charset=GBK"%>
<%@ include file="/IncludeBegin.jsp"%>
<%
    //所用的全局变量
    String schedule = "";
    String ddue = "";
    float cuBookx = 0.0f;
    float cuShipx = 0.0f;
    float cudevlbs = 0.0f;
    float brBookx = 0.0f;
    float brShipx = 0.0f;
    float brdevlbs = 0.0f;
    float totlbs = 0.0f;

    //schedule表的字段
    float etpBook = 0.0f;
    float c420Book = 0.0f;
    float c300Book = 0.0f;
    float c200Book = 0.0f;
    float etpShip = 0.0f;
    float c420Ship = 0.0f;
    float c300Ship = 0.0f;
    float c200Ship = 0.0f;
    float regBook = 0.0f;
    float wtbBook = 0.0f;
    float regShip = 0.0f;
    float wtbShip = 0.0f;
%>
<body class="pagebackground" >
   <%
        String  Week = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("WEEK");
        String  Due = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("DUE");
        String  BrBook = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BRBOOK");
        String  BrShip = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BRSHIP");
        String  BrLBS = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("BRLBS");
        String  CuBook = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("CUBOOK");
        String  CuShip = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("CUSHIP");
        String  CuLBS = (String) Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("CULBS");
        String  Total = (String)Configure.getConfigure(sIe_Language, "ShippingManager_shippingcapacity").get("TOTAL");
       try
       {
       //存储检索schedule表的结果
        ASResultSet scheduleRs;
       String sql = " select * from schedule  order by week_date";
       scheduleRs = Sqlca.getASResultSet(sql);
       if(scheduleRs.getRowCount() > 0)
       {
   %>
   <table border="1" cellpadding="1" cellspacing="1" >
      <tr >
	        <td ><%=Week%></td>
			<td><%=Due%></td>
			<td><%=CuBook%></td>
			<td><%=CuShip%></td>
			<td><%=CuLBS%></td>
			<td><%=BrBook%></td>
			<td><%=BrShip%></td>
			<td><%=BrLBS%></td>
			<td><%=Total%>></td>
	  </tr>

      <%
          while(scheduleRs.next())
          {
              //从数据库里取数据
              schedule = scheduleRs.getString("schedule");
              ddue = scheduleRs.getString("week_date");
              etpBook = scheduleRs.getFloat("etpbook");
              c420Book = scheduleRs.getFloat("c420book");
              c300Book = scheduleRs.getFloat("c300book");
              c200Book = scheduleRs.getFloat("c200book");
              etpShip = scheduleRs.getFloat("etpship");
              c420Ship = scheduleRs.getFloat("c420ship");
              c300Ship = scheduleRs.getFloat("c300ship");
              c200Ship = scheduleRs.getFloat("c200ship");
              regBook = scheduleRs.getFloat("regbook");
              wtbBook = scheduleRs.getFloat("wtbbook");
              regShip = scheduleRs.getFloat("regship");
              wtbShip = scheduleRs.getFloat("wtbship");

              //页面显示数据
              cuBookx = etpBook + c420Book + c300Book + c200Book ;
              cuShipx = etpShip + c420Ship + c300Ship + c200Ship;
              cudevlbs = cuShipx - cuBookx;
              brBookx = regBook + wtbBook;
              brShipx = regShip + wtbShip;
              brdevlbs = brShipx - brBookx;
              totlbs = etpShip + c420Ship + c300Ship + regShip + c200Ship + wtbShip;

      %>
      <tr>
	         <td><%=schedule%></td>
			 <td><%=ddue%></td>
			 <td><%=cuBookx%></td>
			 <td><%=cuShipx%></td>
			 <td><%=cudevlbs%></td>
			 <td><%=brBookx%></td>
			 <td><%=brShipx%></td>
			 <td><%=brdevlbs%></td>
			 <td><%=totlbs%></td>
      </tr>
      <%
           }//while(scheduleRs.next())
      %>

	</table>
<%
       }//if(scheduleRs.getRowCount() > 0)
    }//try
    catch (Exception e) {
           e.printStackTrace();
   }
%>
</body>
<%@ include file="/IncludeEnd.jsp" %>
⌨️ 快捷键说明

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