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