Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- private class FetchSQL extends AsyncTask<Void,Void,String> {
- Connection conn;
- Statement st;
- @Override
- protected String doInBackground(Void... params) {
- String retval = "";
- try {
- Class.forName("org.postgresql.Driver");
- Class.forName("java.sql.Driver");
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- retval = e.toString();
- }
- //DriverManager.setLoginTimeout(10);
- try {
- conn = DriverManager.getConnection("jdbc:postgresql://cirrus.no-ip.org:5432/postgres", "postgres", "l+!plu");
- st = conn.createStatement();
- System.out.println("oi");
- PreparedStatement ps = conn.prepareStatement("INSERT INTO usuario VALUES (?, ?)");
- ps.setString(1, "Faabio");
- ps.setString(2, "'12234'");
- ps.executeUpdate();
- ps.close();
- }
- catch (SQLException e1) {
- e1.printStackTrace();
- }
- return retval;
- }
Add Comment
Please, Sign In to add comment