outbooks.java~29~

来自「教材管理系统」· JAVA~29~ 代码 · 共 434 行 · 第 1/2 页

  void jButtonsearch_mouseClicked(MouseEvent e) {
  String strSQL;
  //校验书名是否为空
  if (jTextFieldISBN.getText().trim().equals("")) {
    JOptionPane.showMessageDialog(null, "ISBN号不许为空！");
    return;
  }
  //生成sql操作语句，查询要更新的书是否存在，若存在将此书相关信息绑顶到窗体上，若不存在提示并返回
  strSQL = "select book.name,price,roomnum,num from books where ISBN='" +
      jTextFieldISBN.getText().trim() + "' ";
  rs = db.getResult(strSQL);
  boolean isexist = false;
  try {
    isexist = rs.first();
  }
  catch (SQLException ex1) {
  }
  //若此书不存在，提示警告信息
  if (!isexist) {
    JOptionPane.showMessageDialog(null, "此书不存在！");
  }
  else {
    try {
      //将游标移动到首位置
      rs.first();
      //在文本框中显示数据集中的数据
      jTextFieldname.setText(rs.getString("name"));


      jTextFieldnum.setText(rs.getString("num"));
      jTextFieldroomnum.setText(rs.getString("roomnum"));

      jTextFieldprice.setText(rs.getString("Price"));

       }
    catch (SQLException ex) {
    }
  }

  }




  void jButtonOk_mouseClicked(MouseEvent e) {
    String sql;

    if (jTextFieldaccptuser.getText().trim().equals("")) {
         JOptionPane.showMessageDialog(null, "领书用户不许为空！");
         return;
       }


    //用户名是否为空
    if (jTextFieldusername.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "经办人不许为空！");
      return;
    }
    //书名是否为空
    if (jTextFieldname.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "书名不许为空！");
      return;
    }
    //出库日期是否为空
    if (jTextFieldoutdate.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "领书日期不许为空！");
      return;
    }
    if (jTextFieldoutnum.getText().trim().equals("")) {
     JOptionPane.showMessageDialog(null, "领书数量不许为空！");
     return;
   }
   if (jTextFieldroomnum.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "仓库号不许为空！");
      return;
    }
    if (jTextFieldprofessional.getText().trim().equals("")) {
      JOptionPane.showMessageDialog(null, "所属院系不许为空！");
      return;
    }
    if (jTextFielddepartment.getText().trim().equals("")) {
          JOptionPane.showMessageDialog(null, "所在专业不许为空！");
          return;
        }
  if (jTextFieldISBN.getText().trim().equals("")) {
              JOptionPane.showMessageDialog(null, "ISBN号不许为空！");
              return;
            }


  if (jTextFieldnum.getText().trim().equals("")) {
                  JOptionPane.showMessageDialog(null, "现存数量不许为空！");
                  return;
                }


  if (jTextFieldoutnewnum.getText().trim().equals("")) {
                  JOptionPane.showMessageDialog(null, "出库后数量不许为空！");
                  return;
                }
     if  (jTextFieldsumpay.getText().trim().equals("")) {
                      JOptionPane.showMessageDialog(null, "总费用不许为空！");
                      return;
                    }
 if (jTextFieldprice.getText().trim().equals("")) {
                          JOptionPane.showMessageDialog(null, "单价不许为空！");
                          return;
                        }




    //然后执行插入操作
    sql = "insert into Bookout(ISBN,username,outusertype,outdate,outnum,outnewnum,sumpay,accptuser,department,professional)values(  ";
    sql = sql + "'" + jTextFieldISBN.getText() + "',";
    sql = sql + "'" + jTextFieldusername.getText() + "',";
    sql = sql + "'" +    jComboBoxoutusertype.getSelectedItem().toString()  + "',";
    sql = sql + "'" + jTextFieldoutdate.getText() + "',";
    sql = sql + "'" + jTextFieldoutnum.getText() + "',";
    sql = sql + "'" + jTextFieldoutnewnum.getText() + "',";
    sql = sql + "'" + jTextFieldsumpay.getText() + "',";
    sql = sql + "'" + jTextFieldaccptuser.getText().trim() + "',";
    sql = sql + "'" + jTextFielddepartment.getText().trim() + "',";
    sql = sql + "'" + jTextFieldprofessional.getText() + "',";
    sql = sql + ")";

    //由数据库操作对象执行数据库操作，并返回操作成功失败的提示信息
    if (db.executeSql(sql)) {
      JOptionPane.showMessageDialog(null, "成功出库！");
    }
    else {
      JOptionPane.showMessageDialog(null, " 出库失败，请重新操作！");
    }
  sql =  "update books set books.num=bookout.outnewnum where books.ISBN=bookout.ISBN";
  }


//void this_windowOpened(WindowEvent e) {
   // String strSQL = "";
  //  strSQL = "select book.ISBN from Books  ";
    //rs = db.getResult(strSQL);
    //boolean isexist = false;
    //try {
      //isexist = rs.first();
    //}
   // catch (SQLException ex1) {
    //}

//}
    class outBookS_jButtonsearch_mouseAdapter
        extends java.awt.event.MouseAdapter {
     outBookS adaptee;

     outBookS_jButtonsearch_mouseAdapter(outBookS adaptee) {
        this.adaptee = adaptee;
      }

      public void mouseClicked(MouseEvent e) {
        adaptee.jButtonsearch_mouseClicked(e);
      }
    }



class outBookS_jButtonCancel_mouseAdapter
    extends java.awt.event.MouseAdapter {
 outBookS adaptee;

 outBookS_jButtonCancel_mouseAdapter(outBookS adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonCancel_mouseClicked(e);
  }
}

class outBookS_jButtonReset_mouseAdapter
    extends java.awt.event.MouseAdapter {
 outBookS adaptee;

  outBookS_jButtonReset_mouseAdapter(outBookS adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonReset_mouseClicked(e);
  }
}

class outBookS_jButtonOk_mouseAdapter
    extends java.awt.event.MouseAdapter {
  outBookS adaptee;

 outBookS_jButtonOk_mouseAdapter(outBookS adaptee) {
    this.adaptee = adaptee;
  }

  public void mouseClicked(MouseEvent e) {
    adaptee.jButtonOk_mouseClicked(e);
  }
}

class outBookS_this_windowAdapter
    extends java.awt.event.WindowAdapter {
 outBookS adaptee;

  outBookS_this_windowAdapter(outBookS adaptee) {
    this.adaptee = adaptee;
  }

 // public void windowOpened(WindowEvent e) {
   // adaptee.this_windowOpened(e);
 // }
}
    }