📄 sqlview.java
字号:
package atm;
import java.awt.FlowLayout;
import java.sql.SQLException;
import java.util.*;
import javax.swing.*;
import javax.swing.table.TableColumn;
//import javax.swing.table.TableColumn;
public class Sqlview
{
private Iatm atm = new Dbatm();
private JFrame jf;
private JTable jta;
Sqlview(User user)
{
jf = new JFrame("历史纪录");
jf.setLayout(new FlowLayout(FlowLayout.CENTER));
jf.setSize(600,480);
jf.setLocation(100,100);
String[] columnNames = {"序号", "用户1", "操作","金额","时间", "用户2"};
List historys = new ArrayList();
Object[][] data = new Object[1000][6];
try {
historys = atm.view(user);
} catch (SQLException e) {
e.printStackTrace();
}
for(int i = 0 ; i < historys.size(); i++)
{
History history = (History)historys.get(i);
data[i][0] = new Integer(i+1);
data[i][1] = history.getMainaccount();
data[i][2] = history.getType();
data[i][3] = new Integer(history.getMoney());
data[i][4] = history.getDate();
data[i][5] = history.getSecondaccount();
}
jta = new JTable(data, columnNames);
jf.add(jta);
TableColumn column = jta.getColumnModel().getColumn(4);
column.setPreferredWidth(200);
jf.setVisible(true);
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -