consume.java

这是我我完成的java的课程设计,是一个宾馆管理系统

import java.awt.BorderLayout;
import java.awt.Dimension;
import java.awt.FlowLayout;
import java.awt.Rectangle;
import java.awt.Toolkit;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.WindowAdapter;
import java.awt.event.WindowEvent;
import java.awt.event.WindowListener;
import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.swing.ButtonGroup;
import javax.swing.JButton;
import javax.swing.JComboBox;
import javax.swing.JFrame;
import javax.swing.JLabel;
import javax.swing.JPanel;
import javax.swing.JRadioButton;
import javax.swing.JScrollPane;
import javax.swing.JTextField;

/************************************************************/
public class consume extends DBAccess implements ActionListener 
{
	String sql="select * from HistoryCustomer";
	JFrame fm=new JFrame("消费查询");//创建一个窗口
	ButtonGroup buttonGroup2 = new ButtonGroup();
	JRadioButton ave = new JRadioButton();
	JRadioButton ave1= new JRadioButton();
	JRadioButton sum = new JRadioButton();
	JRadioButton sum1 = new JRadioButton();
	JLabel lb1=new JLabel("结果:");//标签
	JLabel lb2=new JLabel();//标签
	//JLabel lb2=new JLabel("        ");//显示结果
	JTextField tf=new JTextField(10);//文本框显示结果
	JButton bt1=new JButton("查询");//查询按钮
	JPanel p1=new JPanel();//创建一个容器
	JPanel p2=new JPanel();//容器2
	
	public void show(){
		    ave.setFont(new java.awt.Font("Dialog", 0, 15));
		    ave.setRolloverEnabled(false);
		    ave.setText("求今天预定顾客数");
		    ave.setBounds(new Rectangle(80, 417, 90, 34));
		    ave1.setFont(new java.awt.Font("Dialog", 0, 15));
		    ave1.setRolloverEnabled(false);
		    ave1.setText("求今天入住顾客数");
		    ave1.setBounds(new Rectangle(80, 417, 90, 34));
		    sum.setBounds(new Rectangle(200, 418, 74, 34));
		    sum.setText("求今天的营业额");
		    sum.setRolloverEnabled(false);
		    sum.setFont(new java.awt.Font("Dialog", 0, 15));
		    sum1.setBounds(new Rectangle(200, 418, 74, 34));
		    sum1.setText("求月营业额");
		    sum1.setRolloverEnabled(false);
		    sum1.setFont(new java.awt.Font("Dialog", 0, 15));
		    buttonGroup2.add(ave);
		    buttonGroup2.add(ave1);
		    buttonGroup2.add(sum);
		    buttonGroup2.add(sum1);
		 
		fm.setSize(800,400);//大小
		 Dimension screen = Toolkit.getDefaultToolkit().getScreenSize(); 
			fm.setLocation( 
				(screen.width - fm.getWidth()) / 2, 
				(screen.height - fm.getHeight()) / 2);//位置
		fm.setLayout(new BorderLayout());//窗口布局
		p1.setLayout(new FlowLayout());//容器布局
		p1.add(ave1);p1.add(ave);p1.add(sum);
		p1.add(sum1);p1.add(lb1);p1.add(tf);p1.add(bt1);//添加组件
		 
		
		p2.setLayout(new BorderLayout());//容器2布局
		p2.add(p1,"North");
		p2.add(new Query().getTablePane(sql),"Center");//调用文件Query中的getTablePane()方法
		fm.add(p2);
		fm.setVisible(true);
		fm.setResizable(false);
		fm.addWindowListener(new WindowAdapter(){
			public void windowClosing(WindowEvent e){
				fm.dispose();
			}
		});
/*********************实现对查询按钮的监听*******************************************/
bt1.addActionListener(new ActionListener(){
			public void actionPerformed(ActionEvent arg0) {
				 if (ave.isSelected()) {
                	 tf.setText("");
                     try {
						tf.setText(""+getValue("select count(*) as result from Customer where DATEPART(day , 预定时间)=day(getdate())","result"));
					} catch (SQLException e) {
						e.printStackTrace();
					}
                 }
				 if (ave1.isSelected()) {
                	 tf.setText("");
                     try {
						tf.setText(""+getValue("select count(*) as result from Customer where DATEPART(day , 入住时间)=day(getdate())","result"));
					} catch (SQLException e) {
						e.printStackTrace();
					}
                 }
                 if (sum.isSelected()) {
                	 tf.setText("");
                	 try {
						tf.setText(""+getValue("select sum(消费金额) as result from HistoryCustomer where DATEPART(day , 离开时间)=day(getdate())","result" ));
					} catch (SQLException e) {
						e.printStackTrace();
					}              
                 }
                 if (sum1.isSelected()) {
                	 tf.setText("");
                	 try {
						tf.setText(""+getValue("select sum(消费金额) as result from HistoryCustomer where DATEPART(month , 离开时间)=month(getdate())","result" ));
					} catch (SQLException e) {
						e.printStackTrace();
					}              
                 }
			}		
		});
	}
	public void actionPerformed(ActionEvent e) {
		show();
	}
}