要部署一个Java FX数据库应用程序,可以按照以下步骤进行:
dependencies {
implementation 'org.openjfx:javafx-controls:15.0.1'
implementation 'org.openjfx:javafx-fxml:15.0.1'
implementation 'mysql:mysql-connector-java:8.0.26'
}
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class DatabaseHandler {
private static final String JDBC_URL = "jdbc:mysql://localhost:3306/database_name";
private static final String USERNAME = "username";
private static final String PASSWORD = "password";
private Connection connection;
public DatabaseHandler() {
try {
connection = DriverManager.getConnection(JDBC_URL, USERNAME, PASSWORD);
} catch (SQLException e) {
e.printStackTrace();
}
}
public ResultSet executeQuery(String query) {
try {
Statement statement = connection.createStatement();
return statement.executeQuery(query);
} catch (SQLException e) {
e.printStackTrace();
}
return null;
}
public void executeUpdate(String query) {
try {
Statement statement = connection.createStatement();
statement.executeUpdate(query);
} catch (SQLException e) {
e.printStackTrace();
}
}
public void close() {
try {
connection.close();
} catch (SQLException e) {
e.printStackTrace();
}
}
}
import javafx.application.Application;
import javafx.fxml.FXMLLoader;
import javafx.scene.Parent;
import javafx.scene.Scene;
import javafx.stage.Stage;
public class Main extends Application {
@Override
public void start(Stage primaryStage) throws Exception {
Parent root = FXMLLoader.load(getClass().getResource("sample.fxml"));
primaryStage.setTitle("Java FX Database App");
primaryStage.setScene(new Scene(root, 800, 600));
primaryStage.show();
}
public static void main(String[] args) {
launch(args);
}
}
import javafx.fxml.FXML;
import javafx.scene.control.Button;
import javafx.scene.control.Label;
import javafx.scene.control.TextField;
public class Controller {
@FXML
private TextField nameTextField;
@FXML
private Button saveButton;
@FXML
private Label statusLabel;
private DatabaseHandler databaseHandler;
public Controller() {
databaseHandler = new DatabaseHandler();
}
@FXML
private void onSaveButtonClicked() {
String name = nameTextField.getText();
String query = "INSERT INTO users (name) VALUES ('" + name + "')";
databaseHandler.executeUpdate(query);
statusLabel.setText("Data saved successfully!");
}
}
完成上述步骤后,您可以部署Java FX数据库应用程序并运行它。请注意,这只是一个简单的示例,您可以根据实际需求和数据库架构进行进一步的开发和改进。