Java 如何将 Android Studio 与 SQL Server 数据库连接？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/42247465/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
How to connect Android Studio with SQL Server database?
提问by mhyeah
We are currently having the same problem as here: How to connect Android Studio with SQL Server database, but it hasn't been answered.
我们目前遇到与此处相同的问题：如何将 Android Studio 与 SQL Server 数据库连接，但尚未得到解答。
We also succeeded the connection on Eclipse, using the sqljdb4.jarfile, we tried on android the same code as in Eclipse, but it works only on Eclipse.
我们也在 Eclipse 上成功连接，使用该sqljdb4.jar文件，我们在 android 上尝试了与 Eclipse 中相同的代码，但它仅适用于 Eclipse。
We also tried another driver, jtds1.3.1.jar, but it didn't work either
我们还尝试了另一个驱动程序，jtds1.3.1.jar但它也不起作用
We replaced the login and password by x and y ;)
我们用 x 和 y 替换了登录名和密码；)
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_flux_sequence);
String url = "jdbc:jtdc:sqlserver://vps342074.ovh.net/IZY309";
//String url = "jdbc:jtdc:sqlserver://vps342074.ovh.net/MSSQLSERVER;databaseName=IZY309";
//String url = "jdbc:sqlserver://vps342074.ovh.net\MSSQLSERVER;databaseName=IZY309";
String user = "x";
String pass = "y";
try {
//TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
//textViewToChange.setText("Hello");
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection con = DriverManager.getConnection(url, user, pass);
Statement statement = con.createStatement();
ResultSet resultat = statement.executeQuery("SELECT CATEGORIE FROM dbo.PPROFIL WHERE CATEGORIE = 'ac' ");
while (resultat.next()) {
String result = resultat.getString(1);
TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
textViewToChange.setText(result);
Log.d("My Custom Tag", result);
}resultat.close();
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
} catch (ClassNotFoundException e) {
e.printStackTrace();
}
}
private static void close(Connection con) {
// TODO Auto-generated method stub
close(con);
}
Here are the returned errors :
以下是返回的错误：
W/System.err: java.sql.SQLException: No suitable driver
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:186)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at java.sql.DriverManager.getConnection(DriverManager.java:213)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at
com.example.gaetan.fluxsequence.flux_sequence.onCreate(flux_sequence.java:32)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.Activity.performCreate(Activity.java:6876)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1135)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:3207)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:3350)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.ActivityThread.access00(ActivityThread.java:222)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1795)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.os.Handler.dispatchMessage(Handler.java:102)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.os.Looper.loop(Looper.java:158)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at android.app.ActivityThread.main(ActivityThread.java:7229)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at java.lang.reflect.Method.invoke(Native Method)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:1230)
02-15 14:34:01.896 4180-4180/com.example.gaetan.fluxsequence W/System.err: at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:1120)
回答by Prerak Sola
The error that you are getting is because you are missing the line Class.forName("net.sourceforge.jtds.jdbc.Driver");
你得到的错误是因为你错过了这条线 Class.forName("net.sourceforge.jtds.jdbc.Driver");
Add it before establishing the database connection, so it will look something like this in your code:
在建立数据库连接之前添加它，所以它在你的代码中看起来像这样：
String url = "jdbc:jtdc:sqlserver://vps342074.ovh.net/IZY309";
try {
//TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
//textViewToChange.setText("Hello");
Class.forName("net.sourceforge.jtds.jdbc.Driver");
Connection con = DriverManager.getConnection(url, user, pass);
Statement statement = con.createStatement();
ResultSet resultat = statement.executeQuery("SELECT CATEGORIE FROM dbo.PPROFIL WHERE CATEGORIE = 'ac' ");
while (resultat.next()) {
String result = resultat.getString(1);
TextView textViewToChange = (TextView) findViewById(R.id.textViewCol5);
textViewToChange.setText(result);
Log.d("My Custom Tag", result);
}
resultat.close();
statement.close();
} catch (SQLException e) {
// TODO Auto-generated catch block
e.printStackTrace();
}
回答by Vinh Phan
Before you make connection, you must add 2 lines of code:
在建立连接之前，您必须添加两行代码：
StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);
Complete code as: (may be)
完整代码为：（可能是）
package com.ipvsoft.sendsms.utility;
import android.os.StrictMode;
import android.util.Log;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
public class SQLConnection {
private static final String LOG = "DEBUG";
private static String ip = "192.168.3.85";
private static String port = "1433";
private static String classs = "net.sourceforge.jtds.jdbc.Driver";
private static String db = "THTData";
private static String un = "sa";
private static String password = "admin";
public static Connection connect() {
Connection conn = null;
String ConnURL = null;
StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
StrictMode.setThreadPolicy(policy);
try {
Class.forName(classs);
ConnURL = "jdbc:jtds:sqlserver://" + ip +":"+port+";"
+ "databaseName=" + db + ";user=" + un + ";password="
+ password + ";";
conn = DriverManager.getConnection(ConnURL);
} catch (SQLException e) {
Log.d(LOG, e.getMessage());
} catch (ClassNotFoundException e) {
Log.d(LOG, e.getMessage());
}
return conn;
}
}
