Advertisement
Guest User

Untitled

a guest
Sep 19th, 2017
79
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 2.14 KB | None | 0 0
  1. Network error IDException: failed to connect to /ANDRESPCSQLEXPRESS
  2. (port 1433): connect failed: ENETUNREACH (Network is unreachable)
  3.  
  4. Attempt to invoke interface method
  5. 'java.sql.PreparedStatementjava.sql.Conn
  6. ection.prepareStatement(java.lang.String)'
  7. on a null object reference
  8.  
  9. public Connection conexionBD() {
  10. Connection conexion = null;
  11. try{
  12. StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
  13. StrictMode.setThreadPolicy(policy);
  14. Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
  15. conexion = DriverManager.getConnection("jdbc:jtds:sqlserver://ANDRESPC\SQLEXPRESS;databasename=speedex1;user=andres;password=123;");
  16.  
  17. }
  18. catch (Exception e) {
  19. Toast.makeText(getApplicationContext(), e.getMessage(), Toast.LENGTH_LONG).show();
  20. }
  21. return conexion;
  22. }
  23.  
  24. public void consultarPaquete() {
  25. try {
  26. PreparedStatement pat = conexionBD().prepareStatement("SELECT es.estado, en.fechaLlegada, t.transporte, en.precioTotal FROM estado es, envio en, medioTransporte t WHERE es.estadoId = en.estadoId AND t.transporteId = en.transporteId AND en.envioId = ?");
  27. pat.setInt(1, Integer.parseInt(envio));
  28. pat.executeUpdate();
  29. ResultSet rs = pat.executeQuery();
  30. if(rs.next()){
  31. //asignandole a los atributos de la clase
  32.  
  33. estado = rs.getString(1);
  34. fecha = rs.getString(2);
  35. transporte = rs.getString(3);
  36. precio = rs.getDouble(4);
  37. }
  38. //cerrando conexion
  39. pat.close();
  40.  
  41. Toast.makeText(getApplicationContext(), "Consulta exitosa", Toast.LENGTH_LONG).show();
  42. }
  43. catch (Exception ex) {
  44. Toast.makeText(getApplicationContext(), ex.getMessage(), Toast.LENGTH_LONG).show();
  45. }
  46. }
  47.  
  48. public void ejecutarConsulta(View view) {
  49.  
  50. consultarPaquete();
  51. System.out.println("El estado es " + estado + "/n" + "La fecha es " + fecha + "/n" + "El tipo de transporte es " + transporte + "/n" + "El precio es " + precio);
  52. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement