frameproductoutinformation.java~23~

若已安装Jbuilder X

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

  void jButtonSearch_actionPerformed(ActionEvent e) {
    jText36.setText("");
    jText37.setText("");
    jText38.setText("");
    jText39.setText("");
    jText40.setText("");
    jText41.setText("");
    jText42.setText("");
    jText43.setText("");
    jText44.setText("");
    jTextoperator.setText("");
    jTextdate.setText("");
    jTextcomment.setText("");
  boolean  isfirst =true;
    sql="select * from ProductOut ";
    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() +"'";
      }
 // JOptionPane.showMessageDialog(null,sql);


    rs =db.getResult(sql);
     try {
       if(! rs.equals(null) )
       {  rs.next();
          showResult();
       }
     }
     catch (SQLException ex) {
     }
  }

  void jButtonfirst_actionPerformed(ActionEvent e) {
    try {
         rs.first() ;
         showResult();
      }
      catch (SQLException ex) {
      }
  }
  void jButtonpre_actionPerformed(ActionEvent e) {
    try {
           if(! rs.isFirst() )
           {  rs.previous();
              showResult();
           }
         }
         catch (SQLException ex) {
         }

  }

  void jButtonnext_actionPerformed(ActionEvent e) {
    try {
          if(! rs.isLast())
           {  rs.next();
              showResult();
           }
         }
             catch (SQLException ex) {
               }

  }

  void jButtonlast_actionPerformed(ActionEvent e) {
    try {
            rs.last();
             showResult();
          }
          catch (SQLException ex) {
          }

  }

  void jButtonupdate_actionPerformed(ActionEvent e) {
        //update
      sql="update ProductOut 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+" dateout='"+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!") ;
          else
              System.out.println(sql+"update failed!!!") ;

  }

  void jButtondelete_actionPerformed(ActionEvent e) {
         sql="delete from ProductOut 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_actionPerformed(ActionEvent e) {
        dispose();
  }
}

class FrameProductOutInformation_jButtonSearch_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonSearch_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonSearch_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtonfirst_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonfirst_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonfirst_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtonpre_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonpre_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonpre_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtonnext_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonnext_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonnext_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtonlast_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonlast_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonlast_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtonupdate_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonupdate_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonupdate_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtondelete_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtondelete_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtondelete_actionPerformed(e);
  }
}

class FrameProductOutInformation_jButtonexit_actionAdapter implements java.awt.event.ActionListener {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonexit_actionAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void actionPerformed(ActionEvent e) {
    adaptee.jButtonexit_actionPerformed(e);
  }
}