frameproductininformation.java~67~

若已安装Jbuilder X

      jText40.setText(rs.getString("40") );
      jText41.setText(rs.getString("41") );
      jText42.setText(rs.getString("42") );
      jText43.setText(rs.getString("43") );
      jText44.setText(rs.getString("44") );

    }
    catch (SQLException ex) {
    }


  }


  void jButtonSearch_mouseClicked(MouseEvent e) {

    boolean  isfirst =true;

        sql="select * from ProductIn ";
  // JOptionPane.showMessageDialog(null,jCombocolor.getSelectedItem().toString().trim() );
         if (jTextkuanxing.getText().trim().length() ==0)
         {}
         else
         {
            sql=sql+"  where  kuanxing='"+jTextkuanxing.getText().trim()+"'";
            isfirst=false;
         }
        if (jCombocolor.getSelectedItem().toString().trim() .length() ==0)
        {}
        else
        {
          if (isfirst)
          sql=sql+" where color='"+jCombocolor.getSelectedItem().toString().trim() +"'";
          else
           sql=sql+" and color='"+jCombocolor.getSelectedItem().toString().trim() +"'";
        }

          rs =db.getResult(sql);
         try {
           if(! rs.equals(null) )
           {  rs.next();
              showResult();
           }
         }
         catch (SQLException ex) {
            JOptionPane.showMessageDialog(null," search failed!");
         }

  }

  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 ProductIn 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+" operator='"+jTextoperator.getText().trim() +"', ";
       sql=sql+" datein='"+jTextdate.getText().trim() +"', ";
        sql=sql+" comment='"+jTextcomment.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!") ;
      JOptionPane.showMessageDialog(null,"successed!");
          }
            else
            {
              System.out.println(sql + "update failed!!!");
              JOptionPane.showMessageDialog(null,"failed!");
            }

  }

  void jButtondelete_mouseClicked(MouseEvent e) {
    sql="delete from ProductIn 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!!!") ;

  }

}

class FrameProductInInformation_jButtonSearch_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonSearch_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonSearch_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtonfirst_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonfirst_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonfirst_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtonpre_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonpre_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonpre_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtonnext_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonnext_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonnext_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtonlast_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonlast_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonlast_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonupdate_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonupdate_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtondelete_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtondelete_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtondelete_mouseClicked(e);
  }
}

class FrameProductInInformation_jButtonexit_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductInInformation adaptee;

  FrameProductInInformation_jButtonexit_mouseAdapter(FrameProductInInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonexit_mouseClicked(e);
  }
}