有 Java 编程相关的问题?

你可以在下面搜索框中键入要查询的问题!

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) 个答案