如何在本地将Android应用程序连接到SQL Server数据库。 [英] How can I connect android app to SQL server database locally.

问题描述

我有Android应用程序和SQL服务器数据库。

我的问题是如何将我的Android应用程序连接到SQL数据库本地我不希望从服务器访问数据库。我正在使用android studio和sql server 2005

提前感谢



我尝试了什么：



public void ConnectToDatabase（）{

try {



// SET CONNECTIONSTRING

Class.forName（net.sourceforge.jtds.jdbc.Driver）。newInstance（）;

String username =XXXXXXXXX;

String password =XXXXXX;

连接DbConn = DriverManager.getConnection（jdbc：jtds：sqlserver：//192.188.4.83：1433 / DATABASE; user =+ username +; password =+密码）;



Log.w（连接，打开）;

语句stmt = DbConn.createStatement（ ）;

ResultSet reset = stmt.executeQuery（select * from users）;





EditText num =（EditText）findViewById（R.id.displaymessage）;

num.setText（reset.getString（1））;



DbConn.close（）;



} catch（例外e）

{

Log.w（错误连接，+ e.getMessage（））;

}

}

i have android app and sql server database.
my question is how can i connect my android app to sql database Locally i don't want access database from server. i am using android studio and sql server 2005
thanks in advance

What I have tried:

public void ConnectToDatabase(){
try {

// SET CONNECTIONSTRING
Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
String username = "XXXXXXXXX";
String password = "XXXXXX";
Connection DbConn = DriverManager.getConnection("jdbc:jtds:sqlserver://192.188.4.83:1433/DATABASE;user=" + username + ";password=" + password);

Log.w("Connection","open");
Statement stmt = DbConn.createStatement();
ResultSet reset = stmt.executeQuery(" select * from users ");


EditText num = (EditText) findViewById(R.id.displaymessage);
num.setText(reset.getString(1));

DbConn.close();

} catch (Exception e)
{
Log.w("Error connection","" + e.getMessage());
}
}

推荐答案

< a href =http://mob-programming.blogspot.co.uk/search/label/How%20to%20connect%20and%20access%20SQL%20Database%20server%20from%20Android%20app%3F%3F>移动版编程指南：如何从Android应用程序连接和访问SQL数据库服务器 [ ^ ]

这篇关于如何在本地将Android应用程序连接到SQL Server数据库。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！