4 - Hand Tree

public void get_trees(String id)
{
try{

java.sql.Connection con=new model.connection.connection().getCon();

java.sql.Statement st=con.createStatement();

java.sql.ResultSet rs=st.executeQuery("select child_1,child_2,child_3,child_4 from "+tablename+" where emp_code='"+id.trim()+"'");

if(rs.next())
{
String c1=rs.getString(1).trim();
String c2=rs.getString(2).trim();
String c3=rs.getString(3).trim();
String c4=rs.getString(4).trim();

if(c1.equals("N"))
{
v.addElement("N");
}
else
{
v.addElement(c1);
}


if(c2.equals("N"))
{
v.addElement("N");
}
else
{
v.addElement(c2);
}


if(c3.equals("N"))
{
v.addElement("N");
}
else
{
v.addElement(c3);
}


if(c4.equals("N"))
{
v.addElement("N");
}
else
{
v.addElement(c4);
}

}
else
{
v.addElement("N");
v.addElement("N");
v.addElement("N");
v.addElement("N");
}

}
catch(Exception ex){JOptionPane.showMessageDialog(null,ex.toString());}
}


public Vector get_tree(String id)
{
try
{
int x=0;
get_trees(id) ;
for(int y=0;y<2;y++)
{
int size= v.size();
System.out.println("S"+size);
for(;x {
//String sp[]=v.get(x).toString().split("
");
get_trees(v.get(x).toString());
// System.out.println(sp[1]);
}
//System.out.println(tot+""+tot.size());
//System.out.println(");
}
}
catch(Exception e1)
{
System.out.print(e1+"get");
}
return v;
}