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 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129
|
/*
* To change this template, choose Tools | Templates
* and open the template in the editor.
*/
package rmi;
/**
*
* @author Blaugrana
*/
import java.awt.BorderLayout;
import java.awt.Color;
import java.awt.Dimension;
import java.sql.*;
import java.util.Vector;
import javax.swing.*;
import javax.swing.table.DefaultTableModel;
public class ListeUser extends JDialog {
private Statement state;
private ResultSet resultat;
private ResultSetMetaData resultatMD;
private JTable table = null;
private JPanel panotable = null;
private JScrollPane js= null;
final Vector columnNames = new Vector();
final Vector data = new Vector();
Connection con;
public ListeUser() throws ClassNotFoundException, SQLException
{
this.setLayout(null);
this.setTitle("Liste des utilisateurs");
new Connexion().getInstance();
this.setLocationRelativeTo(this.getParent());
java.awt.Dimension screenSize = java.awt.Toolkit.getDefaultToolkit().getScreenSize();
this.pack();
this.setLocation(
(screenSize.width-1000)/2,
(screenSize.height-590)/2
);
this.setSize(1000, 620);
this.setModal(true);
Color c = new Color(224,255,255);
afficheUser();
this.setVisible(true);
}
public void afficheUser() throws ClassNotFoundException, SQLException
{
state=Connexion.getInstance().createStatement();
resultat=state.executeQuery("select * from user");
resultatMD =resultat.getMetaData();
int compteur= resultatMD.getColumnCount();
for(int i=1;i<=compteur;i++)
{
columnNames.addElement(resultatMD.getColumnName(i));
}
columnNames.addElement("Check Box");
while(resultat.next()){
Vector row = new Vector(compteur + 1);
for(int i=1;i<=compteur;i++)
{
row.addElement( resultat.getObject(i) );
}
row.addElement(new JCheckBox().isFocusable());
data.addElement( row );
}
table = new JTable(data,columnNames);
panotable = new JPanel();
panotable.setBounds(22,300,519,156);
panotable.setLayout(new BorderLayout());
panotable.setBackground(Color.gray);
js = new JScrollPane(table);
js.setPreferredSize(new Dimension(50,50));
panotable.add(js,BorderLayout.CENTER );
this.setContentPane(panotable);
}
} |
Partager