Creating Jbutton using MySQL database entry

Question

I am a beginner and I am trying to figure out a way to have a jbutton automatically be created when a new entry is inserted into the MySQL database column. The text of this button will be pulled in from an entry in the database. I have figured out how to pull in the information from the table to be used as the jbutton text, however, I feel that there has to be an easier way to do it. Any ideas on either of these issues? I have included a snippet of my code below. Thanks!

public class JuniorSkills extends javax.swing.JFrame {

/**
 * Creates new form JuniorSkills
 */
public JuniorSkills() throws ClassNotFoundException {
initComponents();
    Connection conn = null;
    Statement statement = null;
    ResultSet rs = null;


    try {
        Class.forName("com.mysql.jdbc.Driver");
        conn=DriverManager.getConnection("jdbc:mysql://localhost:3306/simlab","root","password");
        System.out.println("Connected to database");

        statement = conn.createStatement();
        rs = statement.executeQuery("SELECT * FROM skill_table WHERE class='junior'");

        int count = 0;
        while(rs.next())
        {
            count++;
            String gotit = rs.getString(1);
            //System.out.println(gotit);
            if(count==1)
            {
                Skill1.setText(rs.getString(1));
            }
            else if(count==2)
            {
                skill2.setText(rs.getString(1));
            }
            else if(count==3)
            {
                skill3.setText(rs.getString(1));
            }
            else if(count==4)
            {
                skill4.setText(rs.getString(1));
            }
            else if(count==5)
            {
                Skill5.setText(rs.getString(1));
            }
            else if(count==6)
            {
                skill6.setText(rs.getString(1));
            }
            else if(count==7)
            {
                Skill7.setText(rs.getString(1));
            }
            else if(count==8)
            {
                Skill8.setText(rs.getString(1));
            }
            else if(count==9)
            {
                Skill9.setText(rs.getString(1));
            }
            else if(count==10)
            {
                Skill10.setText(rs.getString(1));
            }
        }
    } catch (SQLException ex) {
        Logger.getLogger(JuniorSkills.class.getName()).log(Level.SEVERE, null, ex); 
    }



}

If you have a fixed number of buttons, create an array of buttons — MadProgrammer
– MadProgrammer, Commented Mar 20, 2013 at 0:01

MadProgrammer · Accepted Answer · 2013-03-20 00:08:02Z

1

If you only ever have a fixed number of rows, you could create an array of JButtons

private JButton[] myFixedListOfButtons;

//...//

myFixedListOfButtons = new JButton[10];

//...//

while(rs.next())
{
    String gotit = rs.getString(1);
    if (count < myFixedListOfButtons.length) 
    {
        myFixedListOfButtons[count].setText(gotit);
    }
    count++;
}

Alternatively, if you have a variable number of rows, you should simply create the buttons as you need

removeAll(); // remove all the old buttons...
while(rs.next())
{
    String gotit = rs.getString(1);
    JButton btn = new JButton(gotit);
    add(btn);
}

answered Mar 20, 2013 at 0:08

MadProgrammer

348k22 gold badges243 silver badges379 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

user2188777 Over a year ago

Thank you both. I will give it a shot and see what I can come up with.

Collectives™ on Stack Overflow

Creating Jbutton using MySQL database entry

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related