?? actdetails.jsp
字號:
<html>
<head>
<title>Money Banks, Inc. -- Account Details</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, Inc.</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" %>
<%@ page language = "java" %>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","","");
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\">Account Holder: ");
out.print(result1.getString("First_Name"));
out.print("<p><font size=\"3\">Account Number: ");
out.print(request.getParameter("txtActNumber"));
out.println("</font></p>");
}
}
catch(Exception e){
out.println("done exception" +e);
}
%>
<p><font size="3" ><b>Transaction Details: </b></font></p>
<table border="1" width="95%" height="21">
<tr>
<td width="17%" valign="top" height="15"><font size="3" >Date</font></td>
<td width="25%" height="15" valign="top"><font size="3" >Debit Amount ($)</font></td>
<td width="25%" height="15" valign="top"><font size="3" >Credit Amount ($)</font></td>
<td width="35%" height="15" valign="top"><font size="3" >Check Number ($)</font></td>
</tr>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","","");
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("done exception" +e);
}
%>
</table>
<p align="left"><font size="3" >Balance Amount ($): </font>
<%
try{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection connect;
connect=DriverManager.getConnection("jdbc:odbc:BankDataSource","","");
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("done exception" +e);
}
%></p>
<p><font size="3" >In case of any questions, please contact our office at <A href="mailto:helpdesk@MoneyBanks.com">helpdesk@MoneyBanks.com</a>.</font></p>
<p align="center"><input type="button" value="OK " name="Ok" onClick="window.open('Home_page.htm')">
</font>
<script language='JavaScript'>
function show()
{
window.navigateTo("Register_page.htm");
return false;
}
</script>
</body>
</html>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -