java中的derby注册表单

Question

大家好，我对java非常陌生，我想有一个注册表单，我几乎可以得到它，但不知道我做错了什么。这是我的方法

private void RegisterBtnActionPerformed(java.awt.event.ActionEvent evt) { try { final String host = "abc"; final String user = "abc"; final String pwd = "abc"; connection = DriverManager.getConnection(host, user, pwd); statement = connection.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE); String userName = txt_registerUsername.getText(); String address = txt_registerAddress.getText(); String phoneNo = txt_phoneNo.getText(); String password = txt_registerPassword.getText(); //final String select_query = "INSERT INTO Users ('username','address','phoneno','password') VALUES(?,?,?,?)"; //rs = statement.executeQuery(select_query); //rs.next(); PreparedStatement ps = connection.prepareStatement( "INSERT INTO Users VALUES(?,?,?,?)"); ps.setString(1, userName); ps.setString(2, address); ps.setString(3, phoneNo); ps.setString(4, password); int i = ps.executeUpdate(); if (i > 0) System.out.print("You are successfully registered..."); else { JOptionPane.showMessageDialog(null, "Sorry Try again Later"); } } catch (SQLException ex) { JOptionPane.showMessageDialog(null, "Sorry Something went wrong"); } }

Answer 1

您尚未选择数据库。 此外，还可以在SQLException捕获块中使用e.printStackTrace（）

Answer 2

updateString（）和我没有正确提供列名这里是如何为我工作的

&13； 第13部分,；

try {
  String username = txt_registerUsername.getText();
  String address = txt_registerAddress.getText();
  String phoneno = txt_phoneNo.getText();
  int pass = Integer.parseInt(txt_registerPassword.getText());

  rs.moveToInsertRow();

  rs.updateString("username", username);
  rs.updateString("address", address);
  rs.updateString("phoneno", phoneno);
  rs.updateInt("password", pass);

  rs.insertRow();

  statement.close();
  rs.close();
  JOptionPane.showMessageDialog(Registeration.this, "New Record Added");
  connectDB();

} catch (SQLException ex) {
  ex.printStackTrace();
  JOptionPane.showMessageDialog(null, "Sorry Something went wrong");
}

；

和#13；