Advertisement
Guest User

Untitled

a guest
Feb 15th, 2017
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.31 KB | None | 0 0
  1. enter code here protected void onCreate(Bundle savedInstanceState) {
  2. super.onCreate(savedInstanceState);
  3. setContentView(R.layout.activity_flux_sequence);
  4.  
  5. //String url = "jtds:sqlserver://vps342074.ovh.net\MSSQLSERVER;databaseName=IZY309";
  6.  
  7.  
  8. String url = "jdbc:sqlserver://vps342074.ovh.net\MSSQLSERVER;databaseName=IZY309";
  9. String user = "x";
  10. String pass = "y";
  11. //System.out.println("Hello World");
  12.  
  13. try {
  14. //TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
  15. //textViewToChange.setText("Hello");
  16. Connection con = DriverManager.getConnection(url, user, pass);
  17.  
  18. Statement statement = con.createStatement();
  19. ResultSet resultat = statement.executeQuery("SELECT CATEGORIE FROM dbo.PPROFIL WHERE CATEGORIE = 'ac' ");
  20. while (resultat.next()) {
  21.  
  22. String result = resultat.getString(1);
  23. TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
  24. textViewToChange.setText(result);
  25. Log.d("My Custom Tag", result);
  26.  
  27.  
  28. }resultat.close();
  29. statement.close();
  30. } catch (SQLException e) {
  31. // TODO Auto-generated catch block
  32. e.printStackTrace();
  33. }
  34. }
  35.  
  36. private static void close(Connection con) {
  37. // TODO Auto-generated method stub
  38. close(con);
  39.  
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement