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 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86
| package Interfaces;
import java.awt.EventQueue;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;
import javax.swing.JTable;
import javax.swing.JLabel;
import Classes.connexion;
import java.sql.*;
import java.util.*;
public class Fenetre extends JFrame {
private JPanel contentPane;
private JTable table;
private Statement st=null;
private ResultSet rs=null;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
Fenetre frame = new Fenetre();
frame.setVisible(true);
} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the frame.
*/
public Fenetre() {
setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
setBounds(100, 100, 683, 444);
contentPane = new JPanel();
contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
setContentPane(contentPane);
contentPane.setLayout(null);
Vector columnNames = new Vector();
Vector data = new Vector();
try {
Connection conn = connexion.getMySqlConnection();
String sql = "Select * from emplacement ";
st = conn.createStatement();
rs = st.executeQuery( sql );
ResultSetMetaData md = rs.getMetaData();
int columns = md.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement( md.getColumnName(i) );
}
while (rs.next()) {
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++) {
row.addElement( rs.getObject(i) );
}
data.addElement( row );
}
rs.close();
st.close();
}
catch(Exception e) {
System.out.println( e );
}
table = new JTable(data, columnNames);
table.setBounds(678, 325, -637, -255);
contentPane.add(table);
JLabel lblUneTable = new JLabel("Une table");
lblUneTable.setBounds(294, 11, 83, 14);
contentPane.add(lblUneTable);
}
} |
Partager