Guest User

Untitled

a guest
Aug 31st, 2018
91
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.19 KB | None | 0 0
  1. private class FetchSQL extends AsyncTask<Void,Void,String> {
  2. Connection conn;
  3. Statement st;
  4. @Override
  5. protected String doInBackground(Void... params) {
  6. String retval = "";
  7. try {
  8. Class.forName("org.postgresql.Driver");
  9. Class.forName("java.sql.Driver");
  10.  
  11. } catch (ClassNotFoundException e) {
  12. e.printStackTrace();
  13. retval = e.toString();
  14. }
  15.  
  16.  
  17. //DriverManager.setLoginTimeout(10);
  18.  
  19. try {
  20. conn = DriverManager.getConnection("jdbc:postgresql://cirrus.no-ip.org:5432/postgres", "postgres", "l+!plu");
  21. st = conn.createStatement();
  22. System.out.println("oi");
  23.  
  24. PreparedStatement ps = conn.prepareStatement("INSERT INTO usuario VALUES (?, ?)");
  25. ps.setString(1, "Faabio");
  26. ps.setString(2, "'12234'");
  27. ps.executeUpdate();
  28. ps.close();
  29. }
  30. catch (SQLException e1) {
  31. e1.printStackTrace();
  32. }
  33. return retval;
  34.  
  35. }
Add Comment
Please, Sign In to add comment