mainframe.java~747~

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

                       pStatement3.close();
                       con.close();
                   } catch (SQLException de) {
                       de.printStackTrace();
                   }
               }
           }
       }else {

           try{
               int t1=0;
               Connection con=DriverManager.getConnection(DATASOURCE);
               Statement s=con.createStatement();
               ResultSet rs=s.executeQuery("Select Id from Card where OnUse=1");
               while(rs.next()){
                   if(kahao.equals(rs.getString(1).trim())){
                       t1=1;
                       dlgMessage.showMessageDialog(this,"该卡号正在使用!","错误",JOptionPane.ERROR_MESSAGE);
                        id.setText("");
                        password.setText("");
                        id.requestFocus(); // 卡号文本框获得焦点(重要)
                   }
               }
               if(t1==0){
                   dlgMessage.showMessageDialog(this,"非法用户名或密码","非法用户",JOptionPane.ERROR_MESSAGE);
                    id.setText("");
                    password.setText("");
                    id.requestFocus();// 卡号文本框获得焦点(重要)
               }
               rs.close();
               s.close();
           }catch(SQLException ce){
               ce.printStackTrace();
           }
       }
    }



    public void kaika_actionPerformed(ActionEvent e) {
        Up.setVisible(false);
        Down.setVisible(false);
        Author.setVisible(false);
        Congzhi.setVisible(false);
        jLabel1.setVisible(false);
        jLabel2.setVisible(false);
        Kaika.setVisible(true);
        Congzhi.setVisible(false);
        Tuika.setVisible(false);
        Selectqian.setVisible(false);
        Changepassword.setVisible(false);
        txtn.setText("");
        txtk.setText("");
        txtp.setText("");
        txtm.setText("");
        txtn.requestFocus();// 卡号文本框获得焦点(重要)
    }


    public void btnn_actionPerformed(ActionEvent e) {
        txtn.setText("");
        txtk.setText("");
        txtp.setText("");
        txtm.setText("");
        txtn.requestFocus();// 卡号文本框获得焦点(重要)
    }


    public void btny_actionPerformed(ActionEvent e) {
        String b3=txtk.getText().trim();
        String b=txtn.getText();
        String b2=txtm.getText();
        String p = "";
        int bz=0;
        char d[] = txtp.getPassword();
        for (int j = 0; j < d.length; j++)
            p = p + d[j];

        if (b=="" || b2=="" ||b3=="" || p==""){
            bz=1;
            dlgMessage.showMessageDialog(this,"您的资料没有全部填完!,请填写完整!","错误",JOptionPane.ERROR_MESSAGE);
        }
        if (bz==0){
            Connection con;
            String url="jdbc:odbc:NetBarDataSource";
            try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            }catch(ClassNotFoundException ce){
                System.out.print(ce);
            }
            int q = 0;
            try {
                con = DriverManager.getConnection(url);
                String sql = "select Id from Card";
                Statement s = con.createStatement();
                ResultSet rs = s.executeQuery(sql);
                while (rs.next()) {
                    if (b3.trim().equals(rs.getString(1).trim())){
                        q = 1;
                        dlgMessage.showMessageDialog(this, "该卡号已经存在，请重新设置卡号!", "错误",
                                                 JOptionPane.ERROR_MESSAGE);
                        txtk.setText("");
                        txtp.setText("");
                        txtm.setText("");
                        txtk.requestFocus();
                        break;
                    }
                }
                String p1=p.trim();
                if (q == 0)
                    try {
                        int menoy = Integer.parseInt(txtm.getText());
                        String n = txtn.getText();
                        PreparedStatement pStatement7 = null;
                        con = DriverManager.getConnection(DATASOURCE);
                        String sql2 =
                                "insert into Card(Id,Password,balance,UserName) values (?,?,?,?)";
                        pStatement7 = con.prepareStatement(sql2);
                        pStatement7.setString(1, b3);
                        pStatement7.setString(2, p1);
                        pStatement7.setInt(3, menoy);
                        pStatement7.setString(4, n);
                        pStatement7.executeUpdate();
                        dlgMessage.showMessageDialog(this, "恭喜您开卡成功", "经验证用户",
                                JOptionPane.INFORMATION_MESSAGE);
                        Up.setVisible(false);
                        Down.setVisible(false);
                        Congzhi.setVisible(false);
                        Kaika.setVisible(false);
                        Congzhi.setVisible(false);
                        Tuika.setVisible(false);
                        Selectqian.setVisible(false);
                        Changepassword.setVisible(false);
                        Author.setVisible(true);
                        jLabel1.setVisible(true);
                        jLabel2.setVisible(true);
                        Author.setVisible(true);
                        pStatement7.close();
                        con.close();

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


    public void chongzhi_actionPerformed(ActionEvent e) {
        jLabel1.setVisible(false);
        jLabel2.setVisible(false);
        Author.setVisible(false);
        Up.setVisible(false);
        Down.setVisible(false);
        Kaika.setVisible(false);
        Congzhi.setVisible(true);
        Tuika.setVisible(false);
        Selectqian.setVisible(false);
        Changepassword.setVisible(false);
        txtmon.setText("0");
        cbokahao.addItem("--请选择需要充值的卡号--");

        try{
            Class.forName(DRIVER_CLASS);
        }catch(ClassNotFoundException ce){
            System.out.print(ce);
        }
        try{
            Connection con=DriverManager.getConnection(DATASOURCE);
            String sql="select Id from Card";
            Statement s=con.createStatement();
            ResultSet rs=s.executeQuery(sql);
            while(rs.next()){
                cbokahao.addItem(rs.getString(1));
            }
            rs.close();
            s.close();
            con.close();
        }catch(SQLException ce){
             ce.printStackTrace();
        }
    }


    public void btnc_actionPerformed(ActionEvent e) {
        cbokahao.setSelectedIndex(0);
        txtmon.setText("");
        lbly.setText("");
    }

    public void btnkk_actionPerformed(ActionEvent e) {
        int p=0;
        int money=Integer.parseInt(txtmon.getText());
        String k=(String)cbokahao.getSelectedItem();

        if(cbokahao.getSelectedIndex()==0){
            p=1;
            dlgMessage.showMessageDialog(this,"请选择需要充值的卡号!","错误",JOptionPane.ERROR_MESSAGE);
        }else if (txtmon.getText().equals("0")) {
                p = 1;
                dlgMessage.showMessageDialog(this, "请输入充值金额!", "错误",JOptionPane.ERROR_MESSAGE);
        }

        if(p==0){
            String url="jdbc:odbc:NetBarDataSource";
            try{
                Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
            }catch(ClassNotFoundException ce){
                System.out.print(ce);
            }
            try {
                PreparedStatement pStatement = null;
                Connection con = DriverManager.getConnection(url);
                String sql = "update Card set balance=balance+? where Id=?";
                pStatement = con.prepareStatement(sql);
                pStatement.setInt(1, money);
                pStatement.setString(2, k);
                pStatement.executeUpdate();

                String sql2 = "select balance from Card where Id=?";
                pStatement = con.prepareStatement(sql2);
                pStatement.setString(1, k);
                ResultSet rs = pStatement.executeQuery();
                while (rs.next()) {
                    lbly.setText(rs.getString(1));
                }
                rs.close();
                pStatement.close();
                con.close();
            } catch (SQLException ce) {
                ce.printStackTrace();
            }
            dlgMessage.showMessageDialog(this, "您已成功充值!", "消息",
                                         JOptionPane.INFORMATION_MESSAGE);
        }
    }

    public void tuika_actionPerformed(ActionEvent e) {
        jLabel1.setVisible(false);
        jLabel2.setVisible(false);
        Author.setVisible(false);
        Up.setVisible(false);
        Down.setVisible(false);
        Kaika.setVisible(false);
        Congzhi.setVisible(false);
        Tuika.setVisible(true);
        Selectqian.setVisible(false);
        Changepassword.setVisible(false);
        ka.addItem("--请选择需要充值的卡号--");
        ka.setSelectedIndex(0);
        menoy1.setText("0");
        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 where OnUse=0";
            Statement s= con.createStatement();
            ResultSet rs = s.executeQuery(sql);
            while (rs.next()) {
                ka.addItem(rs.getString(1));
            }
            rs.close();
            s.close();
            con.close();
        } catch (SQLException et) {
            et.printStackTrace();
        }
    }

    public void but1_actionPerformed(ActionEvent e) {
        int flag=0;
        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;
        PreparedStatement pStatemen = null;
        String k=(String)ka.getSelectedItem();
        if (ka.getSelectedIndex()==0){
            flag=1;
            dlgMessage.showMessageDialog(this,"您还没有选择要退出的卡号，请选择!","错误",JOptionPane.ERROR_MESSAGE);
        }
        if(flag==0){
            try {
                con1 = DriverManager.getConnection(url);
                String sql2 = "select balance from Card where Id=?";
                pStatement = con1.prepareStatement(sql2);
                pStatement.setString(1, k);
                ResultSet rs = pStatement.executeQuery();
                while (rs.next()) {
                    String n = "";
                    n = n + rs.getInt(1);
                    menoy1.setText(n);
                }
                rs.close();
            } catch (SQLException eb) {
                eb.printStackTrace();
            }

            try {
                con1 = DriverManager.getConnection(url);
                String sqlt = "update Card set balance=0 where Id=?";
                pStatemen = con1.prepareStatement(sqlt);
                pStatemen.setString(1, k);
                pStatemen.executeUpdate();

                String sql2 = "select balance from Card where Id=?";
                pStatement = con1.prepareStatement(sql2);
                pStatement.setString(1, k);
                ResultSet rs1 = pStatement.executeQuery();
                while (rs1.next()) {
                    String n1 = "";
                    n1 = n1 + rs1.getInt(1);
                    menoy2.setText(n1);
                }
                rs1.close();
                con1.close();
            } catch (SQLException eb) {
                eb.printStackTrace();
            }
        }
    }

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