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