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
|
import java.sql.*;
import java.util.ArrayList;
import javax.swing.table.AbstractTableModel;
import java.util.*;
public class TabModel extends AbstractTableModel{
String[] nomsColonnes = {" nom de Compte"," Unité de mesure"};
ArrayList donnees ;
public TabModel() {
donnees = new ArrayList();
initialiser();
}
public int getColumnCount(){return nomsColonnes.length;}
public int getRowCount(){return donnees.size();}
public String getColumnName(int col){return nomsColonnes[col];}
public Object getValueAt(int row, int col){
return ((ArrayList)donnees.get(row)).get(col);
}
public Class getColumnClass(int c) {return getValueAt(0, c).getClass();}
public void initialiser(){
String dataBase = "jdbc:odbc:depense";
try
{
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection dbConnection = DriverManager.getConnection(dataBase);
Statement stmt = dbConnection.createStatement();
System.out.println("connection etablie ");
ResultSet rslt = stmt.executeQuery("select * from tabCompte ");
while(rslt.next()){
donnees.add(rslt.getString(1));
donnees.add(rslt.getString(2));
}
dbConnection.close();
System.out.println("fermeture de connection a la base de données");
}
catch(Exception ex){
System.out.println("erreur de connection !!!!");
}
}
} |
Partager