dvdmanage.java~181~

管理dvd碟片的软件

          String s2="values ('"+dvdid + "', '" +
          Integer.parseInt(level) + "', '" +
          DVDcn + "', '" +
          Integer.parseInt(pprice) + "', '" +
          Integer.parseInt(sprice) + "', '" +
          type + "',  '" +
          Integer.parseInt(number);

      if(!directorid.equals("")){
        s1+=",d_id";
        s2+="', '"+directorid;
      }
      if(!mdate.equals("")){
        s1+=",m_date";
        s2+="','"+mdate;
      }
      if(!DVDen.equals("")){
        s1+=",DVD_en";
        s2+="','"+DVDen;
      }
      s1+=")";
      s2+="')";

      String quire1=s1+s2;



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

     if(result==1)
     {JOptionPane.showMessageDialog(null,"录入成功","enter DVD success",JOptionPane.INFORMATION_MESSAGE);
     jtx1.setText("");
     jtx2.setText("");
     jtx3.setText("");
     jtx4.setText("");
     jtx5.setText("");
     jtx6.setText("");
     jtx7.setText("");
     jtx8.setText("");
     jtx9.setText("");
     jtx10.setText("");
  }
   statement.close();
}
   else
     JOptionPane.showMessageDialog(null,"请输入提示为必要的录入信息","sorry",JOptionPane.INFORMATION_MESSAGE);

 }

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


 }

  void jButton2_actionPerformed(ActionEvent e) {
    try {
      Statement statement = connection.createStatement();
      String dvdid = jtx1.getText().trim();
      String directorid = jtx2.getText().trim();
      String level = jtx3.getText().trim();
      String mdate = jtx4.getText().trim();
      String DVDcn = jtx5.getText().trim();
      String DVDen = jtx6.getText().trim();
      String pprice = jtx7.getText().trim();
      String sprice = jtx8.getText().trim();
      String typeList = jtx9.getText().trim();
      String number = jtx10.getText().trim();

      int result1=0,result2=0,result3=0,result4=0,result5=0,
          result6=0,result7=0,result8=0,result9=0,result10=0;
      if(!dvdid.equals("")){
        if (!directorid.equals("")) {
          String s1 = "update DVD set ";
          String s2 = "where DVD_no='" + dvdid + "'";

          s1 += "d_id='" + directorid + "'";
          String quire2 = s1 + s2;

          connection.nativeSQL(quire2);
          result1 = statement.executeUpdate(quire2);
          System.out.println(result1);
        }

        if (!level.equals("")) {
        String s1 = "update DVD set ";
        String s2 = "where DVD_no='" + dvdid + "'";

        s1 += "r_level='" + level + "'";
        String quire3 = s1 + s2;

        connection.nativeSQL(quire3);
        result2 = statement.executeUpdate(quire3);
      }

      if (!mdate.equals("")) {
        String s1 = "update DVD set ";
        String s2 = "where DVD_no='" + dvdid + "'";

        s1 += "m_date='" + mdate + "'";
        String quire4 = s1 + s2;

        connection.nativeSQL(quire4);
        result3= statement.executeUpdate(quire4);
      }

      if (!DVDcn.equals("")) {
        String s1 = "update DVD set ";
        String s2 = "where DVD_no='" + dvdid + "'";

        s1 += "DVD_cn='" + DVDcn + "'";
        String quire5 = s1 + s2;

        connection.nativeSQL(quire5);
        result4 = statement.executeUpdate(quire5);
      }

      if (!DVDen.equals("")) {
        String s1 = "update DVD set ";
        String s2 = "where DVD_no='" + dvdid + "'";

        s1 += "DVD_en='" + DVDen + "'";
        String quire6 = s1 + s2;

        connection.nativeSQL(quire6);
        result5 = statement.executeUpdate(quire6);
      }
      if (!pprice.equals("")) {
        String s1 = "update DVD set ";
        String s2 = "where DVD_no='" + dvdid + "'";

        s1 += "p_price='" + pprice + "'";
        String quire7 = s1 + s2;

        connection.nativeSQL(quire7);
        result6 = statement.executeUpdate(quire7);
       }

       if (!sprice.equals("")) {
         String s1 = "update DVD set ";
         String s2 = "where DVD_no='" + dvdid + "'";

         s1 += "s_price='" +sprice  + "'";
         String quire8 = s1 + s2;

         connection.nativeSQL(quire8);
         result7 = statement.executeUpdate(quire8);
       }

       if (!typeList.equals("")) {
         String s1 = "update DVD set ";
         String s2 = "where DVD_no='" + dvdid + "'";

         s1 += "type='" + typeList + "'";
         String quire9 = s1 + s2;

         connection.nativeSQL(quire9);
         result8 = statement.executeUpdate(quire9);
       }

       if (!number.equals("")) {
         String s1 = "update DVD set ";
         String s2 = "where DVD_no='" + dvdid + "'";

         s1 += "remains='" + number + "'";
         String quire10 = s1 + s2;

         connection.nativeSQL(quire10);
         result9= statement.executeUpdate(quire10);
       }

       if((result1==1)||(result2==1)||(result3==1)||(result4==1)||(result5==1)||(result6==1)||(result7==1)||(result8==1)||(result9==1)){

         JOptionPane.showMessageDialog(null,"更新成功","amend DVD information success",JOptionPane.INFORMATION_MESSAGE);
         jtx1.setText("");
         jtx2.setText("");
         jtx3.setText("");
         jtx4.setText("");
         jtx5.setText("");
         jtx6.setText("");
         jtx7.setText("");
         jtx8.setText("");
         jtx9.setText("");
         jtx10.setText("");
       }
       else JOptionPane.showMessageDialog(null,"请确认输入的DVDid号及修改信息是否正确   ","sorry",JOptionPane.INFORMATION_MESSAGE);
          statement.close();

    }

    else
       JOptionPane.showMessageDialog(null,"若要修改DVD信息请输入dvdID及欲修改的相关信息","sorry",JOptionPane.INFORMATION_MESSAGE);
    }
    catch ( SQLException sqlex )
    {

      sqlex.printStackTrace();
    }

 }

 void jButton3_actionPerformed(ActionEvent e) {
   try {
     Statement statement = connection.createStatement();
     String dvdid = jtx1.getText().trim();
     String DVDcn = jtx5.getText().trim();

     if(!dvdid.equals("")&&!DVDcn.equals("")){
       String quireDelete="delete DVD where DVD_no='"+
           dvdid+"'and DVD_cn='"+
           DVDcn+"'";
       connection.nativeSQL(quireDelete);
       int result =statement.executeUpdate(quireDelete);

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

         JOptionPane.showMessageDialog(null,"数据库中不存在dvdID号为"+dvdid+"影片名为"+DVDcn+"的碟片,请确认dvdID号与影片名是否匹配,然后重新输入","sorry",JOptionPane.INFORMATION_MESSAGE);

       }
       statement.close();
     }
     else {
       JOptionPane.showMessageDialog(null,"若要删除DVD请同时输入dvdID和影片中文名","sorry",JOptionPane.INFORMATION_MESSAGE);

     }

   }

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




class DVDManage_jtx1_actionAdapter implements java.awt.event.ActionListener {
  DVDManage adaptee;

  DVDManage_jtx1_actionAdapter(DVDManage adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jtx1_actionPerformed(e);
  }
}

class DVDManage_jButton1_actionAdapter implements java.awt.event.ActionListener {
  DVDManage adaptee;

  DVDManage_jButton1_actionAdapter(DVDManage adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class DVDManage_jButton2_actionAdapter implements java.awt.event.ActionListener {
  DVDManage adaptee;

  DVDManage_jButton2_actionAdapter(DVDManage adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class DVDManage_jButton3_actionAdapter implements java.awt.event.ActionListener {
  DVDManage adaptee;

  DVDManage_jButton3_actionAdapter(DVDManage adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
   this.adaptee.jButton3_actionPerformed(e);
  }
}