shopmis.java~362~

百货商场信息管理系统

  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem2_actionPerformed(e);
  }
}

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

  ShopMIS_jMenuItem3_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem3_actionPerformed(e);
  }
}

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

  ShopMIS_jMenu2_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenu2_actionPerformed(e);
  }
}

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

  ShopMIS_jMenu3_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenu3_actionPerformed(e);
  }
}

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

  ShopMIS_jMenu4_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenu4_actionPerformed(e);
  }
}

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

  ShopMIS_jMenuItem4_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem4_actionPerformed(e);
  }
}

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

  ShopMIS_jButton3_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton3_actionPerformed(e);
  }
}

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

  ShopMIS_jButton4_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton4_actionPerformed(e);
  }
}

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

  ShopMIS_jMenuItem6_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jMenuItem6_actionPerformed(e);
  }
}

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

  ShopMIS_jButton7_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton7_actionPerformed(e);
  }
}

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

  ShopMIS_jButton6_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton6_actionPerformed(e);
  }
}

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

  ShopMIS_jButton5_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
   // adaptee.jButton5_actionPerformed(e);
  }
}

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

  ShopMIS_jButton8_actionAdapter(ShopMIS adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButton8_actionPerformed(e);
  }
}

  void jButton9_actionPerformed(ActionEvent e) {
    cardLayout2.show(jPanel2,"jPanel6");
    int l=0;
    String gNO=jTextField6.getText();//货物编号
    double gPrice=0;
    int gNumber=Integer.parseInt(jTextField8.getText()); //货物数量
    int left=0;//货物剩余数量
    String gName="";//货物名称
    String pNO="";//厂商编号
    String pName="";//厂商名称
    String cNO=jTextField3.getText();//客户号
    String cName="";//客户名
    String cTel="";//客户电话
/////查看是否存在货物
    try{
      boolean ex=false;
      String s="";
      String sql="select * from 货物库存 ";
      st=con.createStatement();
      ResultSet result=st.executeQuery(sql);
      while(result.next()){
      s=result.getString("货物编号").trim();
      gPrice=result.getInt("单价");
      gName=result.getString("货物名称").trim();
      left=result.getInt("剩余数量");
      pNO=result.getString("出产厂商编号").trim();
      //System.out.println(s+"  "+name+"  "+left+"  "+pNO);
      if(s.equals(gNO)){
        ex=true;
        //System.out.println(gPrice);
        break;
      }
     }
     if(!ex){
       JOptionPane.showMessageDialog(null,"该货物不存在！");
       return;
     }
      st.close();
   }catch(SQLException e1)
   {
     JOptionPane.showMessageDialog(null,"数据库连接失败");
   }
/////查看货物出产厂商
   try{
     String s="";
     String sql="select * from 厂商信息 ";
     st=con.createStatement();
     ResultSet result=st.executeQuery(sql);
     while(result.next())
     {
       s=result.getString("厂商编号").trim();
       pName=result.getString("厂商名").trim();
       //System.out.println(s+"  "+pName);
       if(s.equals(pNO))
       {
         //System.out.println(s+"  "+pName);
         break;
       }
     }

     st.close();
   }catch(SQLException e1)
   {
     JOptionPane.showMessageDialog(null,"数据库连接失败");
   }
/////查看客户是否存在
   try{
     boolean ex=false;
     String s="";
     String sql="select * from 客户 ";
     st=con.createStatement();
     ResultSet result=st.executeQuery(sql);
     while(result.next())
     {
       s=result.getString("客户号").trim();
       cName=result.getString("客户名").trim();
       cTel=result.getString("客户电话").trim();
       if(s.equals(cNO))
       {
         ex=true;
         break;
       }
     }
     if(!ex)
     {
       JOptionPane.showMessageDialog(null,"客户号不存在！");
       return;
     }
     //else{}

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


/////生成订单
   int temp=0;
   try{
     int  s=0,n=0;
     String s1="";
     String sql="select * from 订单 ";
     st=con.createStatement();
     ResultSet result=st.executeQuery(sql);
     while(result.next())
     {
       s=result.getInt("订单号");
       s1=result.getString("货物编号");
       n=result.getInt("货物数量");
       if(s1.equals(gNO))
       {
         gNumber=gNumber+n;
       }
       if(temp<s)
       {
         temp=s;
       }
     }

     st.close();
  }catch(SQLException e1)
  {
    JOptionPane.showMessageDialog(null,"数据库连接失败");
  }
////////
  try{
    int  s=0,n=0;
    String s1="";
    String sql="select * from 已供订单 ";
    st=con.createStatement();
    ResultSet result=st.executeQuery(sql);
    while(result.next())
    {
      s=result.getInt("订单号");
      if(temp<s)
      {
        temp=s;
      }
    }
    dingdanNO=temp;//订单号为所有订单中（以供和未供）订单号最大的值加一
    //System.out.println(dingdanNO+"");
    st.close();
 }catch(SQLException e1)
 {
   JOptionPane.showMessageDialog(null,"数据库连接失败");
 }

////////
  if(left<gNumber)
  {
    l=0;
    jTextField12.setText("货物库存不足");
    JOptionPane.showMessageDialog(null,"货物库存不足！");
  }
  else
  {
    l=1;
    jTextField12.setText("货物库存充足");
    //left=left-gNumber;
  }

   try{
     dingdanNO++;
     String sql="insert into 订单 values("+dingdanNO+","+l+",'"+cNO+"','"+gNO+"',"+gNumber+")";
     st=con.createStatement();
     st.executeUpdate(sql);
     st.close();
  }catch(SQLException e1)
  {
    JOptionPane.showMessageDialog(null,"数据库连接失败");
  }


////////更新货物库存信息
/*  try{
    //left=left-gNumber;//货物剩余数量
    String sql="update 货物库存 set 剩余数量='"+left+"' where 货物编号='"+gNO+"'";
    st=con.createStatement();
    st.executeUpdate(sql);
    st.close();
  }catch(SQLException e1)
  {
    JOptionPane.showMessageDialog(null,"数据库连接失败");
  }*/


   jTextField4.setText(cNO);
   jTextField5.setText(cName);
   jTextField7.setText(gNO);
   jTextField9.setText(gName);
   jTextField10.setText(gNumber+"");
   jTextField11.setText(pName);
   jTextField14.setText(pNO);
   jTextField15.setText(cTel);
   jTextField16.setText(gPrice+"元/千克");
   jTextField2.setText((dingdanNO)+"");

  }

  void jMenuItem7_actionPerformed(ActionEvent e) {
    cardLayout1.show(this.getContentPane(),"jPanel3");
    cardLayout3.show(jPanel3,"jPanel8");
  }

  void jMenuItem8_actionPerformed(ActionEvent e) {
    cardLayout1.show(this.getContentPane(),"jPanel3");
    cardLayout3.show(jPanel3,"jPanel9");
  }


  void jButton10_actionPerformed(ActionEvent e) {
    int gPrice=0;
    int left=0;
    String gName="";
    String pNO="";
    try{
      jTextArea3.setText("货物编号\t货物名称\t剩余数量\t出产厂商编号\t出产厂商名称\t\n");
      boolean ex=false;
      String s="",s1="";
      String sql="select * from 货物库存 ";
      st=con.createStatement();
      ResultSet result=st.executeQuery(sql);
      while(result.next())
     {
      s=result.getString("货物编号").trim();
      gName=result.getString("货物名称").trim();
      left=result.getInt("剩余数量");
      pNO=result.getString("出产厂商编号").trim();

      try
      {
        sql="select * from 厂商信息 where 厂商编号='"+pNO+"'";
        Statement st1=con1.createStatement();
        ResultSet result1=st1.executeQuery(sql);
        while(result1.next())
        {
          s1=result1.getString("厂商名");