Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- public Connection con;
- public void azureSQL(){
- try{
- con = connectionClass();
- if (con == null){
- Log.d("Hore","faenpule, du må Check your Internet Access!");
- } else {
- String query = "SELECT * FROM TodoItem;";
- Statement stmt = con.createStatement();
- ResultSet rs = stmt.executeQuery(query);
- if(rs.next()){
- String horefitte = rs.getString("Text");
- Log.d("hore",horefitte);
- con.close();
- }
- }
- }catch(Exception e){
- Log.d("Error", "som faen");
- }
- }
- @SuppressLint("NewApi")
- public Connection connectionClass(){
- StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
- StrictMode.setThreadPolicy(policy);
- Connection connection = null;
- String ConnectionURL = null;
- try{
- Class.forName("net.sourceforge.jtds.jdbc.Driver");
- 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;";
- connection = DriverManager.getConnection(ConnectionURL);
- } catch (ClassNotFoundException e) {
- e.printStackTrace();
- } catch (SQLException e) {
- e.printStackTrace();
- }
- return connection;
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement