how can i populate a jtable with data from a MySQL table?

[jonneymendoza]

hi i have made a jtable and i dont know how to populate it with data from a MySQL table.

i have no problem making a connection to the database and executiung queries, the problem lies in how can i actualy insert the values from a resulset into a table?

[yamangman]

You understand that actual JTable data is stored "in" the class "DefaultTableModel" yes, using methods in the "TableModel" interface to interact with that data? If you look at the API you can see that "DefaultTableModel" inherits from the abstract class "AbstractTableModel". Why not write your own tablemodel class ("JonneysTableModel") that extends AbstractTableModel to retrieve the values via SQL from your database, and then call the JTable constructor "JTable(JonneysTableModel myModel)", specifying your own TableModel. That's probably the most noddy way to do it.

If you're still stuck for what to do, why not look at the code for "DefaultTableModel" and see how Sun do it. (hint: Vector of Vectors for rows/columns). There is also a JTable constructor for vectors of data representing rows/columns.

All of this is from just looking at the javadoc API, everything you need really is there. If you're still stuck, give me a PM and i'll offer what assitence I can time-permitting.

[yamangman]

Also, as you're already familiar with the ResultSet Interface, have a look at the Interface ResultSetMetaData. With this you can try out some additional things by the looks of it, such as naming the columns in your JTable directly from your database table field names.