frameproductininformation.java~69~

若已安装Jbuilder X

      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 ";
  //如果款型的查询条件不为空
         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() +"'";
      //由DBManager对象执行更新操作
      if(db.executeSql(sql))
      {   //若成功，提示成功
           System.out.println(sql+"update successed!") ;
           JOptionPane.showMessageDialog(null,"更新成功!");
          }
            else
            {
              //若失败，提示失败
              System.out.println(sql + "更新失败");
              JOptionPane.showMessageDialog(null,"更新失败!");
            }

  }
//删除操作
  void jButtondelete_mouseClicked(MouseEvent e) {
    sql="delete from ProductIn where kuanxing='"+jTextkuanxing.getText().trim() +"'";
            sql= sql+" and color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
              //由DBManager对象执行删除操作
            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);
  }
}