shopmis.java~359~

百货商场信息管理系统

  }

  void jButton3_actionPerformed(ActionEvent e) {
    int l=0;//订单是否可用标志
    int NO=Integer.parseInt(jTextField13.getText());//订单号
    String cNO=jTextField18.getText();//客户号
    String gNO="";//货物编号
    int gNumber=0;//货物数量
    int gPrice=0;//货物单价
    int left=0;//剩余数量
    boolean exsit=false;
    try{
      int  s1=0;
      String s2="";
      //int s3=0;
      String sql="select * from 订单 ";
      st=con.createStatement();
      ResultSet result=st.executeQuery(sql);
      while(result.next())
      {
        s1=result.getInt("订单号");
        l=result.getInt("订单是否可用标志");
        s2=result.getString("客户号").trim();
        gNO=result.getString("货物编号").trim();
        gNumber=result.getInt("货物数量");
        //System.out.println(s1+"  "+l+"  "+s2+" "+gNO+" "+gNumber);
        if(NO==s1&&s2.equals(cNO))
        {
          exsit=true;
          break;
        }
        //jTextArea1.append(gNO+"\t"+gName+"\t\n");

     }
     st.close();
////////////////订单及客户号存在
     if(exsit)
     {
       if(l==1)//订单可满足
       {

         try{
           boolean ex=false;
           String s="";
           sql="select * from 货物库存 ";
           st=con.createStatement();
           result=st.executeQuery(sql);
         while(result.next())
         {
           s=result.getString("货物编号").trim();
           gPrice=result.getInt("单价");
           left=result.getInt("剩余数量");
           if(s.equals(gNO))
           {
             ex=true;
             break;
           }
         }
         //st.close();
        }catch(SQLException e1)
        {
          JOptionPane.showMessageDialog(null,"数据库连接失败");
        }
        st.close();
///////记录已处理订单
        try{
          int t=gPrice*gNumber;
          sql="insert into 已供订单 values("+NO+",'"+cNO+"','"+gNO+"',"+gNumber+","+t+")";
          st=con.createStatement();
          st.executeUpdate(sql);

        }catch(SQLException e1)
        {
          JOptionPane.showMessageDialog(null,"数据库连接失败");
        }
        st.close();
//////删除已处理订单
        try{
          sql="delete  from 订单 where 订单号="+NO;
          st=con.createStatement();
          st.executeUpdate(sql);
          st.close();
        }catch(SQLException e1)
        {
          JOptionPane.showMessageDialog(null,"数据库连接失败");
        }

        /////更新货物库存信息
         try{
           left=left-gNumber;//货物剩余数量
           sql="update 货物库存 set 剩余数量='"+left+"' where 货物编号='"+gNO+"'";
           st=con.createStatement();
           st.executeUpdate(sql);
           st.close();
         }catch(SQLException e1)
         {
           JOptionPane.showMessageDialog(null,"数据库连接失败");
         }
         JOptionPane.showMessageDialog(null,"订单货物已提取！");
       }
       else//订单无法满足
       {
         JOptionPane.showMessageDialog(null,"货物库存不足!");
       }
       //JOptionPane.showMessageDialog(null,"数据库连接失败");
     }
     else
     {
       JOptionPane.showMessageDialog(null,"该订单不存在! ");
     }
     st.close();
   }catch(SQLException e1)
   {
     JOptionPane.showMessageDialog(null,"数据库连接失败");
   }


  }

  void jButton4_actionPerformed(ActionEvent e) {
    jTextField3.setText("");
    jTextField6.setText("");
    jTextField8.setText("");

  }

  void jMenuItem6_actionPerformed(ActionEvent e) {
    cardLayout1.show(this.getContentPane(),"jPanel2");
    cardLayout2.show(jPanel2,"jPanel7");

  }

  void jButton7_actionPerformed(ActionEvent e) {
    String gName="";
    String gNO="";
    try{
      //String s="";
      String sql="select * from 货物库存 ";
      st=con.createStatement();
      ResultSet result=st.executeQuery(sql);
      jTextArea1.setText("货物编号\t货物名称\t\n");
      while(result.next())
      {
        gNO=result.getString("货物编号").trim();
        gName=result.getString("货物名称").trim();
        jTextArea1.append(gNO+"\t"+gName+"\t\n");

     }
      st.close();
   }catch(SQLException e1)
   {
     JOptionPane.showMessageDialog(null,"数据库连接失败");
   }


  }

  void jButton6_actionPerformed(ActionEvent e) {
    jTextField13.setText("");
    jTextField18.setText("");

  }

  void jButton8_actionPerformed(ActionEvent e) {
    int count=0;
    int l=0;//订单是否可用标志
    int NO=Integer.parseInt(jTextField13.getText());//订单号
    //String cNO=jTextField18.getText();//客户号
    String gNO="";//货物编号
    String gName="";//货物名称
    int gNumber=0;//货物数量
    int left=0;//剩余数量

    String sql1="";
    Statement st1;
    ResultSet result1;
    //Connection con1;

    jTextArea2.setText("货物编号\t货物名称\t库存数量\t需要货物数量\n");

    try{
       sql1="select * from 货物库存 ";
       st1=con1.createStatement();
       result1=st1.executeQuery(sql1);
       while(result1.next())
       {
         gNO=result1.getString("货物编号").trim();
         gName=result1.getString("货物名称");
         left=result1.getInt("剩余数量");

         try{
           String s1="";
           int  s2=0;//所有订单中货物编号为gNO的货物的数量
           String sql="select * from 订单 ";
           st=con.createStatement();
           ResultSet result=st.executeQuery(sql);
           while(result.next())
           {
             //l=result.getInt("订单是否可用标志");
             s1=result.getString("货物编号").trim();
             gNumber=result.getInt("货物数量");
             if(s1.equals(gNO))
             {
               s2=s2+gNumber;
             }
           }
           if(s2!=0)
           {
             jTextArea2.append(gNO+"\t"+gName+"\t"+left+"\t"+s2+"\n");
           }

           st.close();
         }catch(SQLException e1)
         {
           JOptionPane.showMessageDialog(null,"数据库连接失败");
         }

       }
       st1.close();
     }catch(SQLException e2)
     {
       JOptionPane.showMessageDialog(null,"数据库连接失败");
     }

/*
    try{
      int  s1=0;
      String s2="";
      //int s3=0;
      String sql="select * from 订单 ";
      st=con.createStatement();
      ResultSet result=st.executeQuery(sql);
      while(result.next())
      {
        l=result.getInt("订单是否可用标志");
        gNO=result.getString("货物编号").trim();
        gNumber=result.getInt("货物数量");
        if(l==0)
        {
          count++;
        }
      }
      st.close();
    }catch(SQLException e1)
    {
      JOptionPane.showMessageDialog(null,"数据库连接失败");
    }
    ///////库存充足
    if(count==0)
    {
      JOptionPane.showMessageDialog(null,"所有货物库存充足！");
    }
    //////库存不足
    if(count!=0)
    {
      int n=0;
      String[] ss=new String[count];
      int[] a=new int[count];
      try{
        int  s1=0;
        String s2="";
        //int s3=0;
        String sql="select * from 订单 ";
        st=con.createStatement();
        ResultSet result=st.executeQuery(sql);
        while(result.next())
        {
          l=result.getInt("订单是否可用标志");
          gNO=result.getString("货物编号").trim();
          gNumber=result.getInt("货物数量");
          if(l==0)
          {
            ss[n]=gNO;
            a[n]=gNumber;
            n++;
            //count++;
            /*
           try{
              sql1="select * from 货物库存 where 货物编号='"+gNO+"'";
              st1=con1.createStatement();
              result1=st1.executeQuery(sql1);
              while(result1.next())
              {
                gName=result1.getString("货物名称");
                left=result1.getInt("剩余数量");
                System.out.println(gName);
                //jTextArea2.append(gNO+"\t"+gName+"\t"+left+"\t"+gNumber+"\n");
              }
              st1.close();
            }catch(SQLException e2)
            {
              //JOptionPane.showMessageDialog(null,"数据库连接失败");
            }
            jTextArea2.append(gNO+"\t"+gName+"\t"+left+"\t"+gNumber+"\n");
          }
        }
        st.close();
        //将ss数组中的重复元组删除
        for(int i=0;i<count;i++)
        {
          for(int j=i+1;j<count;j++)
          {
            if(ss[i].equals(ss[j]))
            {
              if(ss[i].equals(""))
              {
              }
              else
              {
                ss[j]="";
                a[i]=a[i]+a[j];
              }
              //a[j]=-1;
            }
          }

        }
        /////
        try{
          //int s1 = 0;
          //String s2 = "";
          //int s3=0;
          sql = "select * from 订单 ";
          st = con.createStatement();
          result = st.executeQuery(sql);
          while (result.next()) {
            //l = result.getInt("订单是否可用标志");
            gNO = result.getString("货物编号").trim();
            gNumber = result.getInt("货物数量");
          }
        }catch(SQLException e2){}

      }catch(SQLException e1)
      {
        JOptionPane.showMessageDialog(null,"数据库连接失败");
      }

    }*/
}

class ShopMIS_jButton2_actionAdapter implements java.awt.event.ActionListener {
  ShopMIS adaptee;

  ShopMIS_jButton2_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton2_actionPerformed(e);
  }
}

class ShopMIS_jButton1_actionAdapter implements java.awt.event.ActionListener {
  ShopMIS adaptee;

  ShopMIS_jButton1_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton1_actionPerformed(e);
  }
}

class ShopMIS_jMenuItem1_actionAdapter implements java.awt.event.ActionListener {
  ShopMIS adaptee;

  ShopMIS_jMenuItem1_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem1_actionPerformed(e);
  }
}

class ShopMIS_jMenuItem2_actionAdapter implements java.awt.event.ActionListener {
  ShopMIS adaptee;

  ShopMIS_jMenuItem2_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }