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