package myapp.hello;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;

import org.apache.wicket.markup.html.WebPage;
import org.apache.wicket.markup.html.form.Form;
import org.apache.wicket.markup.html.form.PasswordTextField;
import org.apache.wicket.markup.html.form.TextField;
import org.apache.wicket.model.Model;

public class LogIn extends WebPage {

    private Model userNameModel = new Model("");
    private Model passwordModel = new Model("");


    public LogIn(){
        Form form1 = new Form("logInForm"){

            protected void onSubmit(){

                String  userName = (String)userNameModel.getObject();
                String  passWord = (String) passwordModel.getObject();

                try {
                    doLogIn(userName, passWord);
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
            }
        };



        form1.add(new TextField("username", userNameModel));
        form1.add(new PasswordTextField("password", passwordModel));
        add(form1);


    }


    private void doLogIn(String username, String password) throws SQLException{


        try{

            Class.forName("org.postgresql.Driver");
            Connection conn = DriverManager.getConnection(
                                    "jdbc:postgresql://localhost/FMSDatabase",
                                    "FMS",
                                    "fms");

            try{
                PreparedStatement st = conn.prepareStatement(
                        "insert into logindb values (?,?);");

                try{

                    st.setString(1, username);
                    st.setString(2, password);
                    st.addBatch();
                    conn.setAutoCommit(false);
                    st.executeBatch();
                    conn.setAutoCommit(true);

                }catch(SQLException e){
                    while(e.getNextException()!=null){
                        e.printStackTrace();
                        e = e.getNextException();
                    }
                        throw e;
                    }






            } finally{ conn.close();}


        }catch(Exception e){
            throw new RuntimeException(e);
        }





    }












}