Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.time.LocalDate;
- import java.util.Calendar;
- import javafx.application.Application;
- import javafx.event.ActionEvent;
- import javafx.event.EventHandler;
- import javafx.geometry.Pos;
- import javafx.stage.Stage;
- import javafx.scene.Group;
- import javafx.scene.Scene;
- import javafx.scene.control.*;
- import javafx.scene.layout.GridPane;
- import javafx.scene.layout.HBox;
- import javafx.scene.layout.VBox;
- import javafx.scene.paint.Color;
- import javafx.scene.text.Font;
- import java.lang.Thread.State;
- import java.sql.*;
- public class Devansh_JavaFx_JDBC extends Application{
- public static void main(String[] args) {
- // TODO Auto-generated method stub
- launch();
- }
- @Override
- public void start(Stage primaryStage) throws Exception {
- // TODO Auto-generated method stub
- primaryStage.setTitle("Registration Form");
- GridPane root = new GridPane();
- root.setHgap(15);
- root.setVgap(15);
- Label lb_name = new Label("Name:");
- TextField name = new TextField();
- root.add(lb_name, 1,1);
- root.add(name, 2,1);
- Label lb_email = new Label("Email:");
- //lb_email.setFont(new Font(20));
- //lb_email.setTextFill(Color.RED);
- TextField email = new TextField();
- root.add(lb_email, 1,2);
- root.add(email, 2,2);
- Label lb_password = new Label("Password:");
- PasswordField password = new PasswordField();
- root.add(lb_password, 1,3);
- root.add(password, 2,3);
- Label lb_date = new Label("Birthdate");
- DatePicker date = new DatePicker();
- root.add(lb_date, 1, 4);
- root.add(date, 2, 4);
- Label lb_country = new Label("Country:");
- ComboBox<String> country = new ComboBox<String>();
- country.getItems().add("India");
- country.getItems().add("USA");
- country.getItems().add("UK");
- country.getItems().add("Africa");
- country.getItems().add("Australia");
- country.setEditable(true);
- root.add(lb_country, 1,5);
- root.add(country, 2,5);
- Label lb_gender = new Label("Gender");
- ToggleGroup gender_group = new ToggleGroup();
- RadioButton male = new RadioButton("Male");
- RadioButton female = new RadioButton("Female");
- RadioButton other = new RadioButton("Other");
- male.setSelected(true);
- male.setToggleGroup(gender_group);
- female.setToggleGroup(gender_group);
- other.setToggleGroup(gender_group);
- root.add(lb_gender, 1, 6, 1, 3);
- root.add(male, 2, 6);
- root.add(female, 2, 7);
- root.add(other, 2, 8);
- Button submit = new Button("Submit");
- root.add(submit, 2, 9);
- Label messg = new Label();
- root.add(messg, 1, 10, 2, 1);
- submit.setOnAction(new EventHandler<ActionEvent>() {
- @Override
- public void handle(ActionEvent event) {
- String textToSet = "";
- boolean flag = true;
- // TODO Auto-generated method stub
- if (name.getText().isEmpty()) {
- textToSet += "Name cannot be empty!\n";
- flag = false;
- }
- if (email.getText().isEmpty()) {
- textToSet += "Email cannot be empty!\n";
- flag = false;
- }
- if (password.getText().length() < 8) {
- textToSet += "Password cannot be less than 8 characters!\n";
- flag = false;
- }
- if (date.getValue() == null) {
- textToSet += "Enter a valid date!\n";
- flag = false;
- }
- if (country.getValue() == null) {
- textToSet += "Enter a Country!\n";
- flag = false;
- }
- if (flag == true) {
- String SelectedGender = ((RadioButton)gender_group.getSelectedToggle()).getText();
- try {
- addToJCBC(name.getText(), email.getText(), password.getText(), date.getValue().toString(), country.getValue().toString(), SelectedGender);
- } catch (Exception e) {
- // TODO Auto-generated catch block
- e.printStackTrace();
- }
- textToSet = "Accepted!";
- }
- messg.setText(textToSet);
- }
- });
- Scene sc = new Scene(root);
- primaryStage.setScene(sc);
- primaryStage.setWidth(500);
- primaryStage.setHeight(800);
- primaryStage.show();
- }
- void addToJCBC(String name, String email, String password, String date, String country, String gender) throws Exception{
- try {
- Connection con;
- Class.forName("com.mysql.cj.jdbc.Driver").newInstance();
- con = DriverManager.getConnection("jdbc:mysql://localhost:3307/test", "root", "");
- Statement stmt = con.createStatement();
- stmt.executeUpdate("insert into form values('"+name+"', '"+email+"', '"+password+"', '"+date+"', '"+country+"', '"+gender+"');");
- stmt.close();
- con.close();
- }
- catch (Exception e) {
- // TODO: handle exception
- }
- }
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement