java 做app和sql_java-如何将Android Studio与SQL Server数据库连接...

我们目前遇到的问题与此处相同：How to connect Android Studio with SQL Server database,但尚未得到解答.

我们还使用sqljdb4.jar文件在Eclipse上成功建立了连接,我们在android上尝试了与Eclipse中相同的代码,但仅在Eclipse上有效.

我们还尝试了另一个驱动程序jtds1.3.1.jar,但它也不起作用

我们用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);

}

这是返回的错误：

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.access$1100(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)