any idea about JComboBox Modal? with JDBC

[Farhad Rahmati]

hi guys

I am using JDBC to connect to database and it's relational database which tables are related.

I have used combo box, list box and JTable

but I have a problem with combo box.

how do you retrieve and store data in a related table. I mean if you have primary key and foriegn keys with Dialog box.

I used modals and each combo box has modal.

but when you enter data, i tried to send the combo box index in to database . which is a stupid idea, and it's not working properly

I am looking for a method which modal shoul have it to retrieve data and send data.

thanks in advance

[Rob Camick]

Not sure if I understand the question but here is a solution that allows you to store an Object in the combo box model. It will contain a String value which is visible in the combo box and and "int" value which can be used as the key to access data in the database:

import java.awt.*;
import java.awt.event.*;
import java.util.*;
import javax.swing.*;
import javax.swing.plaf.basic.*;

public class ComboBoxItem extends JFrame implements ActionListener
{
	public ComboBoxItem()
	{
		Vector model = new Vector();
		model.addElement( new Item(1, "car" ) );
		model.addElement( new Item(2, "plane" ) );
		model.addElement( new Item(3, "train" ) );
		model.addElement( new Item(4, "boat" ) );
		model.addElement( new Item(5, "boat aadf asfsdf a asd asd" ) );

		JComboBox comboBox;

		//  Easiest approach is to just override toString() method
		//  of the Item class

		comboBox = new JComboBox( model );
		comboBox.addActionListener( this );
		comboBox.putClientProperty("JComboBox.isTableCellEditor", Boolean.TRUE);
		getContentPane().add(comboBox, BorderLayout.NORTH );

		//  Most flexible approach is to create a custom render
		//  to diplay the Item data

		comboBox = new JComboBox( model );
		comboBox.setRenderer( new ItemRenderer() );
		comboBox.addActionListener( this );
		getContentPane().add(comboBox, BorderLayout.SOUTH );
	}

	public void actionPerformed(ActionEvent e)
	{
		JComboBox comboBox = (JComboBox)e.getSource();
		Item item = (Item)comboBox.getSelectedItem();
		System.out.println( item.getId() + " : " + item.getDescription() );
	}

	class ItemRenderer extends BasicComboBoxRenderer
	{
		public Component getListCellRendererComponent(
			JList list, Object value, int index,
			boolean isSelected, boolean cellHasFocus)
		{
			super.getListCellRendererComponent(list, value, index,
				isSelected, cellHasFocus);

			if (value != null)
			{
				Item item = (Item)value;
				setText( item.getDescription().toUpperCase() );
			}

			if (index == -1)
			{
				Item item = (Item)value;
				setText( "" + item.getId() );
			}


			return this;
		}
	}

	class Item
	{
		private int id;
		private String description;

		public Item(int id, String description)
		{
			this.id = id;
			this.description = description;
		}

		public int getId()
		{
			return id;
		}

		public String getDescription()
		{
			return description;
		}

		public String toString()
		{
			return description;
		}
	}

	public static void main(String[] args)
	{
		JFrame frame = new ComboBoxItem();
		frame.setDefaultCloseOperation( EXIT_ON_CLOSE );
		frame.pack();
		frame.setVisible( true );
	 }

}

[Farhad Rahmati]

Thank you very much Rob

I think that is what I need

I just went through your code and I understand it. I will try it today and I'll let you know,

thank you very much