import javax.swing.*;
import java.awt.event.*;
import java.awt.*;
import java.sql.*;

public class MimerApplet extends JApplet implements ActionListener {
    public void actionPerformed (ActionEvent event) {
        try {
            Class.forName("com.mimer.jdbc.Driver");
            String url = "jdbc:mimer://bengt:soptipp@basen.oru.se/bilbasen";
            Connection con = DriverManager.getConnection(url);
            Statement stmt = con.createStatement();
            String sql = "select number, name from person where number < 4";
            ResultSet rs = stmt.executeQuery(sql);
            text.setText("Personer:\n");
            while (rs.next()) {
                int number = rs.getInt(1);
                String name = rs.getString(2);
                text.append("Person nummer " + number + " heter " + name + ".\n");
            }
            rs.close();
            stmt.close();
            con.close();
        }
        catch (SQLException sqle) {
            while (sqle != null) {
                text.setText("SQLException:\n");
                text.append("    SQLState: " + sqle.getSQLState() + "\n");
                text.append("    Message: " + sqle.getMessage() + "\n");
                text.append("    ErrorCode: " + sqle.getErrorCode() + "\n");
                sqle = sqle.getNextException();
            }
        } catch (Exception exc) {
            text.setText("Other Exception:\n");
            text.append(exc.toString() + "\n");
        }
    } // actionPerformed

    private JTextArea text;

    public void init() {
        Container cp = getContentPane();
        cp.setLayout(new FlowLayout());
        cp.add(new JLabel("En applet som hämtar data om personer"));
        text = new JTextArea("Här kommer personerna att skrivas ut", 6, 30);
        cp.add(new JScrollPane(text));
        JButton runButton = new JButton("Hämta data");
        runButton.addActionListener(this);
        cp.add(runButton);
    } // init

    public static void main(String[] args) {
        MimerApplet applet = new MimerApplet();
        JFrame frame = new JFrame("MimerApplet");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.getContentPane().add(applet);
        frame.setSize(400, 200);
        applet.init();
        applet.start();
        frame.setVisible(true);
    } // main
} // class MimerApplet