hi,

i am new to java.i have been given assignment where i have to display emp name based on state city area.

i have mysql table employee in db with int id[10],name varchar(20),state varchar(20),city varchar(20),area varchar(20));

i have written java program which works properly .where it should display id and name based on state city area.


import java.util.ArrayList;
import java.io.*;

public class Employeelookup {

static ArrayList<Employeelookup> al = new ArrayList<Employeelookup>();
int id;
String name;
String State;
String city;
String Area;
class OldEmployeeObject {
int id;
String name;
String State;
String city;
String Area;
}
class State {
City[]
}
class City {
Area[]
}
class Area {
Employee[]
}
class Employee {
id;
name;
}
static int count = 0;
{
}
Employeelookup()
{
}
Employeelookup(int id, String name, String State,String city,String Area)
{
this.id = id;
this.name = name;
this.State=State;
this.city=city;
this.Area=Area;

count++;
}
public void SetId(int id)

{
this.id=id;
}
public int getId()
{
return id;
}
public void SetName()
{
this.name=name;
}

public void putDetails(Employeelookup e)
{
al.add(e);

}

public Employeelookup getDetails(int id)
{
Employeelookup es = (Employeelookup)al.get(id);
return es;
}

public static void main(String[] args ) throws IOException
{

BufferedReader br = new BufferedReader(new InputStreamReader(System.in));

Employeelookup e = new Employeelookup();
Employeelookup e1 = new Employeelookup(1, "SaiRam", "karnataka","bangalore","rajajinagar");
Employeelookup e2 = new Employeelookup(2, "Anu", "karnataka","mysore","temple road");
Employeelookup e3 = new Employeelookup(3, "Vasu", "karnataka","bangalore","rajajinagar");
Employeelookup e4 = new Employeelookup(4, "Shillu", "Tamil Nadu","madhurai","b");
Employeelookup e5 = new Employeelookup(5, "Madhu", "Karnataka","shimoga","bus stop");
Employeelookup e6 = new Employeelookup(6, "Volga", "Andra","abc","railway stop");


e.putDetails(e1);
e.putDetails(e2);
e.putDetails(e3);
e.putDetails(e4);
e.putDetails(e5);
e.putDetails(e6);


while(true)
{

System.out.println("Enter state: ");
String State = br.readLine();

System.out.println("Enter city: ");
String city = br.readLine();
System.out.println("Enter area: ");
String Area = br.readLine();

//System.out.println("Enter Employeelookup id to get the Employeelookup details: ");
//int id = Integer.parseInt(br.readLine());

boolean flag = false;

for(int i=0; i <al.size();i++) {
Employeelookup es = e1.getDetails(i);

if((State.equals(es.State))&& (city.equals(es.city))&& (Area.equals(es.Area)))
{
System.out.print(es.id +" "+ es.name+" " );

//if(id == es.id)
{
System.out.println("The details of the Employeelookup is: ");
System.out.print(es.id +" "+ es.name+" " );
flag = true;
break;
}
}
}
System.out.println(" ");

if(!flag)
{
System.out.println("Sorry, no data exists with the id ");
}
System.out.println(" ");
String ch = null;

while(true)
{
System.out.println("Want to Continue(y/n)?)");
System.out.println(" ");
ch = br.readLine();
if(ch.equalsIgnoreCase("y") || ch.equalsIgnoreCase("n")) break;
if(!(ch.equalsIgnoreCase("y") || ch.equalsIgnoreCase("n")))
{
System.out.println("Invalid option : please type y/n");
System.out.println(" ");
}
}

if(ch.equalsIgnoreCase("n"))
{
System.out.println(" ");
System.out.println("Thank you");
break;
}
}
}
}

the above program works correctly that accepts state city area from command line searches employee arrays and display emp id and name if its exist.

but i need to create this class structure for employee table.

class state
{

state name->city[]--> it should display state name and array of cities;
state[0]->karnataka
->bangalore
->mysore
-> shimoga

state[1]-->delhi
-->A
-->B


}

my next class

class city
{
city name:area[];
it should display city name-->with array of area[] of that city
city[0]->bangalore.
area[0]-->jayangar
area[1]-->majestic


}

class Area
{

area name-->array of employees;

area[0]-->jayanagar.
emp[o]-->a
emp[1]-->b

area[1]-->majestic
emp[0]-->a
emp[1]-->n

}
basically its like state class
should display array of city[] of each state
and city class should display
all area present in that city

area[]
and area class shoul display all emp from that area
emp[]




regards