calendarfrm.java

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

package operation;

import javax.swing.JFrame;
import java.awt.BorderLayout;
import java.awt.Dimension;


import javax.swing.JPanel;
import java.awt.*;
import javax.swing.*;
import java.util.Date;
import java.text.SimpleDateFormat;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import javax.swing.JSpinner.DateEditor;
import java.util.Calendar;
import javax.swing.table.JTableHeader;
import javax.swing.event.ChangeEvent;
import javax.swing.event.ChangeListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;
import javax.swing.border.TitledBorder;
import java.awt.event.ItemEvent;
import java.awt.event.ItemListener;
import javax.swing.table.DefaultTableModel;
import java.util.Vector;
/**
 * <p>Title: 山海假日酒点信息管理系统</p>
 *
 * <p>Description: 小型酒店信息管理软件</p>
 *
 * <p>Copyright: Copyright (c) 2007</p>
 *
 * <p>Company: FZ编程小组</p>
 *
 * @author not attributable
 * @version 1.0
 */
public class CalendarFrm extends JFrame {
    static Timer timer;
    JPanel contentPane;
    JPanel panCalendar = new JPanel();
    JPanel panClock = new JPanel();
    JLabel lblTitle = new JLabel();
    JAppletClock clock = new JAppletClock();
    JTextField txtShowTime = new JTextField();
    // SpinnerDateModel dateModel = new SpinnerDateModel() ;
    //  JSpinner spinDate = new JSpinner(dateModel);
    JSpinner spinDate = new JSpinner();
    String[] colnames = {"日", "一", "二", "三", "四", "五", "六"};
    JComboBox cboMonth = new JComboBox();
    TitledBorder titledBorder1 = new TitledBorder("");
    DefaultTableModel dmt;
    JTable tblCalendar = new JTable();
    JTableHeader tblHeader = tblCalendar.getTableHeader();
    JPanel panShowCal = new JPanel();
    BorderLayout borderLayout1 = new BorderLayout();
    JTextField txtShowDayTime = new JTextField();
    JButton btnOK = new JButton();

    JLabel lblPicture = new JLabel();
    JLabel lblP1 = new JLabel();
    JLabel lblP2 = new JLabel();
    JLabel lblAp2 = new JLabel();

    ImageIcon i1 = new ImageIcon("image\\clock\\clock1.jpg");
     ImageIcon i2 = new ImageIcon("image\\clock\\Pclock1.jpg");
      ImageIcon i3 = new ImageIcon("image\\clock\\Pclock2.jpg");



    public CalendarFrm() {
        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.setResizable(false);
        setSize(new Dimension(500, 400));
        setTitle("Calendar");
        panCalendar.setBackground(new Color(212, 236, 255));
        panCalendar.setBorder(BorderFactory.createEtchedBorder());
        panCalendar.setToolTipText("riqi ");
        panCalendar.setBounds(new Rectangle(30, 51, 205, 279));
        panCalendar.setLayout(null);
        panClock.setBackground(new Color(212, 243, 255));
        panClock.setBorder(BorderFactory.createEtchedBorder());
        panClock.setToolTipText("shijian  ");
        panClock.setBounds(new Rectangle(244, 48, 227, 281));
        panClock.setLayout(null);
        lblTitle.setFont(new java.awt.Font("华文彩云", Font.BOLD | Font.ITALIC, 35));
        lblTitle.setForeground(Color.blue);

        lblTitle.setHorizontalAlignment(SwingConstants.CENTER);
        lblTitle.setText("");
        lblTitle.setBounds(new Rectangle(170, 6, 160, 40));
        clock.setBounds(10, 10, 210, 210);
        clock.setBackground(new Color(255, 230, 255));
        clock.setEnabled(false);
        clock.setVisible(true);
        clock.setLayout(null);
        clock.start();
        txtShowTime.setBackground(new Color(190, 220, 255));
        txtShowTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtShowTime.setForeground(Color.blue);
        txtShowTime.setEditable(false);
        txtShowTime.setText("            16:55:04");
        txtShowTime.setBounds(new Rectangle(12, 239, 203, 31));
        spinDate.setBackground(new Color(236, 177, 255));
        spinDate.setBorder(BorderFactory.createEtchedBorder());
        spinDate.setEnabled(true);
        spinDate.setFont(new java.awt.Font("Dialog", Font.BOLD, 15));
        spinDate.setForeground(Color.magenta);
        spinDate.setBounds(new Rectangle(114, 35, 72, 24));
        spinDate.addChangeListener(new CalendarFrm_spinDate_changeAdapter(this));
        cboMonth.setBackground(new Color(243, 197, 255));
        cboMonth.setBounds(new Rectangle(22, 36, 73, 24));
        cboMonth.addItemListener(new CalendarFrm_cboMonth_itemAdapter(this));
        this.cboMonth.addItem("一月");
        this.cboMonth.addItem("二月");
        this.cboMonth.addItem("三月");
        this.cboMonth.addItem("四月");
        this.cboMonth.addItem("五月");
        this.cboMonth.addItem("六月");
        this.cboMonth.addItem("七月");
        this.cboMonth.addItem("八月");
        this.cboMonth.addItem("九月");
        this.cboMonth.addItem("十月");
        this.cboMonth.addItem("十一月");
        this.cboMonth.addItem("十二月");
        panShowCal.setBorder(BorderFactory.createEtchedBorder());
        panShowCal.setBounds(new Rectangle(20, 77, 170, 118));
        panShowCal.setLayout(borderLayout1);
        tblCalendar.setBackground(new Color(255, 217, 190));
        tblCalendar.setEnabled(true);
        tblHeader.setBackground(new Color(212, 171, 200));
        txtShowDayTime.setBackground(new Color(190, 220, 255));
        txtShowDayTime.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        txtShowDayTime.setForeground(Color.blue);
        txtShowDayTime.setEditable(false);
        txtShowDayTime.setBounds(new Rectangle(10, 236, 185, 32));
        contentPane.setBackground(new Color(212, 255, 255));
        btnOK.setBackground(new Color(190, 231, 255));
        btnOK.setBounds(new Rectangle(316, 330, 80, 30));
        btnOK.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnOK.setForeground(Color.blue);

        btnOK.setText("");
        btnOK.addActionListener(new CalendarFrm_btnOK_actionAdapter(this));
        lblPicture.setText("");
        lblPicture.setBounds(new Rectangle( -1, 0, 501, 400));
        lblP1.setText("");
        lblP1.setBounds(new Rectangle(2, 5, 202, 271));
        lblP2.setText("");
        lblP2.setBounds(new Rectangle(2, 3, 222, 276));
        lblAp2.setBackground(new Color(212, 208, 236));
        lblAp2.setText("jLabel1");
        lblAp2.setBounds(new Rectangle( -2, 0, 206, 210));
        this.lblTitle.setIcon(new ImageIcon("image\\frame\\Calendar\\title.jpg"));
        this.btnOK.setIcon(new ImageIcon("image\\frame\\Calendar\\exit.jpg"));
        panClock.add(clock);
        clock.add(lblAp2);
        panClock.add(txtShowTime);
        panClock.add(lblP2);
        contentPane.add(panClock);
        contentPane.add(panCalendar);
        panCalendar.add(panShowCal);
        contentPane.add(lblTitle);
        contentPane.add(btnOK);
        contentPane.add(lblPicture);
        panShowCal.add(tblHeader, java.awt.BorderLayout.NORTH);
        panShowCal.add(tblCalendar, java.awt.BorderLayout.CENTER);
        panCalendar.add(txtShowDayTime);
        panCalendar.add(cboMonth);
        panCalendar.add(spinDate);
        panCalendar.add(lblP1);
        this.cboMonth.requestFocus();
        this.lblPicture.setIcon(i1);
        this.lblP1.setIcon(i2);
        this.lblP2.setIcon(i3);

        showTime();
        makeCalendar();


    }

    //显示时钟时间
    public void showTime() {

        ActionListener al = new ActionListener() {
            public void actionPerformed(ActionEvent e) {
                Date date = new Date();
                SimpleDateFormat sdf = new SimpleDateFormat(
                        "HH:mm:ss");
                txtShowTime.setText("                " + sdf.format(date));
            }
        };

        timer = new Timer(1000, al);
        timer.start();

    }

    //制作日历
    public void makeCalendar() {
        Date calendar = new Date();
        SimpleDateFormat sdf = new SimpleDateFormat("yyyyMMdd");
        String dateCalendar = sdf.format(calendar);
        int Day = calendar.getDay();
        //System.out.println(Day);

       // System.out.println(dateCalendar); //测试 当前日起

        String year = dateCalendar.substring(0, 4); //得到现在的年份
        String month = dateCalendar.substring(4, 6); //得到现在的月份
        String date = dateCalendar.substring(6, 8); //得到现在日期
        String xingqi ="";
        switch (Day) {
        case 0: xingqi="日";
            break;
        case 1:xingqi="一";
            break;
        case 2:xingqi="二";
            break;
        case 3:xingqi="三";
            break;
        case 4:xingqi="四";
            break;
        case 5:xingqi="五";
            break;
        case 6:xingqi="六";
            break;