@Override
public Advertisment findByAdvertismentId(int adId) {
Advertisment adBean = new Advertisment();
ResultSet rs;
try {
connection = getConnection();
psmt = connection.prepareStatement("Select * from ADVERTISEMENT where ADID=?");
psmt.setInt(1, adId);
rs = psmt.executeQuery();
while (rs.next()) {
adBean.setAdId(adId);
adBean.setUserId(rs.getInt("USERID"));
adBean.setAdPostDate(String.valueOf(rs.getDate("ADPOSTDATE")));
adBean.setAdTitle(rs.getString("ADTITLE"));
adBean.setAlcohol(rs.getString("ALCOHOL"));
adBean.setBuildingType(rs.getString("BUILDINGTYPE"));
adBean.setCity(rs.getString("CITY"));
adBean.setCountry(rs.getString("COUNTRY"));
adBean.setDescription(rs.getString("DESCRIPTION"));
adBean.setDiet(rs.getString("DIET"));
adBean.setGender(rs.getString("GENDER"));
adBean.setNoOfRooms(rs.getInt("NOOFROOMS"));
adBean.setPet(rs.getString("PETLOVER"));
adBean.setPostalCode(rs.getString("POSTALCODE"));
adBean.setProvince(rs.getString("PROVINCE"));
adBean.setRent(rs.getDouble("RENT"));
adBean.setRoomType(rs.getString("ROOMTYPE"));
adBean.setSmoke(rs.getString("SMOKER"));
adBean.setStreetAddress(rs.getString("STREETADDRESS"));
}
return adBean;
} catch (SQLException ex) {
Logger.getLogger(AdvertismentDaoImpl.class.getName()).log(Level.SEVERE, null, ex);
}
return adBean;
}
