sql db Connectivity

Question

Hi,     I need code of connectivity between android and sql server.  Please help.. Its important.                                Thanks in advance!

Joginder Banger · Answer

Hi Ankit,   am not sure, but may be this link help you.   http://mob-programming.blogspot.in/search/label/How%20to%20connect%20and%20access%20SQL%20Database%20server%20from%20Android%20app%3F%3F       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 }