我有显示的JTable取决于从我的JTable的数据库,并最后两列的特定列是像我fields.How可以动态改变列不影响最后两个column.please提醒me.how做。
Answer 1:
使用Vector
从java.util.Collection
见从这个例子 http://www.roseindia.com
import java.sql.*;
import java.util.*;
import javax.swing.*;
import javax.swing.table.TableColumn;
public class JTableResultSet {
public static void main(String[] args) {
Vector columnNames = new Vector();
Vector data = new Vector();
JPanel panel = new JPanel(); //
try {
Class.forName("com.mysql.jdbc.Driver").newInstance();
Connection con = DriverManager.getConnection(
"jdbc:mysql://localhost:3306/test", "root", "root");
String sql = "Select name,address from user";
Statement statement = con.createStatement();
ResultSet resultSet = statement.executeQuery(sql);
ResultSetMetaData metaData = resultSet.getMetaData();
int columns = metaData.getColumnCount();
for (int i = 1; i <= columns; i++) {
columnNames.addElement(metaData.getColumnName(i));
}
while (resultSet.next()) {
Vector row = new Vector(columns);
for (int i = 1; i <= columns; i++) {
row.addElement(resultSet.getObject(i));
}
data.addElement(row);
}
resultSet.close();
statement.close();
} catch (Exception e) {
System.out.println(e);
}
JTable table = new JTable(data, columnNames);
TableColumn column;
for (int i = 0; i < table.getColumnCount(); i++) {
column = table.getColumnModel().getColumn(i);
column.setMaxWidth(250);
}
JScrollPane scrollPane = new JScrollPane(table); panel.add(scrollPane);
JFrame frame = new JFrame();
frame.add(panel); //adding panel to the frame
frame.setSize(600, 400); //setting frame size
frame.setVisible(true); //setting visibility true
}
}
Answer 2:
TableModel.setValueAt(Objet value, int row, int col)
文章来源: How to populate the data to Jtable from database directly