AppletJDBCDrop.java Source code

Introduction

Here is the source code for AppletJDBCDrop.java
Source

/*
    
MySQL and Java Developer's Guide
    
Mark Matthews, Jim Cole, Joseph D. Gradecki
Publisher Wiley,
Published February 2003, 
ISBN 0471269239
    
*/

import java.awt.BorderLayout;
import java.awt.Container;
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.SQLException;
import java.sql.Statement;
import java.util.Vector;

import javax.swing.JApplet;
import javax.swing.JButton;
import javax.swing.JList;
import javax.swing.JScrollPane;

public class AppletJDBCDrop extends JApplet implements ActionListener {

    private Connection connection;

    private JList tableList;

    private JButton dropButton;

    public void init() {
        Connection connection;
        try {
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            connection = DriverManager
                    .getConnection("jdbc:mysql://192.168.1.25/accounts?user=spider&password=spider");
        } catch (Exception connectException) {
            connectException.printStackTrace();
        }

        Container c = getContentPane();
        tableList = new JList();
        loadTables();
        c.add(new JScrollPane(tableList), BorderLayout.NORTH);

        dropButton = new JButton("Drop Table");
        dropButton.addActionListener(this);
        c.add(dropButton, BorderLayout.SOUTH);
    }

    public void actionPerformed(ActionEvent e) {
        try {
            Statement statement = connection.createStatement();
            ResultSet rs = statement.executeQuery("DROP TABLE " + tableList.getSelectedValue());
        } catch (SQLException actionException) {
        }
    }

    private void loadTables() {
        Vector v = new Vector();
        try {
            Statement statement = connection.createStatement();
            ResultSet rs = statement.executeQuery("SHOW TABLES");

            while (rs.next()) {
                v.addElement(rs.getString(1));
            }
            rs.close();
        } catch (SQLException e) {
        }
        v.addElement("acc_acc");
        v.addElement("acc_add");
        v.addElement("junk");
        tableList.setListData(v);
    }
}

/*
    
<html>
<applet code="Drop.class" width=200 height=200>
</applet>
</html>
    
*/