1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
| import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.Statement;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JScrollPane;
import javax.swing.JTable;
public class Affichage extends JPanel {
private static final String String = null;
JLabel message;
JPanel pan;
Statement state;
ResultSet result;
ResultSetMetaData resultMeta;
String title[];
Object[][] data;
public Affichage()
{
Fenetre fen = new Fenetre();
try
{
Connection con =Ajout_etudiant.getInstance();
state = con.createStatement();
result = state.executeQuery("SELECT * FROM t_insertion");
resultMeta = result.getMetaData();
String rep[];
for(int i = 1; i <= resultMeta.getColumnCount(); i++)
{
String title[] = new String[i];
title[i] = resultMeta.getColumnName(i).toUpperCase();
}
while(result.next())
{
for(int i = 1; i <= resultMeta.getColumnCount(); i++)
{
Object[][] data = {{result.getObject(i).toString()}};
}
}
JTable tableau = new JTable(data, title);
add(new JScrollPane(tableau));
}catch(Exception e)
{
System.out.println("Affichage Erreur: " +e.getMessage());
e.printStackTrace();
}
fen.setContentPane(this);
fen.repaint();
fen.validate();
}
} |
