Merci pr la reponse. En fait j'ai crée un modele qui etends AbstractTableModel.voici un exemple qui illustre le probleme.
import javax.swing.SwingUtilities; import java.awt.BorderLayout; import javax.swing.JPanel; import javax.swing.JFrame; import javax.swing.JScrollPane; import javax.swing.JTable; import java.awt.Rectangle; import java.sql.Connection; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.swing.JButton; import oracle.jdbc.pool.OracleDataSource; import java.awt.Dimension; import java.awt.event.ActionEvent; import java.awt.event.ActionListener;
public class test extends JFrame {
private static final long serialVersionUID = 1L; private JPanel jContentPane = null; private JScrollPane jScrollPane = null; private static JTable jTable = null; private static JButton jButton = null; private static String req="select * from emp";
/** * This method initializes jScrollPane * * @return javax.swing.JScrollPane */ private JScrollPane getJScrollPane() { if (jScrollPane == null) { jScrollPane = new JScrollPane(); jScrollPane.setBounds(new Rectangle(0, 80, 637, 84)); jScrollPane.setViewportView(getJTable()); } return jScrollPane; }
/** * This method initializes jTable * * @return javax.swing.JTable */ private JTable getJTable() { if (jTable == null) { jTable = new JTable(); jTable.setSize(new Dimension(581, 260)); } return jTable; }
/** * This method initializes jButton * * @return javax.swing.JButton */ private JButton getJButton() { if (jButton == null) { jButton = new JButton(); jButton.setBounds(new Rectangle(99, 20, 91, 26)); jButton.setText("Rechercher"); } return jButton; }
//ici la methode qui effectue la recherche et le raffraichissement public static void rechercher(){ try{ Dbmanager d = new Dbmanager(); //Dbmanager est une classe qui contient les methode relatives a la base (connexion, execution des requete...) d.connect("database", "user", "password"); MonTableModel m =new MonTableModel(d.ColNames(d.getQuery(req)),d.donnee(d.getQuery(req)));//MonTableModel est la classe qui etends abstract table model jTable.setModel(m); while(true){ m.majDonnees(d.donnee(d.getQuery(req))); try { Thread.sleep(2000); }catch(InterruptedException ie){} } }catch(Exception et){et.printStackTrace();} }
public static void main(String[] args) { new test(); rechercher();// la methode placé ainsi ds la main fonctionnecorrectement mais elle fonctionne dés le demarrage de l'application et j n peu pa modifier les criteres de recherche }
/** * This is the default constructor */ public test() { super(); initialize(); }
private void initialize() { this.setSize(300, 200); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setContentPane(getJContentPane()); this.setTitle("JFrame"); this.setVisible(true); }
/** * This method initializes jContentPane * * @return javax.swing.JPanel */ private JPanel getJContentPane() { if (jContentPane == null) { jContentPane = new JPanel(); jContentPane.setLayout(null); jContentPane.add(getJScrollPane(), null); jContentPane.add(getJButton(), null); } return jContentPane; } }
Maintenant si j'elimine l'appel de la methode rechercher du main (et je suupprime l'attribut statique) et que je l'appelle dans un action performed du boutton jButton, l'execution se bloque et je n recoi mem pa de message d'erreur Voici le code bloquant
.import javax.swing.SwingUtilities; import java.awt.BorderLayout; import javax.swing.JPanel; import javax.swing.JFrame; import javax.swing.JScrollPane; import javax.swing.JTable; import java.awt.Rectangle; import java.sql.Connection; import java.sql.ResultSet; import java.sql.ResultSetMetaData; import java.sql.Statement; import java.util.ArrayList; import java.util.List; import javax.swing.JButton; import oracle.jdbc.pool.OracleDataSource; import java.awt.Dimension; import java.awt.event.ActionEvent; import java.awt.event.ActionListener;
public class test extends JFrame {
private static final long serialVersionUID = 1L; private JPanel jContentPane = null; private JScrollPane jScrollPane = null; private static JTable jTable = null; // @jve:decl-index=0:visual-constraint="10,220" private static JButton jButton = null; private static String req="select * from emp"; // @jve:decl-index=0: //private static boolean rech=false; /** * This method initializes jScrollPane * * @return javax.swing.JScrollPane */ private JScrollPane getJScrollPane() { if (jScrollPane == null) { jScrollPane = new JScrollPane(); jScrollPane.setBounds(new Rectangle(0, 80, 637, 84)); jScrollPane.setViewportView(getJTable()); } return jScrollPane; }
/** * This method initializes jTable * * @return javax.swing.JTable */ private JTable getJTable() { if (jTable == null) { jTable = new JTable(); jTable.setSize(new Dimension(581, 260)); } return jTable; }
/** * This method initializes jButton * * @return javax.swing.JButton */ private JButton getJButton() { if (jButton == null) { jButton = new JButton(); jButton.setBounds(new Rectangle(99, 20, 91, 26)); jButton.setText("Rechercher"); jButton.addActionListener(new java.awt.event.ActionListener() { public void actionPerformed(java.awt.event.ActionEvent e) { req="select ename from emp" ; rechercher();} // ajout d'un action performed qui me permet d'afficher la jtable suivant un nouveau critere de recherche et empeche la recherche des le demarrage de l'application }); } return jButton; }
public void rechercher(){ try{ Dbmanager d = new Dbmanager(); d.connect("pfe", "sysman", "password"); MonTableModel m =new MonTableModel(d.ColNames(d.getQuery(req)),d.donnee(d.getQuery(req))); jTable.setModel(m); while(true){ m.majDonnees(d.donnee(d.getQuery(req))); try { Thread.sleep(2000); }catch(InterruptedException ie){} } }catch(Exception et){et.printStackTrace();} } public static void main(String[] args) { new test(); }
/** * This is the default constructor */ public test() { super(); initialize(); }
private void initialize() { this.setSize(300, 200); this.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE); this.setContentPane(getJContentPane()); this.setTitle("JFrame"); this.setVisible(true); }
/** * This method initializes jContentPane * * @return javax.swing.JPanel */ private JPanel getJContentPane() { if (jContentPane == null) { jContentPane = new JPanel(); jContentPane.setLayout(null); jContentPane.add(getJScrollPane(), null); jContentPane.add(getJButton(), null); } return jContentPane; }
}
J'espere que j vous ai eclairci le prob, merci encore Crdlt
|