+ setAutocommit(true) is for setting how transaction control will react.

+ commit() is for ending transaction

+ what you need to do is to delete the row. Example:

    private void deleteAgressoNumbers(String agressoNumberID) throws SQLException {
        sql =
        "delete from agressonumbers " +
        "where agressonumberid = "+ agressoNumberID;
        
        Statement stat = conn.createStatement();
        stat.executeUpdate(sql);
        System.out.println("deleteAgressoNumbers " + stat.getUpdateCount());
        stat.close();
    }