Re: Modifying ResultSetTableModel not Database


<mitchell.ad@xxxxxxx> wrote in message
news:1133283806.880131.123300@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx

> Does
> anyone know how to modify a resultSet or tablemodel so that it changes
> in the Jtable, but not in the database?
>

You can't, ResultSet interface does not preclude the option of a connected
one.
You will have to copy the values out into some other structure.
Generally speaking you should assume that paging the resultset is actually
paging within the DBMS.

--
Mike W


.

Relevant Pages

  • Re: Paging, Filtering and Sorting
    ... The reason I want to use the paging is because of the number of records. ... only show a chunk at a time in the grid. ... > like to be able to load pages into the grid. ... > entire resultset into the dataset and pick up the next block of results as ...
    (microsoft.public.dotnet.languages.vb)
  • Re: Is there any way to optimize count(*)
    ... > I do paging on a table with products. ... Selecting a page in an resultset is ... David ...
    (microsoft.public.sqlserver.programming)
  • Re: Welchen Container =?ISO-8859-15?Q?f=FCr_Resultsets?=
    ... Fuer die reine Datenspeicherung hast Du schon gute Beispiele bekommen. ... TableModel tm = new DefaultTableModel; ... ResultSet rs = stmt.executeQuery; ... JTable anzeige = new JTable; ...
    (de.comp.lang.java)
  • using SQL in Java
    ... I just finished writing a silly class to wrap a ResultSet that ... implemented TableModel so that I could use it in a JPanel. ... is there any particular reason why ResultSet doesn't implement ...
    (comp.lang.java.programmer)
  • Re: Editing JDBC ResultSets in a JTable
    ... you'll need to override the setValueAtmethod of the TableModel ... > using to update your ResultSet with the new value. ... I did not print the error from updateRowin setValueAt() and missed the ...
    (comp.lang.java.gui)