frameproductstoryinformation.java~2~

本源码主要有主界面模块,操作员管理,产品信息管理,入库操作,出库操作,库存信息管理,数据操作模块组成,数据库为ACCESS2003.

      else //如果是第二个查询条件
       sql=sql+" and color='"+jCombocolor.getSelectedItem().toString().trim() +"'";
    }
    //执行数据库的查询操作
            rs =db.getResult(sql);
             try {
               if(! rs.equals(null) )  //判断返回的结果集是否为空，若不为空显示第一条记录
               {  rs.next();
                  showResult();
               }
             }
             catch (SQLException ex) {
             }
  }
  //计算并打开图形显示页面
  void jButtonShow_mouseClicked(MouseEvent e) {
    float[] size={0,0,0,0,0,0,0,0,0};
    String tempstring="";
      try {
            rs.beforeFirst();
               while(rs.next() )
               {
                size[0]= size[0] +rs.getInt("36");
                 size[1]= size[1] +rs.getInt("37");
                  size[2]= size[2] +rs.getInt("38");
                   size[3]= size[3] +rs.getInt("39");
                    size[4]= size[4] +rs.getInt("40");
                     size[5]= size[5] +rs.getInt("41");
                      size[6]= size[6] +rs.getInt("42");
                       size[7]= size[7] +rs.getInt("43");
                        size[8]= size[8] +rs.getInt("44");
                     }
           //创建实例
             FrameProductStoryInformationShow mFrameProductStoryInformationShow =new FrameProductStoryInformationShow(size);
             mFrameProductStoryInformationShow.show();

          }
          catch (SQLException ex) {
             System.out.println(ex.toString() ) ;
          }

  }
//游标移动到第一条，显示纪录
  void jButtonfirst_mouseClicked(MouseEvent e) {
    try {
                rs.first() ;
                showResult();
             }
             catch (SQLException ex) {
             }
  }
//游标移动到前一条，显示纪录
  void jButtonpre_mouseClicked(MouseEvent e) {
    try {
                 if(! rs.isFirst() )
                 {  rs.previous();
                    showResult();
                 }
               }
               catch (SQLException ex) {
               }

  }
//游标移动到后一条，显示纪录
  void jButtonnext_mouseClicked(MouseEvent e) {
    try {
                 if(! rs.isLast())
                  {  rs.next();
                     showResult();
                  }
                }
                    catch (SQLException ex) {
                      }

  }
//游标移动到最后一条，显示纪录
  void jButtonlast_mouseClicked(MouseEvent e) {
    try {
                  rs.last();
                   showResult();
                }
                catch (SQLException ex) {
                }

  }
//更新操作
  void jButtonupdate_mouseClicked(MouseEvent e) {
    //update
     sql="update ProductStore set 36='"+jText36.getText().trim() +"',";
     sql=sql+" 37='"+jText37.getText().trim() +"',";
     sql=sql+" 38='"+jText38.getText().trim() +"',";
     sql=sql+" 39='"+jText39.getText().trim() +"',";
     sql=sql+" 40='"+jText40.getText().trim() +"',";
     sql=sql+" 41='"+jText41.getText().trim() +"',";
     sql=sql+" 42='"+jText42.getText().trim() +"',";
     sql=sql+" 43='"+jText43.getText().trim() +"',";
     sql=sql+" 44='"+jText44.getText().trim() +"' ";
     sql=sql+" where kuanxing='"+jTextkuanxing.getText().trim() +"'";
     sql=sql+" and color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
     if(db.executeSql(sql))
           System.out.println(sql+"update successed!") ;
         else
             System.out.println(sql+"update failed!!!") ;

  }
//删除操作
  void jButtondelete_mouseClicked(MouseEvent e) {
    sql="delete from ProductStore where kuanxing='"+jTextkuanxing.getText().trim() +"'";
   sql= sql+" and color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
   if(db.executeSql(sql))
     System.out.println(sql+"delete successed!") ;
   else
      System.out.println(sql+"delete failed!!!") ;

  }

  void jButtonexit_mouseClicked(MouseEvent e) {
           this.dispose();
  }
}

class FrameProductStoryInformation_jButtonSearch_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonSearch_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonSearch_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonShow_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonShow_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonShow_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonfirst_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonfirst_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonfirst_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonpre_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonpre_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonpre_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonnext_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonnext_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonnext_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonlast_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonlast_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonlast_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonupdate_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonupdate_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtondelete_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtondelete_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtondelete_mouseClicked(e);
  }
}

class FrameProductStoryInformation_jButtonexit_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductStoryInformation adaptee;

  FrameProductStoryInformation_jButtonexit_mouseAdapter(FrameProductStoryInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonexit_mouseClicked(e);
  }
}