frameproductstoryinformation.java~26~

若已安装Jbuilder X

                  showResult();
               }
             }
             catch (SQLException ex) {
             }
  }
  void jButtonShow_mouseClicked(MouseEvent e) {
    int[] 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");
                     }
           //  System.out.println( size[0]) ;
             //  System.out.println( size[1]) ;
             //    System.out.println( size[2]) ;
               //    System.out.println( size[3]) ;


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