📄 cashledgerview.jsp~42~

📁 java 通用进销存系统。很完整的说明文档和源码以及源程序。
💻 JSP~42~
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ page import = "data.*, user.*, method.DataMethod"%>
<%
  //设置取得字符串的编码机制
  request.setCharacterEncoding("GBK");
  String userName = "";
  if(session.getAttribute("user") != null){
    User user = (User)session.getAttribute("user");
    userName = user.getUserName();
  }else{
    out.print("<h3>请先登陆系统.</h3>");
    return;
  }
  String ledgerDate = "";
  if(session.getAttribute("ledgerDate") == null){
    out.print("<h3>请先选择账套.</h3>");
    return;
  }else{
    ledgerDate = (String)session.getAttribute("ledgerDate");
  }
  //创建现金日记账数组
  String[][] cashLedgers = new String[0][6];
  //创建数据类
  StockManagementData stockManagementData = new StockManagementData();
  //创建方法类
  DataMethod dataMethod = new DataMethod();
  //根据传入参数取得现金日记账数组
  if(request.getParameter("selectedIndex") != null){
    int selectedIndex = Integer.parseInt(request.getParameter("selectedIndex"));
    String searchValue = request.getParameter("searchValue");
    String startDateStr = request.getParameter("searchValue");
    String endDateStr = request.getParameter("searchValue");
    if (selectedIndex == 0 | selectedIndex == 1) {
      if (searchValue.length() == 0) {
        out.print("<h3>请输入查询值.</h3>");
        return;
      }
      switch (selectedIndex) {
        case 0:
          //根据关联票据标识取得记录
          cashLedgers = stockManagementData.getCashLedgerByStringField(
              ledgerDate, "linkId", searchValue);
          break;
        case 1:
          //根据记帐用户取得记录
          cashLedgers = stockManagementData.getCashLedgerByStringField(
              ledgerDate, "filler", searchValue);
          break;
      }
    }else{
      java.sql.Timestamp startDate = dataMethod.transferDate(startDateStr);
      java.sql.Timestamp endDate = dataMethod.transferEndDate(endDateStr);
      if(startDate == null | endDate == null){
        out.print("<h3>日期输入错误，正确的日期格式是"
                  + "yyyy-mm-dd（年-月-日），如2004-1-1</h3>");
        return;
      }
      //根据日期取得记录
      cashLedgers = stockManagementData.getCashLedgerByFillDate(ledgerDate,
          startDate, endDate);
    }
  }
  //创建表格标题数组
  String[] colNames = {"序号", "关联票据标识", "借贷标识", "记帐用户", "发生金额", "发生日期"};
%>
<html>
<head>
<title>现金日记账查看页面：用户(<%=userName%>)</title>
</head>
<body bgcolor="#ffffff">
<center>
<h3>现金日记账查看页面:用户(<%=userName%>)</h3>
<form action="cashledgerview.jsp" method="get">
<p>
  查询条件：
  <select name="selectedIndex">
    <option value="0">根据关联票据标识查询</option>
    <option value="1">根据记帐用户查询</option>
    <option value="2">根据发生日期查询</option>
  </select>
  查询值：
  <input name="searchValue" type="text" size="18">
</p>
<p>
  开始日期：
  <input name="startDate" type="text" size="12">
  结束日期：
  <input name="endDate" type="text" size="12">
  <input name="search" type="submit" value="查询">
</p>
</form>
<hr size="3" color="#0066FF">
<!--根据现金日记账数组显示表格内容-->
<table width="100%" border="1">
  <tr align="center">
    <%for(int i = 0; i < colNames.length; i++){%>
      <td><font size="-1"><%=colNames[i]%></font></td>
    <%}%>
  </tr>
  <%for (int i = 0; i < cashLedgers.length; i++){%>
    <tr align="left">
      <%for(int j = 0; j < cashLedgers[0].length; j++){
        if(j == cashLedgers[0].length - 1){%>
          <td>
            <font size="-1">
	      <textarea name="remark" cols="10" rows="1"><%=cashLedgers[i][j]%></textarea>
	    </font>
          </td>
        <%}else{%>
            <td><font size="-1"><%=cashLedgers[i][j]%></font></td>
      <%  }
        }%>
    </tr>
  <%}%>
</table>
</center>
</body>
</html>
⌨️ 快捷键说明

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