totalsaleconditionoftoday.java

这是一个超市管理系统

package file2;
import java.awt.*;
import java.sql.*;
import javax.swing.*;
import java.text.SimpleDateFormat;
public class TotalSaleConditionOfToday extends JPanel{
	private DBConnection con=null;
	private JLabel tip=new JLabel("本日销售情况统计");
	private JPanel tipPane=new JPanel();
	private JTable table=null;
	private JScrollPane tablePane=null;
	private String[][] dataForTable=null;
	private String[] titleForTable={"商品名称","销售数量","销售额","赢利额"};
	public TotalSaleConditionOfToday(){
		con=new DBConnection();
		//tipPane.setLayout(new FlowLayout(FlowLayout.CENTER));
		tipPane.add(tip);
		java.util.Date today=new java.util.Date();
		SimpleDateFormat formatter=new SimpleDateFormat("yyyy-MM-dd");
		String todayStr=formatter.format(today);
		String queryStr="SELECT To_Third_name AS third_name, SUM(quantity) AS saled,"+
				"sum(price*quantity)as moneyGet,sum((price-cost)*quantity)as profit "+
				"FROM operationRecord,Third_Catalog WHERE To_Third_name=Third_name and "+
				"operationState = '1' AND operateTime='"+todayStr+"' GROUP BY To_Third_name";
		ResultSet set=con.executeSelect1(queryStr);
		int count=0;
		try{
			while(set.next()){
				count++;
			}
			if(count==0){
				dataForTable=new String[1][4];
				dataForTable[count][0]="无";
				dataForTable[count][1]="0";
				dataForTable[count][2]="0";
				dataForTable[count][3]="0";
			}else{
				set.beforeFirst();
				dataForTable=new String[count][4];
				count=0;
				while(set.next()){
					dataForTable[count][0]=set.getString(1);
					dataForTable[count][1]=(new Integer(set.getInt(2))).toString();
					dataForTable[count][2]=(new Integer(set.getInt(3))).toString();
					dataForTable[count][3]=(new Integer(set.getInt(4))).toString();
					count++;
				}
			}
			table=new JTable(dataForTable,titleForTable);
			tablePane=new JScrollPane(table);
			this.setLayout(new GridLayout(2,1));
			this.add(tipPane);
			this.add(tablePane);
		}catch(Exception e){
			e.printStackTrace();
		}
		
	}
}