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


public class BirthdayApplet extends JApplet {
    
    Connection conn;
    

    
    public void init()
    {
        setLayout(new FlowLayout());
        JButton test = new JButton("Click Me!");
        testButton happy = new testButton();
        test.addActionListener(happy);
        add(test);
        try
        {    
            // Load the driver
            Class.forName("org.gjt.mm.mysql.Driver").newInstance();
            // Connect to the database
            conn = DriverManager.getConnection("jdbc:mysql://mysql9.ixwebhosting.com/net20_java", "mat2", "yay1");
            

        }
        catch (Exception e) {add(new JLabel(e.getMessage()));}
    }
    
    public void start()
    {
        
    }
    
    public void stop()
    {
        
    }
    
    public void destroy()
    {
        
    }
    
    private class testButton implements ActionListener
    {
        public void actionPerformed(ActionEvent e)
        {
            try {
                conn.createStatement().execute("INSERT INTO `people` (`name`, `address`) VALUES ('Start Here', '52 Woot Ave')");
            } catch (SQLException e1) {
                // TODO Auto-generated catch block
                e1.printStackTrace();
            } //Insert a row
            
        }
    }

}