?? actdetails.jsp
字號:
<%@ page language="java" contentType="text/html; charset=UTF-8" pageEncoding="UTF-8"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN"><html><head><meta http-equiv="Content-Type" content="text/html; charset=UTF-8"><title>Money Banks公司 賬號明細</title>
</head>
<body bgproperties="fixed" bgcolor="#CCCCFF">
<p></p>
<table border="0" width="100%" height="42">
<tr>
<td width="50%" height="36"><b><font size="5" ><i>Money Banks公司</i></font></b></td>
<td width="50%" height="36"></td>
</tr>
</table>
<%@ page import="java.util.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="java.text.*" %>
<%@ page import="java.sql.Date" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
Statement state;
String act=request.getParameter("txtActNumber");
state = connect.createStatement();
String strQuery1 = "select Register_Info.First_Name from Login_Info, Register_Info where Login_Info.Register_Id=Register_Info.Register_Id and Login_Info.Account_No='"+act+"'";
ResultSet result1 = state.executeQuery(strQuery1);
int ctr1=0;
while(result1.next())
{
out.print("<p><font size=\"3\">賬戶擁有者: ");
out.print(result1.getString("First_Name"));
out.print("<p><font size=\"3\">賬號號碼: ");
out.print(request.getParameter("txtActNumber"));
out.println("</font></p>");
}
}
catch(Exception e){
out.println("捕獲異常 " +e);
}
%>
<p><font size="3" ><b>交易明細: </b></font></p>
<table border="1" width="95%" height="21">
<tr>
<td width="17%" valign="top" height="15"><font size="3" >日期</font></td>
<td width="25%" height="15" valign="top"><font size="3" >貸款金額 ($)</font></td>
<td width="25%" height="15" valign="top"><font size="3" >信用金額 ($)</font></td>
<td width="35%" height="15" valign="top"><font size="3" >核對流水號($)</font></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
Statement state;
String act=request.getParameter("txtActNumber");
state = connect.createStatement();
String strQuery1 = "select * from TransCounter_Info where Account_No='"+act+"'";
ResultSet result1 = state.executeQuery(strQuery1);
int ctr1=0;
while(result1.next())
{
out.println("<tr>");
out.println("<td width=\"17%\" valign=\"top\" height=\"15\">");
out.println(result1.getDate("Transaction_date"));
out.println("<td width=\"25%\" valign=\"top\" height=\"15\">");
out.println(result1.getFloat("Debit_Amount"));
out.println("<td width=\"25%\" valign=\"top\" height=\"15\">");
out.println(result1.getFloat("Credit_Amount"));
out.println("<td width=\"35%\" valign=\"top\" height=\"15\">");
out.println(result1.getString("Check_No"));
out.println("</tr>");
}
}
catch(Exception e){
out.println("處理異常 " +e);
}
%>
</table>
<p align="left"><font size="3" >收支余額 ($): </font>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","sa","sa");
Statement state;
String act=request.getParameter("txtActNumber");
state = connect.createStatement();
String strQuery1 = "select Balance from AcHolder_Info where Account_No='"+act+"'";
ResultSet result1 = state.executeQuery(strQuery1);
int ctr1=0;
while(result1.next())
{
out.print("<align=\"right\">");
out.print(result1.getFloat("Balance"));
}
}
catch(Exception e){
out.println("處理異常 " +e);
}
%>
</p>
<p>
<font size="3">如有任何問題，請聯(lián)系我們辦公室，電子郵件
<A href="mailto:helpdesk@MoneyBanks.com">helpdesk@MoneyBanks.com</a>.
</font>
</p>
<p align="center">
<input type="button" value="確定 " name="Ok" onClick="window.open('Home_page.htm')">
</p>
<script language='JavaScript'>
function show()
{
window.navigateTo("Register_page.htm");
return false;
}
</script>
</body>
</html>?? 快捷鍵說明
復(fù)制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -