managerview.java~144~

管理dvd碟片的软件

             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;
      System.out.println(quire3);
      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);
  }
}