public static Object [][] executeQuerySelect(String QUERY) { Connection CON = null; int NCOL = 0; Object [][] tableau = null; ResultSet RESULTAT = null; try { Class.forName(pilote); System.out.println("CONNEXION ..."); CON = DriverManager.getConnection(url, user, pass); System.out.println("STATEMENT ..."); Statement REQUETE = CON.createStatement(); System.out.println("EXECUTION ..."); try { RESULTAT = REQUETE.executeQuery(QUERY); ResultSetMetaData RSMD = RESULTAT.getMetaData(); NCOL = RSMD.getColumnCount(); tableau = new Object[0][0]; } catch(Exception e) { javax.swing.JOptionPane.showMessageDialog(null, "REQUETE INVALIDE: "" + QUERY + """, "Requette !!", javax.swing.JOptionPane.ERROR_MESSAGE); System.out.println("REQUETE INVALIDE: "" + QUERY + """); } System.out.println("TRAITEMENT DES DONNEES ..."); int i = 0; // ExTRACTION DES RESULTAT while (RESULTAT.next()) { Object [] add_tab = new Object[NCOL]; for (int j=1;j<=NCOL;j++) { add_tab[j - 1] = RESULTAT.getObject(j); } tableau = Connect.addRowToTableau(tableau, add_tab, NCOL); i++; } } catch(Exception e){ javax.swing.JOptionPane.showMessageDialog(null, "Erreur dans le traitements de donnees !!", "Traitement !!", javax.swing.JOptionPane.ERROR_MESSAGE); } finally { try { System.out.println("DECONNEXION..."); CON.close(); } catch(SQLException e){ javax.swing.JOptionPane.showMessageDialog(null, "Probleme au niveau SQL", "SQL !!", javax.swing.JOptionPane.ERROR_MESSAGE); } catch (Exception ex) { javax.swing.JOptionPane.showMessageDialog(null, "Impossible de se connecter a la base de donnees !", "Base de donnees !!", javax.swing.JOptionPane.ERROR_MESSAGE); } } return tableau; }
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre question