rate.java

完成课程设计

package 客房管理;

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

public class Rate extends JFrame implements ActionListener
{
	/**
	 * 
	 */
	private static final long serialVersionUID = 1L;
	JLabel lStart,lOver;
	JTextField tStart,tOver;
	String[] conlname={"客房号","入住率"};	
	Object[][] f={};
	JTable table;
	JButton bStatistics,bReturn;	
	Container container;
	JPanel panelM;
	public Rate()
	{
		//窗体布局
		super("入住率");
		f=new Object[60][2];			
		table=new JTable(f,conlname);
		
		lStart=new JLabel("起始时间");
		lOver=new JLabel("结束时间");
		tStart=new JTextField(10);
		tOver=new JTextField(10);
		panelM=new JPanel();
		panelM.add(lStart);panelM.add(tStart);panelM.add(lOver);panelM.add(tOver);
		
		bStatistics=new JButton("统计");
		bStatistics.addActionListener(this);
		bReturn=new JButton("返回");
		bReturn.addActionListener(this);
		panelM.add(bReturn);panelM.add(bStatistics);		
		//new 一个容器						
		container=getContentPane();
		container.add(panelM,BorderLayout.SOUTH);
		container.add(new JScrollPane(table),BorderLayout.CENTER);
		setBounds(400,200,500,400);			
		setVisible(true);
		
	}
	//按扭触发事件
	public void actionPerformed(ActionEvent ae)
	{
		if(ae.getSource()==bStatistics)
		{
			Connection conn;
			Statement stat;
			ResultSet rs;
			try
			{
				int i=0;
				Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
				conn=DriverManager.getConnection("jdbc:odbc:客房管理","sa","");
				stat=conn.createStatement();
				rs=stat.executeQuery("select 客房编号,cast(cast(count(*) as float)/(select count(*) from 历史记录)*100.00 as varchar)+'%' as 入住率 " +
						"from 历史记录 where 离店时间>="+"'"+tStart.getText()+"' and 离店时间<="+"'"+tOver.getText()+"' group by 客房编号");
				while(rs.next())
				{
					f[i][0]=rs.getString("客房编号");					
					f[i][1]=rs.getString("入住率");					
					i++;
					this.setVisible(false);
					this.setVisible(true);					
				}
			}
			catch(Exception e)
			{
				JOptionPane.showMessageDialog(null,"连接失败!");
			}
		}
		//返回按钮
		else if(ae.getSource()==bReturn)
		{
			dispose();
		}
	}
	
	/*public static void main(String[] args)
	{
		new Rate();
	}*/
}