employeeframe.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;

public class EmployeeFrame extends JFrame{
	public EmployeeFrame()
	{
		setTitle("EmployeeWage");
		setSize(500,500);
		Container contentPane = getContentPane();
		list= new JTextArea(20,40);
		 try{
	        Connect.getConnection();   //连接数据库，执行获取交易信息的存储过程
		    rs=Connect.employeewage();
		    list.append("\t"+"employeeID"+"\t"+"   "+"wage"+"\n\n");
		    while(rs.next())
			{
		    	
				list.append("\t"+rs.getString(1)+"\t"+"   "+rs.getString(2)+"\n");
			}
			}
			catch(SQLException e)
			{
				e.printStackTrace();
			}
			JPanel panel = new JPanel();
			
	      	panel.add(list);      
	      
	      	contentPane.add(panel, BorderLayout.CENTER); 
		
	}

	private JTextArea list= null;
	 private JLabel label1=new JLabel();
	    private ResultSet rs;
}