dailyearningframe.java

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

package operation;

import javax.swing.JFrame;
import javax.swing.JLabel;
import java.awt.*;
import javax.swing.*;
import javax.swing.border.Border;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import javax.swing.border.EtchedBorder;
import java.util.Calendar;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import javax.swing.table.DefaultTableModel;
import entity.DBOperatorBean;
import java.sql.ResultSet;
import java.sql.*;
import java.util.Vector;
import entity.DailyEarning;

/**
 * <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 DailyEarningFrame extends JFrame {
    public DailyEarningFrame() {
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        this.getContentPane().setLayout(null);
        lbltitle.setFont(new java.awt.Font("Dialog", Font.PLAIN, 35));
        lbltitle.setForeground(Color.magenta);
        lbltitle.setHorizontalAlignment(SwingConstants.CENTER);
        lbltitle.setText("每 日 营 收 报 表");
        lbltitle.setBounds(new Rectangle(217, 10, 267, 42));
        jToolBar1.setBackground(new Color(212, 243, 255));
        jToolBar1.setBorder(BorderFactory.createEtchedBorder());
        jToolBar1.setBounds(new Rectangle(23, 20, 180, 43));
        btnDaily.addActionListener(new DailyEarningFrame_btnDaily_actionAdapter(this));
        btnMonth.addActionListener(new DailyEarningFrame_btnMonth_actionAdapter(this));

        Pan1.setLayout(null);
        Pan2.setLayout(null);
        cboYear.setBackground(new Color(255, 232, 255));
        cboYear.setBounds(new Rectangle(151, 24, 59, 25));
        cboYear.addItemListener(new DailyEarningFrame_cboYear_itemAdapter(this));
        cboMonth.setBackground(new Color(255, 236, 255));
        cboMonth.setToolTipText("");
        cboMonth.setBounds(new Rectangle(257, 24, 60, 25));
        cboMonth.addItemListener(new DailyEarningFrame_cboMonth_itemAdapter(this));
        cboDate.setBackground(new Color(255, 237, 255));
        cboDate.setBounds(new Rectangle(365, 24, 60, 25));
        cboDate.addItemListener(new DailyEarningFrame_cboDate_itemAdapter(this));
        lblInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblInfo.setForeground(Color.blue);
        lblInfo.setText("请选择统计日期：");
        lblInfo.setBounds(new Rectangle(24, 25, 120, 26));
        lblYear.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblYear.setHorizontalAlignment(SwingConstants.CENTER);
        lblYear.setText("年");
        lblYear.setBounds(new Rectangle(213, 24, 40, 25));
        lblMonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblMonth.setHorizontalAlignment(SwingConstants.CENTER);
        lblMonth.setText("月");
        lblMonth.setBounds(new Rectangle(320, 24, 40, 25));
        lblDate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        lblDate.setHorizontalAlignment(SwingConstants.CENTER);
        lblDate.setText("日");
        lblDate.setBounds(new Rectangle(429, 24, 40, 25));
        btnDaily.setBackground(new Color(210, 223, 255));
        btnDaily.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnDaily.setForeground(Color.blue);
        btnDaily.setText("");
        btnsave.setBackground(new Color(230, 255, 255));
        btnsave.setBounds(new Rectangle(162, 22, 81, 29));
        btnsave.setEnabled(false);
        btnsave.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnsave.setForeground(Color.blue);
        btnsave.setText("");
        btnsave.addActionListener(new DailyEarningFrame_btnsave_actionAdapter(this));
        btnPan.setBackground(new Color(212, 245, 255));

        btnPan.setBorder(BorderFactory.createEtchedBorder());
        btnPan.setBounds(new Rectangle(24, 345, 444, 63));
        btnPan.setLayout(null);
        btnQuery.setBackground(new Color(230, 255, 255));
        btnQuery.setBounds(new Rectangle(41, 21, 80, 30));
        btnQuery.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnQuery.setForeground(Color.blue);
        btnQuery.setText("");
        btnQuery.addActionListener(new DailyEarningFrame_btnQuery_actionAdapter(this));
        btnRrturn.setBackground(new Color(227, 241, 255));
        btnRrturn.setBounds(new Rectangle(286, 22, 80, 30));
        btnRrturn.setFont(new java.awt.Font("Dialog", Font.PLAIN, 20));
        btnRrturn.setForeground(Color.blue);
        btnRrturn.setText("");
        btnRrturn.addActionListener(new
                                    DailyEarningFrame_btnRrturn_actionAdapter(this));
        tabPanel.setBackground(Color.yellow);
        tabPanel.setBorder(BorderFactory.createEtchedBorder());
        tabPanel.setBounds(new Rectangle(23, 70, 446, 268));
        tabPanel.setLayout(null);
        lblPicture.setBackground(new Color(212, 208, 255));
        lblPicture.setBorder(BorderFactory.createEtchedBorder());
        lblPicture.setText("");
        lblPicture.setBounds(new Rectangle(483, 28, 140, 380));
        lblPicture.setIcon(i1);
        datePane.setBounds(new Rectangle(2, 2, 442, 180));
        cumpPane.setBounds(new Rectangle(3, 186, 440, 81));
        this.getContentPane().setBackground(new Color(212, 255, 255));
        this.setTitle("每日营收报表");
        Pan1.setBackground(new Color(212, 235, 255));
        dateTable.setBackground(new Color(255, 249, 235));
        cumpTable.setBackground(new Color(255, 236, 236));
        Pan2.setBackground(new Color(213, 243, 255));
        btnMonth.setBackground(new Color(212, 223, 255));
        btnMonth.setForeground(Color.blue);
        lblPic.setBorder(BorderFactory.createEtchedBorder());
        lblPic.setText("");
        lblPic.setBounds(new Rectangle(20, 20, 600, 380));

        this.lblPic.setIcon(i2);
        this.btnDaily.setIcon(new ImageIcon("image\\dailyTable\\dailyTB.jpg"));
        this.btnMonth.setIcon(new ImageIcon("image\\dailyTable\\bgGround.jpg"));
        this.btnQuery.setIcon(new ImageIcon("image\\dailyTable\\query.jpg"));
        this.btnRrturn.setIcon(new ImageIcon("image\\dailyTable\\exit.jpg"));
        this.btnsave.setIcon(new ImageIcon("image\\dailyTable\\save.jpg"));
        Panel.add(Pan1, "Pan1");
        btnPan.add(btnsave);
        btnPan.add(btnQuery);
        btnPan.add(btnRrturn);
        Pan1.add(cboYear);
        Pan1.add(lblYear);
        Pan1.add(cboMonth);
        Pan1.add(lblMonth);
        Pan1.add(cboDate);
        Pan1.add(lblDate);
        Pan1.add(lblPicture);
        Pan1.add(lblInfo);
        Pan1.add(tabPanel);
        Panel.add(Pan2, "Pan2");
        Pan2.add(lblPic);
        this.getContentPane().add(jToolBar1);
        this.getContentPane().add(lbltitle);
        btnMonth.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnMonth.setText("");
        jToolBar1.add(btnDaily);
        jToolBar1.add(btnMonth);
        this.getContentPane().add(Panel);
        tabPanel.add(datePane, null);
        tabPanel.add(cumpPane);
        Pan1.add(btnPan);
        cumpPane.getViewport().add(cumpTable);
        datePane.getViewport().add(dateTable);
        Panel.setBorder(BorderFactory.createEtchedBorder());
        Panel.setBounds(new Rectangle(22, 64, 650, 427));
        Panel.setLayout(cardLayout1);

//        dtm.addColumn("帐单号");
//        dtm.addColumn("姓名");
//        dtm.addColumn("客房号");
//        dtm.addColumn("类别");
//        dtm.addColumn("结帐");
//        dtm.addColumn("退房状态");
//        dtm.addColumn("操作员");
//        this.dateTable.setModel(dtm);

//        select collectNO ,ondate,totalBeforeTax,tax,totalAfterTax,operator,remark from dailyearning

        //  cumpdtm.addColumn("统计编号");
//        cumpdtm.addColumn("统计日期");
//        cumpdtm.addColumn("税前总额");
//        cumpdtm.addColumn("税   额");
//        cumpdtm.addColumn("税后总额");
//        cumpdtm.addColumn("操 作 员");
//        cumpdtm.addColumn("备    注");
//        this.cumpTable.setModel(cumpdtm);
        initCboYear();
        initCboMonth();
        initCboDate();
        getCal();

    }

    JLabel lbltitle = new JLabel();
    JPanel Panel = new JPanel();
    JToolBar jToolBar1 = new JToolBar();
    CardLayout cardLayout1 = new CardLayout();
    JButton btnDaily = new JButton();
    JButton btnMonth = new JButton();
    Border border1 = BorderFactory.createMatteBorder(6, 6, 6, 6, Color.magenta);
    JPanel Pan1 = new JPanel();
    JPanel Pan2 = new JPanel();
    JComboBox cboYear = new JComboBox();
    JComboBox cboMonth = new JComboBox();
    JComboBox cboDate = new JComboBox();
    JLabel lblInfo = new JLabel();
    JLabel lblYear = new JLabel();
    JLabel lblMonth = new JLabel();
    JLabel lblDate = new JLabel();
    JButton btnsave = new JButton();
    JPanel btnPan = new JPanel();
    JButton btnQuery = new JButton();
    JButton btnRrturn = new JButton();
    JPanel tabPanel = new JPanel();
    JScrollPane datePane = new JScrollPane();
    JLabel lblPicture = new JLabel();
    Border border2 = BorderFactory.createEtchedBorder(EtchedBorder.RAISED,
            Color.white, new Color(148, 145, 140));
    Calendar cal = Calendar.getInstance();
    int year;
    int month;
    int date;
    boolean flag = false;
    JTable dateTable = new JTable();
    DefaultTableModel dtm ;
    DBOperatorBean dbo = new DBOperatorBean();
    DefaultTableModel cumpdtm ;
    DailyEarning daily;
    JScrollPane cumpPane = new JScrollPane();
    JTable cumpTable = new JTable();
    BorderLayout borderLayout1 = new BorderLayout();
    ImageIcon i1 = new ImageIcon("image\\img4\\4002.jpg");
    ImageIcon i2 = new ImageIcon("image\\img4\\4011.jpg");
    JLabel lblPic = new JLabel();


    public void btnDaily_actionPerformed(ActionEvent e) {
        this.Pan1.setVisible(true);
        this.Pan2.setVisible(false);

    }

    public void btnMonth_actionPerformed(ActionEvent e) {
        this.Pan1.setVisible(false);
        this.Pan2.setVisible(true);
    }

    public void btnQuery_actionPerformed(ActionEvent e) {
    //创建表结构帐单表
     dtm = new DefaultTableModel();
     dtm.addColumn("帐单号");
     dtm.addColumn("姓名");
     dtm.addColumn("客房号");
     dtm.addColumn("类别");
     dtm.addColumn("结帐");
     dtm.addColumn("退房状态");
     dtm.addColumn("操作员");
     this.dateTable.setModel(dtm);
     //创建统计表表结构
     cumpdtm = new DefaultTableModel();
    cumpdtm.addColumn("统计日期");
    cumpdtm.addColumn("税前总额");
    cumpdtm.addColumn("税   额");
    cumpdtm.addColumn("税后总额");
    cumpdtm.addColumn("操 作 员");
    cumpdtm.addColumn("备    注");
    this.cumpTable.setModel(cumpdtm);

        //设置查询统计的表的数据
        daily = new DailyEarning();
        //得到查询时间
        String today;
        String y = this.cboYear.getSelectedItem().toString();
        String m = this.cboMonth.getSelectedItem().toString();
        String d= this.cboDate.getSelectedItem().toString();

//        int index = this.cboDate.getSelectedIndex();
//        if(index == 0)
//        {
//            if(this.cboMonth.getSelectedIndex()==0)
//            {
//                if(this.cboYear.getSelectedIndex()==0)
//                {
//                    JOptionPane.showMessageDialog(this,"该系统不支持此前日期查询！！","提示",JOptionPane.INFORMATION_MESSAGE);
//                    return;
//                }
//                else
//                {
//                    y = this.cboYear.getItemAt(cboYear.getSelectedIndex()-1).toString();
//                }
//            }
//            else
//            {
//             m= this.cboMonth.getItemAt(cboMonth.getSelectedIndex()-1).toString();
//            }
//        }
//        else
//        {
//             d = this.cboDate.getItemAt(this.cboDate.getSelectedIndex()-1).toString();
//        }

        today = y + "-" + m + "-" + d;

        //查询当天帐单记录中的数据，放到dateTable中
       String sql ="select accountNo,name,roomNo,Class,reckoning,isreturnrm,operator from account where accountNo in( select accountNo  from register where checkInDate = '" +
                    today + "')";

       ResultSet rs = dbo.returnQuery(sql);
       String admin = "";
       try {
           while (rs.next()) {
               Vector v = new Vector();
               v.add(new Integer(rs.getInt(1)));
               v.add(rs.getString(2));
               v.add(rs.getString(3));
               v.add(rs.getString(4));
               v.add(new Integer(rs.getInt(5)));
               v.add(new Integer(rs.getInt(6)));
               admin = rs.getString(7);
               v.add(admin);
               dtm.addRow(v);
           }
           this.dateTable.setModel(dtm);
           rs.close();
       } catch (SQLException ex) {
           ex.printStackTrace();
       }
        Vector cumpv = new Vector();
        cumpv.add(today);
        daily.setOnDate(today);  //得到统计时间
        String sql1 = "select sum(reckoning) from account where accountNo in( select accountNo  from register where checkInDate = '" +
                      today + "')";
       // System.out.println(sql1);
        ResultSet rst = dbo.returnQuery(sql1);
        boolean tip = true;;