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;
}
} |
Partager