Populating Jtable from database - better way?

[madhura2212]

Hi All,

I have a table in MySQL database.
Is there a way where I can populate a JTable with values from a java bean obnject, which would be getting the values from MySQL table.

Say I have a table named EMPLOYEE with the following details:
1. ID
2. Name
3. Age
4. Address
5. Dept
6. Phone Number

and my Java bean class is Employee which has the following member variables
1. id
2. name
3. age
4. dept

And my JTable should display only the 4 columns out of 6 from MySQL table.

Also I want the table to be auto-refreshed.. the data should be checked for updation.

Which is the best way to do it from the following:
1. Directly read the values from the table using JDBC connection and populate the values into the JTable and poll it using a timer
2. Read the values into a java bean and use a table model to display those values.

Is there any better way to do it?

I am new to Swing so I am unaware of the performance issues related to it.
Would be very thankful for guiding.

Thanks in adavnce.
Madhura

[PhHein]

Crossposter:
Swing - Populating Jtable from database - better way

[madhura2212]

Is cross posting not allowed..
Just thought it would help me.. :-|

[PhHein]

It is not forbidden, but you ask volunteers for help. If you had been given the answer in your other thread, another answer here would be a waste of time.
If you really need to crosspost, be upfront about it and post the links to the other threads to avoid duplicate answers..

[madhura2212]

Same question at:
Swing - Populating Jtable from database - better way

Any help is appreciated on either of the forums..
Thanks! :)

[audriusa]

In the past I wrote an application that was rendering JTable from the remote source through the model, getting values through the network when requested. It worked well and solved the problem of how to read only as much data as needed (the table was much larger than the part that is normally visible). JTable only reads as much from the model as it is currently showing. It even did not require to load the data in any bigger chunks than a single line. It was RMI connection but likely results should be similar with JDBC and you naturally have offset and limit constructs that help to tie the model with SQL.

Some trivial caching of already known values could help in the model.