Java Hyd Team

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

49 views07:16

Java Hyd Team

https://meet.google.com/zwx-igqo-hwh
connect using link

Google

Real-time meetings by Google. Using your browser, share your video, desktop, and presentations with teammates and customers.

40 views14:54

Java Hyd Team

amanrashm use this promo code to join

25 views06:26

Java Hyd Team

Participate Now https://www.credit-suisse.com/codingchallenge

amanrashm

use this promo code to join

207 viewsedited 06:27

Java Hyd Team

Everyone must come to classes

31 views09:08

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="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

34 views15:35

Java Hyd Team

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.*"%>

29 views15:35

Java Hyd Team

balance.jsp

31 views15:35

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

Java Hyd Team

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.*"%>

26 views15:35

Java Hyd Team

balance1.jsp

24 views15:35

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>

</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.*"%>

28 views15:35

Java Hyd Team

closeac.jsp

25 views15:35

About

Blog

Apps

Platform