/**下面这样可以*/
private Object[][] data=
{{"wang",new Integer(28),new Boolean(true)},
{"cheng",new Integer(26),new Boolean(false)},
{"zhang",new Integer(35),new Boolean(true)},
{"lin",new Integer(18),new Boolean(false)},
{"wang",new Integer(28),new Boolean(true)},
{"cheng",new Integer(26),new Boolean(false)},
{"zhang",new Integer(35),new Boolean(true)},
{"lin",new Integer(18),new Boolean(false)}};
/**结束*/
我换成从数据库中读出的数据，编译通过，运行报错
private Object data[][];
int i=0;
void conn(){
Conn conn=new Conn();
Statement stmt=conn.stmt();
ResultSet rs=null;
try{
String sql="select * from student";
rs=stmt.executeQuery(sql);
//rowField=new Vector();
//data=new Vector();
while(rs.next()){
String one=rs.getString(1);
String two=rs.getString(2);
String three=rs.getString(3);
data[i][0]=one;
data[i][1]=two;
data[i][2]=three;
}
}catch(SQLException e3){
System.out.println(e3);
}
}*/
private Object[][] data=
{{"wang",new Integer(28),new Boolean(true)},
{"cheng",new Integer(26),new Boolean(false)},
{"zhang",new Integer(35),new Boolean(true)},
{"lin",new Integer(18),new Boolean(false)},
{"wang",new Integer(28),new Boolean(true)},
{"cheng",new Integer(26),new Boolean(false)},
{"zhang",new Integer(35),new Boolean(true)},
{"lin",new Integer(18),new Boolean(false)}};
/**结束*/
我换成从数据库中读出的数据，编译通过，运行报错
private Object data[][];
int i=0;
void conn(){
Conn conn=new Conn();
Statement stmt=conn.stmt();
ResultSet rs=null;
try{
String sql="select * from student";
rs=stmt.executeQuery(sql);
//rowField=new Vector();
//data=new Vector();
while(rs.next()){
String one=rs.getString(1);
String two=rs.getString(2);
String three=rs.getString(3);
data[i][0]=one;
data[i][1]=two;
data[i][2]=three;
}
}catch(SQLException e3){
System.out.println(e3);
}
}*/
at MyTableModel.getRowCount(Employ.java:135)
at javax.swing.JTable.getRowCount(JTable.java:1656)
at javax.swing.JTable.valueChanged(JTable.java:2959)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSel
ectionModel.java:170)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSel
ectionModel.java:150)
at javax.swing.DefaultListSelectionModel.fireValueChanged(DefaultListSel
ectionModel.java:197)
at javax.swing.DefaultListSelectionModel.setAnchorSelectionIndex(Default
ListSelectionModel.java:559)
at javax.swing.JTable.initializeLocalVars(JTable.java:3357)
at javax.swing.JTable.<init>(JTable.java:374)
at javax.swing.JTable.<init>(JTable.java:317)
at Jtable.<init>(Employ.java:74)
at Employ.main(Employ.java:171)
private Object data[][];
不能动态的增加。
所以你可能得用java的一个数据结构；
我喜欢用ArrayList;
把你的程序用下面的替换一下：
private ArrayList data=new ArrayList();
private ArrayList rowdata;
int i=0;
void conn(){
Conn conn=new Conn();
Statement stmt=conn.stmt();
ResultSet rs=null;
try{
String sql="select * from student";
rs=stmt.executeQuery(sql);
//rowField=new Vector();
//data=new Vector();
while(rs.next()){
String one=rs.getString(1);
String two=rs.getString(2);
String three=rs.getString(3);
rowdata=new ArrayList(3);
rowdata.add(one);
rowdata.add(two);
rowdata.add(three);
data.add(rowdata);
}
}catch(SQLException e3){
System.out.println(e3);
}
}*/
试试。有什么问题。
再贴。
import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import javax.swing.table.*;
import javax.swing.event.*;
import javax.swing.border.*;public class TableExample2 implements LayoutManager {
static String[] ConnectOptionNames = { "Connect" };
static String ConnectTitle = "Connection Information"; Dimension origin = new Dimension(0, 0); JButton fetchButton;
JButton showConnectionInfoButton;
JButton deleteButton; JPanel connectionPanel;
JFrame frame; // The query/results window. JLabel userNameLabel;
JTextField userNameField;
JLabel passwordLabel;
JTextField passwordField;
// JLabel queryLabel;
JTextArea queryTextArea;
JComponent queryAggregate;
JLabel serverLabel;
JTextField serverField;
JLabel driverLabel;
JTextField driverField;
JPanel mainPanel; TableSorter sorter;
JDBCAdapter dataBase;
//Statement dataBase;
JScrollPane tableAggregate; /**
* Brigs up a JDialog using JOptionPane containing the connectionPanel.
* If the user clicks on the 'Connect' button the connection is reset.
*/
void activateConnectionDialog() {
if(JOptionPane.showOptionDialog(tableAggregate, connectionPanel, ConnectTitle,
JOptionPane.DEFAULT_OPTION, JOptionPane.INFORMATION_MESSAGE,
null, ConnectOptionNames, ConnectOptionNames[0]) == 0) {
connect();
frame.setVisible(true);
}
else if(!frame.isVisible())
System.exit(0);
} /**
* Creates the connectionPanel, which will contain all the fields for
* the connection information.
*/
public void createConnectionDialog() {
// Create the labels and text fields.
userNameLabel = new JLabel("User name: ", JLabel.RIGHT);
userNameField = new JTextField("omygame"); passwordLabel = new JLabel("Password: ", JLabel.RIGHT);
passwordField = new JTextField("gameomy"); serverLabel = new JLabel("Database URL: ", JLabel.RIGHT);
serverField = new JTextField("jdbc:oracle:thin:@200.200.200.200:1521:ora8"); driverLabel = new JLabel("Driver: ", JLabel.RIGHT);
driverField = new JTextField("oracle.jdbc.driver.OracleDriver");
connectionPanel = new JPanel(false);
connectionPanel.setLayout(new BoxLayout(connectionPanel,
BoxLayout.X_AXIS)); JPanel namePanel = new JPanel(false);
namePanel.setLayout(new GridLayout(0, 1));
namePanel.add(userNameLabel);
namePanel.add(passwordLabel);
namePanel.add(serverLabel);
namePanel.add(driverLabel); JPanel fieldPanel = new JPanel(false);
fieldPanel.setLayout(new GridLayout(0, 1));
fieldPanel.add(userNameField);
fieldPanel.add(passwordField);
fieldPanel.add(serverField);
fieldPanel.add(driverField); connectionPanel.add(namePanel);
connectionPanel.add(fieldPanel);
} public TableExample2() {
mainPanel = new JPanel(); // Create the panel for the connection information
createConnectionDialog(); // Create the buttons.
showConnectionInfoButton = new JButton("Configuration");
showConnectionInfoButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
activateConnectionDialog();
}
}); fetchButton = new JButton("Fetch");
fetchButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
fetch();
}
});
// Create the query text area and label.
queryTextArea = new JTextArea("SELECT * FROM titles", 25, 25);
queryAggregate = new JScrollPane(queryTextArea);
queryAggregate.setBorder(new BevelBorder(BevelBorder.LOWERED)); // Create the table.
tableAggregate = createTable();
tableAggregate.setBorder(new BevelBorder(BevelBorder.LOWERED)); // Add all the components to the main panel.
mainPanel.add(fetchButton);
mainPanel.add(showConnectionInfoButton);
mainPanel.add(queryAggregate);
mainPanel.add(tableAggregate);
mainPanel.setLayout(this); // Create a Frame and put the main panel in it.
frame = new JFrame("TableExample2");
frame.addWindowListener(new WindowAdapter() {
public void windowClosing(WindowEvent e) {System.exit(0);}});
frame.setBackground(Color.lightGray);
frame.getContentPane().add(mainPanel);
frame.pack();
frame.setVisible(false);
frame.setBounds(200, 200, 640, 480); activateConnectionDialog();
} public void connect() {
dataBase = new JDBCAdapter(
serverField.getText(),
driverField.getText(),
userNameField.getText(),
passwordField.getText());
sorter.setModel(dataBase);
} public void fetch() {
dataBase.executeQuery(queryTextArea.getText());
} public JScrollPane createTable() {
sorter = new TableSorter();
//connect();
//fetch();
// Create the table
JTable table = new JTable(sorter);
// Use a scrollbar, in case there are many columns.
table.setAutoResizeMode(JTable.AUTO_RESIZE_OFF); // Install a mouse listener in the TableHeader as the sorter UI.
sorter.addMouseListenerToHeaderInTable(table); JScrollPane scrollpane = new JScrollPane(table); return scrollpane;
} public static void main(String s[]) {
new TableExample2();
} public Dimension preferredLayoutSize(Container c){return origin;}
public Dimension minimumLayoutSize(Container c){return origin;}
public void addLayoutComponent(String s, Component c) {}
public void removeLayoutComponent(Component c) {}
public void layoutContainer(Container c) {
Rectangle b = c.getBounds();
int topHeight = 90;
int inset = 4;
showConnectionInfoButton.setBounds(b.width-2*inset-120, inset, 120, 25);
fetchButton.setBounds(b.width-2*inset-120, 60, 120, 25);
queryAggregate.setBounds(inset, inset, b.width-2*inset - 150, 80);
tableAggregate.setBounds(new Rectangle(inset,
inset + topHeight,
b.width-2*inset,
b.height-2*inset - topHeight));
}}import java.util.*;import javax.swing.table.TableModel;
import javax.swing.event.TableModelEvent;// Imports for picking up mouse events from the JTable. import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.awt.event.InputEvent;
import javax.swing.JTable;
import javax.swing.table.JTableHeader;
import javax.swing.table.TableColumn;
import javax.swing.table.TableColumnModel;public class TableSorter extends TableMap
{
int indexes[];
Vector sortingColumns = new Vector();
boolean ascending = true;
int compares; public TableSorter()
{
indexes = new int[0]; // For consistency.
} public TableSorter(TableModel model)
{
setModel(model);
} public void setModel(TableModel model) {
super.setModel(model);
reallocateIndexes();
} public int compareRowsByColumn(int row1, int row2, int column)
{
Class type = model.getColumnClass(column);
TableModel data = model; // Check for nulls Object o1 = data.getValueAt(row1, column);
Object o2 = data.getValueAt(row2, column); // If both values are null return 0
if (o1 == null && o2 == null) {
return 0;
}
else if (o1 == null) { // Define null less than everything.
return -1;
}
else if (o2 == null) {
return 1;
}/* We copy all returned values from the getValue call in case
an optimised model is reusing one object to return many values.
The Number subclasses in the JDK are immutable and so will not be used in
this way but other subclasses of Number might want to do this to save
space and avoid unnecessary heap allocation.
*/
if (type.getSuperclass() == java.lang.Number.class)
{
Number n1 = (Number)data.getValueAt(row1, column);
double d1 = n1.doubleValue();
Number n2 = (Number)data.getValueAt(row2, column);
double d2 = n2.doubleValue(); if (d1 < d2)
return -1;
else if (d1 > d2)
return 1;
else
return 0;
}
else if (type == java.util.Date.class)
{
Date d1 = (Date)data.getValueAt(row1, column);
long n1 = d1.getTime();
Date d2 = (Date)data.getValueAt(row2, column);
long n2 = d2.getTime(); if (n1 < n2)
return -1;
else if (n1 > n2)
return 1;
else return 0;
}
else if (type == String.class)
{
String s1 = (String)data.getValueAt(row1, column);
String s2 = (String)data.getValueAt(row2, column);
int result = s1.compareTo(s2); if (result < 0)
return -1;
else if (result > 0)
return 1;
else return 0;
}
else if (type == Boolean.class)
{
Boolean bool1 = (Boolean)data.getValueAt(row1, column);
boolean b1 = bool1.booleanValue();
Boolean bool2 = (Boolean)data.getValueAt(row2, column);
boolean b2 = bool2.booleanValue(); if (b1 == b2)
return 0;
else if (b1) // Define false < true
return 1;
else
return -1;
}
else
{
Object v1 = data.getValueAt(row1, column);
String s1 = v1.toString();
Object v2 = data.getValueAt(row2, column);
String s2 = v2.toString();
int result = s1.compareTo(s2); if (result < 0)
return -1;
else if (result > 0)
return 1;
else return 0;
}
} public int compare(int row1, int row2)
{
compares++;
for(int level = 0; level < sortingColumns.size(); level++)
{
Integer column = (Integer)sortingColumns.elementAt(level);
int result = compareRowsByColumn(row1, row2, column.intValue());
if (result != 0)
return ascending ? result : -result;
}
return 0;
} public void reallocateIndexes()
{
int rowCount = model.getRowCount(); // Set up a new array of indexes with the right number of elements
// for the new data model.
indexes = new int[rowCount]; // Initialise with the identity mapping.
for(int row = 0; row < rowCount; row++)
indexes[row] = row;
} public void tableChanged(TableModelEvent e)
{
System.out.println("Sorter: tableChanged");
reallocateIndexes(); super.tableChanged(e);
} public void checkModel()
{
if (indexes.length != model.getRowCount()) {
System.err.println("Sorter not informed of a change in model.");
}
} public void sort(Object sender)
{
checkModel(); compares = 0;
// n2sort();
// qsort(0, indexes.length-1);
shuttlesort((int[])indexes.clone(), indexes, 0, indexes.length);
System.out.println("Compares: "+compares);
} public void n2sort() {
for(int i = 0; i < getRowCount(); i++) {
for(int j = i+1; j < getRowCount(); j++) {
if (compare(indexes[i], indexes[j]) == -1) {
swap(i, j);
}
}
}
} // This is a home-grown implementation which we have not had time
// to research - it may perform poorly in some circumstances. It
// requires twice the space of an in-place algorithm and makes
// NlogN assigments shuttling the values between the two
// arrays. The number of compares appears to vary between N-1 and
// NlogN depending on the initial order but the main reason for
// using it here is that, unlike qsort, it is stable.
public void shuttlesort(int from[], int to[], int low, int high) {
if (high - low < 2) {
return;
}
int middle = (low + high)/2;
shuttlesort(to, from, low, middle);
shuttlesort(to, from, middle, high); int p = low;
int q = middle; /* This is an optional short-cut; at each recursive call,
check to see if the elements in this subset are already
ordered. If so, no further comparisons are needed; the
sub-array can just be copied. The array must be copied rather
than assigned otherwise sister calls in the recursion might
get out of sinc. When the number of elements is three they
are partitioned so that the first set, [low, mid), has one
element and and the second, [mid, high), has two. We skip the
optimisation when the number of elements is three or less as
the first compare in the normal merge will produce the same
sequence of steps. This optimisation seems to be worthwhile
for partially ordered lists but some analysis is needed to
find out how the performance drops to Nlog(N) as the initial
order diminishes - it may drop very quickly. */ if (high - low >= 4 && compare(from[middle-1], from[middle]) <= 0) {
for (int i = low; i < high; i++) {
to[i] = from[i];
}
return;
} // A normal merge. for(int i = low; i < high; i++) {
if (q >= high || (p < middle && compare(from[p], from[q]) <= 0)) {
to[i] = from[p++];
}
else {
to[i] = from[q++];
}
}
} public void swap(int i, int j) {
int tmp = indexes[i];
indexes[i] = indexes[j];
indexes[j] = tmp;
} // The mapping only affects the contents of the data rows.
// Pass all requests to these rows through the mapping array: "indexes". public Object getValueAt(int aRow, int aColumn)
{
checkModel();
return model.getValueAt(indexes[aRow], aColumn);
} public void setValueAt(Object aValue, int aRow, int aColumn)
{
checkModel();
model.setValueAt(aValue, indexes[aRow], aColumn);
} public void sortByColumn(int column) {
sortByColumn(column, true);
} public void sortByColumn(int column, boolean ascending) {
this.ascending = ascending;
sortingColumns.removeAllElements();
sortingColumns.addElement(new Integer(column));
sort(this);
super.tableChanged(new TableModelEvent(this));
} // There is no-where else to put this.
// Add a mouse listener to the Table to trigger a table sort
// when a column heading is clicked in the JTable.
public void addMouseListenerToHeaderInTable(JTable table) {
final TableSorter sorter = this;
final JTable tableView = table;
tableView.setColumnSelectionAllowed(false);
MouseAdapter listMouseListener = new MouseAdapter() {
public void mouseClicked(MouseEvent e) {
TableColumnModel columnModel = tableView.getColumnModel();
int viewColumn = columnModel.getColumnIndexAtX(e.getX());
int column = tableView.convertColumnIndexToModel(viewColumn);
if(e.getClickCount() == 1 && column != -1) {
System.out.println("Sorting ...");
int shiftPressed = e.getModifiers()&InputEvent.SHIFT_MASK;
boolean ascending = (shiftPressed == 0);
sorter.sortByColumn(column, ascending);
}
}
};
JTableHeader th = tableView.getTableHeader();
th.addMouseListener(listMouseListener);
}
}import javax.swing.table.*;
import javax.swing.event.TableModelListener;
import javax.swing.event.TableModelEvent; public class TableMap extends AbstractTableModel implements TableModelListener
{
protected TableModel model; public TableModel getModel() {
return model;
} public void setModel(TableModel model) {
this.model = model;
model.addTableModelListener(this);
} // By default, Implement TableModel by forwarding all messages
// to the model. public Object getValueAt(int aRow, int aColumn) {
return model.getValueAt(aRow, aColumn);
}
public void setValueAt(Object aValue, int aRow, int aColumn) {
model.setValueAt(aValue, aRow, aColumn);
} public int getRowCount() {
return (model == null) ? 0 : model.getRowCount();
} public int getColumnCount() {
return (model == null) ? 0 : model.getColumnCount();
}
public String getColumnName(int aColumn) {
return model.getColumnName(aColumn);
} public Class getColumnClass(int aColumn) {
return model.getColumnClass(aColumn);
}
public boolean isCellEditable(int row, int column) {
return model.isCellEditable(row, column);
}
//
// Implementation of the TableModelListener interface,
// // By default forward all events to all the listeners.
public void tableChanged(TableModelEvent e) {
fireTableChanged(e);
}
}