voila c un peu fouilli avec des system.out.println c'est pour tester!! :-)
public void getFieldValues(Connection connection,String table_name)
{
String fieldvalues ="";
int j = 0;
int i=0;
conteneur = frame.getContentPane();
int cols = getColumnCount(connection,table_name);
int rows = getNumberOfRow(connection,table_name);
conteneur.setLayout(new BorderLayout());
JScrollPane jsp = new JScrollPane(table);
table = new JTable(rows, cols);
JTableHeader header = table.getTableHeader();
//------start process
for(int k =0 ; k<cols;k++)
{
table.getColumnModel().getColumn(k).setHeaderValue(getColumnName(connection,k+1,table_name));
}
conteneur.add(header, BorderLayout.NORTH);
conteneur.add(table, BorderLayout.CENTER);
//start view field
int columnnumber = getColumnCount(connection,table_name);
int rowNumber = getNumberOfRow(connection,table_name);
System.out.println("number of row : "+rowNumber);
try {
// Select the number of rows in the table
Statement stmt = connection.createStatement();
ResultSet resultSet = (ResultSet) stmt.executeQuery("SELECT count(*),* FROM "+table_name+" having count(*) = 10");
// Get the number of rows from the result set
resultSet.next();
for(j = 0 ;j<rowNumber;j++)
{
System.out.println("nombre de colonne 1: "+getColumnCount(connection,table_name));
for(i = 0 ; i<columnnumber;i++)
{
fieldvalues = resultSet.getString(i+1);
System.out.println("Field values : "+fieldvalues);
table.setValueAt(fieldvalues,j,i);
}
System.out.println(j);
resultSet.next();
}
} catch (SQLException e) {System.out.println("erreur de selection : "+e);}
frame.setSize(600,500);
frame.setVisible(true);
}
et voila
