Hey, join my group on magicpin within the next 23 hours to 70% off up to Rs.400 on Food Vouchers Coupon code will be revealed on group completion.! There are only 49 slots left, so click here now: http://magp.in/cGccH
<!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="RajBankLogo2.jpg" alt="Business"width="100" height="60"></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;
String num=request.getParameter("accountno");
int accountno=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.setInt(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);
System.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
<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="RajBankLogo2.jpg" alt="Business"width="100" height="60"></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;
String num=request.getParameter("accountno");
int accountno=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.setInt(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);
System.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();
System.out.println(status3);
}
else{
out.print("Please check your username and Password");
request.setAttribute("balance","Please check your username and Password");
%>
<jsp:forward page="balance1.jsp"></jsp:forward>
<%
}
}catch (Exception e) {
e.printStackTrace();
}
//}
//}
%></table><%
%>
</table>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*"%>
<%@ page import="java.util.*"%>
System.out.println(status3);
}
else{
out.print("Please check your username and Password");
request.setAttribute("balance","Please check your username and Password");
%>
<jsp:forward page="balance1.jsp"></jsp:forward>
<%
}
}catch (Exception e) {
e.printStackTrace();
}
//}
//}
%></table><%
%>
</table>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*"%>
<%@ page import="java.util.*"%>
<!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
<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
your username and Password");
request.setAttribute("balance","Please check your username and Password");
%>
<jsp:forward page="balance1.jsp"></jsp:forward>
<%
}
}catch (Exception e) {
e.printStackTrace();
}
//}
//}
%></table><%
%>
</table>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*"%>
<%@ page import="java.util.*"%>
request.setAttribute("balance","Please check your username and Password");
%>
<jsp:forward page="balance1.jsp"></jsp:forward>
<%
}
}catch (Exception e) {
e.printStackTrace();
}
//}
//}
%></table><%
%>
</table>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*"%>
<%@ page import="java.util.*"%>
<!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>
</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;
String num=request.getParameter("accountno");
int accountno=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;
}
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("delete from NEW_ACCOUNT where account_no='"+accountno+"'");
//ps.setInt(1,accountno);
ps.executeUpdate();
out.print(" your account no '"+accountno+"' has closed.");
out.print(" <A href='index.html'><IMG SRC='images/home1.gif'></IMG></A>");
}
else{
out.print("Please check your username and Password");
request.setAttribute("balance","Please check your username and Password");
%>
<jsp:forward page="closeac1.jsp"></jsp:forward>
<%
}
}catch (Exception e) {
e.printStackTrace();
}
%></table><%
%>
</table>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*"%>
<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>
</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;
String num=request.getParameter("accountno");
int accountno=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;
}
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("delete from NEW_ACCOUNT where account_no='"+accountno+"'");
//ps.setInt(1,accountno);
ps.executeUpdate();
out.print(" your account no '"+accountno+"' has closed.");
out.print(" <A href='index.html'><IMG SRC='images/home1.gif'></IMG></A>");
}
else{
out.print("Please check your username and Password");
request.setAttribute("balance","Please check your username and Password");
%>
<jsp:forward page="closeac1.jsp"></jsp:forward>
<%
}
}catch (Exception e) {
e.printStackTrace();
}
%></table><%
%>
</table>
<%@ page import="java.sql.*"%>
<%@ page import="java.io.*" %>
<%@ page import="javax.servlet.*"%>
<!DOCTYPE HTML>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
function dil(form)
{
for(var i=0; i<form.elements.length; i++)
{
if(form.elements[i].value == "")
{
alert("Fill out all Fields")
document.F1.accountno.focus()
return false
}
}
if(isNaN(document.F1.accountno.value))
{
alert("Accountno must be number & can't be null")
document.F1.accountno.value=""
document.F1.accountno.focus()
return false
}
if(!isNaN(document.F1.username.value))
{
alert("User Name must be char's & can't be null")
document.F1.username.value=""
document.F1.username.focus()
return false
}
if(!isNaN(document.F1.password.value))
{
alert("Password must be char's & can't be null")
document.F1.password.value=""
document.F1.password.focus()
return false
}
return true
}
</SCRIPT>
<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">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>CLOSE ACCOUNT FORM</h1><br>
<table align="center" bgcolor="white">
<tr>
</tr>
<tr>
<td>
<div><%if(request.getAttribute("balance")!=null)
{
out.print(request.getAttribute("balance"));
}
%></div>
<form name=F1 onSubmit="return dil(this)" action="closeac.jsp" >
<table cellspacing="5" cellpadding="3">
<tr><td>ACCOUNT NO:</td><td> <input type="text" name="accountno"/></td></tr>
<tr><td>USER NAME:</td><td> <input type="text" name="username"/></td></tr>
<tr><td>PASSWORD:</td><td> <input type="password" name="password"/></td></tr>
<tr><td></td><td><input type="submit" value="Submit"/>
<INPUT TYPE=RESET VALUE="CLEAR"></td></tr>
</table>
</form>
</td>
</tr>
</table>
</div>
</td>
<td width="299" valign="top">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>Welcome</h1><br>
<center><img src="images/globe_10.gif" alt="business" width="196" height="106"></center><br>
<p>Each people plan their site layouts depending upon their business type. Here comes a free designer template which provides you with a selection of different kinds of webdesign starting from business template, fashion template, media template, Science template, Arts template and much more.</p>
</div>
</td>
</tr></table>
<div id="footer_top">
<div id="footer_navigation">
</div>
<div id="footer_copyright" >
<center><img alt="business" width="196"
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
function dil(form)
{
for(var i=0; i<form.elements.length; i++)
{
if(form.elements[i].value == "")
{
alert("Fill out all Fields")
document.F1.accountno.focus()
return false
}
}
if(isNaN(document.F1.accountno.value))
{
alert("Accountno must be number & can't be null")
document.F1.accountno.value=""
document.F1.accountno.focus()
return false
}
if(!isNaN(document.F1.username.value))
{
alert("User Name must be char's & can't be null")
document.F1.username.value=""
document.F1.username.focus()
return false
}
if(!isNaN(document.F1.password.value))
{
alert("Password must be char's & can't be null")
document.F1.password.value=""
document.F1.password.focus()
return false
}
return true
}
</SCRIPT>
<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">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>CLOSE ACCOUNT FORM</h1><br>
<table align="center" bgcolor="white">
<tr>
</tr>
<tr>
<td>
<div><%if(request.getAttribute("balance")!=null)
{
out.print(request.getAttribute("balance"));
}
%></div>
<form name=F1 onSubmit="return dil(this)" action="closeac.jsp" >
<table cellspacing="5" cellpadding="3">
<tr><td>ACCOUNT NO:</td><td> <input type="text" name="accountno"/></td></tr>
<tr><td>USER NAME:</td><td> <input type="text" name="username"/></td></tr>
<tr><td>PASSWORD:</td><td> <input type="password" name="password"/></td></tr>
<tr><td></td><td><input type="submit" value="Submit"/>
<INPUT TYPE=RESET VALUE="CLEAR"></td></tr>
</table>
</form>
</td>
</tr>
</table>
</div>
</td>
<td width="299" valign="top">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>Welcome</h1><br>
<center><img src="images/globe_10.gif" alt="business" width="196" height="106"></center><br>
<p>Each people plan their site layouts depending upon their business type. Here comes a free designer template which provides you with a selection of different kinds of webdesign starting from business template, fashion template, media template, Science template, Arts template and much more.</p>
</div>
</td>
</tr></table>
<div id="footer_top">
<div id="footer_navigation">
</div>
<div id="footer_copyright" >
<center><img alt="business" width="196"
height="106"></center><br>
<p>Each people plan their site layouts depending upon their business type. Here comes a free designer template which provides you with a selection of different kinds of webdesign starting from business template, fashion template, media template, Science template, Arts template and much more.</p>
Copyright © RajBank</div>
</div>
<script type="text/javascript">
document.onload = ctck();
</script>
</div>
</body>
</html>
<p>Each people plan their site layouts depending upon their business type. Here comes a free designer template which provides you with a selection of different kinds of webdesign starting from business template, fashion template, media template, Science template, Arts template and much more.</p>
Copyright © RajBank</div>
</div>
<script type="text/javascript">
document.onload = ctck();
</script>
</div>
</body>
</html>
<!DOCTYPE HTML>
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
function dil(form)
{
for(var i=0; i<3; i++)
{
if(!isNaN(form.elements[i].value))
{
alert("This Field must be Char's")
form.elements[i].value=""
form.elements[i].focus()
return false
}
}
if(document.F1.password.value!=document.F1.repassword.value)
{
alert("Check Confirm PWD");
document.F1.repassword.value=""
document.F1.repassword.focus()
return false
}
if(!isNaN(document.F1.phone.value))
{
if(document.F1.phone.value >9999999999 )
{
alert("ye kabhi nhi aayegi")
document.F1.phone.value=""
document.F1.phone.focus()
return false
}
}
else
{
alert("This field must be number")
document.F1.phone.value=""
return false
}
if(!isNaN(document.F1.amount.value))
{
if(document.F1.amount.value < 500)
{
alert("Minimum Balance should be 500 /-")
document.F1.amount.value=""
document.F1.amount.focus()
return false
}
}
else
{
alert("This field must be number")
document.F1.amount.value=""
return false
}
for(var i=0; i<form.elements.length; i++)
{
if(form.elements[i].value == "")
{
alert("Fill out all Fields")
document.F1.username.focus()
return false
}
}
return true
}
</SCRIPT>
<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>RajBank<span class="style1"></span></h1>
<h2>Your Professional Banking Partner</h2>
<A href="index.html"><IMG SRC="RajBankLogo3.jpg" alt="Business"width="120" height="40"></IMG></A>
</div>
<div id="navigation">
<ul>
<li><a href="create.html">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="about.jsp">ABOUT US</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">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>OPEN ACCOUNT FORM</h1><br>
<table align="center" bgcolor="white">
<tr>
</tr>
<tr>
<td>
<form name=F1 onSubmit="dil(this)" action="CreateServlet" >
<table cellspacing="5" cellpadding="3">
<tr><td>USER NAME:</td><td> <input type="text" name="username"/></td></tr>
<tr><td>PASSWORD:</td><td> <input type="password" name="password"/></td></tr>
<tr><td>RE-PASSWORD:</td><td> <input type="password" name="repassword"/></td></tr>
<tr><td>AMOUNT:</td><td> <input type="text" name="amount"/></td></tr>
<!-- Gender:<br/><br/>
Male<input type="radio" name="gender" value="male"> Female<input type="radio" name="gender" value="female"/><br/><br/> -->
<tr><td>ADDRESS:</td><td> <input type="text" name="adderess"/></td></tr>
<tr><td>PHONE:</td><td> <input type="text" name="phone"/></td></tr>
<tr><td></td><td><input type="submit" value="Submit"/>
<INPUT TYPE=RESET VALUE="CLEAR"></td></tr>
</table>
</form>
</td>
</tr>
</table>
</div>
</td>
<td width="299" valign="top">
<html>
<head>
<SCRIPT LANGUAGE="JavaScript">
function dil(form)
{
for(var i=0; i<3; i++)
{
if(!isNaN(form.elements[i].value))
{
alert("This Field must be Char's")
form.elements[i].value=""
form.elements[i].focus()
return false
}
}
if(document.F1.password.value!=document.F1.repassword.value)
{
alert("Check Confirm PWD");
document.F1.repassword.value=""
document.F1.repassword.focus()
return false
}
if(!isNaN(document.F1.phone.value))
{
if(document.F1.phone.value >9999999999 )
{
alert("ye kabhi nhi aayegi")
document.F1.phone.value=""
document.F1.phone.focus()
return false
}
}
else
{
alert("This field must be number")
document.F1.phone.value=""
return false
}
if(!isNaN(document.F1.amount.value))
{
if(document.F1.amount.value < 500)
{
alert("Minimum Balance should be 500 /-")
document.F1.amount.value=""
document.F1.amount.focus()
return false
}
}
else
{
alert("This field must be number")
document.F1.amount.value=""
return false
}
for(var i=0; i<form.elements.length; i++)
{
if(form.elements[i].value == "")
{
alert("Fill out all Fields")
document.F1.username.focus()
return false
}
}
return true
}
</SCRIPT>
<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>RajBank<span class="style1"></span></h1>
<h2>Your Professional Banking Partner</h2>
<A href="index.html"><IMG SRC="RajBankLogo3.jpg" alt="Business"width="120" height="40"></IMG></A>
</div>
<div id="navigation">
<ul>
<li><a href="create.html">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="about.jsp">ABOUT US</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">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>OPEN ACCOUNT FORM</h1><br>
<table align="center" bgcolor="white">
<tr>
</tr>
<tr>
<td>
<form name=F1 onSubmit="dil(this)" action="CreateServlet" >
<table cellspacing="5" cellpadding="3">
<tr><td>USER NAME:</td><td> <input type="text" name="username"/></td></tr>
<tr><td>PASSWORD:</td><td> <input type="password" name="password"/></td></tr>
<tr><td>RE-PASSWORD:</td><td> <input type="password" name="repassword"/></td></tr>
<tr><td>AMOUNT:</td><td> <input type="text" name="amount"/></td></tr>
<!-- Gender:<br/><br/>
Male<input type="radio" name="gender" value="male"> Female<input type="radio" name="gender" value="female"/><br/><br/> -->
<tr><td>ADDRESS:</td><td> <input type="text" name="adderess"/></td></tr>
<tr><td>PHONE:</td><td> <input type="text" name="phone"/></td></tr>
<tr><td></td><td><input type="submit" value="Submit"/>
<INPUT TYPE=RESET VALUE="CLEAR"></td></tr>
</table>
</form>
</td>
</tr>
</table>
</div>
</td>
<td width="299" valign="top">
<div id="welcome" style="border-right:#666666 1px dotted;"><h1>Welcome</h1><br>
<center><img src="RajbankLogo.jpg" alt="business" width="196" height="106"></center><br>
<p>Each people plan their site layouts depending upon their business type. Here comes a free designer template which provides you with a selection of different kinds of webdesign starting from business template, fashion template, media template, Science template, Arts template and much more.</p>
</div>
</td>
</tr></table>
<div id="footer_top">
<div id="footer_navigation">
</div>
<div id="footer_copyright" >
<center><img src ="RajBankLogo2.jpg"alt="business" width="196" height="106"></center><br>
<p>Happy Banking</p>
Copyright © RajBank</div>
</div>
<script type="text/javascript">
document.onload = ctck();
</script>
</div>
</body>
</html>
<center><img src="RajbankLogo.jpg" alt="business" width="196" height="106"></center><br>
<p>Each people plan their site layouts depending upon their business type. Here comes a free designer template which provides you with a selection of different kinds of webdesign starting from business template, fashion template, media template, Science template, Arts template and much more.</p>
</div>
</td>
</tr></table>
<div id="footer_top">
<div id="footer_navigation">
</div>
<div id="footer_copyright" >
<center><img src ="RajBankLogo2.jpg"alt="business" width="196" height="106"></center><br>
<p>Happy Banking</p>
Copyright © RajBank</div>
</div>
<script type="text/javascript">
document.onload = ctck();
</script>
</div>
</body>
</html>