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


public class DataController{

private Connection dbConnection;
private Statement stmt;

private LoginFrame loginFrame;
private EntryFrame entryFrame;

private int idNum = 1;

public DataController(LoginFrame loginFrame){
    this.loginFrame = loginFrame;
}



public void connect(JTextField nameField, JPasswordField passField, JTextField serverField, JTextField dbNameField){

        String username = nameField.getText();
        String password = new String(passField.getPassword());
        String server = serverField.getText();
        String dbName = dbNameField.getText();
        String url = "jdbc:mysql://"+ server +"/" + dbName;

        try{

            Class.forName("com.mysql.jdbc.Driver").newInstance();
            dbConnection = DriverManager.getConnection(url, username, password);

            stmt = dbConnection.createStatement();

            stmt.executeUpdate("DROP TABLE personTabell");

            stmt.executeUpdate(
                "CREATE TABLE personTabell(person_id int, "+
                    "person_namn char(30), " +
                        "person_epost char(30), "+
                            "person_hemsida char(50), "+
                                "person_kommentar char(50))");

        }catch(ClassNotFoundException cnfe){
            System.err.println("Class not found");
        }catch(InstantiationException ie){
            System.err.println("InstantiationException");
        }catch(SQLException sqle){
            System.err.println(sqle.getMessage());
        }catch(IllegalAccessException iae){
            System.err.println("Illegal access exception");
        }catch(Exception e){
        System.err.println("Table personTabell does not exists");
        }

        loginFrame.setVisible(false);
        entryFrame = new EntryFrame(this);
}


public void addData(JTextField nameField, JTextField mailField, JTextField homepageField, JTextField commentField, JTextArea displayArea){

    String name = nameField.getText();
    String mail = mailField.getText();
    String homepage = mailField.getText();
    String comment = commentField.getText();
    idNum += 1;



    try{
        stmt.executeUpdate("INSERT INTO personTabell (person_id, " +
                                                        "person_namn, " +
                                                            "person_epost, " +
                                                                "person_hemsida, " +
                                                                    "person_kommentar) VALUES(idNum, name, mail, homepage, comment)");
    }catch(SQLException sqle){
        System.err.println(sqle.getMessage());
    }

    appendData(idNum, name, mail, homepage, comment, displayArea);

}

public void displayData(JTextArea displayArea){

    ResultSet resultSet;

    try{
        Statement statement = dbConnection.createStatement(
                        ResultSet.TYPE_SCROLL_INSENSITIVE,
                            ResultSet.CONCUR_READ_ONLY);


        resultSet = statement.executeQuery("SELECT * " + "from personTabell ORDER BY person_id");



        while(resultSet.next()){
            int id = resultSet.getInt("person_id");
            String name = resultSet.getString("person_namn");
            String mail = resultSet.getString("person_epost");
            String homepage = resultSet.getString("person_hemsida");
            String comment = resultSet.getString("person_kommentar");

            if(id >= idNum){
                idNum = id+1;
            }
            appendData(id, name, mail, homepage, comment, displayArea);


        }
    }catch(SQLException sqle){
        System.err.println("SQLException");
    }
}

private void appendData(int id, String name, String mail, String homepage, String comment, JTextArea displayArea){
    //add htmlcheck here
    //Make this an SQL statement...
    displayArea.append("ID:"+ id+"\nNAME: "+name+" EMAIL: "+
                            mail+" HOMEPAGE: "+homepage+"\n COMMENT: "+
                            comment+"\n");
}

}