JList data from a database - 2 columns - 1 column hidden

Hi gang.

I'm working on a application that uses a JList to hold a result of a query to a database. What I'd like the JList to show is the names of the query result with the record number of the result as a hidden value in the JList.

Example

query result holds:

1,project 1
2,project 2
16, project 3

JList displays
project 1
project 2
project 3

Selecting the item in the JList will allow the program to pull the first column that is not visible and use it to make another query to the database.

Is this possible in Java using JList? Or is there a differnt component that I should be using?

Thanks!

Steve

try this (click on any item in the JList to display the full data)

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
class Testing extends JFrame
{
  DefaultListModel listModel = new DefaultListModel();
  JList list = new JList(listModel);
  public Testing()
  {
    setLocation(400,300);
    setDefaultCloseOperation(EXIT_ON_CLOSE);
    JPanel jp = new JPanel();
    JScrollPane sp = new JScrollPane(list);
    sp.setPreferredSize(new Dimension(100,200));
    jp.add(sp);
    getContentPane().add(jp);
    pack();
    listModel.addElement(new QueryResult(1,"project 1"));
    listModel.addElement(new QueryResult(2,"project 2"));
    listModel.addElement(new QueryResult(16,"project 3"));
    list.addMouseListener(new MouseAdapter(){
      public void mouseClicked(MouseEvent me){
        QueryResult temp = (QueryResult)list.getSelectedValue();
        if(temp != null)
        {
          JOptionPane.showMessageDialog(Testing.this,temp.recordNumber + " - "+temp.description);
        }}});
  }
  public static void main(String[] args){new Testing().setVisible(true);}
}
class QueryResult
{
  int recordNumber;
  String description;
  public QueryResult(int rn, String desc)
  {
    recordNumber = rn;
    description = desc;
  }
  public String toString(){return description;}
}

Michael,

You are, without a doubt, my hero!

That is exactly what I was looking for.

Thank you very much!

Steve