Making an Applet use a MySQL Database

I made an applet using Java, but now I want it to read information from a MySQL Database. The applet itself is a bunch of drop down menu lists that the user would pick an item from the list and it displays information about the item chosen.

Does anyone know the coding to make an applet be able to connect to a MySQL database?

My code is currently something like:

Code:

---

import java.awt.*;
import java.applet.*;

public class Labeling extends Applet
{
    Label nameLabel, resultLabel;
    Choice nameChoice;
    TextField resultText;

    public void init()
    {
        nameLabel = new Label("Name of Box");
        nameChoice = new Choice();
        nameChoice.add("");
        nameChoice.add("Choice One");
        nameChoice.add("Choice Two");
       
        resultLabel = new Label ("Choice Picked: ");
            resultText = new TextField(4);
            resultText.setEditable(false);

        display();
                  addIn();
    }
   
    public boolean action(Event event, Object object)
    {
            if(event.target == nameChoice)
            {
                    if (true)
                          {
                            putValue();
                          }
                       
                    return(true);
            }
            else
            {
                    return(false);
            }
    }
   
    public void putValue()
    {
            int choices = 0;
           
            String name = nameChoice.getSelectedItem();
           
            if(name.equals("Choice One"))
                    choices = 1;
            else if(name.equals("Choice Two"))
                    choices = 2;
           
            resultText.setText("" + choices);
    }
   
    public void display()
          {
                // Use a grid bag layout.
            GridBagLayout gbag = new GridBagLayout();
            GridBagConstraints gbc = new GridBagConstraints();
            setLayout(gbag);
           
            // Define the grid bag.
            gbc.weighty = 1.0; // use a row weight of 1
            gbc.gridwidth = GridBagConstraints.REMAINDER;
            gbc.anchor = GridBagConstraints.NORTH;
           
            gbc.anchor = GridBagConstraints.EAST;
            gbc.gridwidth = GridBagConstraints.FIRST_LINE_START;
            gbag.setConstraints(nameLabel, gbc);
            gbc.gridwidth = 0;
            gbc.anchor = GridBagConstraints.WEST;
            gbag.setConstraints(nameChoice, gbc);

            gbc.anchor = GridBagConstraints.EAST;
            gbc.gridwidth = GridBagConstraints.FIRST_LINE_START;
            gbag.setConstraints(resultLabel, gbc);
            gbc.gridwidth = 0;
            gbc.anchor = GridBagConstraints.WEST;
            gbag.setConstraints(resultText, gbc);
          }
   
    public void addIn()
    {
            add(nameLabel);
            add(nameChoice);
            add(resultLabel);
            add(resultText);
    }
}

---

Pretty much instead of my code having the part:

Code:

---

if(name.equals("Choice One"))
  choices = 1;
else if(name.equals("Choice Two"))
  choices = 2;

---

I want the applet to get the value of choice somehow in the database without having the if else statements because its around 2,000 choices and coding it would take an insanely long time.

I write code to write the choice as formatted java source code, then open it in the editor. For what you are asking there are almost always Selection.getIndex() methods which return an int. That can be used to index an array or a Collection.

Writing SQL statments may be done directly in the applet code as however they are normally done.

Quote:

---

Originally Posted by Bomber_Will

I made an applet using Java, but now I want it to read information from a MySQL Database.

---

Where does the MySql database live? On the same machine as the browser?

Why are you using applets for this? Applets live in a sandbox that prohibits tons of things.

OT: Actually, I don't understand why anyone uses applets for anything this century.

Applets are simple for me to make and manipulate. The database should be in the same machine thats hosting the website the applet is in.

"hello World!"

Quote:

---

Originally Posted by kaybest

"hello World!"

---

And clearly new to forums. What you did is called "thread hijacking" where one posts stuff clearly unrelated to the topic at hand. Its is bad form, impolite, etc.

There is a forum section for introductions. Post your statement there, not here