public void updateInfos() { ConnexionBD bd = new ConnexionBD(); Statement st = bd.createStatement(); try { ResultSet rs = st.executeQuery( "SELECT id_colis, id_commande, cast(date_emballage as varchar) FROM " + Constantes.base_colis + " natural join " + Constantes.base_emballage + " WHERE id_colis =" + id + ";"); int col, com; String embal; if (rs.next()) { // rs.previous(); col = rs.getInt(1); com = rs.getInt(2); embal = rs.getString(3); // q = rs.getInt(4); colis.setText(String.valueOf(col)); commande.setText(String.valueOf(com)); date.setText(embal); // qual.setText(String.valueOf(q)); } rs.close(); st.close(); bd.close(); } catch (SQLException e) { e.printStackTrace(); } }