mainframe.java

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

package rummery;

import java.awt.*;
import java.awt.event.*;
import javax.swing.JFrame;
import javax.swing.JPanel;
import javax.swing.JMenuBar;
import javax.swing.JMenu;
import javax.swing.JMenuItem;
import javax.swing.UIManager;
import javax.swing.JLabel;
import javax.swing.ImageIcon;
import javax.swing.JToolBar;
import javax.swing.JButton;
import operation.QueryRoomFrame;
import operation.ResetStatusFrame;
import javax.swing.*;
import operation.RegisterFrame;
import operation.ReturnRoomFrame;
import operation.DailyEarningFrame;
import java.awt.Font;
import java.util.Calendar;
import java.util.Date;
import java.text.SimpleDateFormat;
import operation.EmployeeFrame;
import operation.DailyGusetFrame;
import operation.AdminManageFrame;
import operation.OnDutyFrame;
import operation.HotelIntro;
import operation.CalendarFrm;

/**
 * <p>Title: 山海假日酒点信息管理系统</p>
 *
 * <p>Description: 小型酒店信息管理软件</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: FZ编程小组</p>
 *
 * @author FZ编程小组
 * @version 1.0
 */
public class MainFrame extends JFrame {
    JPanel contentPane;
    JMenuBar MenuBar = new JMenuBar();
    JMenu mnuGuestInfo = new JMenu();
    ImageIcon backgroud = new ImageIcon("image\\壁画.jpg");
    JToolBar ToolBar = new JToolBar();
    JButton btnRegistRoom = new JButton();
    JButton btnReturnRoom = new JButton();
    JButton btnQueryRoom = new JButton();
    JButton btnEmInfo = new JButton();
    JButton btnBusinessTb = new JButton();
    JButton btnAdminInfo = new JButton();
    JButton btnExit = new JButton();
    JMenu mnuroomInfo = new JMenu();
    JMenu EmInfo = new JMenu();
    JMenu mnuBusinessInfo = new JMenu();
    JMenu mnuSystemInfo = new JMenu();
    JMenu mnuRummery = new JMenu();
    JMenu mnuHelp = new JMenu();
    JMenuItem mnuIntro = new JMenuItem();
    JMenuItem mnuGuestRegistInfo = new JMenuItem();
    JMenuItem mnuGusetCheckInfo = new JMenuItem();
    JMenuItem mnuDailyInfo = new JMenuItem();
    JMenuItem mnuaboutMe = new JMenuItem();
    JMenuItem mnuBaseInfo = new JMenuItem();
    JMenuItem mnuOnDuty = new JMenuItem();
    JMenuItem mnuReturnInfo = new JMenuItem();
    JMenuItem mnuUpdateStatus = new JMenuItem();
    JMenuItem mnuQueryRoon = new JMenuItem();
    JMenuItem mnuQueryRoom = new JMenuItem();
    JMenuItem mnuRegistAdmin = new JMenuItem();
    JMenu mnuAdmin = new JMenu();
    JPanel mainPanel = new JPanel();
    JPanel jPanel1 = new JPanel();
    JLabel lblAdminInfo = new JLabel();
    JLabel lblShowTime = new JLabel();
    LoginFrame login = new LoginFrame();
    static Timer timer;
    JMenu mnuDataAdmin = new JMenu();
    JMenuItem munInit = new JMenuItem();
    CardLayout card = new CardLayout();

    ImageIcon i0 = new ImageIcon("image\\imgMain\\1000.jpg");
    ImageIcon i1 = new ImageIcon("image\\imgMain\\1001.jpg");
    ImageIcon i2 = new ImageIcon("image\\imgMain\\1002.jpg");
    ImageIcon i3 = new ImageIcon("image\\imgMain\\1003.jpg");
    ImageIcon i4 = new ImageIcon("image\\imgMain\\1004.jpg");
    ImageIcon i5 = new ImageIcon("image\\imgMain\\1005.jpg");
    ImageIcon i6 = new ImageIcon("image\\imgMain\\1006.jpg");
    ImageIcon i7 = new ImageIcon("image\\imgMain\\1007.jpg");
    ImageIcon i8 = new ImageIcon("image\\imgMain\\1008.jpg");
    ImageIcon i9 = new ImageIcon("image\\imgMain\\1009.jpg");


    JLabel lbl1 = new JLabel();
    JLabel lbl2 = new JLabel();
    JLabel lbl3 = new JLabel();
    JLabel lbl4 = new JLabel();
    JLabel lbl5 = new JLabel();
    JLabel lbl6 = new JLabel();
    JLabel lbl7 = new JLabel();
    JLabel lbl8 = new JLabel();
    JLabel lbl9 = new JLabel();
    JLabel lbl0 = new JLabel();
    static Timer timer2;
    static int number = 0;
    JLabel lblMakerInfo = new JLabel();
    JPopupMenu popmnu = new JPopupMenu();
    JMenuItem jMenuItem1 = new JMenuItem();
    JMenuItem jMenuItem2 = new JMenuItem();
    JMenuItem jMenuItem3 = new JMenuItem();
    JMenuItem jMenuItem4 = new JMenuItem();
    JMenuItem jMenuItem5 = new JMenuItem();
    JMenuItem jMenuItem6 = new JMenuItem();





    JMenuItem mnu = new JMenuItem();
    public MainFrame() {
        try {
            setDefaultCloseOperation(EXIT_ON_CLOSE);
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    /**
     * Component initialization.
     *
     * @throws java.lang.Exception
     */
    private void jbInit() throws Exception {
        contentPane = (JPanel) getContentPane();
        contentPane.setLayout(null);
        this.getContentPane().setBackground(SystemColor.activeCaptionBorder);
        this.setDefaultCloseOperation(EXIT_ON_CLOSE);
        this.setResizable(false);

        setSize(new Dimension(700, 550));
        setTitle("Hawaii rummery manage system");
        mnuGuestInfo.setBackground(new Color(212, 255, 255));
        mnuGuestInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuGuestInfo.setText("客人入住");
        MenuBar.setBackground(new Color(203, 255, 255));
        ToolBar.setBackground(new Color(203, 255, 255));
        ToolBar.setBounds(new Rectangle(1, 0, 679, 31));
        btnRegistRoom.setBackground(SystemColor.info);
        btnRegistRoom.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnRegistRoom.addActionListener(new
                                        MainFrame_btnRegistRoom_actionAdapter(this));
        btnReturnRoom.setBackground(SystemColor.info);
        btnReturnRoom.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnReturnRoom.setText("");
        btnReturnRoom.addActionListener(new
                                        MainFrame_btnReturnRoom_actionAdapter(this));
        btnQueryRoom.setBackground(SystemColor.info);
        btnQueryRoom.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnQueryRoom.setText("");
        btnQueryRoom.addActionListener(new MainFrame_btnQueryRoom_actionAdapter(this));
        btnEmInfo.setBackground(SystemColor.info);
        btnEmInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnEmInfo.setText("");
        btnEmInfo.addActionListener(new MainFrame_btnEmInfo_actionAdapter(this));
        btnBusinessTb.setBackground(SystemColor.info);
        btnBusinessTb.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnBusinessTb.setText("");
        btnBusinessTb.addActionListener(new
                                        MainFrame_btnBusinessTb_actionAdapter(this));
        btnAdminInfo.setBackground(SystemColor.info);
        btnAdminInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAdminInfo.setText("");
        btnAdminInfo.addActionListener(new MainFrame_btnAdminInfo_actionAdapter(this));
        btnExit.setBackground(SystemColor.info);
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnExit.setText("");
        btnExit.addActionListener(new MainFrame_jButton8_actionAdapter(this));
        mnuRummery.setBackground(new Color(212, 255, 255));
        mnuRummery.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuRummery.setText("信息");
        mnuroomInfo.setBackground(new Color(212, 255, 255));
        mnuroomInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuroomInfo.setText("客房信息");
        EmInfo.setBackground(new Color(212, 255, 255));
        EmInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        EmInfo.setText("员工信息");
        mnuBusinessInfo.setBackground(new Color(212, 255, 255));
        mnuBusinessInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuBusinessInfo.setText("业务报表");
        mnuSystemInfo.setBackground(new Color(212, 255, 255));
        mnuSystemInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuSystemInfo.setText("系统信息");
        mnuHelp.setBackground(new Color(212, 255, 255));
        mnuHelp.setFont(new java.awt.Font("Dialog", Font.PLAIN, 14));
        mnuHelp.setText("帮助");
        mnuIntro.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuIntro.setText("简介");
        mnuIntro.addActionListener(new MainFrame_mnuIntro_actionAdapter(this));
        mnuGuestRegistInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuGuestRegistInfo.setText("客人登记");
        mnuGuestRegistInfo.addActionListener(new
                                             MainFrame_mnuGuestRegistInfo_actionAdapter(this));
        mnuGusetCheckInfo.setEnabled(false);
        mnuGusetCheckInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuGusetCheckInfo.setText("客人登记");
        mnuGusetCheckInfo.addActionListener(new
                                            MainFrame_mnuGusetCheckInfo_actionAdapter(this));
        mnuDailyInfo.setEnabled(false);
        mnuDailyInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuDailyInfo.setText("每日营收");
        mnuDailyInfo.addActionListener(new MainFrame_mnuDailyInfo_actionAdapter(this));
        mnuaboutMe.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuaboutMe.setText("关于");
        mnuaboutMe.addActionListener(new MainFrame_mnuaboutMe_actionAdapter(this));
        mnuBaseInfo.setEnabled(false);
        mnuBaseInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuBaseInfo.setText("基本信息");
        mnuBaseInfo.addActionListener(new MainFrame_mnuBaseInfo_actionAdapter(this));
        mnuOnDuty.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuOnDuty.setText("员工值班");
        mnuOnDuty.addActionListener(new MainFrame_mnuOnDuty_actionAdapter(this));
        mnuReturnInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuReturnInfo.setText("客人退房");
        mnuReturnInfo.addActionListener(new
                                        MainFrame_mnuReturnInfo_actionAdapter(this));
        mnuUpdateStatus.setEnabled(false);
        mnuUpdateStatus.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuUpdateStatus.setText("信息修改");
        mnuUpdateStatus.addActionListener(new
                                          MainFrame_mnuUpdateStatus_actionAdapter(this));
        mnuQueryRoom.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuQueryRoom.setText("客房查询");
        mnuQueryRoom.addActionListener(new MainFrame_mnuQueryRoom_actionAdapter(this));
        mnuRegistAdmin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuRegistAdmin.setText("注册管理员");
        mnuRegistAdmin.addActionListener(new
                                         MainFrame_mnuRegistAdmin_actionAdapter(this));
        mnuAdmin.setEnabled(false);
        mnuAdmin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuAdmin.setText("管理员管理");

        mainPanel.setBorder(BorderFactory.createEtchedBorder());
        mainPanel.setBounds(new Rectangle(11, 29, 670, 404));
        mainPanel.setLayout(card);
        jPanel1.setBackground(new Color(212, 255, 255));
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(12, 440, 669, 50));
        jPanel1.setLayout(null);
        contentPane.setBackground(new Color(212, 255, 255));
        lblAdminInfo.setBackground(new Color(212, 208, 255));
        lblAdminInfo.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        lblAdminInfo.setForeground(Color.blue);
        lblAdminInfo.setBorder(BorderFactory.createEtchedBorder());
        lblAdminInfo.setText("jLabel1");
        lblAdminInfo.setBounds(new Rectangle(188, 22, 240, 25));
        lblShowTime.setBackground(new Color(212, 208, 255));
        lblShowTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        lblShowTime.setForeground(Color.blue);
        lblShowTime.setBorder(BorderFactory.createEtchedBorder());
        lblShowTime.setBounds(new Rectangle(428, 22, 238, 25));
        lblShowTime.addMouseListener(new MainFrame_lblShowTime_mouseAdapter(this));
        mnuDataAdmin.setEnabled(false);
        mnuDataAdmin.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
        mnuDataAdmin.setText("数据库管理");
        munInit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        munInit.setText("初始化数据库");
        munInit.addActionListener(new MainFrame_jMenuItem1_actionAdapter(this));
        lbl1.setText("");
        lbl2.setText("");
        lbl3.setText("");
        lbl4.setText("");
        lbl5.setText("");
        lbl6.setText("");
        lbl7.setText("");
        this.lbl0.setIcon(i0);
        this.lbl1.setIcon(i1);
        this.lbl2.setIcon(i2);
        this.lbl3.setIcon(i3);