Java

Java RSS

Populate data from database into JList

•

Join Date: Sep 2004

Posts: 10

Reputation: abc2004 is an unknown quantity at this point

Solved Threads: 0

abc2004

Offline

Newbie Poster

Populate data from database into JList

Jul 20th, 2006

How to populate data from a database table into JList?
I can retrieve the data from the database table ok. No Problem but now want to populate those data into the JList. What are the code for this?
I need to know the class and methods for this.

Thanks!!!!

•

Join Date: Aug 2005

Posts: 5,264

Reputation: iamthwee is a splendid one to behold

Solved Threads: 377

iamthwee

Offline

Posting Expert

Re: Populate data from database into JList

Jul 20th, 2006

•

Originally Posted by abc2004

How to populate data from a database table into JList?
I can retrieve the data from the database table ok. No Problem but now want to populate those data into the JList. What are the code for this?
I need to know the class and methods for this.

Thanks!!!!

Googling for the JList api would be a good start?

*Voted best profile in the world*

•

Join Date: May 2005

Posts: 19

Reputation: Rotak is an unknown quantity at this point

Solved Threads: 0

Rotak

Offline

Newbie Poster

Re: Populate data from database into JList

Jul 22nd, 2006

•

Originally Posted by abc2004

How to populate data from a database table into JList?
I can retrieve the data from the database table ok. No Problem but now want to populate those data into the JList. What are the code for this?
I need to know the class and methods for this.

Thanks!!!!

Well, as you can use a Vector to fill the JList, this would be one option.

I chose a slightly bigger solution. I wrote my own DatabaseTransaction class, which basically wraps query(), update() and get[Type]() functions of the JDBC interface.

Then I wrote my own TableModel and ListModel classes, providing a function which takes the transaction class and the column name of the value to be displayed as a parameter (resp. an array of column names and one of column captions for tables).

This works pretty smooth, as long as all of your values can be retreived as a string, which is making trouble with date/time fields.

•

Join Date: Sep 2004

Posts: 10

Reputation: abc2004 is an unknown quantity at this point

Solved Threads: 0

abc2004

Offline

Newbie Poster

Re: Populate data from database into JList

Jul 23rd, 2006

Wow, that sounds very nice to me. Would be nice if you could share the code. I love reuse!!! :p

THANKS!

•

Originally Posted by Rotak

Well, as you can use a Vector to fill the JList, this would be one option.

I chose a slightly bigger solution. I wrote my own DatabaseTransaction class, which basically wraps query(), update() and get[Type]() functions of the JDBC interface.

Then I wrote my own TableModel and ListModel classes, providing a function which takes the transaction class and the column name of the value to be displayed as a parameter (resp. an array of column names and one of column captions for tables).

This works pretty smooth, as long as all of your values can be retreived as a string, which is making trouble with date/time fields.

•

Join Date: May 2005

Posts: 19

Reputation: Rotak is an unknown quantity at this point

Solved Threads: 0

Rotak

Offline

Newbie Poster

Re: Populate data from database into JList

Jul 23rd, 2006

•

Originally Posted by abc2004

Wow, that sounds very nice to me. Would be nice if you could share the code. I love reuse!!! :p

THANKS!

I can imagine, that you love reuse.

The library is not ready, yet. I still need to fix problems with date/time fields (autodetecting field types from tables) and kill dependencies to other librarys used in the project.

Maybe you should simply use the Vector method for now, if you don't want to write a rather big solution like mine.

I'll check if I can post some code snippets for you, to give an idea of what the classes do. But that's not only my decission!!

•

Join Date: Mar 2004

Posts: 763

Reputation: Phaelax is on a distinguished road

Solved Threads: 38

Phaelax

Offline

Master Poster

Re: Populate data from database into JList

Jul 27th, 2006

A JList with a default model could be used as a mutable list.

MutableList myList = new MutableList();
myList.getContents().removeAllElements();

myList.getContents().addElement(something);

 Help with Code Tags 
 Java Syntax (Toggle Plain Text) 
import javax.swing.JList;
import javax.swing.DefaultListModel;
public class MutableList extends JList
{
    public MutableList()
    {
        super(new DefaultListModel());
    }
 
    public DefaultListModel getContents()
    {
        return (DefaultListModel)getModel();
    }
 
}
import javax.swing.JList;
import javax.swing.DefaultListModel;
public class MutableList extends JList
{
    public MutableList()
    {
        super(new DefaultListModel());
    }
    
    public DefaultListModel getContents()
    {
        return (DefaultListModel)getModel();
    }
    
}