连接到mssql服务器返回null

xxslljrj  于 2021-07-26  发布在  Java
关注(0)|答案(1)|浏览(372)

我想将android应用程序连接到sql server,但连接总是返回null。我没有发现任何有助于相同代码无处不在,但问题是相同的。有什么问题吗?

  1. class DatabaseHandler {
  2. private static Connection connection;
  3. private static String db,ip,un,pass,connectionURL,port;
  4. private static Statement statement;
  5. static Connection getConnection(Context context)
  6. {
  7. //ActivityCompat.requestPermissions((Activity) context,new String[]{Manifest.permission.INTERNET}, PackageManager.PERMISSION_GRANTED);
  8. ip = "****"; //database ip
  9. db = "***"; //database name
  10. un = "***"; //username to connect to db
  11. pass = "***"; //password to connect to db
  12. connectionURL = null;
  13. port = "1433";
  14. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  15. StrictMode.setThreadPolicy(policy);
  16. if(connection == null)
  17. {
  18. try
  19. {
  20. Class.forName("net.sourceforge.jtds.jdbc.Driver");
  21. connectionURL = "jdbc:jtds:sqlserver://" + ip + ";databaseName=" + db + ";user=" + un+ ";password=" + pass +";";
  22. connection = DriverManager.getConnection(connectionURL);
  23. statement = connection.createStatement();
  24. } catch (ClassNotFoundException | SQLException e) {
  25. e.printStackTrace();
  26. }
  27. }
  28. Log.i("ifconnectionsucceeded",""+connection);
  29. return connection;
  30. }
2ul0zpep

2ul0zpep1#

我想出来了。。问题是我使用的是jtdsjar1.3.1,我把它降级到了1.2.7,它运行得很好

相关问题