xiaji.java~89~

用java实现的一个网吧计费系统,大家可以参考下

package 网吧计费系统;

import java.awt.*;
import java.awt.event.*;
import javax.swing.JLabel;
import javax.swing.JComboBox;
import javax.swing.JTextField;
import javax.swing.JButton;
import java.util.Calendar;
import java.sql.*;
import javax.swing.JOptionPane;


public class xiaji extends Dialog {
    Panel panel1 = new Panel();
    JLabel jiqihao = new JLabel();
    JLabel jieshushijian = new JLabel();
    JComboBox cbojiqihao = new JComboBox();
    JTextField timeend = new JTextField();
    JButton btnok = new JButton();
    JButton btncz = new JButton();
    String endtime;
    String cbo;
    JOptionPane dlgD = new JOptionPane();

    public xiaji(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            enableEvents(AWTEvent.WINDOW_EVENT_MASK);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public xiaji() {
        this(new Frame(), "xiaji", false);
    }

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        jiqihao.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
        jiqihao.setText("机  器  号：");
        jiqihao.setBounds(new Rectangle(39, 37, 100, 32));
        jieshushijian.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
        jieshushijian.setText("结束时间：");
        jieshushijian.setBounds(new Rectangle(39, 106, 99, 34));
        cbojiqihao.setBounds(new Rectangle(145, 42, 155, 27));
        timeend.setEnabled(false);
        timeend.setBounds(new Rectangle(145, 104, 155, 35));
        btnok.setBounds(new Rectangle(72, 172, 73, 31));
        btnok.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
        btnok.setText("确定");
        btnok.addActionListener(new xiaji_btnok_actionAdapter(this));
        btncz.setBounds(new Rectangle(197, 172, 73, 31));
        btncz.setFont(new java.awt.Font("Dialog", Font.PLAIN, 18));
        btncz.setText("重置");
        btncz.addActionListener(new xiaji_btncz_actionAdapter(this));
        add(panel1);
        panel1.add(jiqihao);
        panel1.add(jieshushijian);
        panel1.add(cbojiqihao);
        panel1.add(btnok);
        panel1.add(timeend);
        panel1.add(btncz);
        this.add(dlgD, java.awt.BorderLayout.NORTH);
        dlgD.setVisible(false);

        /*
         * 将正在使用的机子放入下拉列表
         */

        try{
                String url="jdbc:odbc:NetBarDateSource";
                String str="select Id from Computer where OnUse='1'";
                Connection con=DriverManager.getConnection(url);
                Statement s=con.createStatement();
                ResultSet rs=s.executeQuery(str);
                while(rs.next()){
                    cbojiqihao.addItem(rs.getString(1));
                }
                rs.close();
                s.close();
                con.close();
            }catch(SQLException ce){
                System.out.print(ce);
            }

        Calendar objCalendar=Calendar.getInstance();
        int year=objCalendar.get(Calendar.YEAR);
        int month=objCalendar.get(Calendar.MONTH);
        int day=objCalendar.get(Calendar.DATE);
        int hour=objCalendar.get(Calendar.HOUR);
        int min=objCalendar.get(Calendar.MINUTE);

        /**显示下机时间*/
        if(month<9 && min<10){
            endtime=year+"-"+0+(month+1)+"-"+day+"    "+hour+":"+0+min;
            timeend.setText(endtime);
        }else if(month<9 && min>=10) {
            endtime=year+"-"+0+(month+1)+"-"+day+"    "+hour+":"+min;
            timeend.setText(endtime);
        } else if (month>=9 && min < 10) {
            endtime=year+"-"+(month+1)+"-"+day+"    "+hour+":"+0+min;
            timeend.setText(endtime);
        }else
        {
            endtime=year+"-"+(month+1)+"-"+day+"    "+hour+":"+min;
            timeend.setText(endtime);
        }
    }

    protected void processWindowEvent(WindowEvent windowEvent) {
        if (windowEvent.getID() == WindowEvent.WINDOW_CLOSING) {
            dispose();
        }
        super.processWindowEvent(windowEvent);
    }

    public void btnok_actionPerformed(ActionEvent e) {
        if(cbojiqihao.getSelectedItem()==null){
            dlgD.showMessageDialog(this,"没有正在使用的机子","错误",JOptionPane.ERROR_MESSAGE);
            System.exit(0);
        }else {
            cbo=(String)cbojiqihao.getSelectedItem();
            this.dispose();
            /**将下机时间放入数据库*/
            try{
                PreparedStatement pStatement1 = null;
                PreparedStatement pStatement2 = null;
                Record record=new Record();
                String url="jdbc:odbc:NetBarDateSource";
                Connection con=DriverManager.getConnection(url);
                /**查找Record表中最大的Id*/
                String str2="select max(Id) from Record where ComputerId=?";
                pStatement2=con.prepareStatement(str2);
                pStatement2.setString(1,cbo);
                ResultSet rs=pStatement2.executeQuery();
                while(rs.next()){
                    record.setNewId(rs.getInt(1));
                }
                rs.close();
                /**更新数据库中当前下机时间*/
                String str1="update Record set EndTime=? where Id=?";
                pStatement1=con.prepareStatement(str1);
                pStatement1.setString(1,endtime);
                pStatement1.setInt(2,record.getNewId());
                pStatement1.executeUpdate();

                pStatement2.close();
                pStatement1.close();
                con.close();
            }catch (SQLException ee) {
                ee.printStackTrace();
            }
        }
    }

    public void btncz_actionPerformed(ActionEvent e) {
        cbojiqihao.setSelectedIndex(0);
    }
}


class xiaji_btncz_actionAdapter implements ActionListener {
    private xiaji adaptee;
    xiaji_btncz_actionAdapter(xiaji adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btncz_actionPerformed(e);
    }
}


class xiaji_btnok_actionAdapter implements ActionListener {
    private xiaji adaptee;
    xiaji_btnok_actionAdapter(xiaji adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnok_actionPerformed(e);
    }
}