Databases
StackOverflow2013
Postsdbo
PODatabase to GlazedList/Jtable and then edit the database through the GlazedList/JTable
Body
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PODatabase to GlazedList/Jtable and then edit the database through the GlazedList/JTable
    text
    copied!<p>I am able to break this problem down into two questions:</p> <ol> <li>What is the best way to put the contents of a database (MS-Access) into a <a href="http://www.publicobject.com/glazedlists/" rel="nofollow noreferrer"><code>GlazedList</code></a>/<a href="http://java.sun.com/j2se/1.4.2/docs/api/javax/swing/JTable.html" rel="nofollow noreferrer"><code>JTable</code></a>?</li> <li>How do I make sure any changes made to the <a href="http://www.publicobject.com/glazedlists/" rel="nofollow noreferrer"><code>GlazedList</code></a>/<a href="http://java.sun.com/j2se/1.4.2/docs/api/javax/swing/JTable.html" rel="nofollow noreferrer"><code>JTable</code></a> are reflected on the database (MS-Access)?</li> </ol> <p>Here are the things I know:</p> <ol> <li>I know how to retrieve/manipulate the information from a database using the <a href="http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=2691&amp;lngWId=2" rel="nofollow noreferrer">JDBC method</a>.</li> <li>I know that <a href="http://www.publicobject.com/glazedlists/" rel="nofollow noreferrer"><code>GlazedList</code></a>'s require reflection so I would need to make a class that contains every column/field in the database. This is not very expandable...</li> </ol> <p>What is the best way to go about this problem?</p> <p><strong>edit://</strong> I have managed to create a class generator. It takes the column headings and creates an instance field. This should resolve the #2 <a href="http://pastebin.ca/1770996" rel="nofollow noreferrer">http://pastebin.ca/1770996</a> - It creates the class but I do not think I used reflection correctly... <strong>edit2://</strong> Edited my code from above so it works... <a href="http://pastebin.ca/1776722" rel="nofollow noreferrer">http://pastebin.ca/1776722</a></p>
 

Querying!

 
Guidance
An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload