JList and mysql

[gedas]

hey,

is there a way of dynamically adding data from MySql database to a jlist?
any code snippets or tutorials of how this could be done would be greatly appreciated

thank you

[JosAH]

is there a way of dynamically adding data from MySql database to a jlist?
any code snippets or tutorials of how this could be done would be greatly appreciated

It's a two step process:

1) you submit your query and get a ResultSet back;
2) you populate your JList given the values in the ResultSet.

Set 2) usually is a while loop until you've fetched all the values you want from the Resultset. There is no magic fillMyJListFromADatabase( ... ) method.

kind regards,

Jos

[gedas]

thanks i just thought their might be such a method lol

anyway i have sorted the problem
thanks

[Tolls]

As part of 2 in Jos's list, you will be turning each row into an object of some class you have defined in your model that represents that returned data.

That will be what your List consists of.
So you'll return a List<MyClass>.

[DarrylBurke]

So you'll return a List<MyClass>

Um, the question was about a badly capitalized JList

db

[Tolls]

Oh....bugger.
I need my eyes testing!


...again.

Anyway. My point still stands. You would still return a List<MyClass>, and not a JList, since the GUI and db access should not be munged into the same bit of code.

So there...:p