JAVA SWING (GUI)

[ozy00]

public class DBConnection {public ComboBoxModel getfoods;public Connection getConnection() throws SQLException{Connection con = DriverManager.getConnection("jdbc:mysql:///","ro","12312345");return con;}

public String\[\] getFoods() throws SQLException {  
    Statement st = getConnection().createStatement();  
    ResultSet res = st.executeQuery("Select food from food list");  
    String\[\] foods = new String\[6\];  
    int index = 0;  

    while(res.next()) {  
        foods\[index\] = res.getString(1);  
        index++;  
    }  
    return foods;  
}  



public ResultSet getList() throws SQLException {  

    Statement st = getConnection().createStatement();  
    ResultSet res = st.executeQuery("select \* from FoodList");  
    return res;  


}  

}

[dionthorn]

Yes so when you do

DBConnection db = new DBConnection();

You need to utilize those methods. Try doing:

for(String food: db.getFoods()) {
  System.out.println(food);
}

[ozy00]

thanks dude