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