java如何在jtable行的底部插入新行
我有一个I jTable,当从MYSQL添加数据时,它会自动增加,我想在其他行的底部显示标记的总数,这意味着如果表得到五行的结果,它必须自动附加第六行,其中包含文本总数及其数字结果。我的问题是所有的结果都是垂直排列的,我可以在表的底部追加一个总的结果。请帮助我:
我的代码:
try {
String sql = "SELECT Module_Title as 'Module Title', Assignment_One as 'Ass 1',Assignment_Two as 'Ass 2', Cat_One as 'Cat 1',Cat_Two as 'Cat 2',Course_Work as 'CW', Final_Exam as 'FE', SUM(Total) as 'Total marks' FROM ace_result_register arr WHERE arr.Registration_No= '" + this.Rsltsrch_txtfld.getText() + "'";
this.pst = this.conn.prepareStatement(sql);
this.rs = this.pst.executeQuery();
if (this.rstl_tbl2.getRowCount() >= 0 && this.rstl_tbl2.getRowCount() < 1000) {
this.rstl_tbl2.setModel(DbUtils.resultSetToTableModel((ResultSet)this.rs));
this.rstl_tbl2.setBorder(BorderFactory.createLineBorder(Color.GRAY, 1));
this.rstl_tbl2.getTableHeader().setBorder(BorderFactory.createLineBorder(Color.GRAY, 1));
this.jScrollPane3.setBorder(BorderFactory.createEmptyBorder());
this.jScrollPane3.setPreferredSize(new Dimension(900, 18 + this.rstl_tbl2.getRowCount() * this.rstl_tbl2.getRowHeight()));
DefaultTableCellRenderer centerRenderer = new DefaultTableCellRenderer();
centerRenderer.setHorizontalAlignment(0);
this.rstl_tbl2.getColumn("Module Title").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("Ass 1").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("Ass 2").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("Cat 1").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("Cat 2").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("CW").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("FE").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumn("Total").setCellRenderer(centerRenderer);
this.rstl_tbl2.getColumnModel().getColumn(0).setCellRenderer(new TextAreaCellRenderer());
}
}
catch (SQLException e) {
JOptionPane.showMessageDialog(null, e);
}
共 (0) 个答案