sign up

package application;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.time.LocalDate;

import javafx.event.ActionEvent;
import javafx.event.EventHandler;
import javafx.geometry.Insets;
import javafx.geometry.Pos;
import javafx.scene.Scene;
import javafx.scene.control.Alert;
import javafx.scene.control.Alert.AlertType;
import javafx.scene.control.Button;
import javafx.scene.control.ButtonType;
import javafx.scene.control.ChoiceBox;
import javafx.scene.control.DatePicker;
import javafx.scene.control.PasswordField;
import javafx.scene.control.TextField;
import javafx.scene.layout.GridPane;
import javafx.scene.text.Text;
import javafx.stage.Stage;

public class SignUp extends Stage{

    public  SignUp(Stage prev) {
        Stage current = this;
        setAttribute(current , prev);

    }

    void setAttribute(Stage current , Stage prev) {
        Text userName = new Text("user Name ");
        Text pass = new Text("password ");
        Text creditCard = new Text("credit number ");
        Text FName = new Text("first name ");
        Text Lname = new Text("last name ");
        Text phone = new Text("phone number ");
        Text shippingAddress = new Text("shipping address ");
        Text EMail = new Text("E-mai");
        Text expiredDate = new Text("expiredDate");
        TextField userNameField = new TextField();
        PasswordField passField = new PasswordField();
        TextField creditField = new TextField();
        TextField firstNameField = new TextField();
        TextField lastNameField = new TextField();
        TextField phoneField = new TextField();
        TextField shippingField = new TextField();
        TextField EMailField = new TextField();
        DatePicker  expiredDateField = new DatePicker ();

        Text signUpChoice = new Text("sign up as :");
        ChoiceBox signUpChoiceBox = new ChoiceBox();
        signUpChoiceBox.getItems().addAll( "User","Manager");
        signUpChoiceBox.getSelectionModel().selectFirst();


        Button signUpButton = new Button("sign up");
        Button back = new Button("back");
        GridPane gridPane2 = new GridPane();

        gridPane2.setMinSize(600, 400);
        gridPane2.setPadding(new Insets(10, 10, 10, 10));

        // Setting the vertical and horizontal gaps between the columns
        gridPane2.setVgap(30);
        gridPane2.setHgap(30);

        // Setting the Grid alignment
        gridPane2.setAlignment(Pos.CENTER);

        // Arranging all the nodes in the grid

        gridPane2.add(userName, 0, 0);
        gridPane2.add(userNameField, 1, 0);
        gridPane2.add(pass, 0, 1);
        gridPane2.add(passField, 1, 1);
        gridPane2.add(FName, 0, 2);
        gridPane2.add(firstNameField, 1, 2);
        gridPane2.add(Lname, 0, 3);
        gridPane2.add(lastNameField, 1, 3);
        gridPane2.add(phone, 0, 4);
        gridPane2.add(phoneField, 1, 4);
        gridPane2.add(EMail, 0, 5);
        gridPane2.add(EMailField, 1, 5);
        gridPane2.add(shippingAddress, 0, 6);
        gridPane2.add(shippingField, 1, 6);
        gridPane2.add(creditCard, 0, 7);
        gridPane2.add(creditField, 1, 7);
        gridPane2.add(expiredDate, 0, 8);
        gridPane2.add(expiredDateField, 1, 8);
        gridPane2.add(signUpChoice, 0, 9);
        gridPane2.add(signUpChoiceBox, 1, 9);
        gridPane2.add(signUpButton, 0, 10);
        gridPane2.add(back, 1, 10);

        // Styling nodes
        signUpButton.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
        back.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");

        userName.setStyle("-fx-font: normal bold 20px 'serif' ");
        pass.setStyle("-fx-font: normal bold 20px 'serif' ");
        FName.setStyle("-fx-font: normal bold 20px 'serif' ");
        Lname.setStyle("-fx-font: normal bold 20px 'serif' ");
        phone.setStyle("-fx-font: normal bold 20px 'serif' ");
        EMail.setStyle("-fx-font: normal bold 20px 'serif' ");
        shippingAddress.setStyle("-fx-font: normal bold 20px 'serif' ");
        creditCard.setStyle("-fx-font: normal bold 20px 'serif' ");
        signUpChoice.setStyle("-fx-font: normal bold 20px 'serif' ");
        expiredDate.setStyle("-fx-font: normal bold 20px 'serif' ");

        // Creating a scene object
        Scene scene2 = new Scene(gridPane2);

        // Setting title to the Stage
        setTitle("Sign Up ");

        // Adding scene to the stage
        setScene(scene2);




        back.setOnAction(new EventHandler<ActionEvent>() {
            @Override
            public void handle(ActionEvent event) {
                current.close();
                prev.show();


            }
        });

        signUpButton.setOnAction(new EventHandler<ActionEvent>()  {
            @Override
            public void handle(ActionEvent event) {
                int ID;
                String userName = userNameField.getText();
                String pass = passField.getText();
                String firstName =firstNameField.getText();
                String lastName = lastNameField.getText();
                String phone= phoneField.getText();
                String Email =EMailField.getText();
                String shipping =shippingField.getText();
                String numberOfCredit = creditField.getText();
                String type = (String) signUpChoiceBox.getValue();


                System.out.println(userName);
                System.out.println(pass);
                System.out.println(firstName);
                System.out.println(lastName);
                System.out.println(phone);
                System.out.println(Email);
                System.out.println(shipping);
                System.out.println(numberOfCredit);
                System.out.println(type);
                System.out.println(expiredDateField.getValue());





                    try {
                        Class.forName("com.mysql.jdbc.Driver") ;
                    } catch (ClassNotFoundException e1) {
                        // TODO Auto-generated catch block
                        e1.printStackTrace();
                    }

                Connection conn = null;
                try {
                    conn = DriverManager.getConnection("jdbc:mysql://localhost:3306/Online_Book_Store?useSSL=false", "root", "ahmed666");
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }
                try {
                    String query;
                    String selectQuery;
                    String IDQueryForManagers="select MAX(ID) as MID from MANAGERS";
                    String IDQueryForUsers="select MAX(ID) as MID from USERS";

                    PreparedStatement selectStmtForManager = conn.prepareStatement(IDQueryForManagers);
                    ResultSet resForManager=selectStmtForManager.executeQuery();

                    PreparedStatement selectStmtForUesr = conn.prepareStatement(IDQueryForUsers);
                    ResultSet resForUsers=selectStmtForUesr.executeQuery();

                    int IDUser=0;
                    int IDManager=0;
                    while(  resForUsers.next()) {
                         IDUser= resForUsers.getInt("MID") ;

                    }
                    while(resForManager.next()) {
                         IDManager= resForManager.getInt("MID") ;
                    }


                        ID = Math.max(IDUser, IDManager)+1;



                    if(type.equals("Manager")) {
                         query = "insert into MANAGERS values (?,?,?,?,?,?,?,?,?,?)" ;
                         selectQuery="select * from MANAGERS where USER_NAME = ?";
                    }else {
                         query = "insert into USERS values (?,?,?,?,?,?,?,?,?,?)" ;
                         selectQuery="select * from USERS where USER_NAME = ?";
                    }
                    PreparedStatement selectStmt = conn.prepareStatement(selectQuery);
                    selectStmt.setString(1, userName);
                    ResultSet res=selectStmt.executeQuery();




                    PreparedStatement stmt = conn.prepareStatement(query);
                    stmt.setInt(1, ID);
                    stmt.setString(2, userName);
                    stmt.setString(3, pass);
                    stmt.setString(4, firstName);
                    stmt.setString(5, lastName);
                    stmt.setString(6, phone);
                    stmt.setString(7, Email);
                    stmt.setString(8, shipping);
                    stmt.setString(9, numberOfCredit);
                    stmt.setObject(10, expiredDateField.getValue());

                    if(pass.isEmpty()) {
                        Alert alert = new Alert(AlertType.WARNING, "please enter password" , ButtonType.OK);
                        alert.showAndWait();
                    }else if (res.next()) {
                        Alert alert = new Alert(AlertType.WARNING, "dublicate user name " , ButtonType.OK);
                        alert.showAndWait();
                    }
                    else {
                        stmt.executeUpdate();

                    }
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }

                try {
                    conn.close();
                } catch (SQLException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                }


            }

        });



    }



}