Guest User

Untitled

a guest
Feb 6th, 2018
105
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.88 KB | None | 0 0
  1. @Override
  2. protected void onCreate(Bundle savedInstanceState) {
  3. super.onCreate(savedInstanceState);
  4. setContentView(R.layout.activity_main);
  5.  
  6. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  7. StrictMode.setThreadPolicy(policy);
  8. try {
  9. Class.forName("net.sourceforge.jtds.jdbc.Driver");
  10. String cn = "jdbc:jtds:sqlserver://ip:port/DBname;instance=INSTANCIA_SQL;user=username;password=secret;";
  11. connection = DriverManager.getConnection(cn);
  12. Statement statement = connection.createStatement();
  13. ResultSet resultSet = statement.executeQuery("select * from table");
  14. while (resultSet.next()){
  15. Log.i("primer campo",resultSet.getString(1));
  16. }
  17.  
  18. } catch (ClassNotFoundException e) {
  19. e.printStackTrace();
  20.  
  21. } catch (SQLException e) {
  22. e.printStackTrace();
  23.  
  24. }
Add Comment
Please, Sign In to add comment