java - Definition TableModel removeRow() method -
this question has answer here:
this tablemodel:
public class d9 extends abstracttablemodel { arraylist<string> cols = new arraylist<>(); arraylist<arraylist<string>> data = new arraylist<>(); public d9() { ... int c = resultset.getmetadata().getcolumncount(); while (resultset.next()) { arraylist<string> eachrow = new arraylist<>(); (int = 1; <= c; i++) { eachrow.add(resultset.getstring(i)); } data.add(eachrow); } ... } @override public int getrowcount() { return data.size(); } @override public int getcolumncount() { return cols.size(); } @override public object getvalueat(int rowindex, int columnindex) { arraylist<string> selectedrow = data.get(rowindex); return selectedrow.get(columnindex); } @override public string getcolumnname(int column) { return cols.get(column); } public void removerow(int rownumber) { data.remove(rownumber); firetablerowsdeleted(rownumber, rownumber); } } now, after passing convertrowindextomodel line number removerow method row remove table, after re-run program, come back!
when call removerow need try , remove row database.
now because have not idea structure of database is, need fill in details, simple outline of need do
public void removerow(int rownumber) throws sqlexception { connection con = ...; preparedstatement ps = null; string keyvalue = ...; // key value arraylist try { ps = con.preparestatement("delete youdatabasetabe key=?"); ps.setobject(1, keyvalue); if (ps.executeupdate() == 1) { data.remove(rownumber); firetablerowsdeleted(rownumber, rownumber); } else { throw new sqlexception("failed remove row database"); } } { try { ps.close(); } catch (exception e) { } } } you may want spend time having read through jdbc database access
Comments
Post a Comment