package se.ltu.d0007n;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import javax.faces.bean.ManagedBean;
import javax.faces.bean.ViewScoped;

/**
 *
 * @author Erik
 */
@ManagedBean(name = "megaBean")

@ViewScoped
public class MegaBean {

    private String studentID = "";
    private String kurskod = "";
    private String termin = "";
    private String provnr = "";
    private String betyg = "";

    public String testmessage = "hej";

    public String getTestmessage() {
        return testmessage;
    }

    public void setTestmessage(String testmessage) {
        this.testmessage = testmessage;
    }




    Connection connect;
    Statement stmt;
    ResultSet rs;
    /**
     * Creates a new instance of StudentBean
     */
    public MegaBean() {

    }




    public String getStudentID() {
        return studentID;
    }

    public void setStudentID(String studentID) {
        this.studentID = studentID;
    }

    public String getKurskod() {
        return kurskod;
    }

    public void setKurskod(String kurskod) {
        this.kurskod = kurskod;
    }

    public String getTermin() {
        return termin;
    }

    public void setTermin(String termin) {
        this.termin = termin;
    }

    public String getBetyg() {
        return betyg;
    }

    public void setBetyg(String betyg) {
        this.betyg = betyg;
    }

    public String getProvnr() {
        return provnr;
    }

    public void setProvnr(String provnr) {
        this.provnr = provnr;
    }



    public void addResult(){

        testmessage = "hejx2";

        try{
            String hostname = "jdbc:mysql://localhost:3306/test";
            String user = "root";
            String password = "password";
            connect = DriverManager.getConnection(hostname, user, password);

            if (connect != null) {
                testmessage = "Connected to the database test1";
            }
            else{
                testmessage = "poop";
            }

            try{
            Statement statement = connect.createStatement();
            statement.executeUpdate(
            "INSERT INTO `resultat` (`resultatID`, `studentID`, `kurskod`, `termin`, `provnr`, `betyg`) VALUES ('2', 'eriped-3', 'D0006N', 'HT2015', '3', 'VG');");
            }
            catch (SQLException ex) {

                testmessage = "testing123";
                System.out.println(ex.getMessage());
            }
        }
        catch (SQLException ex) {
              testmessage = "testing123456";
            System.out.println(ex.getMessage());
        }





    }
}