exit.java

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

package 网吧计费系统;

import java.awt.*;
import java.awt.event.WindowEvent;
import javax.swing.JLabel;
import javax.swing.JButton;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.DriverManager;
import java.sql.Connection;
import java.sql.*;


public class Exit extends Dialog {
    Panel panel1 = new Panel();
    JLabel lblinfor = new JLabel();
    JButton btnt = new JButton();
    JButton btnq = new JButton();
    JLabel lblf = new JLabel();

    private static final String DRIVER_CLASS="sun.jdbc.odbc.JdbcOdbcDriver";
    private static final String DATASOURCE="jdbc:odbc:NetBarDataSource";

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

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

    private void jbInit() throws Exception {
        panel1.setLayout(null);
        lblinfor.setFont(new java.awt.Font("Dialog", Font.BOLD, 20));
        lblinfor.setText("现在仍然有机子正在使用");
        lblinfor.setBounds(new Rectangle(36, 20, 241, 40));
        btnt.setBounds(new Rectangle(40, 117, 77, 35));
        btnt.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnt.setText("退出");
        btnt.addActionListener(new Information_btnt_actionAdapter(this));
        btnq.setBounds(new Rectangle(174, 117, 77, 35));
        btnq.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnq.setText("取消");
        btnq.addActionListener(new Information_btnq_actionAdapter(this));
        lblf.setFont(new java.awt.Font("Dialog", Font.BOLD, 20));
        lblf.setText("您想退出吗?");
        lblf.setBounds(new Rectangle(94, 66, 125, 40));
        add(panel1);
        panel1.add(lblinfor);
        panel1.add(lblf);
        panel1.add(btnt);
        panel1.add(btnq);
    }

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

    /**退出的确定*/
    public void btnt_actionPerformed(ActionEvent e) {
        Connection con = null;
        PreparedStatement pStatement1=null;
        PreparedStatement pStatement2=null;
        /**将数据库中所有的在用卡号改为未用*/
        try{
            con=DriverManager.getConnection(DATASOURCE);//获取连接
            String sql1="update Card set OnUse=0 where OnUse=1";
            pStatement1=con.prepareStatement(sql1);
            pStatement1.executeUpdate();
            pStatement1.close();
           pStatement1.close();
           con.close();
          }catch (SQLException ce) {
              System.out.println(ce);
          }
          /**将数据库中所有的在用机器号改为未用*/
          try{
            con=DriverManager.getConnection(DATASOURCE);//获取连接
            String sql2="update Computer set OnUse=0 where OnUse=1";
            pStatement2=con.prepareStatement(sql2);
            pStatement2.executeUpdate();
            pStatement2.close();
            con.close();
          }catch (SQLException ce) {
              System.out.println(ce);
          }
          System.exit(0);
    }

    /**退出的取消*/
    public void btnq_actionPerformed(ActionEvent e) {
        this.dispose();
    }
}


class Information_btnq_actionAdapter implements ActionListener {
    private Exit adaptee;
    Information_btnq_actionAdapter(Exit adaptee) {
        this.adaptee = adaptee;
    }

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


class Information_btnt_actionAdapter implements ActionListener {
    private Exit adaptee;
    Information_btnt_actionAdapter(Exit adaptee) {
        this.adaptee = adaptee;
    }

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