Creating a H2 Database in IntelliJ JavaFX Project

Опубликовано: 27 Сентябрь 2024
на канале: Prof. Vanselow

5,565

build.gradle code (in dependencies):
compile group: 'com.h2database', name: 'h2', version: '1.4.197'

Controller code
import javafx.fxml.FXML;
import javafx.scene.control.TextArea;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

public class Controller {

@FXML
private TextArea taOutput;

public void initialize() {

final String JDBC_DRIVER = "org.h2.Driver";
final String DB_URL = "jdbc:h2:./resources/BicycleDB";

// Database credentials
final String USER = "";
final String PASS = "";
Connection conn = null;
Statement stmt = null;

try {
// STEP 1: Register JDBC driver
Class.forName(JDBC_DRIVER);
//Class.forName(new org.h2.Driver());

//STEP 2: Open a connection
//conn = DriverManager.getConnection(DB_URL, USER, PASS);
conn = DriverManager.getConnection(DB_URL);

//STEP 3: Execute a query
stmt = conn.createStatement();

String sql = "SELECT * FROM Bike";

ResultSet rs = stmt.executeQuery(sql);
while (rs.next()) {
taOutput.appendText(rs.getString(1) + "\n");
}

// STEP 4: Clean-up environment
stmt.close();
conn.close();
} catch (SQLException e) {
taOutput.appendText(e.toString());
} catch (ClassNotFoundException e) {
taOutput.appendText(e.toString());
}
}
}

FXML code: https://pastebin.com/nCASvu3v