mainframe.java~747~

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

    public void select_actionPerformed(ActionEvent e) {
        Up.setVisible(false);
        jLabel1.setVisible(false);
        jLabel2.setVisible(false);
        Author.setVisible(false);
        Down.setVisible(false);
        Kaika.setVisible(false);
        Congzhi.setVisible(false);
        Tuika.setVisible(false);
        Selectqian.setVisible(true);
        Changepassword.setVisible(false);
        idtxt.addItem("--请选择需要充值的卡号--");
        String url="jdbc:odbc:NetBarDataSource";
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(ClassNotFoundException ce){
            System.out.print(ce);
        }
        try {
            Connection con=DriverManager.getConnection(url);
            String sql = "select Id from Card";
            Statement s= con.createStatement();
            ResultSet rs = s.executeQuery(sql);
            while (rs.next()) {
                idtxt.addItem(rs.getString(1));
            }
            rs.close();
            s.close();
            con.close();
        } catch (SQLException et) {
            et.printStackTrace();
        }

    }

    public void butt1_actionPerformed(ActionEvent e) {
        String v1="";
        int p=0,q=0;
        String a=(String)idtxt.getSelectedItem();
        char d[]= txtpass.getPassword();
        for(int j=0;j<d.length;j++)
            v1=v1+d[j];
        try{
           Connection con=DriverManager.getConnection(DATASOURCE);
           Statement s=con.createStatement();
           ResultSet rs=s.executeQuery("Select Id,Password from Card where OnUse=0");
           while(rs.next()){
               if(a.trim().equals(rs.getString(1).trim())){
                   p=1;
                   if (v1.trim().equals(rs.getString(2).trim())){
                       q=1;
                   }
               }
           }
           if (p==1 && q==1){
               String url="jdbc:odbc:NetBarDataSource";
               try{
                   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
               }catch(ClassNotFoundException ce){
                   System.out.print(ce);
               }
               Connection con1=null;
               PreparedStatement pStatement = null;
               try{
                   con1=DriverManager.getConnection(url);
                   String sql2 = "select balance from Card where Id=?";
                   pStatement = con1.prepareStatement(sql2);
                   pStatement.setString(1,a);
                   ResultSet r = pStatement.executeQuery();
                   while (r.next()) {
                       String n1="";
                       n1=n1+r.getInt(1);
                       txtyu.setText(n1);
                   }
                   rs.close();
               }catch (SQLException eb) {
                   eb.printStackTrace();
               }
               idtxt.removeAllItems();
               txtpass.setText("");

           }else{
               dlgMessage.showMessageDialog(this,"卡号与密码不一致！请重新输入密码！","错误",JOptionPane.ERROR_MESSAGE);
               txtpass.setText("");
               txtpass.requestFocus();
           }


           con.close();
       }catch(SQLException ce){
           System.out.println(ce);
       }

    }

    public void butt2_actionPerformed(ActionEvent e) {
        this.dispose();
    }

    public void gai_actionPerformed(ActionEvent e) {
        dlgMessage.setVisible(false);
        Up.setVisible(false);
        Down.setVisible(false);
        Kaika.setVisible(false);
        Congzhi.setVisible(false);
        Tuika.setVisible(false);
        Selectqian.setVisible(false);
        Changepassword.setVisible(true);
        jLabel1.setVisible(false);
        jLabel2.setVisible(false);
        Author.setVisible(false);
        ka8.addItem("--请选择需要充值的卡号--");
        String url="jdbc:odbc:NetBarDataSource";
        try{
            Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        }catch(ClassNotFoundException ce){
            System.out.print(ce);
        }
        try {
            Connection con=DriverManager.getConnection(url);
            String sql = "select Id from Card";
            Statement s= con.createStatement();
            ResultSet rs = s.executeQuery(sql);
            while (rs.next()) {
                ka8.addItem(rs.getString(1));
            }
            rs.close();
            s.close();
            con.close();
        } catch (SQLException et) {
            et.printStackTrace();
        }

    }

    public void bu8_actionPerformed(ActionEvent e) {
        String k=(String)ka8.getSelectedItem();
        int p=0,q=0;
        String v="";
        char d[]= pass8.getPassword();
        for(int j=0;j<d.length;j++)
            v=v+d[j];
        try{
           Connection con=DriverManager.getConnection(DATASOURCE);
           Statement s=con.createStatement();
           ResultSet rs=s.executeQuery("Select Id,Password from Card where OnUse=0");
           while(rs.next()){
               if(k.trim().equals(rs.getString(1).trim())){
                   p=1;
                   if (v.trim().equals(rs.getString(2).trim())){
                       q=1;
                   }
               }
           }
           if (p==1 && q==1){
               char a[]= pass9.getPassword();
               String b="";
               for (int i=0;i<a.length;i++){
                   b=b+a[i];
               }
               String url="jdbc:odbc:NetBarDataSource";
               try{
                   Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
               }catch(ClassNotFoundException ce){
                   System.out.print(ce);
               }

               try{
                   Connection con1=null;
                   PreparedStatement pStatement = null;
                   con1=DriverManager.getConnection(url);
                   String s0 = "update Card set Password=? where Id=?";
                   pStatement = con1.prepareStatement(s0);
                   pStatement.setString(1,b);
                   pStatement.setString(2,k);
                   pStatement.executeUpdate();
               }catch (SQLException eb) {
                   eb.printStackTrace();
               }
               dlgMessage.showMessageDialog(this,"恭喜您更改密码成功！","",JOptionPane.INFORMATION_MESSAGE);
           }else{
               dlgMessage.showMessageDialog(this,"卡号与密码不一致！请重新输入！","错误",JOptionPane.ERROR_MESSAGE);
               ka8.setSelectedIndex(0);
               pass8.setText("");
               pass9.setText("");
               ka8.requestFocus();

           }
           rs.close();
           s.close();
           con.close();
       }catch(SQLException ce){
           System.out.println(ce);
       }

    }

    public void bu9_actionPerformed(ActionEvent e) {
        this.dispose();
    }


    class MainFrame_tuichu_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_tuichu_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_guanyu_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_guanyu_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_bu9_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_bu9_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_gai_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_gai_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_bu8_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_bu8_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_butt2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_butt2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_butt1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_butt1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_select_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_select_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_but2_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_but2_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_but1_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_but1_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class MainFrame_tuika_actionAdapter implements ActionListener {
    private MainFrame adaptee;
    MainFrame_tuika_actionAdapter(MainFrame adaptee) {
        this.adaptee = adaptee;
    }

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


class