public List<Area> getAllArea() { List<Area> areaList = new ArrayList<Area>(); con = new DBConnection(); try { cstmt = con.connection.prepareCall("{call getAllArea()}"); ResultSet rs = cstmt.executeQuery(); while (rs.next()) { Area objArea = new Area(); objArea.setAreaID(rs.getInt("AreaID")); objArea.setAreaName(rs.getString("AreaName")); City c = new City(); c.setCityName(rs.getString("CityName")); objArea.setCity(c); areaList.add(objArea); } rs.close(); } catch (Exception ex) { ex.getMessage(); } finally { con.closeConnection(); } return areaList; }
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; }
public Area getArea(int area_id) { Area objArea = null; con = new DBConnection(); try { cstmt = con.connection.prepareCall("{call getArea(?)}"); cstmt.setInt(1, area_id); ResultSet rs = cstmt.executeQuery(); if (rs.next()) { objArea = new Area(); objArea.setAreaName(rs.getString("AreaName")); objArea.setAreaID(rs.getInt("AreaID")); City ct = new City(); // ct.setCityID(rs.getInt("CityID")); ct.setCityName(rs.getString("CityName")); objArea.setCity(ct); } rs.close(); } catch (Exception ex) { ex.getMessage(); } finally { con.closeConnection(); } return objArea; }