Advertisement
Guest User

Untitled

a guest
May 6th, 2016
92
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.50 KB | None | 0 0
  1. public ConnectionHelper() {
  2. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder()
  3. .permitAll().build();
  4. StrictMode.setThreadPolicy(policy);
  5. setConnection(connection);
  6.  
  7. try {
  8.  
  9. Class.forName("net.sourceforge.jtds.jdbc.Driver");
  10. setIpAddress("X.X.X.X:1433");
  11. setDb("XXX");
  12. setUserName("XX");
  13. setPassword("XXXX");
  14.  
  15. setConnectionURL("jdbc:jtds:sqlserver://" + getIpAddress() + ";"
  16. + "databaseName=" + getDb() + ";user=" + getUserName()
  17. + ";password=" + getPassword() + ";");
  18. setConnection(DriverManager.getConnection(getConnectionURL()));
  19. } catch (SQLException se) {
  20. Log.e("ERRO", se.getMessage());
  21.  
  22. } catch (ClassNotFoundException e) {
  23. Log.e("ERRO", e.getMessage());
  24. } catch (Exception e) {
  25. Log.e("ERRO", e.getMessage());
  26. }
  27. }
  28.  
  29. public Connection getConnection() {
  30. return connection;
  31. }
  32.  
  33. ConnectionHelper connectionHelper = new ConnectionHelper();
  34. CallableStatement callableStatement;
  35. try {
  36. callableStatement = connectionHelper.getConnection().prepareCall("{call MySP(?, ?, ?)}");
  37. callableStatement.setInt(1, X);
  38. callableStatement.setInt(2, X));
  39. callableStatement.setInt(3, X);
  40. callableStatement.executeUpdate();
  41.  
  42. } catch (SQLException e) {
  43. e.printStackTrace();
  44.  
  45. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement