Advertisement
Guest User

Untitled

a guest
May 13th, 2016
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.22 KB | None | 0 0
  1. private class MyTask extends AsyncTask<Void, Void, Void> {
  2.  
  3. private String idFromServer;
  4. private String url="jdbc:mysql://192.168.1.xxx:xxxxx/test";
  5. String name = "AAA";
  6.  
  7. @Override
  8. protected Void doInBackground(Void... params) {
  9. try {
  10. ResultSet result = null;
  11. String a = "SELECT * FROM testtable";
  12. Class.forName("com.mysql.jdbc.Driver").newInstance();
  13. Connection con = DriverManager.getConnection(url,"aaa","abcdef");
  14. Statement state = con.createStatement();
  15. result = state.executeQuery(a);
  16. while (result.next()) {
  17. if (name.equals(result.getString("name"))) {
  18. idFromServer = result.getString("id");
  19. }
  20. }
  21. } catch (IllegalAccessException e) {
  22. e.printStackTrace();
  23. } catch (InstantiationException e) {
  24. e.printStackTrace();
  25. } catch (SQLException e) {
  26. e.printStackTrace();
  27. } catch (ClassNotFoundException e) {
  28. e.printStackTrace();
  29. }
  30. return null;
  31. }
  32.  
  33. protected void onPostExecute(Void result) {
  34. id.setText(idFromServer);
  35. super.onPostExecute(result);
  36. }
  37.  
  38. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement