Android Direct Connect SQL Server database

1. Download the JDBC driver for Jtds, an open source Java implementation, address: http://sourceforge.net/projects/jtds/

2. Add Jtds to the current Android project, I use the Jtds version of 1.2.5

3. Writing code

String ip= ""; String DBName=""; String UserName=""; String Password=""; String drivername= "Net.sourceforge.jtds.jdbc.Driver"; String Dburl= "jdbc:jtds:sqlserver://" +ip+ ": 1433/" +dbname+ "; charset=utf-8;"; Connection Dbconn=NULL;Try{class.forname (drivername); Dbconn=drivermanager.getconnection (Dburl,username, Password); Statement Statement=dbconn.createstatement (); String strSQL= "SELECT top 10* from SerialNumber"; ResultSet RS=statement.executequery (strSQL); ResultSetMetaData MetaData=Rs.getmetadata (); intnumcolumns=Metadata.getcolumncount ();  for(inti=1;i<=numcolumns;i++) {System.out.println (Metadata.getcolumnname (i)); }        while(Rs.next ()) {System.out.println (rs.getstring (1)); }       if(dbconn!=NULL) {dbconn.close (); }}Catch(Exception e) {e.printstacktrace ();}

4. Add access to network permissions in Androidmanifest.xml

<uses-permission android:name= "Android.permission.INTERNET"/>

5. The connection database cannot be manipulated in the current main thread, and new threads need to be created for database operations

Android Direct Connect SQL Server database