Multiple combobox

[zealman]

i have form to customer fill it out.
In that form, i have combobox which connect to my database to show product name.

teks=new JLabel("Car Name");
textPerintah=new JTextField(15);
teks1=new JLabel("Car Number");
textPerintah1=new JTextField(15);
teks2=new JLabel("Driver");
textPerintah2=new JTextField(15);
teks3=new JLabel("Date :");
textPerintah3=new JTextField(15);
teks4=new JLabel("Product Name :");
	try {
		Class.forName("com.mysql.jdbc.Driver");
		Connection connect=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
		Statement s=connect.createStatement();
		String SQL=("SELECT product FROM storeproduct");
		rs=s.executeQuery(SQL);
		while (rs.next()) 
		{
			String product =rs.getString("product_name");
			listBox.addItem(nama.trim());
		}
	    }
	catch (Exception e)
	    {
		JOptionPane.showMessageDialog(null,"Failed to Connect to Database","Error Connection", JOptionPane.WARNING_MESSAGE);
		System.exit(0);
	    }

listBox.addActionListener();
teks5=new JLabel("Price");
textPerintah5=new JTextField(15);

If the customer have more than one product name, how can i make it?
Can anybody help me. Thanks Before....

[eRaaaa]

You select the colums "product" in your storeproduct table, but wants the "product_name" at the getString method? That`s not matching...it seems to be one of them is wrong.
Have you debugged the code? Is the while loop entered?
Maybe you have to use (just a suspicion):
"SELECT product_name FROM storeproduct" ?
Or tell us more about your table!

[zealman]

You select the colums "product" in your storeproduct table, but wants the "product_name" at the getString method? That`s not matching...it seems to be one of them is wrong.
Have you debugged the code? Is the while loop entered?
Maybe you have to use (just a suspicion):
"SELECT product_name FROM storeproduct" ?
Or tell us more about your table!

upss..sorry...
this is the correct code and i already debugged...

teks=new JLabel("Car Name");
textPerintah=new JTextField(15);
teks1=new JLabel("Car Number");
textPerintah1=new JTextField(15);
teks2=new JLabel("Driver");
textPerintah2=new JTextField(15);
teks3=new JLabel("Date :");
textPerintah3=new JTextField(15);
teks4=new JLabel("Product Name :");
	try {
		Class.forName("com.mysql.jdbc.Driver");
		Connection connect=DriverManager.getConnection("jdbc:mysql://localhost:3306/test","root","");
		Statement s=connect.createStatement();
		String SQL=("SELECT product FROM storeproduct");
		rs=s.executeQuery(SQL);
		while (rs.next()) 
		{
			String product =rs.getString("product");
			listBox.addItem(nama.trim());
		}
	    }
	catch (Exception e)
	    {
		JOptionPane.showMessageDialog(null,"Failed to Connect to Database","Error Connection", JOptionPane.WARNING_MESSAGE);
		System.exit(0);
	    }

listBox.addActionListener();
teks5=new JLabel("Price");
textPerintah5=new JTextField(15);

Can u help me, sir?

[Tolls]

Sorry, not sure what your problem is.
What should it be doing?
That code can't be compiling, surely?
I can see at least one error in there witht he addActionListener.

[zealman]

Sorry, not sure what your problem is.
What should it be doing?
That code can't be compiling, surely?
I can see at least one error in there witht he addActionListener.

If the customer have more than one product name, how can i make it?

[Tolls]

They can, assuming that's a default JList.
It defaults (if I remember) to multi select.

(And that code still doesn't compile).