Advertisement
Guest User

Untitled

a guest
Jan 11th, 2018
86
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. @FXML
  2. private void InsertButtonAction(ActionEvent event) throws IOException {
  3. //alterar conection!
  4. String myDriver = "org.gjt.mm.mysql.Driver";
  5. String myUrl = "jdbc:mysql://localhost/test";
  6. Class.forName(myDriver);
  7. Connection conn = DriverManager.getConnection(myUrl, "root", "");
  8.  
  9. //alterar table name
  10. String query = " insert into tableName (dept_no, dept_name)"
  11. + " values (?, ?)";
  12.  
  13.  
  14. PreparedStatement preparedStmt = conn.prepareStatement(query);
  15. //aletrar String
  16. preparedStmt.setString (1, "Numero+1 de departamentos");
  17. preparedStmt.setString (2, textfield.getText());
  18.  
  19. preparedStmt.execute();
  20.  
  21. conn.close();
  22. }
  23. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement