main.java的一部分代码
rsp=stmt.executeQuery("select p_id, p_name,p_type, p_out,p_danwei,p_begintime,p_shuliang p_price,p_nowvalue,p_shuliang from property where p_name!='' and p_shuliang>0");
ResultSetMetaData rsmd = rsp.getMetaData();
int numberOfColumns=rsmd.getColumnCount();
int b=1;
model = new DefaultTableModel();
jTable1 = new JTable();
jTable1.setModel(model);
//以下是显示数据库中的列名的代码
while(b<=numberOfColumns) {
model.addColumn(rsmd.getColumnName(b));
b++;
}
//以下是在表格中显示数据中的内容 while(rsp.next()) {
Vector newRow=new Vector();
int c=1;
while(c<=numberOfColumns){
newRow.addElement(rsp.getString(c));
c++;
}
model.addRow(newRow);
}
model.addTableModelListener(new TableModelListener() {
public void tableChanged(TableModelEvent e) {
jTable1.updateUI();
jTable1.repaint();
}
}); // jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
// RowSorter <TableModel> sorter = new TableRowSorter (model);
// jTable1.setRowSorter(sorter);
JScrollPane pane = new JScrollPane(jTable1);
Main main = new Main(); Vector rowdata = new Vector();
rowdata.addElement(p_id);
rowdata.addElement(p_name);
rowdata.addElement(p_type);
rowdata.addElement(p_out);
rowdata.addElement(p_danwei);
rowdata.addElement(p_begintime);
rowdata.addElement(p_price);
rowdata.addElement(p_nowvalue);
rowdata.addElement(p_shuliang);
main.model.addRow(rowdata);
main.jTable1.setModel(main.model);
main.jTable1.updateUI();
rsp=stmt.executeQuery("select p_id, p_name,p_type, p_out,p_danwei,p_begintime,p_shuliang p_price,p_nowvalue,p_shuliang from property where p_name!='' and p_shuliang>0");
ResultSetMetaData rsmd = rsp.getMetaData();
int numberOfColumns=rsmd.getColumnCount();
int b=1;
model = new DefaultTableModel();
jTable1 = new JTable();
jTable1.setModel(model);
//以下是显示数据库中的列名的代码
while(b<=numberOfColumns) {
model.addColumn(rsmd.getColumnName(b));
b++;
}
//以下是在表格中显示数据中的内容 while(rsp.next()) {
Vector newRow=new Vector();
int c=1;
while(c<=numberOfColumns){
newRow.addElement(rsp.getString(c));
c++;
}
model.addRow(newRow);
}
model.addTableModelListener(new TableModelListener() {
public void tableChanged(TableModelEvent e) {
jTable1.updateUI();
jTable1.repaint();
}
}); // jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
// RowSorter <TableModel> sorter = new TableRowSorter (model);
// jTable1.setRowSorter(sorter);
JScrollPane pane = new JScrollPane(jTable1);
Main main = new Main(); Vector rowdata = new Vector();
rowdata.addElement(p_id);
rowdata.addElement(p_name);
rowdata.addElement(p_type);
rowdata.addElement(p_out);
rowdata.addElement(p_danwei);
rowdata.addElement(p_begintime);
rowdata.addElement(p_price);
rowdata.addElement(p_nowvalue);
rowdata.addElement(p_shuliang);
main.model.addRow(rowdata);
main.jTable1.setModel(main.model);
main.jTable1.updateUI();
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货