Java Hyd Team

<!DOCTYPE HTML>
<html>
<head>

<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<title>Global Banking ..</title>
<link href="style.css" rel="stylesheet" type="text/css">
<script type="text/javascript">
function ctck()
{
var sds = document.getElementById("dum");
}
</script>

</head>

<body>

<div id="top_links">

<div id="header">
<h1>Online Banking System<span class="style1"></span></h1>
<h1>RajBank<span class="style1"></span></h1>
<h2>Your Professional Banking Partner</h2>
<A href="index.html"><IMG SRC="images/home1.gif"></IMG></A>
</div>

<div id="navigation">
<ul>
<li><a href="createacc.jsp">NEW ACCOUNT</a></li>
<li><a href="balance1.jsp">BALANCE</a></li>
<li><a href="deposit1.jsp">DEPOSIT</a></li>
<li><a href="withdraw1.jsp">WITHDRAW</a></li>
<li><a href="transfer1.jsp">TRANSFER</a></li>
<li><a href="closeac1.jsp">CLOSE A/C</a></li>
<li><a href="logout.jsp">LOGOUT</a></li>
</ul>
</div>

<table style="width:897px; background:#FFFFFF; margin:0 auto;">
<tr >
<td width="300" valign="top" style="border-right:#666666 1px dotted;">
<div id="services"><h1>Services</h1><br>
<ul>
<li><a href="#">NetBanking</a></li>
<li><a href="#">Loan</a></li>
<li><a href="#">Credit Card</a></li>
</ul>

</div>
</td>

<td width="1200" valign="top">

<%
%>
<table><%
boolean status=false;
long accountno=Long.parseLong(request.getParameter("accountno"));
//int num=Integer.parseInt(num);
String username=request.getParameter("username");
String password=request.getParameter("password");
String ssn=(String)session.getAttribute("ssn");
//Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con1=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","Amanrash","Amanrash");
PreparedStatement ps1=con1.prepareStatement("Select * from customer where userid='"+username+"' and password='"+password+"' and ssn='"+ssn+"'");
ResultSet rs1=ps1.executeQuery();
//Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con2=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","Amanrash","Amanrash");
PreparedStatement ps2=con2.prepareStatement("Select * from new_account where account_no="+accountno+"");
ResultSet rs2=ps2.executeQuery();
if(rs1.next()&&rs2.next()){
status=true;
}

//if(status==true){
// out.print("Welcome " + username);
try {
if(status==true){
out.print("Welcome " + username);
//Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","Amanrash","Amanrash");
PreparedStatement ps=con.prepareStatement("Select * from NEW_ACCOUNT where account_no=?");
ps.setLong(1,accountno);
ResultSet rs=ps.executeQuery();

out.print("<table align='left' cellspacing='5' cellpadding='5'>");
out.print("<tr><th>USER ID</th><th>ACCOUNT NO</th><th>ACCOUNT TYPE</th><th>AMOUNT</th><th>SSN</th></tr>");
while(rs.next()){
int accountno1=rs.getInt(1);
session.setAttribute("accountno",accountno1);

out.print(accountno);

out.print("<tr>");
out.print("<td>" +username+ "</td>");
out.print("<td>" + rs.getInt(1) + "</td>");
out.print("<td>" + rs.getString(2) + "</td>");
out.print("<td>" + rs.getInt(3) + "</td>");
out.print("<td>" +ssn+ "</td>");

out.print("</tr>");

}
out.print("</table>");

Random r=new Random();
int tid=r.nextInt(123456789);
//Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con3=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","Amanrash","Amanrash");
PreparedStatement ps3=con3.prepareStatement("insert into transaction values(?)");
ps3.setInt(1,tid);
int status3=ps3.executeUpdate();
out.println(status3);
}
else{
out.print("Please check

30 views15:35