/*
 * DBApplet.java
 *
 * Created on den 13 maj 2002, 21:55
 */

/**
 *
 * @author  h&m
 */

import java.sql.*;
import java.util.*;
import java.lang.Thread;
import java.applet.*;
import java.net.URL;
import java.net.MalformedURLException;
//import org.gjt.mm.mysql.*;

public class DBApplet extends java.applet.Applet implements DBApplets {    
    private String user = "";
    private String password = null;
    private DBConnection dbconn = null;
    private DBpw pwdialog = null;

    public void removeDbNode(String id, String lastInNodeId, String prevId, String nextId) {
        if(dbconn != null && dbconn.removeDbNode(id, lastInNodeId, prevId, nextId)) {
            yellow();
        }
    }
    
    public void addBookmarkNode(String id, String prevId, String nextId, String parentId, String name, String url) {
        if(dbconn != null) {
            dbconn.addBookmarkNode(id, prevId, nextId, parentId, name, url);
            yellow();
        }
    }
    
    public void addFolderNode(String id, String prevId, String nextId, String parentId, String name) {
        if(dbconn != null) {
            dbconn.addFolderNode(id, prevId, nextId, parentId, name);
            yellow();
        }
    }
    
    public void pasteNode(String id, String lastInNodeId, String prevId, String nextId, String parentId) {
        if(dbconn != null && dbconn.pasteNode(id, lastInNodeId, prevId, nextId, parentId)) {
            yellow();
        }
    }
        
    public void cancelUpdate() {
        if(dbconn != null) {
            dbconn.cancelUpdate();
            green();
        }
    }
    
    public void setExpanded(String id, boolean expanded) {
        if(dbconn != null) {
            if(dbconn.setExpanded(id, expanded)) {
                yellow();
            } else {
                green();
            }
        }
    }
    
    public boolean dbupdate() {
        if(dbconn != null) {
            red();
            if(dbconn.dbupdate()) {
                green();
                return true;
            } else {
                label.setText("error!!!");
                return false;
            }
        }
        label.setText("dbApplet not loaded!");
        return false;
    }
    
    public void destroy() {
        if(dbconn != null && dbconn.destroy()) {}
    }

    /** Initializes the applet DBApplet */
    public void init() {
        user = getParameter("user");
        initComponents();
        green.setBackground(java.awt.Color.white);
        yellow.setBackground(java.awt.Color.white);
        red.setBackground(java.awt.Color.white);
        red();
        label.setText("connecting...");
        DBLoader tmp = new DBLoader(this);
        tmp.start();
    }

    /** This method is called from within the init() method to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    private void initComponents() {//GEN-BEGIN:initComponents
        panel = new java.awt.Panel();
        label = new java.awt.Label();
        green = new java.awt.Panel();
        yellow = new java.awt.Panel();
        red = new java.awt.Panel();
        
        setLayout(new java.awt.BorderLayout());
        
        setBackground(java.awt.Color.black);
        panel.setLayout(new java.awt.GridBagLayout());
        java.awt.GridBagConstraints gridBagConstraints1;
        
        panel.setBackground(java.awt.Color.black);
        label.setBackground(java.awt.Color.white);
        label.setText("data unsaved");
        gridBagConstraints1 = new java.awt.GridBagConstraints();
        gridBagConstraints1.gridx = 0;
        gridBagConstraints1.gridy = 1;
        gridBagConstraints1.gridwidth = 3;
        gridBagConstraints1.fill = java.awt.GridBagConstraints.HORIZONTAL;
        gridBagConstraints1.insets = new java.awt.Insets(0, 1, 1, 1);
        gridBagConstraints1.weightx = 1.0;
        panel.add(label, gridBagConstraints1);
        
        gridBagConstraints1 = new java.awt.GridBagConstraints();
        gridBagConstraints1.fill = java.awt.GridBagConstraints.BOTH;
        gridBagConstraints1.insets = new java.awt.Insets(1, 1, 1, 1);
        gridBagConstraints1.weightx = 1.0;
        gridBagConstraints1.weighty = 1.0;
        panel.add(green, gridBagConstraints1);
        
        gridBagConstraints1 = new java.awt.GridBagConstraints();
        gridBagConstraints1.fill = java.awt.GridBagConstraints.BOTH;
        gridBagConstraints1.insets = new java.awt.Insets(1, 1, 1, 1);
        gridBagConstraints1.weightx = 1.0;
        gridBagConstraints1.weighty = 1.0;
        panel.add(yellow, gridBagConstraints1);
        
        gridBagConstraints1 = new java.awt.GridBagConstraints();
        gridBagConstraints1.fill = java.awt.GridBagConstraints.BOTH;
        gridBagConstraints1.insets = new java.awt.Insets(1, 1, 1, 1);
        gridBagConstraints1.weightx = 1.0;
        gridBagConstraints1.weighty = 1.0;
        panel.add(red, gridBagConstraints1);
        
        add(panel, java.awt.BorderLayout.CENTER);
        
    }//GEN-END:initComponents

    public void green() {
        showStatus("data base are updated");
        green.setBackground(java.awt.Color.green);
        yellow.setBackground(java.awt.Color.white);
        red.setBackground(java.awt.Color.white);
        label.setText("data saved");
    }    

    public void yellow() {
        showStatus("data base needs to be updated");
        green.setBackground(java.awt.Color.white);
        yellow.setBackground(java.awt.Color.yellow);
        red.setBackground(java.awt.Color.white);
        label.setText("data unsaved");
    }    

    public void red() {
        showStatus("updateing data base");
        green.setBackground(java.awt.Color.white);
        yellow.setBackground(java.awt.Color.white);
        red.setBackground(java.awt.Color.red);
        label.setText("saving data");
    }
    
    public void progress(int p) {
        label.setText(p + "% saved");
    }
    
    public void error(String e) {
        label.setText(e);
    }
    
    public void setPassword(String pw) {
        if(!dbconn.setPassword(pw)) {
            pwdialog.hide();
            pwdialog.dispose();
            try {
                getAppletContext().showDocument(new URL("http://atlas.dsv.su.se/~henrik-j/ip3/u7/error.cgi?id=" + user), "_self");
            } catch (MalformedURLException e) {
                label.setText("error");
            }
        }
        pwdialog.hide();
        pwdialog.dispose();
        green();
        label.setText("db connected");
    }
    
    private class DBLoader extends Thread {
        DBApplets parent;
        
        DBLoader(DBApplets parent) {
            this.parent = parent;
        }
        
        public void run() {
            dbconn = new DBConnection(parent, user);
            pwdialog = new DBpw(parent, "jossa70");
            pwdialog.show();
        }
    }
    
    // Variables declaration - do not modify//GEN-BEGIN:variables
    private java.awt.Panel panel;
    private java.awt.Label label;
    private java.awt.Panel green;
    private java.awt.Panel yellow;
    private java.awt.Panel red;
    // End of variables declaration//GEN-END:variables

}