esc.java

来自「java+sql 图书管理系统」· Java 代码 · 共 129 行

package MyLibraryok.giveback;

import java.awt.*;
import java.awt.event.*;
import javax.swing.*;
import java.awt.event.WindowEvent;

import java.sql.SQLException;
import java.sql.ResultSet;
import MyLibraryok.Mydb.Mydb;

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

  BOOK book1;
  public Esc(BOOK BOOK1) {
    this.book1 = BOOK1;
  }

  public void actionPerformed(ActionEvent e) {

    if (e.getSource() == book1.jButton5) {
      book1.dispose(); //*System.exit(0);*/
      int t = JOptionPane.showConfirmDialog(null, "您真的要退出吗?", "Tip...",
                                            JOptionPane.YES_NO_OPTION);
      if (t == JOptionPane.YES_OPTION) {
        book1.dispose();
      }
      else if (t == JOptionPane.NO_OPTION) {
        book1.setVisible(true);
      }
    }
    else if (e.getSource() == book1.jButton3) {
      book1.jTextFieldDZBH.setText("");
      book1.jTextFieldSM.setText("");
      book1.jTextFieldTSBH.setText("");
      book1.jTextFieldXM.setText("");
    }
    else if (e.getSource() == book1.jButtonGH) {

      String strDZBH = book1.jTextFieldDZBH.getText();
      String strSM = book1.jTextFieldSM.getText();
      String strTSBH = book1.jTextFieldTSBH.getText();
      String strXM = book1.jTextFieldXM.getText();
      String st1 = "select * from jiehuan where 图书编号='" + strTSBH + "'";
      String st2 = "select * from jiehuan where 读者编号='" + strDZBH + "'";

      String st5 = "select 图书编号,读者编号 from jiehuan where 读者编号='" +
          strDZBH + "' and 图书编号='" +
          strTSBH + "'";
      String s;

      try {

        Mydb mydb = new Mydb();
        String st3 = "select * from reader where 读者编号='" + strDZBH + "'";
        ResultSet sttt = mydb.sqlcha(st3);
        if (sttt.next()) {
          book1.jTextFieldDZBH.setText(sttt.getString(1));
          book1.jTextFieldXM.setText(sttt.getString(3));
        }

        String dda = "select *from books where 图书编号=" + strTSBH;
        ResultSet dr = mydb.sqlcha(dda);
        if (dr.next()) {
          book1.jTextFieldTSBH.setText(dr.getString(1));

          book1.jTextFieldSM.setText(dr.getString(2));

          Mydb my = new Mydb();
          String aa = "select 库存图书 from books where 图书编号=" + strTSBH;
          ResultSet dd = my.sqlcha(aa);

//          String sql1 = "update jiehuanbiao " +
//              "set 还书时间='" + str6 + "',还书经手人='"
//              + str5 + "' " +
//              "where 借书编号='" + str1 + "'";

          if (dd.next()) {
            String bb = "update books set   库存图书=库存图书+1 " +
                "',借出图书=借出图书-1,"+
                "where 图书编号='" +
                strTSBH + "'";
            System.out.println(">>>>>>>>>>>>>" + bb);
            my.sqlgai(bb);
          }
        }
//        mydb = new MyDB(); /////////SQL语句
//           String ss = "delete reader where 读者姓名='" +
//                       jiemian.jTextField8.getText() + "'";
//
//           try {
//               mydb.sqlzen(ss);
//              JOptionPane.showMessageDialog(null, "信息已删除：", "信息提示：", 0);
//               jiemian.arraylist.remove(a); //刷新表格内容
//               jiemian.jtablemodle.fireTableStructureChanged();//
//           } catch (SQLException sss) {}

        Mydb my2 = new Mydb();
          String aa2 = "select 库存图书 from books where 图书编号=" + strTSBH;
          ResultSet dd2 = my2.sqlcha(aa2);
          if(dd2.next()){
            String ok = "delete jiehuan where 读者姓名='" +strTSBH;
            my2.sqlgai(ok);
          }

      }
      catch (SQLException E) {
        E.printStackTrace();
      }
      JOptionPane.showMessageDialog(null, "成功!", "图书管理系统",
                                    JOptionPane.OK_OPTION);

    }
  }

  private void jbInit() throws Exception {
  }

}