FMCSAApplet (Java)

import java.applet.*;
import java.awt.*;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;
import java.util.ArrayList;

import javax.swing.*;
import javax.swing.table.DefaultTableModel;


public class FMCSAApplet extends Applet implements ActionListener {

    String database="fmcsa";
    String username="root";
    String password="password";
    String table="motorcoaches";
    String zipcode;

    Label lab1;
    TextField t1;
    Button submitButton;
    MDTable aTable;

    public void init()
    {
        setLayout(new FlowLayout());
        submitButton = new Button("Submit");
        lab1 = new Label("Enter a zipcode:");
        t1 = new TextField(15);

        add(lab1);
        add(t1);
        add(submitButton);
        submitButton.addActionListener(this);
    }

    public void paint(Graphics g)
    {
        g.drawString("Zip code: "+zipcode,30,100);
        if(zipcode!=null) {
            g.drawString("dotNum\t inputZip\t name\t\t city\t state\t mileage\t unsafe\t fatigued\t fitness\t substance\t maintenance\t inspections",30,120);
            try {
                String url = "jdbc:mysql://localhost:3306/"+database;
                Connection con = DriverManager.getConnection( url, username, password );

                Statement stmt = con.createStatement();
                stmt.execute("USE "+database );
                // get list of tables in current database
                stmt.executeQuery ("SELECT * FROM "+table+";");
                ResultSet rs = stmt.getResultSet();
                int i = 120;
                ArrayList<MData> mdList = new ArrayList<MData>();;
                while (rs.next()) {
                    i = i+20;
                    int dotNum=rs.getInt(1);
                    int inputZip=rs.getInt(2);
                    String name=rs.getString(3);
                    String city=rs.getString(4);
                    String state=rs.getString(5);
                    int mileage=rs.getInt(6);
                    int unsafe=rs.getInt(7);
                    int fatigued=rs.getInt(8);
                    int fitness=rs.getInt(9);
                    int substance=rs.getInt(10);
                    int maintenance=rs.getInt(11);
                    int inspections=rs.getInt(12);
                    int zipcodeToInt = Integer.parseInt( zipcode );
                    if (inputZip==zipcodeToInt) {
                        MData motorcoach = new MData(dotNum, inputZip, name, city, state, mileage, unsafe, fatigued, fitness, substance, maintenance, inspections);
                        mdList.add(motorcoach);
                    }
                } // end while
                rs.close();

                aTable = new MDTable(mdList);
                add( aTable );

            }catch (Exception f) {
                System.out.println(f);
            }
        }
    }

    public void actionPerformed(ActionEvent evt)
    {
// Here we will ask what component called this method
         if (evt.getSource() == submitButton) {
             zipcode = t1.getText();
             repaint();
         }
    }

    public boolean action(Event e,Object o)
    {
        zipcode = t1.getText();
        repaint();
        return true;
    }

}

class MDTable extends JPanel {
    public MDTable(ArrayList<MData> md) {
        Object[][] cellData = {
            {1,2,"3","4","5",6,7,8,9,10,11,12}
        };

        String[] columnNames = {"dotNum","inputZip", "name","city","state","mileage","unsafe","fatigued","fitness","substance","maintenance","inspections"};
        add(  new JTable(cellData, columnNames) ) ;
        DefaultTableModel model = new DefaultTableModel(cellData,columnNames);
        JTable table = new JTable(model);
        for (MData md1 : md) {
            model.insertRow(table.getRowCount(),new Object[]{md1.getDotNum(), md1.getInputZip(), md1.getName(), md1.getCity(), md1.getState(), md1.getMileage(), md1.getUnsafe(), md1.getFatigued(), md1.getFitness(), md1.getSubstance(), md1.getMaintenance(), md1.getInspections()});
        }
    }
}

class MData {
    private int dotNum;
    private int inputZip;
    private String name;
    private String city;
    private String state;
    private int mileage;
    private int unsafe;
    private int fatigued;
    private int fitness;
    private int substance;
    private int maintenance;
    private int inspections;

    public MData(int d, int i, String n, String c, String s, int m, int u, int f, int fi, int su, int ma, int in)
      {
            dotNum = d;
            inputZip = i;
            name = n;
            city = c;
            state=s;
            mileage=m;
            unsafe=u;
            fatigued=f;
            fitness=fi;
            substance=su;
            maintenance=ma;
            inspections=in;
      }

    public int getDotNum() {
        return dotNum;
    }
    public int getInputZip() {
        return inputZip;
    }
    public String getName() {
        return name;
    }
    public String getCity() {
        return city;
    }
    public String getState() {
        return name;
    }
    public int getMileage() {
        return mileage;
    }
    public int getUnsafe() {
        return unsafe;
    }
    public int getFatigued() {
        return fatigued;
    }
    public int getFitness() {
        return fitness;
    }
    public int getSubstance() {
        return substance;
    }
    public int getMaintenance() {
        return maintenance;
    }
    public int getInspections() {
        return inspections;
    }
}