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(connStringusernamepassword); 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(Datareset.getString(2)); 28 } 29 conn.close(); 30 31 } catch (Exception e) 32 { 33 Log.w( Error connection   + e.getMessage()); 34 } 35 }