Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- Network error IDException: failed to connect to /ANDRESPCSQLEXPRESS
- (port 1433): connect failed: ENETUNREACH (Network is unreachable)
- Attempt to invoke interface method
- 'java.sql.PreparedStatementjava.sql.Conn
- ection.prepareStatement(java.lang.String)'
- on a null object reference
- public Connection conexionBD() {
- Connection conexion = null;
- try{
- StrictMode.ThreadPolicy policy = new StrictMode.ThreadPolicy.Builder().permitAll().build();
- StrictMode.setThreadPolicy(policy);
- Class.forName("net.sourceforge.jtds.jdbc.Driver").newInstance();
- conexion = DriverManager.getConnection("jdbc:jtds:sqlserver://ANDRESPC\SQLEXPRESS;databasename=speedex1;user=andres;password=123;");
- }
- catch (Exception e) {
- Toast.makeText(getApplicationContext(), e.getMessage(), Toast.LENGTH_LONG).show();
- }
- return conexion;
- }
- public void consultarPaquete() {
- try {
- 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 = ?");
- pat.setInt(1, Integer.parseInt(envio));
- pat.executeUpdate();
- ResultSet rs = pat.executeQuery();
- if(rs.next()){
- //asignandole a los atributos de la clase
- estado = rs.getString(1);
- fecha = rs.getString(2);
- transporte = rs.getString(3);
- precio = rs.getDouble(4);
- }
- //cerrando conexion
- pat.close();
- Toast.makeText(getApplicationContext(), "Consulta exitosa", Toast.LENGTH_LONG).show();
- }
- catch (Exception ex) {
- Toast.makeText(getApplicationContext(), ex.getMessage(), Toast.LENGTH_LONG).show();
- }
- }
- public void ejecutarConsulta(View view) {
- consultarPaquete();
- System.out.println("El estado es " + estado + "/n" + "La fecha es " + fecha + "/n" + "El tipo de transporte es " + transporte + "/n" + "El precio es " + precio);
- }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement