down.java

用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 Down 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 Down(Frame owner, String title, boolean modal) {
        super(owner, title, modal);
        try {
            enableEvents(AWTEvent.WINDOW_EVENT_MASK);
            jbInit();
            pack();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    public Down() {
        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);
        cbojiqihao.addItem("请选择要下机的卡号!");

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

        try{
                String url="jdbc:odbc:NetBarDataSource";
                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.getSelectedIndex() >0){
            cbo=(String)cbojiqihao.getSelectedItem();
            this.dispose();
            /**将下机时间放入数据库*/
            try{
                PreparedStatement pStatement1 = null;
                PreparedStatement pStatement2 = null;
                Record record=new Record();
                String url="jdbc:odbc:NetBarDataSource";
                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();
            }
        }else{
            dlgD.showMessageDialog(this,"没有正在使用的机子","错误",JOptionPane.ERROR_MESSAGE);
            this.dispose();
        }

    }

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


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

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


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

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