Обсуждение: JDBC update changes to JTable.
So far what I have been wondering:
- I have somehow finished the beginner level of JTable step by step following the official tutorial.
- I know how to use JDBC to query/update/ delete PostgreSQL database records.
- Add a button to update and insert and delete database table.
After using select syntax to populate JTable, I wonder how to update changes made in JTable to the database.
After browsing StackOverFlow, I have some basic idea:
- Step 1: editing
- step 2: stop editing;
- Step 3: make the update sync with the database.
Step1 is about adjusting the DefaultTableModel by calling related methods as per requirement. Related link: DefaultTableModel (Java Platform SE 7 ) (oracle.com)
Step2: I copied from StackOverFlow ( https://stackoverflow.com/questions/12823475/what-is-the-best-way-to-listen-for-changes-in-jtable-cell-values-and-update-data )
Step3: I don't know how to do it. So I asked the question on StackOverFlow (java - Update changes In JTable to database? - Stack Overflow) If you guys know how to do it, please help me.
I know it's less about JDBC, more about Java. Anyway.................
Hi Jian,
I'm not exactly sure what you are asking here.
One way is to use logical replication in Postgres.
Dave Cramer
www.postgres.rocks
On Sun, 27 Jun 2021 at 04:12, Jian He <hejian.mark@gmail.com> wrote:
So far what I have been wondering:
- I have somehow finished the beginner level of JTable step by step following the official tutorial.
- I know how to use JDBC to query/update/ delete PostgreSQL database records.
- Add a button to update and insert and delete database table.
After using select syntax to populate JTable, I wonder how to update changes made in JTable to the database.After browsing StackOverFlow, I have some basic idea:
- Step 1: editing
- step 2: stop editing;
- Step 3: make the update sync with the database.
Step1 is about adjusting the DefaultTableModel by calling related methods as per requirement. Related link: DefaultTableModel (Java Platform SE 7 ) (oracle.com)Step2: I copied from StackOverFlow ( https://stackoverflow.com/questions/12823475/what-is-the-best-way-to-listen-for-changes-in-jtable-cell-values-and-update-data )Step3: I don't know how to do it. So I asked the question on StackOverFlow (java - Update changes In JTable to database? - Stack Overflow) If you guys know how to do it, please help me.I know it's less about JDBC, more about Java. Anyway.................