balance.java

JAVA编写的单击的PIZZA店销售系统

package GUI;

import org.eclipse.jface.viewers.TableViewer;
import org.eclipse.swt.SWT;
import org.eclipse.swt.events.SelectionAdapter;
import org.eclipse.swt.events.SelectionEvent;
import org.eclipse.swt.widgets.Composite;
import org.eclipse.swt.widgets.Label;
import org.eclipse.swt.widgets.Table;

import java.util.Date;
import java.util.List;
import org.eclipse.jface.viewers.ILabelProviderListener;
import org.eclipse.jface.viewers.IStructuredContentProvider;
import org.eclipse.jface.viewers.ITableLabelProvider;
import org.eclipse.jface.viewers.TableLayout;
import org.eclipse.jface.viewers.Viewer;
import org.eclipse.swt.graphics.Image;
import org.eclipse.swt.widgets.Button;
import org.eclipse.swt.widgets.TableColumn;
import Dbprocess.*;

import java.sql.*;

import Storage.*;
public class Balance extends Composite {
	
	private Table table;
	final MyTableViewer myTableViewer;
	final Label label_1 ;
	/**
	 * Create the composite
	 * @param parent
	 * @param style
	 */
	public Balance(Composite parent, int style) {
		super(parent, style);

		final Label totalLabel = new Label(this, SWT.NONE);
		totalLabel.setText("Total Sales");
		totalLabel.setBounds(10, 10, 66, 30);

		label_1 = new Label(this, SWT.NONE);
		label_1.setBounds(82, 10, 66, 30);
		
		myTableViewer = new MyTableViewer(this, SWT.BORDER|SWT.FULL_SELECTION);
		myTableViewer.draw();
		computeTotal();

		final Button button = new Button(this, SWT.NONE);
		button.addSelectionListener(new SelectionAdapter() {
			public void widgetSelected(SelectionEvent e) {
				 myTableViewer.draw();
			}
		});
		button.setText("刷新");
		button.setBounds(469, 79, 48, 22);
		//
	}

	public class MyTableViewer extends TableViewer{
		public MyTableViewer(Composite com,int style){
			super(com,style);
			
			table = this.getTable();
			table.setBounds(10, 46, 405, 326);		
			table.setRedraw(true);
			table.setHeaderVisible(true); //表头显示
			table.setLinesVisible(true); //表格线显示

			TableLayout tLayout = new TableLayout();
			table.setLayout(tLayout);
			final TableColumn newColumnTableColumn = new TableColumn(table, SWT.NONE);
			newColumnTableColumn.setWidth(100);
			newColumnTableColumn.setText("Pizza Name");

			final TableColumn newColumnTableColumn_1 = new TableColumn(table, SWT.NONE);
			newColumnTableColumn_1.setWidth(100);
			newColumnTableColumn_1.setText("Base Type");

			final TableColumn newColumnTableColumn_2 = new TableColumn(table, SWT.NONE);
			newColumnTableColumn_2.setWidth(250);
			newColumnTableColumn_2.setText("Quantity");
	
			this.setContentProvider(new MyContentProvider()); //内容器
			this.setLabelProvider(new MyLabelProvider()); //标签器
		}
		
		public void draw(){		
			StorageManager sm2 = new StorageManager();
			this.setInput(sm2.getBalance());
			computeTotal();
		}
}
	
	 /**
     * 内容器(写成了一个内部类). 在这里对所有记录集中的记录进行处理
     */

	
	private static final class MyContentProvider implements IStructuredContentProvider {
	        public Object[] getElements(Object element) {
	            if (element instanceof List)
	                return ((List) element).toArray();//将List转化为数组
	            else
	                return new Object[0];//否则,返回一个空数组
	        }

	        public void dispose() {}
	        public void inputChanged(Viewer viewer, Object oldInput, Object newInput) {}
	    }

	  /**
	   * 标签器(写成了一个内部类).在这里对单条记录进行处理
	     */
	private static final class MyLabelProvider implements ITableLabelProvider {
	        /**
	         * 这个方法返回的是各列的记录的文字
	         * 参数1:输入的对象
	         * 参数2:列号
	         * 返回值:注意一定要避免Null值,否则出错
	         */
	        public String getColumnText(Object element, int col) {
	        	StorageItem s = (StorageItem) element; //转换一下类型
	            if (col == 0)
	                return s.getName();
	            if (col == 1)
	                return s.getType();
	            if (col == 2)
	                return Integer.toString(s.getQuantity());

	            return "";
	        }
	        /**
	         * 返回每条记录前面的图标
	         */
	        public Image getColumnImage(Object element, int columnIndex) {
	            return null;
	        }
	        //-------------以下方法用处不大,暂时不管它-----------------
	        public void addListener(ILabelProviderListener listener) {}
	        public void dispose() {}
	        public boolean isLabelProperty(Object element, String property) {
	            return false;
	        }
	        public void removeListener(ILabelProviderListener listener) {}
	    }

	public void computeTotal(){
		try{
			DBmanager dbm = new DBmanager();
			Connection con = dbm.getCon();
			Statement state = con.createStatement();
			ResultSet rs= state.executeQuery("Select totalprice,saletime From salesorder");
			int total = 0;
			while(rs.next()){
				Timestamp ts = rs.getTimestamp("saletime");
				Date date= new Date();
				Timestamp ts2 = new Timestamp(date.getTime());
				if(ts.getDate()==ts2.getDate()){
					total=total+rs.getInt("totalprice");
				}
			}
			label_1.setText(Integer.toString(total));
			dbm.close();
			}catch(Exception e) {
		        e.printStackTrace();
		       
			}
			
	}
	public void dispose() {
		super.dispose();
	}

	protected void checkSubclass() {
		// Disable the check that prevents subclassing of SWT components
	}

}