public Object[][] tableauDesDonnees()
Object[][] data = tableauDesDonnees();
public Object [][] tableauDesDonnees() { Object[][] tableauDesDonnees = null; try { Statement state = this.connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String requete = "SELECT * FROM journaliste"; ResultSet result = state.executeQuery(requete); ResultSetMetaData meta = result.getMetaData(); result.last(); int row = result.getRow(); Object [][]data = new Object [result.getRow()] [((ResultSetMetaData) result).getColumnCount()]; result.beforeFirst(); int j= 1; while (result.next()) { for(int i = 1; i<= meta.getColumnCount();i++) { data [j-1][i-1] = result.getObject(i); j++; } } } catch (SQLException e) { e.printStackTrace(); } return tableauDesDonnees; }
internalFrame.setClosable(true); internalFrame.setMaximizable(true); internalFrame.setIconifiable(true); internalFrame.setBounds(50, 43, 265, 255); fenetre.getContentPane().add(internalFrame); Object[][] data =tableauDesDonnees(); String [] nomDesColonnes = {"Nom","Prenom","Agence","EMAIL","ID"}; JTable tableau = new JTable(data, nomDesColonnes); internalFrame.getContentPane().add(new JScrollPane(tableau)); internalFrame.setVisible(true); nouvelArticle.setBounds(31, 32, 305, 318);
Object[][] data =tableauDesDonnees();
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionpublic Object [][] tableauDesDonnees()
internalFrame.setClosable(true); internalFrame.setMaximizable(true); internalFrame.setIconifiable(true); internalFrame.setBounds(50, 43, 265, 255); fenetre.getContentPane().add(internalFrame); Object[][] data =tableauDesDonnees(); String [] nomDesColonnes = {"Nom","Prenom","Agence","EMAIL","ID"}; JTable tableau = new JTable(data, nomDesColonnes); internalFrame.getContentPane().add(new JScrollPane(tableau)); internalFrame.setVisible(true); nouvelArticle.setBounds(31, 32, 305, 318);
Object[][] data = new DAOJournaliste().tableauDesDonnees();
Object[][] data = DAOJournaliste.tableauDesDonnees();
public Object [][] tableauDesDonnees() { Object[][] data = null; try { Statement state = this.connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String requete = "SELECT * FROM journaliste"; ResultSet result = state.executeQuery(requete); ResultSetMetaData meta = result.getMetaData(); result.last(); int row = result.getRow(); data = new Object [result.getRow()] [((ResultSetMetaData) result).getColumnCount()]; result.beforeFirst(); int j= 1; while (result.next()) { for(int i = 1; i<= meta.getColumnCount();i++) { data [j-1][i-1] = result.getObject(i); j++; } } } catch (SQLException e) { e.printStackTrace(); } return tableauDesDonnees; }
Object[][] data = new DAOJournaliste().tableauDesDonnees();
Object[][] data = new DAOJournaliste(null, null, null, null, 0).tableauDesDonnees();
data = new Object [result.getRow()] [((ResultSetMetaData) result).getColumnCount()];
((ResultSetMetaData) result)
result.getMetaData().getColumnCount()
Statement state = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
public class DAOJournaliste extends DAO<Journaliste1>{ public DAOJournaliste(String nom, String prenom, String agence, String email, int id) { if(connect==null) connect = DAOConnexion.getConnexion(); }
public static Object [][] tableauDesDonnees() { Object[][] data = null; try { Statement state = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY); String requete = "SELECT * FROM journaliste"; ResultSet result = state.executeQuery(requete); ResultSetMetaData meta = result.getMetaData(); result.last(); int row = result.getRow(); data = new Object [result.getRow()] [((ResultSetMetaData) result).getColumnCount()]; result.beforeFirst(); int j= 1; while (result.next()) { for(int i = 1; i<= meta.getColumnCount();i++) { data [j-1][i-1] = result.getObject(i); j++; } } } catch (SQLException e) { e.printStackTrace(); } return data; }
internalFrame.setClosable(true); internalFrame.setMaximizable(true); internalFrame.setIconifiable(true); internalFrame.setBounds(325, 283, 265, 255); fenetre.getContentPane().add(internalFrame); Object[][] data = DAOJournaliste.tableauDesDonnees(); String [] nomDesColonnes = {"Nom","Prenom","Agence","EMAIL","ID"}; JTable tableau = new JTable(data, nomDesColonnes); tableau.setSelectionMode(ListSelectionModel.SINGLE_SELECTION); internalFrame.getContentPane().add(new JScrollPane(tableau));
Statement state = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
Sytem.out.println("Connexion:"connect); Statement state = connect.createStatement(ResultSet.TYPE_SCROLL_INSENSITIVE,ResultSet.CONCUR_READ_ONLY);
public class DAOConnexion{ /* * Singleton de connexion * * * */ private String url = "jdbc:postgresql://localhost:5432/GestionJournal"; private String user = "postgres"; private String passwd = "190707190707"; private static Connection connexion = null; //Class.forName("org.postgresql.Driver"); // l'objet est static : il n'en n'existe donc qu'un seul exemplaire, quelque soit le nombre d'objet de la classe. private DAOConnexion(){ //le constructeur fait la connexion, mais il n'est accessible qu'en interne try { connexion = DriverManager.getConnection(url, user, passwd); //connexion = DriverManager.getConnection(url); } catch (SQLException e) { e.printStackTrace(); } } public static Connection getConnexion(){ //l'instanciation active le constructeur if(connexion == null){ new DAOConnexion(); } return connexion; } }
if(connexion == null){ new DAOConnexion();//Créé une nouvelle instance de la classe qui ne sert à rien }
public class ConnexionPostgresql { private static final ConnexionPostgresql instance = new ConnexionPostgresql(); private final String URL = "jdbc:postgresql://localhost:5432/GestionJournal"; private final String USER = "postgres"; private final String PASSWD = "190707190707"; private Connexion connexion; private ConnexionPostgresql(){ connexion = DriverManager.getConnection(URL, USER, PASSWD); } public void getConnexion(){ return connexion; } public static ConnexionPostgresql getInstance(){ return instance; } }
ConnexionPostgresql.getInstance().getConnexion()
public class ConnexionPostgresql { private static final ConnexionPostgresql instance = new ConnexionPostgresql(); private final String URL = "jdbc:postgresql://localhost:5432/GestionJournal"; private final String USER = "postgres"; private final String PASSWD = "190707190707"; private Connexion connexion; private ConnexionPostgresql(){ connexion = DriverManager.getConnection(URL, USER, PASSWD); } public Connexion getConnexion(){ return connexion; } public static ConnexionPostgresql getInstance(){ return instance; } }