@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 List<Advertisment> findByCity(String city) {
Advertisment ads;
connection = getConnection();
List<Advertisment> ls = new ArrayList<>();
String query = "SELECT * FROM advertisement WHERE CITY=?";
PreparedStatement ps;
try {
ps = connection.prepareStatement(query);
ps.setString(1, city);
ResultSet rs = ps.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);
System.out.println(ls.size());
}
} catch (SQLException ex) {
Logger.getLogger(AdvertismentDaoImpl.class.getName()).log(Level.SEVERE, null, ex);
}
return ls;
}
@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;
}