Advertisement
Guest User

Untitled

a guest
Feb 11th, 2016
121
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. private void saveFile(){
  2. String filenameDB = filenameTextField.getText();
  3. String outputdataDB = outputEditorPane.getText();
  4. String keywordDB = keywordTextField.getText();
  5. String JDBC_DRIVER = "com.mysql.jdbc.Driver";
  6. String DB_URL = "jdbc:mysql://localhost:3306/records";
  7.  
  8. String USER = "root";
  9. String PASS = "root";
  10.  
  11. Connection conn;
  12. Statement stmt;
  13. try{
  14. Class.forName(JDBC_DRIVER);
  15. System.out.println("Connecting to Database...");
  16. conn = DriverManager.getConnection(DB_URL, USER, PASS);
  17.  
  18. stmt = conn.createStatement();
  19. stmt.executeUpdate("INSERT INTO `recordstable`(id, filename, keywordcol, outputdata) VALUE ('"+0+"','"+filenameDB+"','"+keywordDB+"','"+outputdataDB+"')");
  20. System.out.println(ocrdataDB);
  21. conn.close();
  22. }
  23. catch(SQLException | ClassNotFoundException se)
  24. {}
  25. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement