public ArrayList<Vendor> getAllVendors() { con = new DBConnection(); ArrayList<Vendor> vendors = new ArrayList<Vendor>(); try { cstmt = con.connection.prepareCall("{call getAllVendors ()}"); ResultSet rs = cstmt.executeQuery(); while (rs.next()) { Vendor objVendor = new Vendor(); objVendor.setUserName(rs.getString("UserName")); objVendor.setVendorName(rs.getString("VendorName")); Area objArea = new Area(); // Creating area object objArea.setAreaName(rs.getString("AreaName")); // setting areaname of vendor City objCity = new City(); objCity.setCityName(rs.getString("CityName")); // setting cityname objArea.setCity(objCity); objVendor.setArea(objArea); // setting all other fields objVendor.setMobileNo(rs.getString("MobileNo")); objVendor.setEmailID(rs.getString("EmailID")); objVendor.setLane(rs.getString("Lane")); objVendor.setOwnerName(rs.getString("OwnerName")); objVendor.setLandlineNumber(rs.getString("LandlineNo")); objVendor.setStatus(rs.getBoolean("Status")); vendors.add(objVendor); } rs.close(); } catch (Exception ex) { ex.getMessage(); } finally { con.closeConnection(); } return vendors; }