public List findAll()
  {
   List employees=new ArrayList();
   EmployeeBean employeeBean=null;
   try
   {
    String querystring="SELECT * FROM EMPLOYEE";
    con=getConnection();
    ptmt=con.prepareStatement(querystring);
    rs=ptmt.executeQuery();
    while(rs.next())
    {
     employeeBean=new EmployeeBean();
     employeeBean.setEmpId(rs.getString(1));
     employeeBean.setEmpName(rs.getString(2));
     employeeBean.setEmpAddr(rs.getString(3));
     employeeBean.setEmpEmail(rs.getString(4));
     employeeBean.setEmpPhone(rs.getString(5));
     
     employees.add(employeeBean);
    }
   }
   catch(SQLException e)
   {
    e.printStackTrace();
   }
   finally
   {
    try
    {
    if(rs!=null)
        rs.close();
    if(ptmt!=null)
       ptmt.close();
    if(con!=null)
       con.close();
    }
    catch(SQLException e)
    {
     e.printStackTrace();
    }
    catch(Exception e)
    {
     e.printStackTrace();
    }
    
   }
   return employees;
  }