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