开发数据库事件触发自动呼叫管理员程序及GUI实现技术问询

Hey there! Let's tackle your problem step by step. You've got three core goals: capturing an admin's phone number from a TextField, making that data accessible to other parts of your app, and triggering an automated call when a specific database event occurs. Here's how to refine your code and tie everything together:

1. Refined UI Class with Accessible Data #

First, let's adjust your UI class to properly store the phone number and make it safely accessible to other methods. The key fix here is moving your TextField and number variable to class-level scope, plus adding a thread-safe getter for external access:

package ui_test;

import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JTextField;
import javax.swing.SwingUtilities;

public class UI implements ActionListener {
    // Class-level members so other methods can access them
    private JTextField phoneInput;
    private String adminPhoneNumber;

    public UI() {
        // Initialize GUI components
        JFrame frame = new JFrame("Admin Call Trigger");
        JPanel panel = new JPanel();
        
        phoneInput = new JTextField(20);
        JButton saveButton = new JButton("Save Admin Number");
        saveButton.addActionListener(this);
        
        panel.add(phoneInput);
        panel.add(saveButton);
        
        frame.add(panel);
        frame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
        frame.pack();
        frame.setVisible(true);
    }

    @Override
    public void actionPerformed(ActionEvent e) {
        // Capture input when button is clicked
        adminPhoneNumber = phoneInput.getText().trim();
        
        // Basic validation (expand with regex for phone format if needed)
        if (adminPhoneNumber.isEmpty()) {
            System.out.println("Error: Please enter a valid phone number!");
        } else {
            System.out.println("Admin number saved successfully: " + adminPhoneNumber);
        }
    }

    // Thread-safe getter to access the stored number from external methods
    public String getAdminPhoneNumber() {
        // Swing requires GUI access on the Event Dispatch Thread (EDT)
        if (SwingUtilities.isEventDispatchThread()) {
            return adminPhoneNumber;
        } else {
            // If called from a background thread, safely retrieve the value
            final String[] numberHolder = new String[1];
            try {
                SwingUtilities.invokeAndWait(() -> numberHolder[0] = adminPhoneNumber);
            } catch (Exception ex) {
                ex.printStackTrace();
            }
            return numberHolder[0];
        }
    }

    // Launch the GUI correctly on the EDT
    public static void main(String[] args) {
        SwingUtilities.invokeLater(UI::new);
    }
}

Key Improvements: #

• Class-Level Variables: phoneInput and adminPhoneNumber are no longer local, so other methods/classes can reach them.
• Thread-Safe Getter: Ensures you don't run into Swing concurrency issues when accessing the number from background threads (like database listeners).
• Basic Validation: Catches empty input easily — you can expand this with regex to validate phone number formats (e.g., ^\\+?[0-9\\s-]+$).

2. Accessing GUI Data from External Methods/Classes #

If you have a database listener or another component that needs to grab the admin number, you can pass the UI instance to that component when initializing it:

// Example database event listener class
public class DatabaseAlertListener {
    private UI guiInstance;

    public DatabaseAlertListener(UI gui) {
        this.guiInstance = gui;
    }

    // Triggered when the specific database event occurs
    public void onCriticalEventDetected() {
        String adminNumber = guiInstance.getAdminPhoneNumber();
        if (adminNumber != null && !adminNumber.isEmpty()) {
            initiateCall(adminNumber);
        } else {
            System.out.println("Cannot call: No admin phone number saved!");
        }
    }

    // Replace with your actual call logic (e.g., telephony API, SIP client)
    private void initiateCall(String phoneNumber) {
        System.out.println("Calling admin at " + phoneNumber + "...");
        // Add your call implementation here
    }
}

To use this, just pass your UI instance when creating the listener:

// In your main method or app initialization
UI gui = new UI();
DatabaseAlertListener alertListener = new DatabaseAlertListener(gui);

3. Detecting Database Events #

How you catch the specific database event depends on your database system:

• Simple Polling: For small apps, use a ScheduledExecutorService to periodically query the database for the event (e.g., new rows in an alerts table).
• Database-Specific Triggers:
  • PostgreSQL: Use LISTEN/NOTIFY to have the database send real-time notifications to your app.
  • MySQL: Use a Binlog listener (like Debezium) to capture data changes.
  • SQL Server: Use Query Notifications or Service Broker for event alerts.

Whichever method you choose, run the event detection in a background thread to avoid freezing your GUI. When the event is detected, call onCriticalEventDetected() to trigger the call.

内容的提问来源于stack exchange，提问作者D.Schall