Filling a ComboBox....

Question

15 Years Ago

Hi,
I'm in a IntrotoOOP class at my school, and my instructor asked me to look up how to fill a Java Swing Class ComboBox with data from a MySql Database. Does anyone know? This question has been quite hard to find any answers on and I have been really bugged by it recently.
Thanks!
Fyrelion
P.S.Any help at all would be really appreciated!!

java

2 Contributors
3 Replies
100 Views
15 Years Discussion Span
Latest Post 9 Years Ago by oliver_lundag

oliver_lundag -4 · Answer 1 · 2009-07-17T10:15:58+00:00

private static void queryCountry(){
		JC_country.addItem("(Choose)");	
		try {
			String query  = DBConnect.Select("addr_ref", "country, description",
																	"region = ''", "country");
			Statement stmt = DBConnect.getConnection().createStatement();
			ResultSet rs = stmt.executeQuery(query);
			while	(rs.next()){
				 JC_country.addItem(rs.getString(1)+"-"+rs.getString(2));
			}
			rs.close();
			stmt.close();
		} catch (SQLException e) {
			e.printStackTrace();
		}
	}

6 year old thread - Don't put comments for old or solved threads

oliver_lundag -4 · Answer 2 · 2009-07-17T10:17:55+00:00

private JComboBox getJC_country(){
		if(JC_country== null){
			JC_country = new JComboBox();
			JC_country.setSize(new Dimension(260, 20));
			JC_country.setLocation(new Point(80, 230));
			JC_country.addActionListener(new ActionListener(){
				public void actionPerformed(ActionEvent arg0) {
					try{						
						if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){
							JC_country.removeAllItems();
							queryCountry();
						}//end of if
						if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){							
							Country_Code = "Nothing";
							JC_region.removeAllItems();
							queryRegion();
							JC_region.setSelectedIndex(0);
							JC_province.setSelectedIndex(0);
						}//end of if
						Country_Code = JC_country.getSelectedItem().toString().substring(0, JC_country.getSelectedItem().toString().indexOf("-"));
						String Filter_By_Code = "select city_municipality,description from addr_ref  " +
																"where  country = '"+Country_Code +"'" +
																"and"+
																"			  region != '' " +
																"and"+
																"			  province != '' " +
																"and"+
																"			  city_municipality != '' "+
																"and"+
																"			  brgy_village = '' " +
																"and"+
																"			  street = '' ";
						try{
							tableMain.setQuery(Filter_By_Code);
						}catch(Exception exp){
						}//end of try catch
							JC_region.removeAllItems();
							queryRegion();						
							JC_region.setSelectedIndex(0);
							JC_province.setSelectedIndex(0);
					}catch(Exception e){
					}//end of try catch					
				}// end of actionPerformed
			});
		}//end of JC_country.addActionListener(new ActionListener(){	
		return JC_country;
	}//end of method getJC_country()

oliver_lundag -4 · Answer 3 · 2009-07-17T10:18:33+00:00

private JComboBox getJC_country(){
		if(JC_country== null){
			JC_country = new JComboBox();
			JC_country.setSize(new Dimension(260, 20));
			JC_country.setLocation(new Point(80, 230));
			JC_country.addActionListener(new ActionListener(){
				public void actionPerformed(ActionEvent arg0) {
					try{						
						if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){
							JC_country.removeAllItems();
							queryCountry();
						}//end of if
						if (JC_country.getSelectedItem().toString().equalsIgnoreCase("(Choose)") == true){							
							Country_Code = "Nothing";
							JC_region.removeAllItems();
							queryRegion();
							JC_region.setSelectedIndex(0);
							JC_province.setSelectedIndex(0);
						}//end of if
						Country_Code = JC_country.getSelectedItem().toString().substring(0, JC_country.getSelectedItem().toString().indexOf("-"));
						String Filter_By_Code = "select city_municipality,description from addr_ref  " +
																"where  country = '"+Country_Code +"'" +
																"and"+
																"			  region != '' " +
																"and"+
																"			  province != '' " +
																"and"+
																"			  city_municipality != '' "+
																"and"+
																"			  brgy_village = '' " +
																"and"+
																"			  street = '' ";
						try{
							tableMain.setQuery(Filter_By_Code);
						}catch(Exception exp){
						}//end of try catch
							JC_region.removeAllItems();
							queryRegion();						
							JC_region.setSelectedIndex(0);
							JC_province.setSelectedIndex(0);
					}catch(Exception e){
					}//end of try catch					
				}// end of actionPerformed
			});
		}//end of JC_country.addActionListener(new ActionListener(){	
		return JC_country;
	}//end of method getJC_country()