?? searchtransact.jsp
字號:
<%@page contentType="text/html"%><%@page pageEncoding="UTF-8"%><%@page import="java.sql.*"%><%--The taglib directive below imports the JSTL library. If you uncomment it,you must also add the JSTL library to the project. The Add Library... actionon Libraries node in Projects view can be used to add the JSTL 1.1 library.--%><%--<%@taglib uri="http://java.sun.com/jsp/jstl/core" prefix="c"%> --%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"><html> <head> <meta http-equiv="Content-Type" content="text/html; charset=UTF-8"> <title>交易查詢</title> </head> <body background="D:/YJ/YJ1.23/NetBank/background/45.jpg"> <% String time = request.getParameter("timeComboBox"); String lowTime = time.substring(0,8); String highTime = time.substring(10,time.length()); String loginID = (String)session.getAttribute("userName"); String accountID = ""; lowTime = lowTime + " 00:00:00"; highTime = highTime + " 00:00:00"; String dbUrl = "jdbc:odbc:afei"; String user = "scott"; String password = "tiger"; try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); Connection conn = DriverManager.getConnection(dbUrl,user,password); String sql = "Select accountID from netMember where loginID='"+loginID+"'"; Statement stat = conn.createStatement(); ResultSet result = stat.executeQuery(sql); if(result.next()) { accountID = result.getString("accountID"); } String sql1= "Select * from currentDeposit where accountID='"+accountID+"' and depositTime between to_date('"+lowTime+"','yyyy-MM-dd HH24:mi:ss') and to_date('"+highTime+"','yyyy-MM-dd HH24:mi:ss')"; stat = conn.createStatement(); ResultSet result1 = stat.executeQuery(sql1); %> <font face="隸書" color="red" size=2> <p align = "center"> 活期存款 <font face="隸書" color="blue" size=2> <table border="1" width="700" cellspacing="0" cellpadding="0"> <tr> <td>存款編號</td><td>存款時間</td><td>操作員工編號</td><td>存款人</td><td>存款金額</td> </tr> <% while(result1.next()) { String depositID = result1.getString("depositID"); String depositTime = result1.getString("depositTime"); String staffID = result1.getString("staffID"); String depositer = result1.getString("depositer"); String currentSum = result1.getString("currentSum"); out.println("<tr>"); out.println("<td>"); out.println(depositID); out.println("</td>"); out.println("<td>"); out.println(depositTime); out.println("</td>"); out.println("<td>"); out.println(staffID); out.println("</td>"); out.println("<td>"); out.println(depositer); out.println("</td>"); out.println("<td>"); out.println(currentSum); out.println("</td>"); out.println("</tr>"); } %> </table> <% String sql2= "Select * from fixedDeposit where accountID='"+accountID+"' and depositTime between to_date('"+lowTime+"','yyyy-MM-dd HH24:mi:ss') and to_date('"+highTime+"','yyyy-MM-dd HH24:mi:ss')"; stat = conn.createStatement(); ResultSet result2 = stat.executeQuery(sql2); %> <p> <p align = "center"> <font face="隸書" color="red" size=2> 定期存款 <font face="隸書" color="blue" size=2> <table border="1" width="700" cellspacing="0" cellpadding="0"> <tr> <td>存款編號</td><td>存款時間</td><td>操作員工編號</td><td>存款人</td><td>存款金額</td><td>是否轉存</td><td>存款年限</td><td>存款利率</td> </tr> <% while(result2.next()) { String depositID = result2.getString("depositID"); String depositTime = result2.getString("depositTime"); String staffID = result2.getString("staffID"); String depositer = result2.getString("depositer"); String fixedSum = result2.getString("fixedSum"); String auto = result2.getString("auto"); String limit = result2.getString("limit"); String rate = result2.getString("rate"); out.println("<tr>"); out.println("<td>"); out.println(depositID); out.println("</td>"); out.println("<td>"); out.println(depositTime); out.println("</td>"); out.println("<td>"); out.println(staffID); out.println("</td>"); out.println("<td>"); out.println(depositer); out.println("</td>"); out.println("<td>"); out.println(fixedSum); out.println("</td>"); out.println("<td>"); out.println(auto); out.println("</td>"); out.println("<td>"); out.println(limit); out.println("</td>"); out.println("<td>"); out.println(rate); out.println("</td>"); out.println("</tr>"); } %> </table> <% String sql3= "Select * from currentFetch 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 result3 = stat.executeQuery(sql3); %> <p> <p align="center"> <font face="隸書" color="red" size=2> 活期取款 <font face="隸書" color="blue" size=2> <table border="1" width="700" cellspacing="0" cellpadding="0"> <tr> <td>取款編號</td><td>取款時間</td><td>操作員工編號</td><td>取款人</td><td>取款金額</td> </tr> <% 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>"); } %> </table> <% 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); %> <p> <p align="center"> <font face="隸書" color="red" size=2> 定期取款 <font face="隸書" color="blue" size=2> <table border="1" width="700" cellspacing="0" cellpadding="0"> <tr> <td>取款編號</td><td>關聯存款編號</td><td>取款時間</td><td>操作員工編號</td><td>取款人</td><td>取款金額</td> </tr> <% 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>"); } %> </table> <% 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); %> <p> <p align="center"> <font face="隸書" color="red" size=2> 銀行轉帳 <font face="隸書" color="blue" size=2> <table border="1" width="700" cellspacing="0" cellpadding="0"> <tr> <td>轉帳編號</td><td>轉帳時間</td><td>操作員工編號</td><td>目的帳戶</td><td>轉帳金額</td> </tr> <% 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>"); } %> </table> <% 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); %> <p> <p align="center"> <font face="隸書" color="red" size=2> 網上銀行轉帳 <font face="隸書" color="blue" size=2> <table border="1" width="700" cellspacing="0" cellpadding="0"> <tr> <td>轉帳編號</td><td>轉帳時間</td><td>目的帳戶</td><td>轉帳金額</td> </tr> <% 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); } %> </font> </table> </body></html>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -