Filling a ComboBox....

[Fyrelion]

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!!

[oliver_lundag]

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();
		}
	}

[oliver_lundag]

[code = JAVA]
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()
[/code]

[oliver_lundag]

[code = JAVA]

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()
[/code]