@Override public List<Advertisment> searchAdvertisement(Advertisment adModel1) { ResultSet rs = null; Advertisment ads; List<Advertisment> ls = new ArrayList<>(); try { Connection con = ConnectionFactory.getConnection(); String query = "Select * from Advertisement where CITY=? and BUILDINGTYPE=? and NOOFROOMS = ? and GENDER=? and PETLOVER=? and DIET=? and SMOKER = ? and ALCOHOL=?"; PreparedStatement preparedStatement = con.prepareStatement(query); preparedStatement.setString(1, adModel1.getCity()); preparedStatement.setString(2, adModel1.getBuildingType()); preparedStatement.setInt(3, adModel1.getNoOfRooms()); preparedStatement.setString(4, adModel1.getGender()); preparedStatement.setString(5, adModel1.getPet()); preparedStatement.setString(6, adModel1.getDiet()); preparedStatement.setString(7, adModel1.getSmoke()); preparedStatement.setString(8, adModel1.getAlcohol()); rs = preparedStatement.executeQuery(); while (rs.next()) { ads = new Advertisment(); ads.setAdId(rs.getInt("ADID")); ads.setAdPostDate(String.valueOf(rs.getDate("ADPOSTDATE"))); ads.setAdTitle(rs.getString("ADTITLE")); ads.setStreetAddress(rs.getString("STREETADDRESS")); ls.add(ads); } } catch (Exception e) { } return ls; }
@Override public List<Advertisment> findByUserId(int userID) { List<Advertisment> userAdList = new ArrayList<>(); try { Connection con = ConnectionFactory.getConnection(); Advertisment adBean; PreparedStatement ps = con.prepareStatement( "Select ADID,ADTITLE,ADPOSTDATE,STREETADDRESS from ADVERTISEMENT where USERID=?"); ps.setInt(1, userID); ResultSet rs = ps.executeQuery(); while (rs.next()) { // System.out.println(rs.getInt("ADID")); adBean = new Advertisment(); adBean.setAdId(rs.getInt("ADID")); adBean.setAdPostDate(String.valueOf(rs.getDate("ADPOSTDATE"))); adBean.setAdTitle(rs.getString("ADTITLE")); adBean.setStreetAddress(rs.getString("STREETADDRESS")); userAdList.add(adBean); } } catch (SQLException ex) { Logger.getLogger(AdvertismentDaoImpl.class.getName()).log(Level.SEVERE, null, ex); } return userAdList; }
@Override public boolean deleteAdvertisement(int adId) { Connection con = ConnectionFactory.getConnection(); try { PreparedStatement ps = con.prepareStatement("Delete from ADVERTISEMENT where ADID=?"); ps.setInt(1, adId); int deletedRow = ps.executeUpdate(); if (deletedRow == 1) return true; } catch (SQLException ex) { Logger.getLogger(AdvertismentDaoImpl.class.getName()).log(Level.SEVERE, null, ex); } return false; }
@Override public Connection getConnection() { return ConnectionFactory.getConnection(); }