Java搜寻按键搜寻mysql表数据

你可以使用Java JDBC API来连接MySQL数据库，然后使用SELECT语句从表中检索数据。以下是一个简单的示例代码，可以在Java Swing应用程序中使用按键来搜索MySQL表数据：

import java.awt.*;
import java.awt.event.*;
import java.sql.*;
import javax.swing.*;

public class SearchData extends JFrame implements ActionListener {
    private JTextField searchField;
    private JTextArea resultArea;
    private JButton searchButton;

    public SearchData() {
        super("Search MySQL Data");
        setLayout(new BorderLayout());
        
        searchField = new JTextField();
        add(searchField, BorderLayout.NORTH);
        
        resultArea = new JTextArea();
        add(new JScrollPane(resultArea), BorderLayout.CENTER);
        
        searchButton = new JButton("Search");
        searchButton.addActionListener(this);
        add(searchButton, BorderLayout.SOUTH);
        
        setSize(400, 400);
        setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        setVisible(true);
    }

    public void actionPerformed(ActionEvent e) {
        try {
            // Connect to MySQL database
            Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/mydatabase", "username", "password");

            // Create a statement object
            Statement stmt = con.createStatement();

            // Execute the SELECT query
            String query = "SELECT * FROM mytable WHERE field LIKE '%" + searchField.getText() + "%'";
            ResultSet rs = stmt.executeQuery(query);

            // Display the result in the text area
            resultArea.setText("");
            while (rs.next()) {
                resultArea.append(rs.getString("field1") + "\t" + rs.getString("field2") + "\n");
            }

            // Close the result set, statement, and connection
            rs.close();
            stmt.close();
            con.close();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    public static void main(String[] args) {
        new SearchData();
    }
}

在上面的代码中，当用户单击“Search”按钮时，将调用actionPerformed方法。该方法将从文本框中获取搜索字符串，然后使用LIKE运算符在MySQL表中搜索匹配的行。查询的结果将在文本区域中显示。注意，这只是一个简单的示例，你需要根据自己的需求进行修改和改进。