JAVAFX::无法向 PHPMyAdmin 插入值



我面临一个与SQL相关的问题,或者我不知道,这是我的数据库处理程序类,我将其连接到:

public class DatabaseHandler extends Configs{
Connection dbCon;
public Connection getDbCon() throws ClassNotFoundException, SQLException {
String connectionString = "jdbc:mysql://" + dbHost +":"
+dbPort +"/"+dbName;
Class.forName("com.mysql.cj.jdbc.Driver");
dbCon= DriverManager.getConnection(connectionString,dbUsername,dbPassword);
return dbCon;
}
public void SignUpUser( String name, String surname, LocalDate date, String mobile,
String login, String password){
String insert = "INSERT INTO users (name, surname, dob, mobile,login, password)" +
"VALUES(?,?,?,?,?,?)";
PreparedStatement statement = null;
try {
statement = getDbCon().prepareStatement(insert);
statement.setString(1,name);
statement.setString(2,surname);
statement.setDate(3, Date.valueOf(date));
statement.setString(4,mobile);
statement.setString(5,login);
statement.setString(6,password);
} catch (SQLException e) {
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}

这是我的控制器类,我用我的按钮进行操作:

@FXML
void btnRegistration(ActionEvent event) {
String login = txtLoginRegistration.getText();
String name = txtNameRegistration.getText();
String surname = txtSurnameRegistration.getText();
LocalDate date = txtDateRegistration.getValue();
String mobile = txtMobile.getText();
String password = txtPasswordRegistration.getText();
//Connect to DB
DatabaseHandler handler = new DatabaseHandler();
handler.SignUpUser(name,surname,date,mobile,login,password);

在扩展Coonfigs类时,我刚刚声明了DB的变量名称编译它时没有任何错误,即使我用Try and Catch完成了所有操作,但无论如何,在检查我的数据库时,它没有插入,我很高兴得到任何答案,希望我的答案不会后悔,如果我后悔了,我道歉。

哦,我刚刚发现我的错误我只是忘了放

statement.executeUpdate();

报表末尾

最新更新