Java Swingでボタンを押しても、登録したメソッドが呼び出されない

Question

Java Swingを使って、簡単なGUIアプリを作成しています。
やりたいことは、GUI（ProductSearchApp.java）のSearchボタンを押下すると、当該ボタンにリンクされたbtnSearchメソッドが呼び出され、DBに接続するDAOクラス（BudgetTrackerDao）内のデータを全件取得するgetAllBudgetTrackingInfoメソッド・特定の文字列に引っかかる検索を行うsearchByProductNameメソッドを実行するはずなのですが、検索ボタンを押下しても、何もコンソール上に表示されません。
解決のヒントがあれば、ご教示頂ければと思います。
よろしくお願いいたします。

BudgetTrackerDto.java

package com.jdbc.budgettracker.core;

import java.util.Date;

public class BudgetTrackerDto {
	private int id;
	private Date date;
	private String storeName;
	private String productName;
	private String productType;
	private int price;
	
	
	
	public BudgetTrackerDto() {
		
	}

	public BudgetTrackerDto(int id, Date date, String storeName, String productName, String productType, int price) {
		super();
		this.id = id;
		this.date = date;
		this.storeName = storeName;
		this.productName = productName;
		this.productType = productType;
		this.price = price;
	}

	public int getId() {
		return id;
	}

	public void setId(int id) {
		this.id = id;
	}

	public Date getDate() {
		return date;
	}

	public void setDate(Date date) {
		this.date = date;
	}

	public String getStoreName() {
		return storeName;
	}

	public void setStoreName(String storeName) {
		this.storeName = storeName;
	}

	public String getProductName() {
		return productName;
	}

	public void setProductName(String productName) {
		this.productName = productName;
	}

	public String getProductType() {
		return productType;
	}

	public void setProductType(String productType) {
		this.productType = productType;
	}

	public int getPrice() {
		return price;
	}

	public void setPrice(int price) {
		this.price = price;
	}
	
	@Override
	public String toString() {
		return String
				.format("Employee [id=%s, date=%s, storeName=%s, productName=%s, productType=%s , price=%s]",
						id, date, storeName, productName, productType, price);
	}
	
	
	
	

}

BudgetTrackerDao.java

package com.jdbc.budgettracker.dao;

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.math.BigDecimal;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.util.Properties;

import com.jdbc.budgettracker.core.BudgetTrackerDto;

import java.util.List;
import java.util.ArrayList;
import java.util.Calendar;
import java.sql.Statement;
import java.text.DateFormat;
import java.text.SimpleDateFormat;
import java.sql.ResultSet;
import java.sql.PreparedStatement;
import java.util.Date;


public class BudgetTrackerDao {
	public static void main(String[] args) throws Exception {

		com.jdbc.budgettracker.dao.BudgetTrackerDao dao = new com.jdbc.budgettracker.dao.BudgetTrackerDao();
		System.out.println(dao.searchByProductName(""));

		System.out.println(dao.getAllBudgetTrackingInfo());
	}

	private Connection myConn;

	public BudgetTrackerDao() throws SQLException, FileNotFoundException, IOException {
		// get db properties
		Properties config;
		Properties props = new Properties();
	    props.load(new FileInputStream("/home/yosuke/git/BudgetTrackerCui/BudgetTrackerCui/sql/config.properties"));

		String user = props.getProperty("user");
		String password = props.getProperty("password");
		String dburl = props.getProperty("dburl");


		// connect to database
		myConn = DriverManager.getConnection(dburl, user, password);

		System.out.println("DB connection successful to: " + dburl);
	}

	public List<BudgetTrackerDto> getAllBudgetTrackingInfo() throws Exception {
		List<BudgetTrackerDto> list = new ArrayList<>();

		Statement myStmt = null;
		ResultSet myRs = null;

		try {
			myStmt = myConn.createStatement();
			myRs = myStmt.executeQuery("select * from 2019_records");

			while (myRs.next()) {
				BudgetTrackerDto tempBudgetInfo = convertRowToBudgetInfo(myRs);
				list.add(tempBudgetInfo);
			}

			return list;
		} finally {
			close(myStmt, myRs);
		}
	}

	public List<BudgetTrackerDto> searchByProductName(String productName) throws Exception {
		List<BudgetTrackerDto> list = new ArrayList<>();

		PreparedStatement myStmt = null;
		ResultSet myRs = null;

		try {
			productName += "%";
			myStmt = myConn.prepareStatement("select * from 2019_records where productname like ?");

			myStmt.setString(1, productName);

			myRs = myStmt.executeQuery();

			while (myRs.next()) {
				BudgetTrackerDto tempBudgetInfo = convertRowToBudgetInfo(myRs);
				list.add(tempBudgetInfo);
			}

			return list;
		} finally {
			close(myStmt, myRs);
		}
	}

	private BudgetTrackerDto convertRowToBudgetInfo(ResultSet myRs) throws SQLException {

		int id = myRs.getInt("id");
		Date date = myRs.getDate("date");
		String storeName = myRs.getString("storename");
		String productName = myRs.getString("productname");
		String productType = myRs.getString("type");
		int price = myRs.getInt("price");

		BudgetTrackerDto tempBudgetInfo = new BudgetTrackerDto(
				id, date, storeName, productName, productType, price);

		return tempBudgetInfo;
	}

	private static void close(Connection myConn, Statement myStmt, ResultSet myRs) throws SQLException {

		if (myRs != null) {
			myRs.close();
		}

		if (myStmt != null) {

		}

		if (myConn != null) {
			myConn.close();
		}
	}

	private void close(Statement myStmt, ResultSet myRs) throws SQLException {
		close(null, myStmt, myRs);
	}

}

ProductSearchApp.java

package com.jdbc.budgettracker.ui;

import java.awt.BorderLayout;
import java.awt.EventQueue;

import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.border.EmptyBorder;

import com.jdbc.budgettracker.core.BudgetTrackerDto;
import com.jdbc.budgettracker.dao.BudgetTrackerDao;

import javax.swing.JLabel;
import java.awt.FlowLayout;
import javax.swing.JTextField;
import javax.swing.JButton;
import javax.swing.JScrollPane;
import javax.swing.JTable;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;

import javax.swing.JOptionPane;
import java.util.List;

public class ProductSearchApp extends JFrame {

	private JPanel contentPane;
	private JTextField productNameTextField;
	private JTable table;

	private BudgetTrackerDao budgetTrackerDao;
	private BudgetTrackerDto budgetTrackerDto;

	/**
	 * Launch the application.
	 */
	public static void main(String[] args) {
		EventQueue.invokeLater(new Runnable() {
			public void run() {
				try {
					ProductSearchApp frame = new ProductSearchApp();
					frame.setVisible(true);
				} catch (Exception e) {
					e.printStackTrace();
				}
			}
		});
	}

	/**
	 * Create the frame.
	 */
	public ProductSearchApp() {

		// create the DAO
		try {
			budgetTrackerDao = new BudgetTrackerDao();
		} catch (Exception exc) {
			JOptionPane.showMessageDialog(this, "Error: " + exc, "Error", JOptionPane.ERROR_MESSAGE);
		}

		setTitle("Product Search App");
		setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
		setBounds(100, 100, 450, 300);
		contentPane = new JPanel();
		contentPane.setBorder(new EmptyBorder(5, 5, 5, 5));
		contentPane.setLayout(new BorderLayout(0, 0));
		setContentPane(contentPane);

		JPanel panel = new JPanel();
		FlowLayout flowLayout = (FlowLayout) panel.getLayout();
		flowLayout.setAlignment(FlowLayout.LEFT);
		contentPane.add(panel, BorderLayout.NORTH);

		JLabel lblEnterProductName = new JLabel("Enter Product Name");
		panel.add(lblEnterProductName);

		productNameTextField = new JTextField();
		panel.add(productNameTextField);
		productNameTextField.setColumns(10);

		JButton btnSeearch = new JButton("Search");
		btnSeearch.addActionListener(new ActionListener() {
			public void actionPerformed(ActionEvent arg0) {
				// Get last name from the text field

				// Call DAO and get employees for the last name

				// If last name is empty, then get all employees

				// Print out employees
				
				try {
					String productName = productNameTextField.getText();

					List<BudgetTrackerDto> budgetTrackerDtos = null;

					if (productName != null && productName.trim().length() > 0) {
						budgetTrackerDtos = budgetTrackerDao.searchByProductName(productName);
					} else {
						budgetTrackerDtos = budgetTrackerDao.getAllBudgetTrackingInfo();
					}
					
					// create the model and update the "table"
//					EmployeeTableModel model = new EmployeeTableModel(employees);
//					
//					table.setModel(model);
					
					/*
					for (Employee temp : employees) {
						System.out.println(temp);
					}
					*/
				} catch (Exception exc) {
					JOptionPane.showMessageDialog(ProductSearchApp.this, "Error: " + exc, "Error", JOptionPane.ERROR_MESSAGE); 
				}
			}
		});
		panel.add(btnSeearch);

		JScrollPane scrollPane = new JScrollPane();
		contentPane.add(scrollPane, BorderLayout.CENTER);

		table = new JTable();
		scrollPane.setViewportView(table);
	}

}

Comments

[jimbe]

"DB connection successful to: ～"
も表示されていないのでしょうか。

[Yakusugi]

そちらは表示されていました。

Answer 1

（BudgetTrackerDao）内のデータを全件取得するgetAllBudgetTrackingInfoメソッド・特定の文字列に引っかかる検索を行うsearchByProductNameメソッドを実行するはずなのですが、

検索ボタンを押下したら、getAllBudgetTrackingInfo()メソッド、もしくは、searchByProductName()メソッドは実行されてるんじゃないですか？

検索ボタンを押下しても、何もコンソール上に表示されません。

どちらのメソッドにも、「コンソール上に」ナニかを表示する処理はありませんよね。そりゃ、「何もコンソール上に表示され」ないでしょう。

「はず」は単なる思い込み。プログラムは書いてあるとおりにしか動かないと、誰かが言ってました。