private Connection conn = null;
private Statement stmt = null;
public void initialize() {
initializeDB();
}
private void initializeDB() {
final String JDBC_DRIVER = "org.h2.Driver";
final String DB_URL = "jdbc:h2:./res/BikeDB";
final String USER = "";
final String PASS = "";
System.out.println("Attempting to connect to database");
try {
Class.forName(JDBC_DRIVER);
conn = DriverManager.getConnection(DB_URL, USER, PASS);
stmt = conn.createStatement();
System.out.println("Successfully connected to database!");
} catch (Exception e) {
e.printStackTrace();
Alert a = new Alert(Alert.AlertType.ERROR);
a.show();
}
}