Deleting the last row in a table. SQL/Netbeans -

in java, trying delete last row of database. database has 15 rows , want delete 15th one. columns called initials , score.

                 intials         scores    rows# 1.         ads          2343          2.         dde          5454               15.         tbk           332 

i can't have selecting tbk because i'm wanting delete 15th 1 no matter new 1 can added. everywhere i've looked it's has specific or delete rows. can help? many help. :)

op : trying delete the last row of database.

• make resultset updatable : resultset.concur_updatable);
• set cursor last record : resultset.last();
• delete last record : resultset.deleterow();
• for further use of rs should set : resultset.beforefirst();

---

private static int dellastrow(resultset resultset) {     if (resultset == null) {         return 0;     }     try {         resultset.last();         int delid = resultset.getint(1);         resultset.deleterow();         system.out.println("deleted id :" + delid);         resultset.beforefirst();         return delid;     } catch (sqlexception exp) {         exp.printstacktrace();     } {         try {             resultset.beforefirst();         } catch (sqlexception exp) {             exp.printstacktrace();         }     }     return 0; }        public static void main(string[] args) {    connection conn = null;    statement stmt = null;    try{       class.forname("com.mysql.jdbc.driver");       conn = drivermanager.getconnection(db_url,user,pass);       stmt = conn.createstatement(               resultset.type_scroll_sensitive,               resultset.concur_updatable);       //rs scrollable, not show changes made others,       //and updatable        string sql;       sql = "select * `order details`";       resultset rs = stmt.executequery(sql);       system.out.println("deleted id :"+ dellastrow(rs));       ....   } 

---