java - 按下按钮时定义 listModel

Question

所以我正在制作一个包含这段代码的程序

final ListModel listModel = new DefaultListModel();
JButton btnBuscar = new JButton("Buscar");
btnBuscar.addActionListener(new ActionListener() {
    public void actionPerformed(ActionEvent e) {
        listModel = MySQL("SELECT * FROM catalogos WHERE id = '" +
                           searchField.getText() +
                           "' OR name LIKE '%" +
                           searchField.getText() +
                            "%' OR keywords LIKE '%" +
                           searchField.getText() + "%'", "SELECT");             
    }
});

btnBuscar.setBounds(336, 11, 89, 23);
searchPanel.add(btnBuscar);

JScrollPane scrollPane = new JScrollPane();
scrollPane.setBounds(10, 44, 316, 185);
searchPanel.add(scrollPane);
JList list = new JList(listModel);
scrollPane.setViewportView(list);

如您所见，我创建了一个 ListModel 变量，然后想在按下按钮时使用它。 MySQL 函数返回一个 listModel。

然后我想创建一个列表并为其提供列表模型内的元素。这段代码有什么问题？

Answer 1

• 请阅读JDBC(TM) Database Access

• 尝试 examples

例如快捷方式

    try {
        String sqlSyntax = "SELECT * FROM ........";
        Statement stmt = myDbConnection.createStatement();
        ResultSet rsts = stmt.executeQuery(sqlSyntax);
        while (rsts.next()) {
            final String str = rsts.getString(1); // or another data types
            SwingUtilities.invokeLater(new Runnable() {

                @Override
                public void run() {
                    listModel.add(str.trim());
                }
            });
        }
    } catch (SQLException ex) {
        // exeption handling
    } finally {
        try {
            rsts.close();
            stmt.close();
        } catch (SQLException ex) {
            // not important  
        }
    }