searchtransact_jsp.java

一个简单的银行管理系统

      out.write("            活期取款        \n");
      out.write("        <font face=\"隶书\" color=\"blue\" size=2>\n");
      out.write("        <table border=\"1\" width=\"700\" cellspacing=\"0\" cellpadding=\"0\">\n");
      out.write("        <tr>\n");
      out.write("        <td>取款编号</td><td>取款时间</td><td>操作员工编号</td><td>取款人</td><td>取款金额</td>\n");
      out.write("        </tr>\n");
      out.write("    ");
        
            while(result3.next())
            {
                String fetchID = result3.getString("fetchID");
                String fetchTime = result3.getString("fetchTime");
                String staffID = result3.getString("staffID");
                String fetcher = result3.getString("fetcher");
                String fetchSum = result3.getString("fetchSum");
                out.println("<tr>");
                    out.println("<td>");
                        out.println(fetchID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(fetchTime);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(staffID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(fetcher);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(fetchSum);
                    out.println("</td>");
               out.println("</tr>");               
            }
    
      out.write("\n");
      out.write("      </table>\n");
      out.write("      ");
          
            String sql6= "Select * from fixedFetch where accountID='"+accountID+"' and fetchTime between to_date('"+lowTime+"','yyyy-MM-dd HH24:mi:ss') and to_date('"+highTime+"','yyyy-MM-dd HH24:mi:ss')";
            stat = conn.createStatement();
            ResultSet result6 = stat.executeQuery(sql6);
    
      out.write("\n");
      out.write("        <p>\n");
      out.write("        <p align=\"center\">\n");
      out.write("        <font face=\"隶书\" color=\"red\" size=2>\n");
      out.write("            定期取款        \n");
      out.write("        <font face=\"隶书\" color=\"blue\" size=2>\n");
      out.write("        <table border=\"1\" width=\"700\" cellspacing=\"0\" cellpadding=\"0\">\n");
      out.write("        <tr>\n");
      out.write("        <td>取款编号</td><td>关联存款编号</td><td>取款时间</td><td>操作员工编号</td><td>取款人</td><td>取款金额</td>\n");
      out.write("        </tr>\n");
      out.write("    ");
        
            while(result6.next())
            {
                String fetchID = result6.getString("fetchID");
                String fetchTime = result6.getString("fetchTime");
                String depositID = result6.getString("depositID");                
                String staffID = result6.getString("staffID");
                String fetcher = result6.getString("fetcher");
                String fetchSum = result6.getString("fetchSum");
                out.println("<tr>");
                    out.println("<td>");
                        out.println(fetchID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(depositID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(fetchTime);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(staffID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(fetcher);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(fetchSum);
                    out.println("</td>");
               out.println("</tr>");               
            }
    
      out.write("\n");
      out.write("      </table>\n");
      out.write("    ");
  
            String sql4= "Select * from transfer where (accountID='"+accountID+"' or aimID = '"+accountID+"') and transferTime between to_date('"+lowTime+"','yyyy-MM-dd HH24:mi:ss') and to_date('"+highTime+"','yyyy-MM-dd HH24:mi:ss')";
            stat = conn.createStatement();
            ResultSet result4 = stat.executeQuery(sql4);
    
      out.write("\n");
      out.write("        <p>\n");
      out.write("        <p align=\"center\">\n");
      out.write("        <font face=\"隶书\" color=\"red\" size=2>\n");
      out.write("            银行转帐       \n");
      out.write("        <font face=\"隶书\" color=\"blue\" size=2>\n");
      out.write("        <table border=\"1\" width=\"700\" cellspacing=\"0\" cellpadding=\"0\">\n");
      out.write("        <tr>\n");
      out.write("        <td>转帐编号</td><td>转帐时间</td><td>操作员工编号</td><td>目的帐户</td><td>转帐金额</td>\n");
      out.write("        </tr>\n");
      out.write("    ");
        
            while(result4.next())
            {
                String transferID = result4.getString("transferID");
                String transferTime = result4.getString("transferTime");
                String staffID = result4.getString("staffID");
                String aimID = result4.getString("aimID");
                String transferSum = result4.getString("transferSum");
                out.println("<tr>");
                    out.println("<td>");
                        out.println(transferID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(transferTime);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(staffID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(aimID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(transferSum);
                    out.println("</td>");
               out.println("</tr>");               
            }
    
      out.write("\n");
      out.write("      </table>\n");
      out.write("    ");
         
            String sql5= "Select * from netTransfer where (accountID='"+accountID+"' or aimID = '"+accountID+"') and transferTime between to_date('"+lowTime+"','yyyy-MM-dd HH24:mi:ss') and to_date('"+highTime+"','yyyy-MM-dd HH24:mi:ss')";
            stat = conn.createStatement();
            ResultSet result5 = stat.executeQuery(sql5);
    
      out.write("\n");
      out.write("        <p>\n");
      out.write("        <p align=\"center\">\n");
      out.write("        <font face=\"隶书\" color=\"red\" size=2>\n");
      out.write("            网上银行转帐    \n");
      out.write("        <font face=\"隶书\" color=\"blue\" size=2>\n");
      out.write("        <table border=\"1\" width=\"700\" cellspacing=\"0\" cellpadding=\"0\">\n");
      out.write("        <tr>\n");
      out.write("        <td>转帐编号</td><td>转帐时间</td><td>目的帐户</td><td>转帐金额</td>\n");
      out.write("        </tr>\n");
      out.write("    ");
        
            while(result5.next())
            {
                String transferID = result5.getString("transferID");
                String transferTime = result5.getString("transferTime");
                String aimID = result5.getString("aimID");
                String netTransferSum = result5.getString("netTransferSum");
                out.println("<tr>");
                    out.println("<td>");
                        out.println(transferID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(transferTime);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(aimID);
                    out.println("</td>");
                    out.println("<td>");
                        out.println(netTransferSum);
                    out.println("</td>");
               out.println("</tr>");               
            }
       }
       catch(Exception e)
       {
           out.println(e);
       }
    
      out.write("\n");
      out.write("    </font> \n");
      out.write("    </table>\n");
      out.write("    </body>\n");
      out.write("</html>\n");
    } catch (Throwable t) {
      if (!(t instanceof SkipPageException)){
        out = _jspx_out;
        if (out != null && out.getBufferSize() != 0)
          out.clearBuffer();
        if (_jspx_page_context != null) _jspx_page_context.handlePageException(t);
      }
    } finally {
      if (_jspxFactory != null) _jspxFactory.releasePageContext(_jspx_page_context);
    }
  }
}