This discussion is archived
2 Replies Latest reply: Dec 24, 2012 12:45 AM by 980759 RSS

Jcombobox!!

864402 Newbie
Currently Being Moderated
Hi folks,

I am new to Java and fairly new to programming in general. I have spent a couple of years in MS Access/VB.

In my quest to broaden my skill set I have started to play with Java. Honestly it seems to require a lot of code and classes to do the littlest thing.

My issue is this I have a mysql db with a customer table. I want by combobox to store the id and customer name but only display the customer name in the combobox.

When the user selects a customer I want the id to query the jtable and display the customer info.

I need to reference this id from the combobox to correctly populate the table.

So my table will look like this
id customername address city
1 customer1 123 this st atown
3 customer2 5 that st btown
4 customer 3 989 overhere st ctown
2 customer 4 9999 overthere st dtown
6 customer 5 234 thisstreet st etown

So when the user selects customer2 from the combobox it will in turn say customer2's id is 3.
3 will then be used to query the customer information and display this in the table.

I hope iam explaining this correctly... this was very common in ms access but all i had todo was hide the column with the id so it only displayed the customer name. When a new customer was selected it would take the hidden id column value to populate a table. It was extremely easy.
  • 1. Re: Jcombobox!!
    Kayaman Guru
    Currently Being Moderated
    861399 wrote:
    this was very common in ms access
    That's because it was designed for simple things like this. There are plenty of applications for Java that would be impossible (or at least very unwise) for Access/VB combo.

    Anyhow, I would start with the tutorial at http://docs.oracle.com/javase/tutorial/uiswing/components/combobox.html and see if that'll help.

    I'm assuming you are having trouble with the combobox and not the mysql part?
  • 2. Re: Jcombobox!!
    980759 Newbie
    Currently Being Moderated
    you need to use data model to support what you expecting
    please go through the below link
    http://www.coderanch.com/t/529195/GUI/java/set-ID-JCombobox

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points