queding.java~1~

来自「java+sql 图书管理系统」· JAVA~1~ 代码 · 共 149 行

package MyLibraryok.borrow.jiemian;

import java.awt.event.*;
import javax.swing.*;
import java.sql.ResultSet;
import java.sql.*;
import java.awt.*;

public class Queding
    implements ActionListener {
  public Queding() {
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  BorrowFram jiemian;

  MyDB mydb;
  Feifa feifa;
  public Queding(BorrowFram jiemian) {
    this.jiemian = jiemian;
  }

  public void actionPerformed(ActionEvent e) {
    if (e.getActionCommand().equals("确定1")) {
      //------------------------------数据库中此图书的库存减少一本------reader
      Feifa feifa = new Feifa(); //-----------------定义判断非法的类Feifa的对象feifa
      if (jiemian.jTextField1.getText().equals("")) { //判断"读者编号"是否为空
        JOptionPane.showMessageDialog(null, "借阅证号和图书编号不能为空!", "信息提示",
                                      JOptionPane.INFORMATION_MESSAGE); //弹出相应对话框
        jiemian.jTextField1.requestFocus(); //读者编号获得光标
      }
      else if (jiemian.jTextField2.getText().equals("")) { //判断"图书编号"是否为空
        JOptionPane.showMessageDialog(null, "借阅证号和图书编号不能为空!", "信息提示",
                                      JOptionPane.INFORMATION_MESSAGE); //弹出相应对话框
        jiemian.jTextField2.requestFocus(); //图书编号获得光标
      }
      /**
       *
       * 定义SQL语句赋于String对象sql,sql1,str
       *
       * 并调用SqlDb类中方法执行这些语句
       *
       * */
      else {
        try {
          MyDB mydb = new MyDB();
          String sql = "update books set 库存图书=库存图书-1 "
              + "where 图书编号='" + jiemian.jTextField2.
              getText() + "'";

          String sql1 = "update books set 借出图书=借出图书+1" +
              "where 图书编号='" +
              jiemian.jTextField2.getText() + "'";

          String str =
              "insert into jiehuan( 读者编号,图书编号,出借日期,应还日期 ) values ('" +
              jiemian.jTextField1.getText() + "','" +
              jiemian.jTextField2.getText() +
                "','"+
                 jiemian.n.getSelectedItem()+ "','" +
                          jiemian.n1.getSelectedItem() +
//
              "')";
          System.out.println(str);
          ///////////////////////////////
          System.out.println(jiemian.n.getSelectedItem().toString());
          ResultSet rs = null;
          try {
            mydb.sqlgai(sql1);
            mydb.sqlgai(sql);
            mydb.sqlzen(str);
          }
          catch (SQLException ex) {
            ex.printStackTrace(); //如有异常,打印其异常
          }

          JOptionPane.showMessageDialog(null,
                                        "借书成功!如要再借书,请重新操作!",
                                        "信息提示",
                                        JOptionPane.CANCEL_OPTION); //---------弹出相应对话框
          jiemian.jTextField1.setText("");
          jiemian.jTextField2.setText("");
        }
        catch (HeadlessException ex2) {
          ex2.printStackTrace(); //如有异常,打印其异常
        }
      }
    }

    else if (e.getActionCommand().equals("确定2")) {
      //---------------------只把数据存入数据库的表-----jiehuan
      Feifa feifa = new Feifa(); //定义判断非法的类Feifa的对象feifa
      if (jiemian.jTextField8.getText().equals("")) { //判断"读者编号"是否为空
        JOptionPane.showMessageDialog(null, "读者编号图书编号都不能为空!", "信息提示",
                                      JOptionPane.INFORMATION_MESSAGE); //弹出相应对话框
        jiemian.jTextField8.requestFocus(); //读者编号获得光标
      }
      else if (jiemian.jTextField9.getText().equals("")) { //判断"图书编号"是否为空
        JOptionPane.showMessageDialog(null, "读者编号和图书编号都不能为空!", "信息提示",
                                      JOptionPane.INFORMATION_MESSAGE); //弹出相应对话框
        jiemian.jTextField9.requestFocus(); //图书编号获得光标
      }
      else {
        try {
          MyDB mydb = new MyDB(); //
          String str =
              "insert into jiehuan( 读者编号,图书编号,出借日期,应还日期,备注) values ('" +
              jiemian.jTextField8.getText() + "','" +
              jiemian.jTextField9.getText()
                +  "','"+  jiemian.n2.getSelectedItem()+ "','" +
                         jiemian.n3.getSelectedItem() +"','"+"续借"
              + "')";

          System.out.println(str);
          ResultSet rs = null;
          try {
            //mydb.sqlgai(sql);
            mydb.sqlzen(str);
            //mydb.sqlgai(sql1);

          }
          catch (SQLException ex) {
            ex.printStackTrace(); //如有异常,打印其异常
          }

          JOptionPane.showMessageDialog(null,
                                        "     续借成功",
                                        "信息提示",
                                        JOptionPane.CANCEL_OPTION); //---------弹出相应对话框
          jiemian.jTextField8.setText("");
          jiemian.jTextField9.setText("");
        }
        catch (HeadlessException ex2) {
          ex2.printStackTrace(); //如有异常,打印其异常
        }

      }
    }
  }

  private void jbInit() throws Exception {
  }
}