Java Hyd Team
@teamJavaHyd
746 subscribers
986 photos
39 videos
670 files
690 links
https://teamhydteam.my.canva.site/

Can visit us on our website ๐Ÿ˜Š
Still working on it ๐Ÿ˜Š
Download Telegram
About
Blog
Apps
Platform
Join
Java Hyd Team
746 subscribers
Java Hyd Team
Remotely org.pdf
2 MB
Get the Office app: https://aka.ms/officeandroidshareinstall
32 viewsedited  
Java Hyd Team
Guy's 1st Create all HTML pages
After Create JavaCodes



<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<center>
<h1 style="color:red">Employee Mananement System</h1><br>
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a><br><br>

<fieldset>
<h3>Delete Employee Here</h3>

<form action="DeleteCode" method="Post">
Name: <input type="text" name="name"><br><br>
<input type="submit" value="Delete">
</form>
</fieldset>
</center>
</body>
</html>
"""""""''delete html""""""'""







<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<center>
<h1 style="color:red">Employee Management System</h1><br>
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a><br>
<h3 style="color:green">welcome to Employee Home page</h3>
<a href="search.html">ShowDetails</a>
<a href="update.html">Update</a>
<a href="delete.html">Delete</a>
</body>
</html>
"""""""Home.html""""""'''






<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Empreg</title>
</head>
<body>
<center>
<h1 style="color:red">Employee Mananement System</h1><br>
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a><br>
<h3 style="color:Green">New Employee Register Here</h3><br>
<form action="Register" method="Post">
NAME: <input type="text" name="name"><br><br>
PASSWORD: <input type="text" name="psw"><br><br>
Email: <input type="text" name="mail"><br><br>
Gender: <input type="radio" name="gen" value=male>MALE
<input type="radio" name="gen" value=male>FEMALE<br><br>
MOBILE NUMBER: <input type="text" name="mno"><br><br>
STATE: <select name="state">
<option >select state</option>
<option>telangana</option>
<option>AP</option>
<option>UP</option>
<option>bihar</option>
<option>MP</option>
<option>orissa</option>
<option>karnataka</option>
</select><br><br>
COUNTRY: <select name="country"><br><br>
<option >select country</option>
<option>india</option>
<option>uk</option>
<option>usa</option>
<option>brazil</option>
<option>egypt</option>
<option>russia</option>
<option>japan</option>
</select><br><br>
ADDRESS: <input type="text" name="addr"><br><br>
<input type="submit" value="Register">
<input type="reset" value="Reset">
</center>
</body>
</html>
""""" empreg.html""""''''






<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<fieldset>
<center>
<h1 style="color:red">Employee Mananement System</h1><br>
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a>
</center>
</fieldset>
</body>
</html>
""""""'''''home.html""""""""







<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<h1 style="color:red">Employee Mananement System</h1><br>
<a href="Homepage.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a>
</body>
</html>
""""""""" homepage.html""""""''









<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<center>
<h1 style="color:red">Employee Mananement System</h1><br>
34 views
Java Hyd Team
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a><br>
<h3 style="color:green">New Employee login Here</h3><br>
<form action="LoginCode" method="Post">
NAME: <input type="text" name="name"><br><br>
PASSWORD: <input type="text" name="pwd"><br><br>

<input type="submit" value="Login"><br><br>
</form>
</center>
</body>
</html>
""""""" login.html """""""










<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<fieldset>
<center>
<h1 style="color:red">Employee Mananement System</h1><br>
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a><br><br>
<center>
<h3>View Your Details</h3>
<form action="searchCodes" method="Post">
Name : <input type="text" name="name"><br><br>
<input type="submit" value="search">
</form>
</center></center>
</fieldset>
</body>
</html>
search.html








<!DOCTYPE html>
<html>
<head>
<meta charset="ISO-8859-1">
<title>Insert title here</title>
</head>
<body>
<fieldset>
<center>
<h1 style="color:red">Employee Mananement System</h1><br>
<a href="Home.html">Home</a>
<a href="contact.html">Contact</a>
<a href="empreg.html">Registration</a>
<a href="login.html">login</a><br><br>

<fieldset>
<h3>Update Employee Record</h3>

<form action="updateCode" method="Post">
Name: <input type="text" name="name"><br><br>
Password: <input type="password" name="pwd"><br><br>
Email: <input type="email" name="mail"><br><br>
Mobile Number: <input type="text" name="mno"><br><br>
Adress: <input type="text" name="adress"><br><br>
<input type="submit" value="Update">
</center>
</form>
</fieldset>
</fieldset>
</body>
</html>
"""" update.html """""








import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class Register
*/
@WebServlet("/Register")
public class Register extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public Register() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();
//PL
String name=request.getParameter("name");
String password=request.getParameter("psw");
String email=request.getParameter("mail");
String gender=request.getParameter("gen");
String mobileno=request.getParameter("mno");
String state=request.getParameter("state");
String country=request.getParameter("country");
String address=request.getParameter("address");
//DAL
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sai","sai");
PreparedStatement ps=con.prepareStatement("insert into empreg values(?,?,?,?,?,?,?,?)");
ps.setString(1,name);
ps.setString(2,password);
ps.setString(3,email);
ps.setString(4,gender);
ps.setString(5,mobileno);
ps.setString(6,state);
ps.setString(7,country);
ps.setString(8,address);

int i=ps.executeUpdate();
out.print(i+"One Record has been inserted successsfully................");
con.close();
}
catch(Exception ex)
{
out.print(ex);
}

}
}
register.java
35 views
Java Hyd Team
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.*;
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class LoginCode
*/
@WebServlet("/LoginCode")
public class LoginCode extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public LoginCode() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();

String name=request.getParameter("name");
String password=request.getParameter("pwd");
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sai","sai");
PreparedStatement ps=con.prepareStatement("select * from empreg where name=? and password=?");
ps.setString(1,name);
ps.setString(2,password);
ResultSet rs=ps.executeQuery();
if (rs.next())
{
response.sendRedirect("emphome.html");
}
else
{
out.print("Please insert a valid Username and Password");
}
con.close();
}
catch (Exception ex)
{
out.print(ex);
}

}

}
login.java







import java.sql.*;
import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class searchCodes
*/
@WebServlet("/searchCodes")
public class searchCodes extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public searchCodes() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();
String name=request.getParameter("uname");
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");

Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sai","sai");

PreparedStatement ps=con.prepareStatement("select * from empreg where name=? ");
ps.setString(1,name);
ResultSet rs=ps.executeQuery();

ResultSetMetaData rsmd=rs.getMetaData();
int n=rsmd.getColumnCount();
out.print("<html><body>");
out.print("<table border='1'>");
for(int i=1;i<=n;i++)

out.println("<td> <font color=blue size=3> "+"<br>"
+rsmd.getColumnName(i));

out.println("<tr>");

while(rs.next())
{
for(int i=1;i<=n;i++)

out.println("<td><br> "+rs.getString(i));
out.println("<tr>");
}
out.println("</table> </body> </html>");

}
catch(Exception ex)
{
out.println(ex);
}
}


}
[9/26, 6:29 PM] SAI KRISHNA: searchCode.java
import java.io.IOException;

import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.*;
40 views
Java Hyd Team
import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class updateCode
*/
@WebServlet("/updateCode")
public class updateCode extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public updateCode() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException {
response.setContentType("text/html");
PrintWriter out=response.getWriter();
//PL
String name=request.getParameter("name");
String password=request.getParameter("pwd");
String email=request.getParameter("mail");
String mobilenumber=request.getParameter("mno");
String address=request.getParameter("address");
//DAL
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con=DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sai","sai");
PreparedStatement ps=con.prepareStatement("update empreg set password=?,email=?,mobilenumber=?,adress=? where name=?");

ps.setString(1,password);
ps.setString(2,email);
ps.setString(3,mobilenumber);
ps.setString(4,address);
ps.setString(5,name);
int i=ps.executeUpdate();
out.print(i+"One Record has been Updated successsfully................");
con.close();
}
catch(Exception ex)
{
out.print(ex);
}

}
}
updateCode.java






import java.io.IOException;
import java.io.PrintWriter;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;

import javax.servlet.ServletException;
import javax.servlet.annotation.WebServlet;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;

/**
* Servlet implementation class DeleteCode
*/
@WebServlet("/DeleteCode")
public class DeleteCode extends HttpServlet {
private static final long serialVersionUID = 1L;

/**
* @see HttpServlet#HttpServlet()
*/
public DeleteCode() {
super();
// TODO Auto-generated constructor stub
}

/**
* @see HttpServlet#doPost(HttpServletRequest request, HttpServletResponse response)
*/
protected void doPost(HttpServletRequest request, HttpServletResponse response) throws ServletException, IOException
{
response.setContentType("text/html");
PrintWriter out=response.getWriter();

String name=request.getParameter("name");
try
{
Class.forName("oracle.jdbc.driver.OracleDriver");
Connection con= DriverManager.getConnection("jdbc:oracle:thin:@localhost:1521:xe","sai","sai");
PreparedStatement ps=con.prepareStatement("delete from empreg where name=?");

ps.setString(1,name);

int i=ps.executeUpdate();
out.print(i+"one Record has been Deleted Successfully.......");
con.close();

}
catch (Exception ex) {

out.print(ex);
}
}
}
[9/26, 6:30 PM] SAI KRISHNA: deleteCode.java
42 views
Java Hyd Team
package com.ankit;


import java.util.Arrays;

class Employee {
private String id;
private String name;

/**
* Employee constructor
*/
public Employee(String id, String name) { // constructor
this.id = id;
this.name = name;
}

@Override
public String toString() {
return "Employee[id=" + id + ", name=" + name + "] ";
}

}


/** Copyright (c), AnkitMittal JavaMadeSoEasy.com */
/**
* @author AnkitMittal
* Copyright (c), AnkitMittal . All Contents are copyrighted and must not be reproduced in any form.
* This class provides custom implementation of ArrayList(without using java api's)
* Insertion order of objects is maintained.
* Implementation allows you to store null as well.
* @param <E>
*/
class ArrayListCustom<E> {

private static final int INITIAL_CAPACITY = 10;
private Object elementData[]={};
private int size = 0;

/**
* constructor.
*/
public ArrayListCustom() {
elementData = new Object[INITIAL_CAPACITY];
}

/**
* method adds elements in ArrayListCustom.
*/
public void add(E e) {
if (size == elementData.length) {
ensureCapacity(); //increase current capacity of list, make it double.
}
elementData[size++] = e;
}


/**
* method returns element on specific index.
*/
@SuppressWarnings("unchecked")
public E get(int index) {
if ( index <0 || index>= size) { //if index is negative or greater than size of size, we throw Exception.
throw new IndexOutOfBoundsException("Index: " + index + ", Size " + index);
}
return (E) elementData[index]; //return value on index.
}


/**
* method returns removedElement on specific index.
* else it throws IndexOutOfBoundException if index is negative or greater than size of size.
*/
public Object remove(int index) {
if ( index <0 || index>= size) { //if index is negative or greater than size of size, we throw Exception.
throw new IndexOutOfBoundsException("Index: " + index + ", Size " + index);
}

Object removedElement=elementData[index];
for(int i=index;i<size - 1;i++){
elementData[i]=elementData[i+1];
}
size--; //reduce size of ArrayListCustom after removal of element.

return removedElement;
}


/**
* method increases capacity of list by making it double.
*/
private void ensureCapacity() {
int newIncreasedCapacity = elementData.length * 2;
elementData = Arrays.copyOf(elementData, newIncreasedCapacity);
}

/**
* method displays all the elements in list.
*/
public void display() {
System.out.print("Displaying list : ");
for(int i=0;i<size;i++){
System.out.print(elementData[i]+" ");
}
}

}


/** Copyright (c), AnkitMittal JavaMadeSoEasy.com */
/**
* Main class to test ArrayListCustom functionality.
*/
public class ArrayListEmployee {

public static void main(String...a) {
ArrayListCustom<Employee> list = new ArrayListCustom<Employee>();
list.add(new Employee("1", "sam"));
list.add(new Employee("2", "amy"));
list.add(new Employee("3", "wil"));
list.add(new Employee("4", "cat"));
list.add(new Employee("1", "sam"));
list.add(new Employee("2", "amy"));
list.add(null);

list.display();
System.out.println("\nelement at index "+1+" = "+list.get(1));
System.out.println("element removed from index "+1+" = "+list.remove(1));

System.out.println("\nlet's display list again after removal at index 1");

list.display();

//list.remove(11); //will throw IndexOutOfBoundsException, because there is no element to remove on index 11.
//list.get(11); //will throw IndexOutOfBoundsException, because there is no element to get on index 11.

}

}
36 views
Java Hyd Team
/*Output

Displaying list : Employee[id=1, name=sam] Employee[id=2, name=amy] Employee[id=3, name=wil] Employee[id=4, name=cat] Employee[id=1, name=sam] Employee[id=2, name=amy] null
element at index 1 = Employee[id=2, name=amy]
element removed from index 1 = Employee[id=2, name=amy]

let's display list again after removal at index 1
Displaying list : Employee[id=1, name=sam] Employee[id=3, name=wil] Employee[id=4, name=cat] Employee[id=1, name=sam] Employee[id=2, name=amy] null

*/
37 views
Java Hyd Team
๐”๐›๐ž๐ซ" ๐ˆ๐ง๐ญ๐ž๐ซ๐ฏ๐ข๐ž๐ฐ ๐๐ฎ๐ž๐ฌ๐ญ๐ข๐จ๐ง๐ฌ - ๐Ÿ๐ŸŽ๐Ÿ๐Ÿ

Based on Uber's job portal, they are hiring for multiple SDE1 and SDE2 positions right now. Here is a list of questions that have been asked by Uber in the last few months.

The compilation provided here is public information that is scattered around on multiple sites. You shouldn't try to use these as preparation material, but rather use these for self-assessment.

๐—–๐—ผ๐—ป๐˜€๐˜๐—ฟ๐˜‚๐—ฐ๐˜๐—ถ๐˜ƒ๐—ฒ ๐—”๐—น๐—ด๐—ผ๐—ฟ๐—ถ๐˜๐—ต๐—บ๐˜€

1.) Split String => https://lnkd.in/eTb6VDmC

2.) Bin packing problem => https://lnkd.in/eXZKX3Sv

๐—–๐—ผ๐—บ๐—ฏ๐—ถ๐—ป๐—ฎ๐˜๐—ผ๐—ฟ๐—ถ๐—ฐ๐˜€

1.) Sum of smallest elements in distinct sets => https://lnkd.in/exm7jDTm

๐——๐˜†๐—ป๐—ฎ๐—บ๐—ถ๐—ฐ ๐—ฃ๐—ฟ๐—ผ๐—ด๐—ฟ๐—ฎ๐—บ๐—บ๐—ถ๐—ป๐—ด

1.) Kth Step Sequence => https://lnkd.in/ertBsik7

2.) Collecting coins [Combinatorics involved] => https://lnkd.in/eqM-zDyi

๐—š๐—ฟ๐—ฎ๐—ฝ๐—ต

1.) Turn on all systems [Minimum spanning tree] => https://lnkd.in/ekj627TZ

2.) Turning Pages [DFS / Backtracking] => https://lnkd.in/eHsfBsM5

๐—ง๐—ฟ๐—ฒ๐—ฒ

1.) Delete Edge to minimize the difference in subtree sum => https://lnkd.in/edba9e8T

๐—•๐—ถ๐˜๐˜€๐—ฒ๐˜

1.) Queries on Binary String [Queues can be used] => https://lnkd.in/edZRjGck

๐—›๐—ฎ๐˜€๐—ต๐—บ๐—ฎ๐—ฝ

1.) Insert Delete Get Random => https://lnkd.in/eRk-hSKW

2.) Implement a hash map => https://lnkd.in/eznHKki3

๐—ฆ๐˜๐—ฎ๐—ฐ๐—ธ๐˜€

1.) Implement a queue with two stacks => https://lnkd.in/ebJbDced

๐—•๐—ถ๐—ป๐—ฎ๐—ฟ๐˜† ๐—ฆ๐—ฒ๐—ฎ๐—ฟ๐—ฐ๐—ต

1.) Index of a rotation point in an array => https://lnkd.in/e2KQs-Mq
lnkd.in
LinkedIn
This link will take you to a page thatโ€™s not on LinkedIn
45 views
Java Hyd Team
44 views
Java Hyd Team
47 views
Java Hyd Team
51 views
Java Hyd Team
https://forms.gle/2RMg7UwGR1guT4P6A
Google Docs
Java - Collection MCQ Test
This is the java programming questions section on "collections" with the explanation for various interview, competitive examination and entrance test. Solved examples with detailed answer description, explanation are given, and it would be easy to understand.
56 views
Java Hyd Team
48 views
Java Hyd Team
I hope you all completed banking apps
48 views
Java Hyd Team
Send the codes we can use as a reference
46 views
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 views
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 views
Java Hyd Team
amanrashm use this promo code to join
25 views
Java Hyd Team
Participate Now https://www.credit-suisse.com/codingchallenge

amanrashm

use this promo code to join
207 viewsedited  
Java Hyd Team
Everyone must come to classes
31 views
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 views