@FXML
    private TextField NewUsernameFieldC;

    @FXML
    private PasswordField NewPasswordFieldC;

    @FXML
    private PasswordField NewPasswordConfFieldC;

    @FXML
    private TextField NewEmailFieldC;

    @FXML
     private TextField NewSteamlinkFieldC;

    @FXML
    private void handleCreateAccountBack(MouseEvent event) throws IOException{
    Parent handleInventoryBackParent = FXMLLoader.load(getClass().getResource("LoginCreateBuffer.fxml"));
    Scene OPBackScene = new Scene(handleInventoryBackParent);
    Stage handleInventoryBackStage = (Stage) ((Node) event.getSource()).getScene().getWindow();
    handleInventoryBackStage.setScene(OPBackScene);
    handleInventoryBackStage.show();
    }

    @FXML
    private void handleCreateAccountContinue(ActionEvent event) throws IOException{
        if(!NewUsernameFieldC.getText().equals("") || !NewPasswordFieldC.getText().equals("") || NewPasswordFieldC.getText().equals(NewPasswordConfFieldC.getText())
           || !NewEmailFieldC.getText().equals("") || !NewSteamlinkFieldC.getText().equals("")){

                String Username = NewUsernameFieldC.getText();
                String Password = NewPasswordFieldC.getText();
                String Email = NewEmailFieldC.getText();
                String SteamTrade = NewSteamlinkFieldC.getText();
                String sql = "INSERT INTO userinfo VALUES("+Username+","+Password+","+SteamTrade+","+Email+")";
                try{
                    //get connection to database
                    Connection c = DataBaseConnect.getConnection();
                    //create a statement
                    Statement stmt = c.createStatement();
                    //process result set
                    stmt.executeUpdate(sql);

                    }
                    catch(Exception e){
                        e.printStackTrace();
                    }

            Parent handleInventoryBackParent = FXMLLoader.load(getClass().getResource("Profile.fxml"));
            Scene OPBackScene = new Scene(handleInventoryBackParent);
            Stage handleInventoryBackStage = (Stage) ((Node) event.getSource()).getScene().getWindow();
            handleInventoryBackStage.setScene(OPBackScene);
            handleInventoryBackStage.show();
        }
        else{
            System.out.println("incorrect input");
        }
    }

public class DataBaseConnect {

    static private Connection connection;

    public static Connection getConnection() throws Exception{
        if(connection != null){
        //get connection to database
        String url = "jdbc:mysql://localhost:3306/csgoopenerdatabase";
        String user = "root";
        String password = "hockey33";
        Connection connection = DriverManager.getConnection(url,user,password);
        System.out.println("Connected to database!");
        //execute sql query
        //process result set
        }
        return connection;
    }


}

String sql = "INSERT INTO userinfo VALUES('"+Username+"','"+Password+"','"+SteamTrade+"','"+Email+"')";