Populate JComboBox with mysql

[Taylor Manley]

I am trying to implement a JComboBox into my eclipse gui. My end goal is to have two drop down combo boxes that compare videos on favorites list between two users. I am trying to populate a combobox with my databases now but I'm running into errors. The code I'm working with for the combo box is

JComboBox comboBox_1 = new JComboBox();
        String SQL = "SELECT userid from favorites_list";        
        Class.forName("com.mysql.cj.jdbc.Driver");
		Connection con=DriverManager.getConnection("jdbc:mysql://localhost:3306/userdatabase", "root", "pass1234");
				Statement stmt= con.createStatement();
        try {
       
            PreparedStatement ps = con.prepareStatement(SQL);
            ResultSet rs = ps.executeQuery();
            while(rs.next()){
                comboBox_1.addElement(new comboBox_1(rs.getString("userid")));
            }
            rs.close();
            ps.close();
        } catch (Exception e) {
            throw e;
        }finally{
            try{con.close();}catch(Exception e){;}
        }
        return;
    
 
   
		comboBox_1.setBounds(291, 412, 28, 20);
		frame.getContentPane().add(comboBox_1);

But I'm getting an error that "comboBox_1" can not be resolved.

Exception in thread "AWT-EventQueue-0" java.lang.Error: Unresolved compilation problem: 
	comboBox_1 cannot be resolved to a type

What am I doing wrong?

[Paul Clapham]

It says you're using comboBox_1 as a type, but you haven't declared it as a type. And you have:

new comboBox_1(rs.getString("userid"))

I think you meant to use the addItem() method of JComboBox here.

By the way can I suggest you use the try-with-resources statement for your JDBC code? It would look more like this:

            try (PreparedStatement ps = con.prepareStatement(SQL);
                 ResultSet rs = ps.executeQuery()) {
                 while(rs.next()){
                    comboBox_1.addItem(rs.getString("userid"));
                }
            }

As you can see, it takes care of all the tedious finally-clauses and resource-closing for you. I also removed the code where you caught an exception and did nothing but throw the exception. There's no point in doing that because the exception is going to be thrown anyway.