Model de table avec vecteur au lieu de table
bonjour,
J'utilise dans mon moel de table des vecteurs pour (donneés et entete) au lieu de table a 2 dimenssions, avez vous une idée comment retourner les indices, colonnes, lignes au niveau des methodes implementés?
voici le code du model:
Code:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
| /* (non-Javadoc)
* @see javax.swing.table.AbstractTableModel#getValueAt(int, int)
*/
public Object getValueAt(int arg0, int arg1) {
return columnData[rowIndex][columnIndex];
//return null;
}
/* (non-Javadoc)
* @see javax.swing.table.AbstractTableModel#getColumnCount()
*/
public int getColumnCount() {
return columnNames.length;
//return 0;
}
/* (non-Javadoc)
* @see javax.swing.table.AbstractTableModel#getRowCount()
*/
public int getRowCount() {
return columnData.length;
//return 0;
} |
voici le code au complet:
Code:
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
| /*
* Created on Apr 5, 2011
*
* To change the template for this generated file go to
* Window>Preferences>Java>Code Generation>Code and Comments
*/
import java.awt.Color;
import java.util.Enumeration;
import java.util.Vector;
import javax.swing.table.AbstractTableModel;
import com.ibm.jvm.util.html.Row;
import java.sql.*;
public class Test3Model extends AbstractTableModel {
private final Vector columnNames = new Vector();
private final Vector columnData = new Vector();
public Test3Model() {
super();
getDataList();
}
public void getDataList() {
int countRows = 0;
String data = "jdbc:odbc:WorldEnergy";
try {
Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
Connection conn = DriverManager.getConnection(data, "", "");
Statement st = conn.createStatement();
ResultSet rec =
st.executeQuery(
"SELECT FIPS, Country, Year FROM Coal "
+ "ORDER BY Country");
// if (elementSelected.equals("")){
// rec =
// st.executeQuery("SELECT FIPS, Country, Year FROM Coal " +
// "ORDER BY Country");
// }else{
// rec =
// st.executeQuery("SELECT FIPS, Country, Year FROM Coal " +
// "WHERE " + "(Country = '" + elementSelected + "') " +
// "ORDER BY Country");
// }
ResultSetMetaData md = rec.getMetaData();
columnNames.removeAllElements();
int columns = md.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement(md.getColumnName(i));
}
Enumeration c = columnNames.elements();
while (c.hasMoreElements()) {
System.out.println("+++++" + c.nextElement());
}
columnData.removeAllElements();
while (rec.next()) {
countRows++;
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++) {
row.addElement(rec.getObject((i)));
}
columnData.addElement(row);
Enumeration el = columnData.elements();
while (el.hasMoreElements()) {
System.out.println("-----" + el.nextElement());
}
}
st.close();
} catch (SQLException s) {
System.out.println(
"SQL Error: "
+ s.toString()
+ " "
+ s.getErrorCode()
+ " "
+ s.getSQLState());
} catch (Exception e) {
System.out.println("Error: " + e.toString() + e.getMessage());
}
}
/* (non-Javadoc)
* @see javax.swing.table.AbstractTableModel#getValueAt(int, int)
*/
public Object getValueAt(int arg0, int arg1) {
return columnData[rowIndex][columnIndex];
//return null;
}
/* (non-Javadoc)
* @see javax.swing.table.AbstractTableModel#getColumnCount()
*/
public int getColumnCount() {
return columnNames.length;
//return 0;
}
/* (non-Javadoc)
* @see javax.swing.table.AbstractTableModel#getRowCount()
*/
public int getRowCount() {
return columnData.length;
//return 0;
}
} |
