sqlview.java

来自「java实现的取款机 前台为图形界面 后面数据用xml存储」· Java 代码 · 共 45 行

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);
	}
}