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<Area> getAllCityArea(int cityid) {
con = new DBConnection();
try {
cstmt = con.connection.prepareCall("{call getAreaCityID(?)}");
cstmt.setInt(1, cityid);
ArrayList<Area> areas = new ArrayList<Area>();
ResultSet rs = cstmt.executeQuery();
while (rs.next()) {
Area objArea = new Area();
objArea.setAreaID(rs.getInt("AreaID"));
objArea.setAreaName(rs.getString("AreaName"));
areas.add(objArea);
}
return areas;
} catch (SQLException ex) {
return null;
}
}
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;
}
