Note that in this tutorial, we are using FXML, an XML based language provided by JavaFX, to create the user interface for our Desktop application.
What will you learn?
- How to create the layout of a JavaFX application window using FXML.
- How to add UI controls like Text Field, Password Field, and Button.
- How to validate UI controls like Text Field, Password Field.
- How to connect JavaFX application with MySQL database via JDBC API.
Tools and Technologies used
- JDK 1.8
- MySQL Connector Java - 8.0.13
- JDBC - 4.2
- Eclipse IDE
- JavaFX
Development steps
- Create a Simple Maven Project
- Add Dependencies
- Project Structure
- Database Setup
- Create the Main Application Class
- Create the Layout for Our Application using FXML
- Create a Login Controller to handle form data
- Create JDBCDao for Database operations
- Run application
- Output
1. Create a Simple Maven Project
2. Add Dependencies
<project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd"> <modelVersion>4.0.0</modelVersion> <groupId>net.javaguides.javafx</groupId> <artifactId>javafx-login-form-jdbc-tutorial</artifactId> <version>0.0.1-SNAPSHOT</version> <name>javafx-login-form-jdbc-tutorial</name> <description>javafx-login-form-jdbc-tutorial</description> <properties> <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding> <mainClass>com.javaguides.javafx.registration.MainApp</mainClass> </properties> <dependencies> <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java --> <dependency> <groupId>mysql</groupId> <artifactId>mysql-connector-java</artifactId> <version>8.0.15</version> </dependency> </dependencies> <build> <plugins> <plugin> <groupId>org.apache.maven.plugins</groupId> <artifactId>maven-compiler-plugin</artifactId> <version>3.6.1</version> <configuration> <source>1.8</source> <target>1.8</target> </configuration> </plugin> </plugins> </build> </project>
3. Project Structure
4. Database Setup
5. Create the Main Application Class
package com.javaguides.javafx.login;
import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.stage.Stage;
public class MainApp extends Application {
@Override
public void start(Stage stage) throws Exception {
System.out.println(getClass());
Parent root = FXMLLoader.load(getClass().getResource("/fxml/login_form.fxml"));
stage.setTitle("User Login");
stage.setScene(new Scene(root, 800, 500));
stage.show();
}
public static void main(String[] args) {
launch(args);
}
}
6. Create the Layout for Our Application using FXML
<?import javafx.scene.layout.GridPane?>
<?import javafx.geometry.Insets?>
<?import javafx.scene.layout.ColumnConstraints?>
<?import javafx.scene.control.Label?>
<?import javafx.scene.text.Font?>
<?import javafx.scene.control.TextField?>
<?import javafx.scene.control.PasswordField?>
<?import javafx.scene.control.Button?>
<GridPane fx:controller="com.javaguides.javafx.login.LoginController"
xmlns:fx="http://javafx.com/fxml" alignment="center"
hgap="10" vgap="10">
<padding>
<Insets top="40" right="40" bottom="40" left="40"/>
</padding>
<columnConstraints>
<ColumnConstraints minWidth="100" prefWidth="100"
maxWidth="Infinity" halignment="RIGHT"></ColumnConstraints>
<ColumnConstraints minWidth="200" prefWidth="200"
maxWidth="Infinity" hgrow="ALWAYS"></ColumnConstraints>
</columnConstraints>
<!-- Add Header Label -->
<Label text="Login Form (FXML)" GridPane.columnIndex="0"
GridPane.rowIndex="0" GridPane.columnSpan="2"
GridPane.rowSpan="1" GridPane.halignment="CENTER" >
<font>
<Font name="Arial" size="24" ></Font>
</font>
<GridPane.margin>
<Insets top="20" right="0" bottom="20" left="0"></Insets>
</GridPane.margin>
</Label>
<!-- Add Email Label -->
<Label text="Email ID : " GridPane.columnIndex="0"
GridPane.rowIndex="2" ></Label>
<!-- Add Email Text Field -->
<TextField fx:id="emailIdField" prefHeight="40"
GridPane.columnIndex="1" GridPane.rowIndex="2"/>
<!-- Add Password Label -->
<Label text="Password : " GridPane.columnIndex="0"
GridPane.rowIndex="3" ></Label>
<!-- Add Password Field -->
<PasswordField fx:id="passwordField" prefHeight="40"
GridPane.columnIndex="1" GridPane.rowIndex="3"/>
<!-- Add Submit Button -->
<Button fx:id="submitButton" text="Submit"
prefWidth="100" prefHeight="40" defaultButton="true"
GridPane.columnIndex="0" GridPane.rowIndex="4"
GridPane.columnSpan="2" GridPane.rowSpan="1"
GridPane.halignment="CENTER"
onAction="#login">
<GridPane.margin>
<Insets top="20" right="0" bottom="20" left="0"></Insets>
</GridPane.margin>
</Button>
</GridPane>
7. Create a Login Controller to Handle Form Data
package com.javaguides.javafx.login;
import java.sql.SQLException;
import javafx.event.ActionEvent;
import javafx.fxml.FXML;
import javafx.scene.control.Alert;
import javafx.scene.control.Alert.AlertType;
import javafx.scene.control.Button;
import javafx.scene.control.PasswordField;
import javafx.scene.control.TextField;
import javafx.stage.Window;
public class LoginController {
@FXML
private TextField emailIdField;
@FXML
private PasswordField passwordField;
@FXML
private Button submitButton;
@FXML
public void login(ActionEvent event) throws SQLException {
Window owner = submitButton.getScene().getWindow();
System.out.println(emailIdField.getText());
System.out.println(passwordField.getText());
if (emailIdField.getText().isEmpty()) {
showAlert(Alert.AlertType.ERROR, owner, "Form Error!",
"Please enter your email id");
return;
}
if (passwordField.getText().isEmpty()) {
showAlert(Alert.AlertType.ERROR, owner, "Form Error!",
"Please enter a password");
return;
}
String emailId = emailIdField.getText();
String password = passwordField.getText();
JdbcDao jdbcDao = new JdbcDao();
boolean flag = jdbcDao.validate(emailId, password);
if (!flag) {
infoBox("Please enter correct Email and Password", null, "Failed");
} else {
infoBox("Login Successful!", null, "Failed");
}
}
public static void infoBox(String infoMessage, String headerText, String title) {
Alert alert = new Alert(AlertType.CONFIRMATION);
alert.setContentText(infoMessage);
alert.setTitle(title);
alert.setHeaderText(headerText);
alert.showAndWait();
}
private static void showAlert(Alert.AlertType alertType, Window owner, String title, String message) {
Alert alert = new Alert(alertType);
alert.setTitle(title);
alert.setHeaderText(null);
alert.setContentText(message);
alert.initOwner(owner);
alert.show();
}
}
8. Create JDBCDao for Database operations
- Establishing a connection
- Create a statement
- Execute the query
- Using try-with-resources Statements to Automatically Close JDBC Resources
Connection conn = DriverManager.getConnection(Urldatabase,Username,Password);
package com.javaguides.javafx.login;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
public class JdbcDao {
// Replace below database url, username and password with your actual database credentials
private static final String DATABASE_URL = "jdbc:mysql://localhost:3306/javafx_registration?useSSL=false";
private static final String DATABASE_USERNAME = "root";
private static final String DATABASE_PASSWORD = "root";
private static final String SELECT_QUERY = "SELECT * FROM registration WHERE email_id = ? and password = ?";
public boolean validate(String emailId, String password) throws SQLException {
// Step 1: Establishing a Connection and
// try-with-resource statement will auto close the connection.
try (Connection connection = DriverManager
.getConnection(DATABASE_URL, DATABASE_USERNAME, DATABASE_PASSWORD);
// Step 2:Create a statement using connection object
PreparedStatement preparedStatement = connection.prepareStatement(SELECT_QUERY)) {
preparedStatement.setString(1, emailId);
preparedStatement.setString(2, password);
System.out.println(preparedStatement);
ResultSet resultSet = preparedStatement.executeQuery();
if (resultSet.next()) {
return true;
}
} catch (SQLException e) {
// print SQL exception information
printSQLException(e);
}
return false;
}
public static void printSQLException(SQLException ex) {
for (Throwable e: ex) {
if (e instanceof SQLException) {
e.printStackTrace(System.err);
System.err.println("SQLState: " + ((SQLException) e).getSQLState());
System.err.println("Error Code: " + ((SQLException) e).getErrorCode());
System.err.println("Message: " + e.getMessage());
Throwable t = ex.getCause();
while (t != null) {
System.out.println("Cause: " + t);
t = t.getCause();
}
}
}
}
}
9. Run application
10. Output
Login Form Validation:
Login Form Success:
Continue Learning with Java Guides
Want to take your programming skills to the next level? Explore my practical Udemy courses on Java, Spring Boot, Microservices, Full-Stack Development, Docker, and Generative AI. You can also follow my structured learning roadmaps to become a professional developer.
By Ramesh Fadatare - Udemy Instructor Partner
Comments
Post a Comment
Leave Comment