JFrame中的Java JTable不同的类

Question

我很难想象如何将引用sqlite数据库的表获取到JTable中，然后将该JTable放入另一个类中存在的JFrame中。

我希望将SearchBooks中的表传递给UserInterface类。我认为SearchBooks中的showTableData方法可以加载到UserInterface类中存在的JFrame(UIFrame(中事实上，这正是我想要做的。它看起来并不像调用showTableData类那么简单，或者我可能缺少一些关键元素。

import javax.swing.*;
import javax.swing.table.DefaultTableModel;
import java.awt.*;
import java.sql.*;
import java.awt.event.*;
public class SearchBooks implements ActionListener {
JFrame SBFrameCol, SBFrameDisplay;
JTextField textbox;
JLabel label;
JButton button;
JPanel panel;
static JTable table;

String driverName = "org.sqlite.JDBC";
String url = "jdbc:sqlite:Library.db";
//String userName = "root";
//String password = "root";
String[] columnNames = { "Book ID", "Book Name", "Book Author", "Quantity" };
public void createUI() {
SBFrameCol = new JFrame("Database Search Result");
SBFrameCol.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
SBFrameCol.setLayout(null);
textbox = new JTextField();
textbox.setBounds(400, 130, 250, 30);
label = new JLabel("Enter A Book Name or Author Name");
label.setBounds(100, 130, 300, 30);
button = new JButton("search");
button.setBounds(220, 200, 150, 20);
button.addActionListener(this);
SBFrameCol.add(textbox);
SBFrameCol.add(label);
SBFrameCol.add(button);
SBFrameCol.setVisible(true);
SBFrameCol.setSize(700, 400);
}
public void actionPerformed(ActionEvent ae) {
button = (JButton) ae.getSource();
System.out.println("Showing Table Data.......");
showTableData();
}
public void showTableData() {
SBFrameDisplay = new JFrame("Database Search Result");
SBFrameDisplay.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
SBFrameDisplay.setLayout(new BorderLayout());
//TableModel tm = new TableModel();
DefaultTableModel model = new DefaultTableModel();
model.setColumnIdentifiers(columnNames);
//DefaultTableModel model = new DefaultTableModel(tm.getData1(), tm.getColumnNames()); 
//table = new JTable(model);
table = new JTable();
table.setModel(model);
table.setAutoResizeMode(JTable.AUTO_RESIZE_ALL_COLUMNS);
table.setFillsViewportHeight(true);
JScrollPane scroll = new JScrollPane(table);
scroll.setHorizontalScrollBarPolicy(JScrollPane.HORIZONTAL_SCROLLBAR_AS_NEEDED);
scroll.setVerticalScrollBarPolicy(JScrollPane.VERTICAL_SCROLLBAR_AS_NEEDED);
String textvalue = textbox.getText();
String bID;
String bName = "";
String aName = "";
String quantity;
try {
Class.forName(driverName);
Connection con = DriverManager.getConnection(url);
String sql = "SELECT * FROM Books WHERE (book_name LIKE '%" + textvalue + "%') OR (book_author LIKE '%" + textvalue + "%');";
PreparedStatement ps = con.prepareStatement(sql);
ResultSet rs = ps.executeQuery();
int i = 0;
while (rs.next()) {
bID = rs.getString("book_id");
bName = rs.getString("book_name");
aName = rs.getString("book_author");
quantity= rs.getString("quantity");
model.addRow(new Object[] { bID, bName, aName, quantity });
i++;
}
if (i < 1) {
JOptionPane.showMessageDialog(null, "No Record Found", "Error", JOptionPane.ERROR_MESSAGE);
}
if (i == 1) {
System.out.println(i + " Record Found");
} else {
System.out.println(i + " Records Found");
}
} catch (Exception ex) {
JOptionPane.showMessageDialog(null, ex.getMessage(), "Error", JOptionPane.ERROR_MESSAGE);
}
SBFrameDisplay.add(scroll);
SBFrameDisplay.setVisible(true);
SBFrameDisplay.setSize(400, 300);
}
public static void main(String args[]) {
SearchBooks sr = new SearchBooks();
sr.createUI();
}
}

这是我的用户界面类(其中包含我需要向其显示表信息的UIFrame框架(。

import java.awt.EventQueue;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.JButton;
import javax.swing.JFrame;
public class UserInterface {
public JFrame UIFrame;
/**
* Launch the application.
*/
public static void main(String[] args) {
EventQueue.invokeLater(new Runnable() {
public void run() {
try {
UserInterface window = new UserInterface();
window.UIFrame.setVisible(true);

} catch (Exception e) {
e.printStackTrace();
}
}
});
}
/**
* Create the application.
*/
public UserInterface() {
initialize();
}
/**
* Initialize the contents of the SBFrameCol.
*/
private void initialize() {
UIFrame = new JFrame();
UIFrame.setTitle("Librarian Functions");
UIFrame.setBounds(100, 100, 700, 800);
UIFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
UIFrame.getContentPane().setLayout(null);


// When button clicked, we will go to the add book window
JButton addBookButton = new JButton("Add Books");
addBookButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent arg0) {
AddBook window = new AddBook();
window.AddFrame.setVisible(true);
UIFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
});
addBookButton.setBounds(40, 41, 117, 50);
UIFrame.getContentPane().add(addBookButton);
JButton SearchViewBooksButton = new JButton("Search/View Books");
//       JFrame window3 = new JFrame();
SearchViewBooksButton.addActionListener(new ActionListener() {
public void actionPerformed(ActionEvent e) {
SearchBooks window = new SearchBooks();
window.createUI();
window.SBFrameCol.setVisible(true);
UIFrame.setDefaultCloseOperation(JFrame.EXIT_ON_CLOSE);
}
});
SearchViewBooksButton.setBounds(239, 130, 187, 61);
UIFrame.getContentPane().add(SearchViewBooksButton);
JButton viewAccountButton = new JButton("View Account");
viewAccountButton.setBounds(45, 130, 146, 61);
UIFrame.getContentPane().add(viewAccountButton);
}
}

此外，在一个java程序中有多个公共静态void main(String[]args(可以吗？我现在是这样做的，但我确信这不是一个好的练习，有什么想法吗？

提前谢谢。

Answer 1

要尝试的是，首先填充模型，然后将其传递给JTable。您首先将模型传递给表，然后操作数据。我用另一种方式。。。像这样：

final Object[][] dataBlob =
blobProcessor.getOneBudgetExpensesDatabaseBlob( expenseList );
final DefaultTableModel defTModel = new DefaultTableModel( dataBlob,
new String [] { "Description", "Amount", "Source", "Date", "File" }
);
jTable1.setModel(defTModel);

我使用相同的表，但每次显示内容时都会创建一个新的模型，填充它，然后在填充模型后将其传递给JTable。

你们都在一个地方，所以只需等待，然后将模型传递给表，而不是之前。

我将在我的代码中添加这一点，我将在那里获得一个数据库查询作为列表(expenseList(，然后将其传递给blobProcessor，该处理器将查询结果设置为Object[][]数组，并将其返回给我以放置到模型中然后模型进入表格。。。最后，而不是第一。