📄 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 + -