Advertisement
Guest User

Untitled

a guest
Sep 20th, 2017
89
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.80 KB | None | 0 0
  1. public void ConnectToDatabase(){
  2. try {
  3.  
  4. // SET CONNECTIONSTRING
  5. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  6. String username = "XXXXXXXXX";
  7. String password = "XXXXXX";
  8. Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://192.188.4.83:1433/DATABASE;user=" + username + ";password=" + password);
  9.  
  10. Log.w("Connection","open");
  11. Statement stmt = DbConn.createStatement();
  12. ResultSet reset = stmt.executeQuery(" select * from users ");
  13.  
  14.  
  15. EditText num = (EditText) findViewById(R.id.displaymessage);
  16. num.setText(reset.getString(1));
  17.  
  18. DbConn.close();
  19.  
  20. } catch (Exception e)
  21. {
  22. Log.w("Error connection","" + e.getMessage());
  23. }
  24. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement