连接android Studio到Azure SQL数据库使用Java

Question

 package com.example.workdb;

 import androidx.appcompat.app.AppCompatActivity;

 import android.os.Bundle;
import androidx.appcompat.app.AppCompatActivity;
import android.os.AsyncTask;
import android.os.StrictMode;
  import android.os.Bundle;
import android.util.Log;
import android.view.View;
import android.widget.Button;
import android.widget.EditText;
import android.os.Bundle;
import android.widget.TextView;

import org.w3c.dom.Text;

 import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
import net.sourceforge.jtds.jdbc.*;
  public class MainActivity extends AppCompatActivity {
   public Button run;
   public TextView message;
   public TextView txtvw;
   public Connection con;
  @Override
   protected void onCreate(Bundle savedInstanceState) {
    super.onCreate(savedInstanceState);
    setContentView(R.layout.activity_main);
    run= (Button) findViewById(R.id.button);
    run.setOnClickListener(new View.OnClickListener() {
        public void onClick(View v)

        {


            CheckLogin checkLogin= new CheckLogin();
            checkLogin.execute("");
            Log.d("CREATION","ON CREATE WORKS");
            //  Log.d("txtvw", connection);
            //System.out.println("Yes");
            // txtvw.setText("hello");

        }

    });
  } public class CheckLogin extends AsyncTask<String,String,String>
  {
    String z="";
    Boolean IsSuccess= false;
    String name1="";


    // Log.d("txtvw","step 1 done");
    protected void onPostExecute(String r){
        if (IsSuccess){
            message=(TextView)findViewById(R.id.textView);
            message.setText(name1);
            Log.d("TAG", "STEP 1 DONE");

        }
    }
    @Override
    protected String doInBackground(String... strings) {
        try
        {
            Connection con = connectionClass();
            if(con==null){
                z="Check interent";
                //Log.d("txtvw", z);

            }
            else
            {
                String query= "select * from Value";
                Statement stmt= con.createStatement();
                ResultSet rs= stmt.executeQuery(query);
                if (rs.next())
                {
                    name1=rs.getString("KneeAngle");
                    Log.d("MYTAG", "name 1 works");
                    z="Query success";
                    IsSuccess=true;
                    con.close();


                }
                else{
                    z="Invalid query";
                    IsSuccess=false;
                }



            }
        } catch (SQLException e) {
            e.printStackTrace();
        }
        return z;
    }
}
public Connection connectionClass(){
    StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
    StrictMode.setThreadPolicy(policy);
    Connection connection = null;
    String ConnectionURL ;

    try{
        Class.forName("net.sourceforge.jtds.jdbs.Driver");
        

  

ConnectionURL=“jdbc:jtds:sqlserver://havvasemserv3.database.windows.net:1433;DatbaseName=Newfin；用户=；密码=；加密=真；trustServerCertificate=false；hostNameInCertificate=*。数据库窗户。网loginTimeout=30”；

        connection= DriverManager.getConnection(ConnectionURL);

    } catch(ClassNotFoundException e){
        Log.e("Error here 2 ",e.getMessage());

    }
    catch (Exception e) {
        Log.e("error here 3:",e.getMessage());

    }
    //Log.d("txtvw", connection);
    return connection;

}

}

我正在尝试将azure sql数据库连接到android studio。我已经在清单文件中添加了所有权限，我还在项目中添加了jtds模块1.3.1，并在gradle模块应用程序中实现了它。我的代码退出时有0个错误，但数据未显示在仿真器上。预期输出是我数据库中的第一个值，即“8”。谢谢

Answer 1

在超时后将此添加到当前连接url的末尾=30； ssl=请求

还要确保在azure服务器的防火墙设置中/数据库当前设备ip允许访问，因为默认情况下所有访问都被阻止，

要允许所有设备访问服务器，请转到防火墙设置，并在插入ip部分添加此ip范围

0,0,0,0和255255