dvdmanage.java

管理dvd碟片的软件

         String  type= jtx9.getText().trim();
         String  number= jtx10.getText().trim();

         if(!(dvdid.equals("")||level.equals("")||type.equals("")||DVDcn.equals("")||pprice.equals("")||sprice.equals("")||number.equals("")))
         {
           String s1= "insert into DVD (" +
               "DVD_no,r_level," +
               "DVD_cn,p_price,s_price," +
               "type,remains";

           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);
     }
   }