dailygusetframe.java

酒店管理系统后台数据库存储过程

package operation;

import java.awt.BorderLayout;

import javax.swing.JFrame;
import javax.swing.JTable;
import java.awt.*;
import javax.swing.JScrollPane;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
import entity.DBOperatorBean;
import java.sql.ResultSet;
import java.sql.*;
import javax.swing.JTextField;
import java.util.Date;
import javax.swing.Timer;
import java.text.SimpleDateFormat;
import javax.swing.JLabel;
import javax.swing.JComboBox;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import entity.Manager;
import java.util.Calendar;
import javax.swing.JOptionPane;
import javax.swing.ImageIcon;

/**
 * <p>Title: Hawaii rummery manage</p>
 *
 * <p>Description: minityperummery manage</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: Yue.</p>
 *
 * @author not attributable
 * @version 1.0
 */
public class DailyGusetFrame extends JFrame {
    public DailyGusetFrame  () {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        Date d = new Date();
        SimpleDateFormat sdf = new SimpleDateFormat("今天的日期为：yyyy年MM月dd日");
        lbltoday.setFont(new java.awt.Font("宋体", Font.PLAIN, 17));
        lbltoday.setForeground(Color.blue);
        lbltoday.setText("当天日期："+(d.getYear()+1900)+"年"+(d.getMonth()+1)+"月"+d.getDate()+"日");
        getContentPane().setLayout(null);
        this.getContentPane().setBackground(new Color(212, 255, 255));
        this.setDefaultCloseOperation(DISPOSE_ON_CLOSE);
        this.setResizable(false);
        this.setTitle("客人登记记录查询");
        btnsee.setBackground(new Color(212, 249, 255));
        btnsee.setBounds(new Rectangle(519, 79, 100, 30));
        btnsee.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnsee.setForeground(Color.blue);
        btnsee.setText("");
        btnsee.addActionListener(new AccountFrame_btnsee_actionAdapter(this));
        jScrollPane1.getViewport().setBackground(new Color(255, 236, 255));
        jScrollPane1.setBounds(new Rectangle(47, 119, 606, 331));
        lblTip.setFont(new java.awt.Font("Dialog", Font.PLAIN, 16));
        lblTip.setText("要查询的日期：");
        lblTip.setBounds(new Rectangle(50, 78, 114, 30));
        btnExit.setBackground(new Color(212, 236, 255));
        btnExit.setBounds(new Rectangle(527, 467, 120, 30));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnExit.setForeground(Color.blue);
        btnExit.setText("");
        btnExit.addActionListener(new AccountFrame_jButton1_actionAdapter(this));
        cboYear.setBackground(new Color(255, 240, 255));
        cboYear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboYear.setBounds(new Rectangle(165, 78, 90, 30));
        cboYear.addItemListener(new AccountFrame_cboYear_itemAdapter(this));
        cboMonth.setBackground(new Color(255, 240, 255));
        cboMonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboMonth.setBounds(new Rectangle(283, 79, 90, 30));
        cboMonth.addItemListener(new AccountFrame_cboMonth_itemAdapter(this));
        cboday.setBackground(new Color(255, 240, 255));
        cboday.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        cboday.setBounds(new Rectangle(399, 79, 90, 30));
        lblYear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblYear.setText("年");
        lblYear.setBounds(new Rectangle(257, 80, 24, 30));
        lblMonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblMonth.setText("月");
        lblMonth.setBounds(new Rectangle(373, 79, 27, 30));
        lblDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDate.setText("日");
        lblDate.setBounds(new Rectangle(490, 79, 27, 30));
        lbltoday.setBounds(new Rectangle(51, 466, 241, 37));
        btnsees.setBackground(new Color(212, 230, 255));
        btnsees.setBounds(new Rectangle(384, 468, 120, 30));
        btnsees.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnsees.setForeground(Color.blue);
        btnsees.setText("");
        btnsees.addActionListener(new AccountFrame_jButton2_actionAdapter(this));
        lblTitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 35));
        lblTitle.setForeground(Color.blue);
        lblTitle.setText("客人登记记录查询");
        lblTitle.setBounds(new Rectangle(207, 5, 287, 54));


       this.btnExit.setIcon( new ImageIcon("image\\frame\\DailyGusteFram\\exit.jpg"));
       this.btnsee.setIcon(new ImageIcon("image\\frame\\DailyGusteFram\\query.jpg"));
       this.btnsees.setIcon(new ImageIcon("image\\frame\\DailyGusteFram\\queryAll.jpg"));
        this.getContentPane().add(lblTitle);
        this.getContentPane().add(lbltoday);
        this.getContentPane().add(btnsees);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(jScrollPane1);
        this.getContentPane().add(btnsee);
        this.getContentPane().add(lblTip);
        this.getContentPane().add(cboYear);
        this.getContentPane().add(cboMonth);
        this.getContentPane().add(lblYear);
        this.getContentPane().add(lblMonth);
        this.getContentPane().add(cboday);
        this.getContentPane().add(lblDate);
        jScrollPane1.getViewport().add(tblaccount);
        dtm.addColumn("客人姓名");
        dtm.addColumn("抵店日期");
        dtm.addColumn("离店日期");
        dtm.addColumn("房间号");
        dtm.addColumn("房间类别");
        dtm.addColumn("折扣价");
        dtm.addColumn("押金");
        dtm.addColumn("总额");
        this.tblaccount.setModel(dtm);

        this.Years();
        this.Months();
        this.days();
        this.getCal();

    }

    Calendar cal = Calendar.getInstance();
    int flag;
    int year;
    int month;
    int day;

    Manager m = new Manager();
    DefaultTableModel dtm = new DefaultTableModel();

    JButton btnsee = new JButton();
    JScrollPane jScrollPane1 = new JScrollPane();
    JTable tblaccount = new JTable();
    DBOperatorBean dbo = new DBOperatorBean();
    JLabel lblTip = new JLabel();
    JButton btnExit = new JButton();
    JComboBox cboYear = new JComboBox();
    JComboBox cboMonth = new JComboBox();
    JComboBox cboday = new JComboBox();
    JLabel lblYear = new JLabel();
    JLabel lblMonth = new JLabel();
    JLabel lblDate = new JLabel();
    JLabel lbltoday = new JLabel();
    JButton btnsees = new JButton();
    JLabel lblTitle = new JLabel();


    public void btnsee_actionPerformed(ActionEvent e) {

        Vector v = new Vector();
        dtm = new DefaultTableModel();
        dtm.addColumn("客人姓名");
        dtm.addColumn("抵店日期");
        dtm.addColumn("离店日期");
        dtm.addColumn("房间号");
        dtm.addColumn("房间类别");
        dtm.addColumn("折扣价");
        dtm.addColumn("押金");
        dtm.addColumn("总额");
        this.tblaccount.setModel(dtm);

        String today = cboYear.getSelectedItem().toString() + "-" +
                       cboMonth.getSelectedItem().toString() + "-" +
                       cboday.getSelectedItem().toString();
        ResultSet rs = dbo.returnQuery("select name,CheckInDate,CheckOutDate,roomno,class,RebatePri,Deposit,Total from register where CheckInDate='" +
                                       today + "'");
        try {
            if(!rs.next())
            {
                JOptionPane.showMessageDialog(this,"当天没有客人入住！！");
                return;
            }else
            {

                do{
                    v = new Vector();
                    v.add(rs.getString("name"));
                    v.add(rs.getString("CheckInDate"));
                    v.add(rs.getString("CheckOutDate"));
                    v.add(rs.getString("roomno"));
                    v.add(rs.getString("class"));
                    v.add(rs.getString("RebatePri"));
                    v.add(rs.getString("Deposit"));
                    v.add(rs.getString("Total"));
                    dtm.addRow(v);
                }while (rs.next()) ;

            }
            this.tblaccount.setModel(dtm);
            //  dtm = new DefaultTableModel();

        } catch (SQLException ex) {
            ex.printStackTrace();
        }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        dispose();
    }

    public void cboYear_itemStateChanged(ItemEvent e) {
    }

    public void Years() {
        this.cboYear.addItem("2007");
        this.cboYear.addItem("2008");
        this.cboYear.addItem("2009");
        this.cboYear.addItem("2010");