@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 int insert(Advertisment advertisment) {
int result = 0;
int last_inserted_id = 0;
try {
connection = getConnection();
String advInsertQuery =
"insert into ADVERTISEMENT(ADTITLE,USERID,ADPOSTDATE,STREETADDRESS,COUNTRY,PROVINCE,"
+ "CITY,POSTALCODE,GENDER,PETLOVER,DIET,SMOKER,ALCOHOL,RENT,BUILDINGTYPE,ROOMTYPE,NOOFROOMS,DESCRIPTION,FURNISHED)"
+ " values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)";
psmt = connection.prepareStatement(advInsertQuery);
psmt.setString(1, advertisment.getAdTitle());
psmt.setInt(2, advertisment.getUserId());
psmt.setDate(3, getCurrentDate());
psmt.setString(4, advertisment.getStreetAddress());
psmt.setString(5, advertisment.getCountry());
psmt.setString(6, advertisment.getProvince());
psmt.setString(7, advertisment.getCity());
psmt.setString(8, advertisment.getPostalCode());
psmt.setString(9, advertisment.getGender());
psmt.setString(10, advertisment.getPet());
psmt.setString(11, advertisment.getDiet());
psmt.setString(12, advertisment.getSmoke());
psmt.setString(13, advertisment.getAlcohol());
psmt.setDouble(14, advertisment.getRent());
psmt.setString(15, advertisment.getBuildingType());
psmt.setString(16, advertisment.getRoomType());
psmt.setInt(17, advertisment.getNoOfRooms());
psmt.setString(18, advertisment.getDescription());
psmt.setString(19, advertisment.getFurnished());
result = psmt.executeUpdate();
Statement s = getConnection().createStatement();
ResultSet rs = s.executeQuery("Select * from ADVERTISEMENT");
if (rs.next()) {
last_inserted_id = rs.getInt(1);
}
} catch (SQLException ex) {
Logger.getLogger(AdvertismentDaoImpl.class.getName()).log(Level.SEVERE, null, ex);
}
System.out.println(last_inserted_id);
return last_inserted_id;
}