todaylistframe.java

java编的销售系统

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.util.*;
import java.io.File;
import java.sql.*;
import java.util.*;
import java.io.*;
import java.util.Date;


class TodayListFrame extends JFrame   //当天销售信息
{    
   
    public TodayListFrame()
    {
		setTitle("Today SaleList");
		setSize(500, 400);	
		Container contentPane = getContentPane();
		list= new JTextArea(20,40);
        try{
        	Connect.getConnection();   //连接数据库，执行获取交易信息的存储过程
	    rs=Connect.getnowlist();
	    list.append("basetype"+"\t\t"+"pizzatype"+"\t"+"amount"+"\n\n");
	    while(rs.next())
		{
			list.append(rs.getString(1)+" "+rs.getString(2)+"\t"+rs.getString(3)+"\n");
		}
		}
		catch(SQLException e)
		{
			e.printStackTrace();
		}
	
		
		JPanel panel = new JPanel();
		
      	panel.add(list);      
      
      	contentPane.add(panel, BorderLayout.CENTER); 
      	
      	JPanel ButtonPanel = new JPanel();
      	
         	
         JButton totalfee=new JButton("Total Income");
         totalfee.addActionListener(new ActionListener()
         {
         	public void actionPerformed(ActionEvent event)
            	{
            	try{
		        Connect.getConnection();
	            rs=Connect.totalfee();
	           while(rs.next())
		        {
			      label1.setText(rs.getString(1));
		        }
		       }
		catch(SQLException e)
		{
			e.printStackTrace();
		}            		
               		
            	}
         	
         });        
         ButtonPanel.add(totalfee);
         ButtonPanel.add(label1);
         contentPane.add(ButtonPanel, BorderLayout.NORTH);
         
         setSize(700, 600);
    }
    
    
    private JTextArea list= null;
    private JLabel label1=new JLabel();
    private ResultSet rs;
 }