Answer :
Connection CON = null; STATEMENT st = null; // OBTAIN connection here st = con.createStatement(); ResultSet rs = null; rs = st.executeQuery("SELECT * FROM USERS"); int recordsUpdated; recordsUpdated = st.executeUpdate("DELETE FROM users WHERE user_id = 1");