queryconsumewin.java

swing+jdbc+sqlserver2000的小型网吧系统

package org.itstar.netbar.swing;

import javax.swing.SwingUtilities;
import javax.swing.JFrame;
import java.awt.Dimension;
import java.util.ArrayList;
import java.util.Iterator;
import java.util.List;

import javax.swing.JScrollPane;
import javax.swing.JTable;
import javax.swing.table.DefaultTableModel;
import javax.swing.table.TableModel;

import org.itstar.netbar.bean.ConsumeBean;
import org.itstar.netbar.domain.IConsumeDomain;
import org.itstar.netbar.domain.impl.ConsumeDomainImpl;
import java.awt.Rectangle;

public class QueryConsumeWin {

	private JFrame jFrame = null;  //  @jve:decl-index=0:visual-constraint="10,10"
	private JScrollPane jScrollPane = null;
	private JTable jTable = null;

	/**
	 * This method initializes jScrollPane	
	 * 	
	 * @return javax.swing.JScrollPane	
	 */
	private JScrollPane getJScrollPane() {
		if (jScrollPane == null) {
			jScrollPane = new JScrollPane();
			jScrollPane.setViewportView(getJTable());
		}
		return jScrollPane;
	}
	
	private TableModel getTableModel()
	{
		ConsumeBean coBean=new ConsumeBean();
		IConsumeDomain coDomain=new ConsumeDomainImpl();
		List list=new ArrayList();
		list=coDomain.queryAll();
		Iterator it=list.iterator();
		Object[] columnName={"机器号码","会员卡号","会员名称","上机时间","下机时间","卡上金额(元)","当前余额(元)","消费金额(元)"};
		Object[][] cells=new Object[list.size()][8];
		int i=0;
		while(it.hasNext())
		{
			coBean=(ConsumeBean)it.next();
			cells[i][0]=coBean.getConPCNum(); //机器号码
			cells[i][1]=coBean.getConCardNum(); //会员卡号
			cells[i][2]=coBean.getConName(); //会员名称
			cells[i][3]=coBean.getConStartTime(); //上机时间
 			cells[i][4]=coBean.getConEndTime(); //下机时间
 			cells[i][5]=Double.parseDouble(coBean.getConCurrentBalance())+Double.parseDouble(coBean.getConMoney()); //卡上金额(消费前)
			cells[i][6]=coBean.getConCurrentBalance();  //当前余额
			cells[i][7]=coBean.getConMoney(); //消费金额
			i++;
		}
		TableModel tableModel=new DefaultTableModel(cells,columnName);
		return tableModel;
	}

	/**
	 * This method initializes jTable	
	 * 	
	 * @return javax.swing.JTable	
	 */
	private JTable getJTable() {
		if (jTable == null) {
			jTable = new JTable(getTableModel());
		}
		return jTable;
	}

	/**
	 * @param args
	 */
	public static void main(String[] args) {
		// TODO 自动生成方法存根
		SwingUtilities.invokeLater(new Runnable() {
			public void run() {
				QueryConsumeWin qcw = new QueryConsumeWin();
				qcw.getJFrame().setVisible(true);
			}
		});
	}

	/**
	 * This method initializes jFrame
	 * 
	 * @return javax.swing.JFrame
	 */
	public JFrame getJFrame() {
		if (jFrame == null) {
			jFrame = new JFrame();
			jFrame.setDefaultCloseOperation(JFrame.DISPOSE_ON_CLOSE);
			jFrame.setAlwaysOnTop(true);
			jFrame.setBounds(new Rectangle(100, 120, 843, 538));
			jFrame.setPreferredSize(new Dimension(500, 450));
			jFrame.setContentPane(getJScrollPane());
			jFrame.setTitle("消费历史");
		}
		return jFrame;
	}

}