Advertisement
Guest User

Untitled

a guest
Apr 4th, 2018
77
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.57 KB | None | 0 0
  1. public Connection con;
  2.  
  3. public void azureSQL(){
  4. try{
  5. con = connectionClass();
  6. if (con == null){
  7. Log.d("Hore","faenpule, du må Check your Internet Access!");
  8. } else {
  9. String query = "SELECT * FROM TodoItem;";
  10. Statement stmt = con.createStatement();
  11. ResultSet rs = stmt.executeQuery(query);
  12. if(rs.next()){
  13. String horefitte = rs.getString("Text");
  14. Log.d("hore",horefitte);
  15. con.close();
  16. }
  17. }
  18. }catch(Exception e){
  19. Log.d("Error", "som faen");
  20. }
  21. }
  22.  
  23. @SuppressLint("NewApi")
  24. public Connection connectionClass(){
  25. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  26. StrictMode.setThreadPolicy(policy);
  27. Connection connection = null;
  28. String ConnectionURL = null;
  29.  
  30. try{
  31. Class.forName("net.sourceforge.jtds.jdbc.Driver");
  32. ConnectionURL = "jdbc:jtds:sqlserver://timeadm.database.windows.net:1433;databaseName=TimeADMdb;user=admin1337@timeadm;password=?123Sindre;encrypt=true;trustServerCertificate=false;hostNameInCertificate=*.database.windows.net;loginTimeout=30;";
  33. connection = DriverManager.getConnection(ConnectionURL);
  34. } catch (ClassNotFoundException e) {
  35. e.printStackTrace();
  36. } catch (SQLException e) {
  37. e.printStackTrace();
  38. }
  39. return connection;
  40. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement