在jTable a中选择记录时在jTable B中显示值

Question

我试图传入一个JTable对象，它有DiscountID和Name列。我基本上是在尝试获取JTable a（折扣ID）中选择的第一列的一行，以及在rs.next（）循环中与JTable B中选择的记录相关的这组数据。

我现在的问题是，因为最初int row=table。getSelectedRow（）我必须将其设置为0，以避免出现IndexOutOfBoundsException但当我运行程序时，JTable B将显示与JTable A中的第一条记录相关的信息，而不需要我选择任何数据。我不想在JTTable B中显示任何信息，直到我从JTTable a中选择了一条记录，同时也避免了IndexOutOfBoundsException。如果有人能帮我解决这个问题，我将不胜感激。我一直在努力寻找解决方案。

下面是我的方法的代码：

public static ArrayList<FlexiBand> getFlexiBands(JTable table, JTable table2) {
    ArrayList<FlexiBand> flexiband = new ArrayList<FlexiBand>();
    try {

        Connection con = null;
        PreparedStatement stmt = null;
        ResultSet rs = null;

        con = DriverManager
                .getConnection("jdbc:mysql://localhost:3306/abpp034?user=abpp034&password=120001772");

        stmt = con
                .prepareStatement("SELECT UpperBound, PercentageRate FROM FlexiBand WHERE DiscountID = ?");

        int row = table.getSelectedRow();

        if (row == -1) {
            row = 0;
            for (int x = 0; x < table2.getRowCount(); x++) {

                table2.setValueAt("", x, 0);
                table2.setValueAt("", x, 1);

            }

        }
        System.out.println(row); // This is printing me 0 meaning that row is still 0

        System.out.println(table.getValueAt(row, 0)); // This means that row will be equal to 0
                                                      // when it goes to the next line.
        stmt.setObject(1, table.getValueAt(row, 0));

        try {

            rs = stmt.executeQuery();

            int i = 0;
            while (rs.next()) {
                FlexiBand fb = new FlexiBand();

                fb.setUpperBound(rs.getInt("UpperBound"));
                fb.setPercentageRate(rs.getInt("PercentageRate"));

                flexiband.add(fb);

            }

        } finally {

            if (rs != null) {
                try {
                    rs.close();
                } catch (SQLException se) {
                    System.out.println(se.getErrorCode());
                }
            }
            if (stmt != null) {
                try {
                    stmt.close();
                } catch (SQLException se) {
                    System.out.println(se.getErrorCode());
                }
            }
            if (con != null) {
                try {
                    con.close();
                } catch (SQLException se) {
                    System.out.println(se.getErrorCode());
                }
            }
        }

    } catch (SQLException ex) {
        Logger.getLogger(Model.class.getName()).log(Level.SEVERE, null, ex);
    }
    return flexiband;

}

下面是我调用该方法的地方：

public static void main(String[] args) {

    DiscountGUIView dgv = new DiscountGUIView();

    setDiscountNames("Fixed", dgv.getjComboBox2());
    getFlexiBands(dgv.getjTable2(), dgv.getjTable5());

}

在与方法相同的类中。

Answer 1

就这样做吧。检查是否选中了行。

public static void main(String[] args) {

    DiscountGUIView dgv = new DiscountGUIView();

    setDiscountNames("Fixed", dgv.getjComboBox2());
    ArrayList<FlexiBand> flexiband = null;
    if (dgv.getjTable2().getSelectedRow != -1) {
        flexiband = getFlexiBands(dgv.getjTable2(), dgv.getjTable5());
    }

    if (flexiband !=null) {
        // user selected a row, do what ever you want to do
    } else {
        // nothing is selected
        // skip other operations
    }

}