java - Delete row from table -

java - Delete row from table -

i want delete current row displayed in jframe table contact

i wrote code

try { conn = java.sql.drivermanager.getconnection(connectionurl, "usrnme", "pswd"); statement stmt = conn.createstatement(resultset.type_scroll_insensitive,resultset.concur_updatable);//also tried resultset.type_scroll_sensitive rs.deleterow(); rs.next();//it may or may not include in code } catch(exception e){system.out.println( "jdbc error: " + e );}

sql query

string sql="select * contact order first_name, last_name"; rs=stmnt.executequery(sql);

but throws exception while running

jdbc error: java.sql.sqlexception: 'deleterow' not allowed because resultset not updatable resultset.

help me!

i suggest totally in sql, need additionally select (internal) rowid of every row

select c.*, c.rowid contact c order first_name, last_name

and afterward delete row row id

delete contact c c.rowid = (?)

this works oracle, every databasetype utilize internal rowid's. mysql rowid using @rowid far remember

java jdbc