String connectdb = "Jdbc:jtds:sqlserver://172.16.1.15:1433;databasename=yanbu";//The connection string is replaced with this try { Class.forName ("Net.sourceforge.jtds.jdbc.Driver");//load driver replaced by this} catch (Exception e) { E.printstacktrace (); System.out.println ("Failed to load Database engine"); System.exit (0); } System.out.println ("Database-driven success"); try {String user = "sa"; String password = "sa"; Connection con = drivermanager.getconnection (connectdb, user, password);//Connect Database object System.out.println (" Connection database succeeded "); int i = 1; Statement Statement = con.createstatement (resultset.type_scroll_sensitive, resultset.concur_updatable); ResultSet ResultSet = Statement.executequery ("select * from Maxsns where Name = ' quality inspection number '); while (Resultset.next ()) {//<code>reSultset</code> initially points to the first row System.out.println (Resultset.getint ("SN"));//output nth row, the value of the column named "test_id" i + = Resultset.getint ("SN"); Resultset.updateint ("SN", I); Resultset.updaterow (); } resultset.close (); Statement.close (); } catch (SQLException e) {e.printstacktrace (); }
Android uses jdbc1.3.0 to operate SQL Server