View difference between Paste ID: JGVE023z and REJdABmX

 package application;
 
 import java.sql.Connection;
 import java.sql.DriverManager;
 import java.sql.PreparedStatement;
 import java.sql.ResultSet;
-import java.util.ArrayList;
+
 
-import com.mysql.jdbc.PreparedStatement;
+import com.mysql.cj.jdbc.integration.jboss.ExtendedMysqlExceptionSorter;
 
 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;
-public class Cart extends Stage {
+import javafx.scene.control.ChoiceBox;
-	public Cart(Stage prev , String userName) {
+import javafx.scene.control.PasswordField;
-		Stage current = this;
+import javafx.scene.control.TextField;
-		java.util.List<Button> list = new ArrayList<Button>();
+
-		GridPane gridPane = new GridPane();
+
-		int counter =0;
+
-		try {
+
-			ResultSet rs;
+public class SignUp extends Stage{
-  		    Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/Online_Book_Store?useSSL=false", "root", "ahmed666" );
+
-			PreparedStatement p = (PreparedStatement) con.prepareStatement("select * from CART where USER_NAME='"+userName+"'");
+	public  SignUp(Stage stage,Scene scene) {
-			rs = p.executeQuery();
+		setAttribute(stage,scene);
-			while(rs.next()) {
+
-		           list.add(new Button("Purchase"));
+
-				   list.get(counter).setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
+
-				   Text ISBN = new Text(Integer.toString(rs.getInt("ISBN")));
+	void setAttribute(Stage stage,Scene scene) {
-				   Text copies = new Text(Integer.toString(rs.getInt("COPIES")));
+		Text userName = new Text("user Name ");
-				   ISBN.setStyle("-fx-font: normal italic 15px 'serif' ");
+		Text pass = new Text("password ");
-				   copies.setStyle("-fx-font: normal italic 15px 'serif' ");
+		Text creditCard = new Text("credit number ");
-				   gridPane.add(ISBN,0,counter+1);
+		Text FName = new Text("first name ");
-				   gridPane.add(copies,1,counter+1);
+		Text Lname = new Text("last name ");
-				   gridPane.add(list.get(counter),(400/30) ,counter+1);
+		Text phone = new Text("phone number ");
-
+		Text shippingAddress = new Text("shipping address ");
-
+		Text EMail = new Text("E-mai");
-				   // Purchasing handling
+		TextField userNameField = new TextField();
-				   Button b;
+		PasswordField passField = new PasswordField();
-				   b =  list.get(counter);
+		TextField creditField = new TextField();
-
+		TextField firstNameField = new TextField();
-				   list.get(counter).setOnAction(new EventHandler<ActionEvent>() {
+		TextField lastNameField = new TextField();
-			            @Override
+		TextField phoneField = new TextField();
-			            public void handle(ActionEvent event) {
+		TextField shippingField = new TextField();
-			            	// connect to db
+		TextField EMailField = new TextField();
-			            	  try {
+
-			            		  String c = copies.getText();
+		Text signUpChoice = new Text("sign up as :");
-			            		  String i = ISBN.getText();
+		ChoiceBox signUpChoiceBox = new ChoiceBox();
-			            		  Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/Online_Book_Store?useSSL=false", "root", "ahmed666" );
+		signUpChoiceBox.getItems().addAll( "User","Manager");
-			          			  PreparedStatement p = (PreparedStatement) con.prepareStatement("update BOOK_STORE set BOOK_COPIES = BOOK_COPIES - "+c+
+		signUpChoiceBox.getSelectionModel().selectFirst();
-			          			  		" where ISBN = "+i);
+
-			          			  p.executeUpdate();
+
-			          			  p = (PreparedStatement) con.prepareStatement("delete from CART where ISBN = "+i+" and USER_NAME = '"+userName+"'");
+		Button signUpButton = new Button("sign up");
-			          			  p.executeUpdate();
+		Button back = new Button("back");
-			          			  b.setDisable(true);
+		GridPane gridPane2 = new GridPane();
-
+
-			          		  }
+		gridPane2.setMinSize(600, 400);
-			            	  catch (SQLException e) {
+		gridPane2.setPadding(new Insets(10, 10, 10, 10));
-			            		  // TODO Auto-generated catch block
+
-			          			  e.printStackTrace();
+		// 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
-				   counter++;
+
 		gridPane2.add(userName, 0, 0);
-
+		gridPane2.add(userNameField, 1, 0);
-		}
+		gridPane2.add(pass, 0, 1);
-  	    catch (SQLException e) {
+		gridPane2.add(passField, 1, 1);
-  		    // TODO Auto-generated catch block
+		gridPane2.add(FName, 0, 2);
-  	    	e.printStackTrace();
+		gridPane2.add(firstNameField, 1, 2);
-	    }
+		gridPane2.add(Lname, 0, 3);
 		gridPane2.add(lastNameField, 1, 3);
 		gridPane2.add(phone, 0, 4);
-		//back button
+		gridPane2.add(phoneField, 1, 4);
-	   	Button back = new Button("Back");
+		gridPane2.add(EMail, 0, 5);
-	   	back.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
+		gridPane2.add(EMailField, 1, 5);
-	   	gridPane.add(back, 0, 400/30);
+		gridPane2.add(shippingAddress, 0, 6);
-	    back.setOnAction(new EventHandler<ActionEvent>() {
+		gridPane2.add(shippingField, 1, 6);
-            @Override
+		gridPane2.add(creditCard, 0, 7);
-            public void handle(ActionEvent event) {
+		gridPane2.add(creditField, 1, 7);
-            	current.close();
+		gridPane2.add(signUpChoice, 0, 8);
-            	prev.show();
+		gridPane2.add(signUpChoiceBox, 1, 8);
-            }
+		gridPane2.add(signUpButton, 0, 9);
-        });
+		gridPane2.add(back, 1, 9);
-
+
-	    //Setting size for the pane
+		// Styling nodes
-	    gridPane.setMinSize(600, 400);
+		signUpButton.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
-
+		back.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
-	    //Setting the padding
+
-	    gridPane.setPadding(new Insets(10, 10, 10, 10));
+		userName.setStyle("-fx-font: normal bold 20px 'serif' ");
-
+		pass.setStyle("-fx-font: normal bold 20px 'serif' ");
-	    //Setting the vertical and horizontal gaps between the columns
+		FName.setStyle("-fx-font: normal bold 20px 'serif' ");
-	    gridPane.setVgap(30);
+		Lname.setStyle("-fx-font: normal bold 20px 'serif' ");
-	    gridPane.setHgap(30);
+		phone.setStyle("-fx-font: normal bold 20px 'serif' ");
 		EMail.setStyle("-fx-font: normal bold 20px 'serif' ");
-		if(counter == 0 ) {
+		shippingAddress.setStyle("-fx-font: normal bold 20px 'serif' ");
-			Text noRes = new Text("Cart is Empty");
+		creditCard.setStyle("-fx-font: normal bold 20px 'serif' ");
-			gridPane.add(noRes,600/120 , 400/60 );
+		signUpChoice.setStyle("-fx-font: normal bold 20px 'serif' ");
-			noRes.setStyle("-fx-font: normal bold 20px 'serif' ");
+
-		}
+		// Creating a scene object
-		else {
+		Scene scene2 = new Scene(gridPane2);
-			Text ISBN = new Text("ISBN");
+
-			Text copies = new Text("COPIES");
+		// Setting title to the Stage
-			Button purchaseAll = new Button("Purchase All");
+		stage.setTitle("Sign Up ");
-
+
-		    // Add Nodes to GridPane
+		// Adding scene to the stage
-		    gridPane.add(ISBN,0,0);
+		stage.setScene(scene2);
-		    gridPane.add(copies,1,0);
+
-		    gridPane.add(purchaseAll, 4 , 400/30);
+		// Displaying the contents of the stage
-
+		stage.show();
-		    // set styling
+
-		    ISBN.setStyle("-fx-font: normal bold 15px 'serif' ");
+
-		    copies.setStyle("-fx-font: normal bold 15px 'serif' ");
+
-		   	purchaseAll.setStyle("-fx-background-color: darkslateblue; -fx-text-fill: white;");
+
-
+		back.setOnAction(new EventHandler<ActionEvent>() {
-
+			@Override
-
+			public void handle(ActionEvent event) {
-		   	purchaseAll.setOnAction(new EventHandler<ActionEvent>() {
+				stage.setTitle("Log in ");
-	            @Override
+
-	            public void handle(ActionEvent event) {
+				// Adding scene to the stage
-	            	try {
+				stage.setScene(scene);
-	            		  Connection con = DriverManager.getConnection( "jdbc:mysql://localhost:3306/Online_Book_Store?useSSL=false", "root", "ahmed666" );
+
-	          			  PreparedStatement p = (PreparedStatement) con.prepareStatement("update BOOK_STORE set BOOK_COPIES = BOOK_COPIES - ( select COPIES"
+				// Displaying the contents of the stage
-	          			  		+ " from CART where BOOK_STORE.ISBN = ISBN and USER_NAME ='"+userName+"') where ISBN IN ( select ISBN from CART );");
+				stage.show();
-	          			  System.out.println("update BOOK_STORE set BOOK_COPIES = BOOK_COPIES - ( select COPIES"
+
-		          			  		+ " from CART where BOOK_STORE.ISBN = ISBN and USER_NAME ='"+userName+"')  where ISBN IN ( select ISBN from CART ); ");
+
-	          			  p.executeUpdate();
+
-	          			  p = (PreparedStatement) con.prepareStatement("delete from CART where USER_NAME = '"+userName+"'");
+		});
-	          			  p.executeUpdate();
+
-	          			  purchaseAll.setDisable(true);
+		signUpButton.setOnAction(new EventHandler<ActionEvent>()  {
-	          			  for(int i =0 ; i< list.size() ;i++) {
+			@Override
-	          				  list.get(i).setDisable(true);
+			public void handle(ActionEvent event) {
-	          			  }
+				String userName = userNameField.getText();
-
+				String pass = passField.getText();
-	          		  }
+				String firstName =firstNameField.getText();
-	            	  catch (SQLException e) {
+				String lastName = lastNameField.getText();
-	            		  // TODO Auto-generated catch block
+				String phone= phoneField.getText();
-	          			  e.printStackTrace();
+				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);
-		Scene scene = new Scene(gridPane);
+				System.out.println(firstName);
-		setScene(scene);
+				System.out.println(lastName);
 				System.out.println(phone);
 				System.out.println(Email);
 				System.out.println(shipping);
 				System.out.println(numberOfCredit);
 				System.out.println(type);
 
 
 
 
 
 					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", "admin");
 				} catch (SQLException e) {
 					// TODO Auto-generated catch block
 					e.printStackTrace();
 				}
 				try {
 					String query;
 					String selectQuery;
 
 					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.setString(1, userName);
 					stmt.setString(2, pass);
 					stmt.setString(3, firstName);
 					stmt.setString(4, lastName);
 					stmt.setString(5, phone);
 					stmt.setString(6, Email);
 					stmt.setString(7, shipping);
 					stmt.setString(8, numberOfCredit);
 					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();
 				}
 
 
 			}
 
 		});
 
 
 
 	}
 
 
 
 }