在JTextfield中显示来自两个不同mysql表的数据

import java.sql.*;

public class Main {
    public static void main(String[] args) {
        String url = "jdbc:mysql://localhost:3306/mydatabase";
        String username = "your-username";
        String password = "your-password";

        try {
            Connection connection = DriverManager.getConnection(url, username, password);
            // 连接成功后的操作
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
}

Statement statement = connection.createStatement();
String query1 = "SELECT * FROM table1";
String query2 = "SELECT * FROM table2";
ResultSet resultSet1 = statement.executeQuery(query1);
ResultSet resultSet2 = statement.executeQuery(query2);

String data = "";
while (resultSet1.next()) {
    // 从resultSet1中获取数据，并拼接到data变量中
}
while (resultSet2.next()) {
    // 从resultSet2中获取数据，并拼接到data变量中
}
textField.setText(data);

resultSet1.close();
resultSet2.close();
statement.close();
connection.close();