income.java

完成课程设计

package 客房管理;

import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Container;
import java.awt.event.*;
import java.sql.*;

public class InCome extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JLabel jYear;
	JTextField tYear;
	JButton bSum,bBack;
	JPanel panel;
	JTable tbMain;
	Container container;
	Object a[][];
	Object colname[]={"月份","收入"};
	
	public InCome()
	{
		super("月收入");
		a=new Object[20][2];
		tbMain=new JTable(a,colname);
		setSize(20,20);
		setVisible(true);
		
		jYear=new JLabel("年份：");
		tYear=new JTextField(10);
				
		bSum=new JButton("计算");
		bSum.addActionListener(this);
		bBack=new JButton("返回");
		bBack.addActionListener(this);
	
		panel=new JPanel();
		panel.add(jYear);
		panel.add(tYear);
		panel.add(bSum);
		panel.add(bBack);
		
		container=getContentPane();
		container.add(panel,BorderLayout.SOUTH);
		container.add(new JScrollPane(tbMain),BorderLayout.CENTER);
		setBounds(400,200,500,400);
		
	}
	
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getSource()==bBack)
		{
			this.dispose();
		}
		else if(ae.getSource()==bSum)
		{
			Connection con;
			Statement stat;
			ResultSet rs;
			int i=0;
			String b="select month(离店时间) as 月份,sum(金额) as 收入 from 历史记录 join 客房编号 on 客房编号=编号 where year(离店时间)="+"'"+tYear.getText()+"'"+" group by month(离店时间)";
			try
			{
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				con=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
				stat=con.createStatement();
				rs=stat.executeQuery(b);
				while(rs.next())
				{
					a[i][0]=rs.getString("月份");
					a[i][1]=rs.getString("收入");
					i++;
					this.setVisible(false);
					this.setVisible(true);
				}
			}
			catch(Exception e)
			{
				JOptionPane.showMessageDialog(null,"系统错误！抱歉！抱歉!","提示",JOptionPane.ERROR_MESSAGE);
				
			}
		}
	}
	
	/*public static void main(String[] args) 
	{
			new InCome();
	}*/

}