import java.awt.*;
import java.awt.event.*;
import javax.swing.JApplet;
import javax.swing.JFrame;
import javax.swing.*;
import javax.swing.SwingUtilities;
import javax.swing.tree.DefaultMutableTreeNode;
import java.sql.*;
import java.util.Properties;

public class RevisionTreeEngine extends JPanel implements ActionListener
{
    private static final String dbconnection = "com.mysql.jdbc.Driver";
    private static final String URL          = "jdbc:mysql://127.0.0.1:3306/cs205";
    private static final String REFRESH_CMD  = "refresh";
    private static final String REFRESH_LBL  = "Refresh/Update";
    private static final int    SIZE_X       = 300;
    private static final int    SIZE_Y       = 150;
    private JPanel       menuPanel;
    private JButton      refresh_btn;
    private RevisionTree treePanel;
    private Connection   conn;

    public RevisionTreeEngine()
    {
        super(new BorderLayout());
        treePanel   = new RevisionTree();
        menuPanel   = new JPanel(new GridLayout(0,3));

        refresh_btn = new JButton(REFRESH_LBL);
        treePanel.setPreferredSize(new Dimension(SIZE_X, SIZE_Y));
        add(treePanel, BorderLayout.CENTER);

        refresh_btn.setActionCommand(REFRESH_CMD);
        refresh_btn.addActionListener(this);
        menuPanel.add(refresh_btn);
        add(menuPanel, BorderLayout.SOUTH);

        openConnection();
        refreshTree();
    }


    private void openConnection()
    {
        try {
            Properties p = new Properties();
            p.put("user", "******");
            p.put("password","******");
            Class.forName("com.mysql.jdbc.Driver").newInstance();
            conn =  DriverManager.getConnection(URL, p);
        } catch (ClassNotFoundException ex) {
            System.err.println(ex.getMessage());
    } catch (IllegalAccessException ex) {
            System.err.println(ex.getMessage());
        } catch (InstantiationException ex) {
            System.err.println(ex.getMessage());
        } catch (SQLException ex) {
            System.err.println(ex.getMessage());
            System.out.println("Failed in SQLException");
        }
    }

    private void refreshTree()
    {
        try {
            treePanel.clear();
            String query =  "select * from project";
            System.out.println("Getting here 3");
            Statement st = conn.createStatement();
            System.out.println("Getting here 4");
            ResultSet rs = st.executeQuery(query);
            while (rs.next()) {
                int id = rs.getInt("id");
                int uid = rs.getInt("uid");
                double lng = rs.getFloat("lng");
                double lat = rs.getFloat("lat");
                String desc = "Node " + id + " by user " + uid + " at lng/lat: " + lng + "/" + lat + "";
                treePanel.addObject(null, desc);
            }
            st.close();
        } catch (SQLException ex) {
            System.err.println(ex.getMessage());
            System.out.println("Failed in SQLException");
        }
    }

    private static void createAndShowGUI()
    {
        //Create and set up the window.

        JFrame frame = new JFrame("RevisionTreeEngine");
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);

        //Create and set up the content pane.

        RevisionTreeEngine newContentPane = new RevisionTreeEngine();
        newContentPane.setOpaque(true); //content panes must be opaque

        frame.setContentPane(newContentPane);

        //Display the window.
                                                                                                                              frame.pack();
        frame.setVisible(true);
    }


    // called when run as an application
    /*
    public static void main(String[] args)
    {
        //Schedule a job for the event-dispatching thread:
        //creating and showing this application's GUI.
    javax.swing.SwingUtilities.invokeLater(new Runnable()
    {
        public void run()
        {
            createAndShowGUI();
        }
    });
    }
    */
}

//========================

import java.applet.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.JFrame;
import javax.swing.JApplet;
import javax.swing.SwingUtilities;
import java.sql.*;
import java.util.Properties;
import javax.swing.tree.DefaultMutableTreeNode;

public class RevisionTreeApplet extends JApplet
{
    private RevisionTreeEngine  app;

    public void init()
    {
        //Execute a job on the event-dispatching thread; creating this applet's GUI.

        try {
            SwingUtilities.invokeAndWait(new Runnable()
                {
                    public void run()
                    {
                        createGUI();
                    }
                });
        } catch (Exception e) {
            System.err.println("createGUI didn't complete successfully");
        }
    }

    private void createGUI()
    {
        //Create and set up the content pane.

        app = new RevisionTreeEngine();
        app.setOpaque(true);
        setContentPane(app);
    }
}