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;
}
