Jtable

Bonjour,
je voudrais effectuer une connection entre la base de donnée et une apllication java en insérant les informations selectionnées de la base de données dans un jTable voila mon code:




package p1;

import javax.swing.SwingUtilities;
import java.awt.BorderLayout;
import javax.swing.JPanel;
import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.Rectangle;
import java.awt.Dimension;
import java.beans.Statement;
import java.sql.*;
import javax.swing.JComboBox;
import javax.swing.JTable;

public class recherche_par_département extends JFrame {

private static final long serialVersionUID = 1L;

private JPanel jContentPane = null;

private JLabel jLabel = null;

private JComboBox jComboBox = null;

private JTable jTable = null;

/**
* This method initializes jComboBox
*
* @return javax.swing.JComboBox
*/
private JComboBox getJComboBox() {
if (jComboBox == null) {
jComboBox = new JComboBox();
jComboBox.setBounds(new Rectangle(187, 22, 257, 36));
jComboBox.addKeyListener(new java.awt.event.KeyAdapter() {
public void keyReleased(java.awt.event.KeyEvent e) {
try {
Connection c= Connect.connect();
Statement st = (Statement) c.createStatement();
ResultSet rs = ((java.sql.Statement) st).executeQuery("select * from mission where nom_departement like '"+getJComboBox()+"'");

DefaultTableModel tm= new DefaultTableModel();

tm.setColumnIdentifiers(new String[]{"nom_mission","duree","date-depart","heure-depart","date-arrivee","heure-arrivee"});
while (rs.next())
{

tm.addRow(new Object[]{rs.getObject(1),rs.getObject(2),rs.getObject(3),rs.getObject(4),rs.getObject(5),rs.getObject(6)});
}
getJTable().setModel(tm);

}
catch (SQLException e1) {
e1.printStackTrace();
}
}

}

);
}
return jComboBox;
}

/**
* This method initializes jTable
*
* @return javax.swing.JTable
*/
private JTable getJTable() {
if (jTable == null) {
jTable = new JTable();
jTable.setBounds(new Rectangle(37, 85, 463, 260));
}
return jTable;
}

/**
* @param args
*/
public static void main(String[] args) {
// TODO Auto-generated method stub
SwingUtilities.invokeLater(new Runnable() {
public void run() {
recherche_par_département thisClass = new recherche_par_département();
thisClass.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
thisClass.setVisible(true);
}
});
}

/**
* This is the default constructor
*/
public recherche_par_département() {
super();
initialize();
}

/**
* This method initializes this
*
* @return void
*/
private void initialize() {
this.setSize(564, 392);
this.setContentPane(getJContentPane());
this.setTitle("JFrame");
try {
Connection c=Connect.connect();
Statement st = (Statement) c.createStatement();
ResultSet rs =((java.sql.Statement) st).executeQuery("select * from type");

getJComboBox().addItem("");
while (rs.next())
{
getJComboBox().addItem(rs.getObject(1));
}
rs.close();


} catch (SQLException e) {

e.printStackTrace();
}


}


/**
* This method initializes jContentPane
*
* @return javax.swing.JPanel
*/
private JPanel getJContentPane() {
if (jContentPane == null) {
jLabel = new JLabel();
jLabel.setBounds(new Rectangle(13, 19, 78, 27));
jLabel.setText("département");
jContentPane = new JPanel();
jContentPane.setLayout(null);
jContentPane.add(jLabel, null);
jContentPane.add(getJComboBox(), null);
jContentPane.add(getJTable(), null);
}
return jContentPane;
}

} // @jve:decl-index=0:visual-constraint="-2,-4"





jespere que vous pouvez maidez