How to connect and access SQL Database server from Android app??

Recently I have tried to connect to SQL Database server which is in my local network machine. I can connect and access SQL server from my Android app. I did it in the following way….

1. First of all you need a JDBC driver library for SQL Server. As we know android library has only SQLite database driver. So first download an open source JDBC driver from this http://jtds.sourceforge.net/ site (I downloaded the Linux version).

2. Then import the jar file into your Android app.(jtds-1.2.5.jar).

3. Now just try this code by modifying according to your context

01	import java.sql.Connection;

02	import java.sql.DriverManager;

03	import java.sql.ResultSet;

04	import java.sql.Statement;

05

06	import net.sourceforge.jtds.jdbc.*;

07

08	public void query2()

09

{

10	Log.i("Android"," MySQL Connect Example.");

11	Connection conn = null;

12

try {

13	String driver = "net.sourceforge.jtds.jdbc.Driver";

14	Class.forName(driver).newInstance();

15	//test = com.microsoft.sqlserver.jdbc.SQLServerDriver.class;

16	String connString = "jdbc:jtds:sqlserver://server_ip_address:1433/DBNAME;encrypt=fasle;user=xxxxxxxxx;                       password=xxxxxxxx;instance=SQLEXPRESS;";

17	String username = "xxxxxx";

18	String password = "xxxxxxxxxx";

19	conn = DriverManager.getConnection(connString,username,password);

20	Log.w("Connection","open");

21	Statement stmt = conn.createStatement();

22	ResultSet reset = stmt.executeQuery("select * from TableName");

23

24	//Print the data to the console

25	while(reset.next()){

26	Log.w("Data:",reset.getString(3));

27	//              Log.w("Data",reset.getString(2));

28

}

29	conn.close();

30

31	} catch (Exception e)

32

{

33	Log.w("Error connection","" + e.getMessage());

34

}

35

}

• Tag:Mobile,programming,guids,database,sql sever,mysql,jtds-1.2.5.jar,android