📄 actdetail.jsp
字号:
<HTML>
<%@page contentType= "text/html;charset=GBK"%>
<HEAD>
<title>帐户细节</title>
</HEAD>
<BODY BGCOLOR="#FFFFFF">
<%@page import="java.util.*,java.sql.*,java.text.*,java.sql.Date"%>
<jsp:useBean id="db" class="bean.ConnDB" scope="session"/>
<%! String actNumber;%>
<%
String actNumber=(String)session.getAttribute("txtAcNo");
actNumber=actNumber.trim();
try
{
String strQuery1="select * from AccountInfo where AccountNo='"+actNumber+"'";
ResultSet rs1=db.executeQuery(strQuery1);
while(rs1.next())
{
out.print("<p><font size=\"3\">户名:");
out.print(rs1.getString("ownerName")+"<br> ");
out.print("帐号:");
out.print(actNumber+"<br>");
out.print("余额：");
out.print(rs1.getFloat("balance")+"<br>");
out.print("</font>");
break;
}
rs1.close();
db.close();
}
catch(Exception e){System.err.print(e+"error1");}
%>
<font size="4"><center><b>资金流水<b></font></center>
<table border="1" width="95%" height="21">
<tR>
<td >发生日期</td>
<td >取款总额</td>
<td>存款总额 </td>
</tR>
<%
try
{
String strQuery1="select * from TransCounterInfo where AccountNo='"+actNumber+"'";
ResultSet rs1=db.executeQuery(strQuery1);
while(rs1.next())
{
out.println("<tr>");
out.println("<td> ");
out.println(rs1.getDate("transDate"));
out.println("</td>");
out.println("<td>");
out.println(rs1.getFloat("DebitAmount"));
out.println("</td>");
out.println("<td> ");
out.println(rs1.getFloat("CreditAmount"));
out.println("</td>");
out.println("</tr>");
}
rs1.close();
db.close();
}
catch(Exception e){}
%>
</table>
</body>
</html>
</BODY>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -