managerview.java

管理dvd碟片的软件

              }
              else if(buildRole.equals("waiter")){

                String insert2 = "insert into waiter ("+
                    "waiterName,passWord) values ('"+
                    userName+"','"+userPassword+"')";
                connection.nativeSQL(insert2);
                int result =statement.executeUpdate(insert2);
                if(result==1)
                {
                  JOptionPane.showMessageDialog(null,"新建服务员登陆成功","bulid actor success",JOptionPane.INFORMATION_MESSAGE);
                  jtx3.setText("");
                  jtx4.setText("");
                }
                statement.close();
              }

            }
            else
              JOptionPane.showMessageDialog(null,"若想新建登陆请输入用户名和密码并选择欲建角色","sorry",JOptionPane.INFORMATION_MESSAGE);

          }

          catch ( SQLException sqlex ) {
            sqlex.printStackTrace();
          }


        }

        void jcb2_actionPerformed(ActionEvent e) {

        }

        void jButton6_actionPerformed(ActionEvent e) {
          try {

            Statement statement = connection.createStatement();
            String  userName=  jtx1.getText().trim();
            String  userPassword= jtx2.getText().trim();
          String amendRole= jcb2.getSelectedItem().toString();

          if(!(userName.equals("")||userPassword.equals("")))
          {
            if(amendRole.equals("manager")){
              String amend1="update manager set passWord='"+userPassword+
                  "'where managerName ='"+userName+"'";

              connection.nativeSQL(amend1);
              int result =statement.executeUpdate(amend1);

              if(result==1)
              {
                JOptionPane.showMessageDialog(null,"修改经理登陆成功","amend actor  success",JOptionPane.INFORMATION_MESSAGE);
                jtx3.setText("");
                jtx4.setText("");
              }
              else {JOptionPane.showMessageDialog(null,"请确认欲修改的登陆与角色是否对应或用户名是否正确","sorry",JOptionPane.INFORMATION_MESSAGE);
                jtx1.setText("");
                jtx2.setText("");


              }
              statement.close();
            }

            else   if(amendRole.equals("waiter")){

              String amend2="update waiter set passWord='"+userPassword+
                  "'where waiterName ='"+userName+"'";
              connection.nativeSQL(amend2);
              int result =statement.executeUpdate(amend2);
              if(result==1)
              {
                JOptionPane.showMessageDialog(null,"修改服务员登陆成功","amend actor success",JOptionPane.INFORMATION_MESSAGE);
                jtx3.setText("");
                jtx4.setText("");
              }
              else {JOptionPane.showMessageDialog(null,"请确认欲修改的登陆与角色是否对应或用户名是否正确","sorry",JOptionPane.INFORMATION_MESSAGE);
                jtx1.setText("");
                jtx2.setText("");

                }
                statement.close();
              }

            }
            else
              JOptionPane.showMessageDialog(null,"若想修改登陆请输入用户名和新的密码并选择修改所属的角色","sorry",JOptionPane.INFORMATION_MESSAGE);

          }

          catch ( SQLException sqlex ) {
            System.err.println( "Unable to connect" );
            sqlex.printStackTrace();
          }

        }

        void year_actionPerformed(ActionEvent e) {

        }

        void jButton2_actionPerformed(ActionEvent e) {
          String Year= year.getSelectedItem().toString();
          String Month= month.getSelectedItem().toString();
          String Day= day.getSelectedItem().toString();

          String sum1="select sum( s_money) as 结算销售额,sum( s_profit) as 结算利润 from sell" ;

          if( jrb1.isSelected()){
            String sum2=" where s_date like '%"+Year+"%'";
            String quire1=sum1+sum2;
            DVDFrame movieFrame=new DVDFrame(connection,quire1);
            movieFrame.setSize(450,450);

          }
          else
          if(jrb2.isSelected()){
            String sum2=" where s_date like '%"+Month+"%"+Year+"%'";
            String quire2=sum1+sum2;
            DVDFrame movieFrame=new DVDFrame(connection,quire2);
            movieFrame.setSize(450,450);

          }

          else
          if(jrb3.isSelected()){
            String sum2=" where s_date like '%"+Month+" "+Day+"%"+Year+"%'";
            String quire3=sum1+sum2;
            DVDFrame movieFrame=new DVDFrame(connection,quire3);
            movieFrame.setSize(450,450);
          }

        }

        void jButton7_actionPerformed(ActionEvent e) {
          try {
            Statement statement = connection.createStatement();
            String userName = jtx6.getText().trim();
            String userPassword= jtx7.getText().trim();
            String actor= jcb3.getSelectedItem().toString();
            if(!userName.equals("")&&!userPassword.equals("")){
              if(actor.equals("manager") ){
                String quireDelete="delete manager where managerName='"+
                    userName+"'and PassWord='"+
                    userPassword+"'";
                connection.nativeSQL(quireDelete);
                int result =statement.executeUpdate(quireDelete);

                if(result==1){
                  JOptionPane.showMessageDialog(null,"成功从数据库中删除此登陆","delete DVD information success",JOptionPane.INFORMATION_MESSAGE);
                  jtx6.setText("");
                  jtx7.setText("");
                }
                else{

                  JOptionPane.showMessageDialog(null," 删除登陆失败","sorry",JOptionPane.INFORMATION_MESSAGE);
                  jtx6.setText("");
                  jtx7.setText("");
                }
                statement.close();
              }
              else if(actor.equals("waiter")){
                String quireDelete1="delete waiter where waiterName='"+
                    userName+"'and PassWord='"+
                    userPassword+"'";
                connection.nativeSQL(quireDelete1);
                int result =statement.executeUpdate(quireDelete1);

                if(result==1){
                  JOptionPane.showMessageDialog(null,"成功从数据库中删除此登陆","delete DVD information success",JOptionPane.INFORMATION_MESSAGE);
                  jtx6.setText("");
                  jtx7.setText("");
                }
                else{

                  JOptionPane.showMessageDialog(null," 删除登陆失败,请确认用户名和密码是否正确","sorry",JOptionPane.INFORMATION_MESSAGE);
                  jtx6.setText("");
                  jtx7.setText("");
                }
                statement.close();
              }


            }
            else {
              JOptionPane.showMessageDialog(null,"若要删除登陆请同时输入用户名和密码","attention",JOptionPane.INFORMATION_MESSAGE);

            }

          }
          catch ( SQLException sqlex ) {
            sqlex.printStackTrace();
          }

        }
     }










     class ManagerView_jcb1_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jcb1_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jcb1_actionPerformed(e);
       }
     }

     class ManagerView_jButton1_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton1_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton1_actionPerformed(e);
       }
     }

     class ManagerView_jButton3_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton3_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton3_actionPerformed(e);
       }
     }

     class ManagerView_jButton5_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton5_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton5_actionPerformed(e);
       }
     }

     class ManagerView_jButton4_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton4_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton4_actionPerformed(e);
       }
     }

     class ManagerView_jcb2_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jcb2_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jcb2_actionPerformed(e);
       }
     }

     class ManagerView_jButton6_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton6_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton6_actionPerformed(e);
       }
     }

     class ManagerView_year_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_year_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.year_actionPerformed(e);
       }
     }

     class ManagerView_jButton2_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton2_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton2_actionPerformed(e);
       }
     }

     class ManagerView_jButton7_actionAdapter implements java.awt.event.ActionListener {
       ManagerView adaptee;

       ManagerView_jButton7_actionAdapter(ManagerView adaptee) {
         this.adaptee = adaptee;
       }
       public void actionPerformed(ActionEvent e) {
         adaptee.jButton7_actionPerformed(e);
       }
     }