frameproductoutinformation.java~31~

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

  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  model='"+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) {
     }
  }

//删除操作
  void jButtondelete_actionPerformed(ActionEvent e) {
         sql="delete from ProductOut where model='"+jTextkuanxing.getText().trim() +"'";
             sql= sql+" and color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
              //由DBManager对象执行更新操作
             if(db.executeSql(sql))
               JOptionPane.showMessageDialog(null,"操作成功！");
             else
               JOptionPane.showMessageDialog(null,"操作失败！");
   }

  void jButtonexit_actionPerformed(ActionEvent e) {
        dispose();
  }
//游标移动到第一条，显示纪录
  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 ProductOut set number36='"+jText36.getText().trim() +"',";
        sql=sql+" number37='"+jText37.getText().trim() +"',";
        sql=sql+" number38='"+jText38.getText().trim() +"',";
        sql=sql+" number39='"+jText39.getText().trim() +"',";
        sql=sql+" number40='"+jText40.getText().trim() +"',";
        sql=sql+" number41='"+jText41.getText().trim() +"',";
        sql=sql+" number42='"+jText42.getText().trim() +"',";
        sql=sql+" number43='"+jText43.getText().trim() +"',";
        sql=sql+" number44='"+jText44.getText().trim() +"', ";
        sql=sql+" operator='"+jTextoperator.getText().trim() +"', ";
        sql=sql+" dateout='"+jTextdate.getText().trim() +"', ";
        sql=sql+" comment='"+jTextcomment.getText().trim() +"' ";
        sql=sql+" where model='"+jTextkuanxing.getText().trim() +"'";
        sql=sql+" and color ='"+jCombocolor.getSelectedItem().toString().trim() +"'";
        if(db.executeSql(sql)) //由DBManager对象执行更新操作
           //若成功，提示成功
              {System.out.println(sql+"update successed!") ;
                JOptionPane.showMessageDialog(null,"更新成功!");}
        else //若失败，提示失败
              { System.out.println(sql+"update failed!!!") ;
                 JOptionPane.showMessageDialog(null,"更新失败!");}

  }
}

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

class FrameProductOutInformation_jButtonfirst_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonfirst_mouseAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonfirst_mouseClicked(e);
  }
}

class FrameProductOutInformation_jButtonpre_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonpre_mouseAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonpre_mouseClicked(e);
  }
}

class FrameProductOutInformation_jButtonnext_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonnext_mouseAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonnext_mouseClicked(e);
  }
}

class FrameProductOutInformation_jButtonlast_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonlast_mouseAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonlast_mouseClicked(e);
  }
}

class FrameProductOutInformation_jButtonupdate_mouseAdapter extends java.awt.event.MouseAdapter {
  FrameProductOutInformation adaptee;

  FrameProductOutInformation_jButtonupdate_mouseAdapter(FrameProductOutInformation adaptee) {
    this.adaptee = adaptee;
  }
  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonupdate_mouseClicked(e);
  }
}