java - ListSelectionModel - getMinSelectionIndex() 错误地返回 -1

Question

我通过 TableModel 从 Oracle 数据库中提取了一个表。这是源代码:

package database;

import javax.swing.*;
import javax.swing.table.*;
import javax.swing.text.Document;

import oracle.jdbc.internal.OracleResultSet;
import oracle.sql.CLOB;
import oracle.xdb.XMLType;

import java.sql.*;
import java.util.*;

/**
 * an immutable table model built from getting metadata about a table in a jdbc
 * database
 */
public class TestKonfigTableModel extends AbstractTableModel {
static Object[][] contents;
String[] columnNames;
Class[] columnClasses;

public TestKonfigTableModel(Connection conn, String tableName) throws SQLException {
    super();
    getTableContents(conn, tableName);

}

protected void getTableContents(Connection conn, String tableName) throws SQLException {

    // get metadata: what columns exist and what
    // types (classes) are they?
    DatabaseMetaData meta = conn.getMetaData();
    System.out.println("got meta = " + meta);
    ResultSet results = meta.getColumns(null, null, tableName, null);
    OracleResultSet orset = (OracleResultSet)results;
    System.out.println("got column results");
    ArrayList colNamesList = new ArrayList();
    ArrayList colClassesList = new ArrayList();

    while (results.next()) {
        colNamesList.add(results.getString("COLUMN_NAME"));
        System.out.println("name: " + results.getString("COLUMN_NAME"));
        int dbType = results.getInt("DATA_TYPE");
        switch (dbType) {
        case Types.INTEGER:
            colClassesList.add(Integer.class);
            break;
        case Types.FLOAT:
            colClassesList.add(Float.class);
            break;
        case Types.DOUBLE:
        case Types.REAL:
            colClassesList.add(Double.class);
            break;
        case Types.DATE:
        case Types.TIME:
        case Types.TIMESTAMP:
            colClassesList.add(java.sql.Timestamp.class);
            break;

        case Types.SQLXML:
            colClassesList.add(oracle.xdb.XMLType.class);

        default:
            colClassesList.add(String.class);
            break;
        }
        ;
        System.out.println("type: " + results.getInt("DATA_TYPE"));
    }

    columnNames = new String[colNamesList.size()];
    colNamesList.toArray(columnNames);
    columnClasses = new Class[colClassesList.size()];
    colClassesList.toArray(columnClasses);

    // get all data from table and put into
    // contents array

    Statement statement = conn.createStatement();
    results = statement.executeQuery("SELECT * FROM " + tableName + " ORDER BY 1");
    ArrayList rowList = new ArrayList();
    while (results.next()) {
        ArrayList cellList = new ArrayList();
        for (int i = 0; i < columnClasses.length - 1; i++) {
            Object cellValue = null;

            if (columnClasses[i] == String.class)
                cellValue = results.getString(columnNames[i]);
            else if (columnClasses[i] == Integer.class)
                cellValue = new Integer(results.getInt(columnNames[i]));
            else if (columnClasses[i] == Float.class)
                cellValue = new Float(results.getInt(columnNames[i]));
            else if (columnClasses[i] == Double.class)
                cellValue = new Double(results.getDouble(columnNames[i]));
            else if (columnClasses[i] == java.sql.Date.class)
                cellValue = results.getTimestamp(columnNames[i]);
            else if (columnClasses[i] == oracle.xdb.XMLType.class) {
                cellValue = results.getSQLXML(columnNames[i]);
            } else
                System.out.println("Can't assign " + columnNames[i]);
            cellList.add(cellValue);
        } // for
        Object[] cells = cellList.toArray();
        rowList.add(cells);

    } // while
        // finally create contents two-dim array
    contents = new Object[rowList.size()][];
    for (int i = 0; i < contents.length; i++)

        contents[i] = (Object[]) rowList.get(i);
    System.out.println("Created model with " + contents.length + " rows");

    // close stuff
    results.close();
    statement.close();

}

// AbstractTableModel methods
public int getRowCount() {
    return contents.length;
}

public int getColumnCount() {
    if (contents.length == 0)
        return 0;
    else
        return contents[0].length;
}

public Object getValueAt(int row, int column) {
    return contents[row][column];
}

// overrides methods for which AbstractTableModel
// has trivial implementations

public Class getColumnClass(int col) {
    return columnClasses[col];
}

public String getColumnName(int col) {
    return columnNames[col];
}
}

一切正常，我的表格完全按照我想要的方式显示。但是现在，我想向表行添加一个操作监听器，以便双击时返回行号。现在总是返回-1。根据 API 描述，这意味着没有选择任何行。但我确实选择并双击了一些行，但它一直返回-1。出于测试原因，我在一个主方法中编写了所有这些内容，所以请原谅这种糟糕的风格:

package database;

import javax.swing.*;
import javax.swing.table.*;

import oracle.jdbc.pool.OracleDataSource;

import java.sql.*;
import java.util.*;
import java.awt.event.MouseAdapter;
import java.awt.event.MouseEvent;
import java.io.*;

public class GUIAutoTest {
public static void main(String[] args) {
    try {

        /*
         * driver, url, user, and pass can be passed in as system properties
         * "jdbctable.driver", "jdbctable.url", "jdbctable.user", and
         * "jdbctable.pass", or specified in a file called
         * "jdbctable.properties" in current directory
         */
        Properties testProps = new Properties();
        String ddriver = System.getProperty("jdbctable.driver");
        String durl = System.getProperty("jdbctable.url");
        String duser = System.getProperty("jdbctable.user");
        String dpass = System.getProperty("jdbctable.pass");
        ListSelectionModel testSelectionModel;

        if (ddriver != null)
            testProps.setProperty("jdbctable.driver", ddriver);
        if (durl != null)
            testProps.setProperty("jdbctable.url", durl);
        if (duser != null)
            testProps.setProperty("jdbctable.user", duser);
        if (dpass != null)
            testProps.setProperty("jdbctable.pass", dpass);
        try {
            testProps.load(new FileInputStream(new File("jdbctable.properties")));
        } catch (Exception e) {
        } // ignore FNF, etc.

        System.out.println("Test Properties:");
        testProps.list(System.out);
        // now get a connection
        // note care to replace nulls with empty strings
        OracleDataSource ods = new OracleDataSource();
        ods.setDriverType("thin");
        ods.setNetworkProtocol("tcp");
        ods.setDatabaseName("***");
        ods.setServerName("***");
        ods.setPortNumber(1521);
        ods.setUser("***");
        ods.setPassword("***");
        Connection conn = ods.getConnection();
        // create db table to use
        String tableName = createSampleTable(conn);

        // get a model for this db table and add to a JTable
        TableModel mod = new TestKonfigTableModel(conn, tableName);
        JTable jtable = new JTable(mod);

        testSelectionModel = jtable.getSelectionModel();
        testSelectionModel.setSelectionMode(ListSelectionModel.SINGLE_SELECTION);
        int testKonfig = testSelectionModel.getMinSelectionIndex();

        jtable.addMouseListener(new MouseAdapter() {
            public void mousePressed(MouseEvent event) {
                if (event.getClickCount() == 2) {
                    System.out.println(testKonfig);
                }
            }
        });


        JScrollPane scroller = new JScrollPane(jtable, ScrollPaneConstants.VERTICAL_SCROLLBAR_AS_NEEDED,
                ScrollPaneConstants.HORIZONTAL_SCROLLBAR_AS_NEEDED);
        JFrame frame = new JFrame("JDBCTableModel demo");
        frame.getContentPane().add(scroller);
        frame.pack();
        frame.setVisible(true);

        conn.close();

    } catch (Exception e) {
        e.printStackTrace();
    }
}

public static String createSampleTable(Connection conn) throws SQLException {
    return "TEST_KONFIG";
}

}

我的错误在哪里？

Answer 1

    int testKonfig = testSelectionModel.getMinSelectionIndex();

    jtable.addMouseListener(new MouseAdapter() {
        public void mousePressed(MouseEvent event) {
            if (event.getClickCount() == 2) {
                System.out.println(testKonfig);
            }
        }
    });

您在用户更改为单击一行之前设置“testDonfig”的值。

代码应该是:

    //int testKonfig = testSelectionModel.getMinSelectionIndex();

    jtable.addMouseListener(new MouseAdapter() {
        public void mousePressed(MouseEvent event) {
            if (event.getClickCount() == 2) {
                int testKonfig = testSelectionModel.getMinSelectionIndex();
                System.out.println(testKonfig);
            }
        }
    });