book.java

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

package MyLibraryok.giveback;

import javax.swing.*;
import java.awt.*;
import java.awt.event.*;
import javax.swing.border.*;
import javax.swing.JOptionPane;
import java.util.*;
import java.util.ArrayList;

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


/**
 * <p>Title:图书 管理 系统 --还书窗口</p>
 * <p>Description: 2007/1/20</p>
 * <p>Copyright: Copyright (c) 2007</p>
 * <p>Company: <清华IT 认证中心/p>
 * @author not attributable BHJ
 * @version 1.0--0824
 */

public class BOOK extends JDialog {
    Dimension screen = getToolkit().getScreenSize(); //得到屏幕尺寸

   int myWidth = screen.width;
   int myHeight = screen.height;
   int x = 666;
   int y = 434;

  JLabel jLabel3 = new JLabel();
  TitledBorder titledBorder1;
  Component component1;
  TitledBorder titledBorder2;
  //滚动条
  JScrollPane jScrollPane1 = new JScrollPane();
  String[] ss = {
      "编号", "读者编号", "图书编号", "读者姓名", "图书名称", "出借日期", "应还日期", "应付金额"};

  ArrayList list = new ArrayList();
  TableModelTest modle = new TableModelTest(list, ss);
  JTable jTable1 = new JTable(modle);


  TitledBorder titledBorder4;
  TitledBorder titledBorder5;
  TitledBorder titledBorder6;
  TitledBorder titledBorder7;
  JPanel jPanel1 = new JPanel();
  TitledBorder titledBorder8;
  TitledBorder titledBorder9;
  TitledBorder titledBorder10;
  JLabel jLabel1 = new JLabel();
  JTextField jTextFieldDZBH = new JTextField();
  TitledBorder titledBorder11;
  JButton jButtonGH = new JButton();
  JButton jButton3 = new JButton();
  JButton jButton5 = new JButton();
  Border border1;
  TitledBorder titledBorder12;
  TitledBorder titledBorder13;
  TitledBorder titledBorder3;
  JLabel jLabel4 = new JLabel();
  JTextField jTextFieldXM = new JTextField();
  Border border2;
  TitledBorder titledBorder14;
  TitledBorder titledBorder15;
  Border border3;
  TitledBorder titledBorder16;
  JPanel jPanel2 = new JPanel();
  Border border4;
  TitledBorder titledBorder17;
  JLabel jLabel2 = new JLabel();
  JLabel jLabel5 = new JLabel();
  JTextField jTextFieldTSBH = new JTextField();
  JTextField jTextFieldSM = new JTextField();

  public BOOK(MainFrame2 ss) {
      super(ss,"",true);
    try {
      jbInit();
    }
    catch (Exception ex) {
      ex.printStackTrace();
    }
  }

  void jbInit() throws Exception {

          // Center the frame
           if (x >= myWidth || y >= myHeight) {
               x = myWidth;
               y = myHeight;
               this.setSize(x, y);
               this.setLocation(0, 0);
           } else {
               this.setSize(x, y);

               this.setLocation((myWidth - this.getSize().width) / 2,
                                (myHeight - this.getSize().height) / 2);
           }

    titledBorder1 = new TitledBorder("");
    component1 = Box.createVerticalStrut(8);
    titledBorder2 = new TitledBorder("");
    // titledBorder3 = new TitledBorder("");
    titledBorder4 = new TitledBorder("");
    titledBorder5 = new TitledBorder(BorderFactory.createEtchedBorder(Color.
        white, new Color(149, 142, 130)), "");
    titledBorder6 = new TitledBorder("");
    titledBorder7 = new TitledBorder(BorderFactory.createEtchedBorder(Color.
        white, new Color(149, 142, 130)), "");
    titledBorder8 = new TitledBorder(BorderFactory.createEtchedBorder(Color.
        white, new Color(149, 142, 130)), "系统信息");
    titledBorder9 = new TitledBorder("");
    titledBorder10 = new TitledBorder(BorderFactory.createEtchedBorder(Color.
        white, new Color(149, 142, 130)), "读者信息");
    titledBorder11 = new TitledBorder(BorderFactory.createEtchedBorder(Color.
        white, new Color(149, 142, 130)), "系统信息");
    border1 = BorderFactory.createEmptyBorder(0, 0, 0, 6);
    titledBorder12 = new TitledBorder("");
    titledBorder13 = new TitledBorder("");
    titledBorder3 = new TitledBorder(BorderFactory.createEtchedBorder(Color.
        white, new Color(178, 178, 178)), "ccc");
    border2 = BorderFactory.createMatteBorder(6, 6, 6, 6, Color.white);
    titledBorder14 = new TitledBorder("");
    titledBorder15 = new TitledBorder("");
    border3 = BorderFactory.createEmptyBorder();
    titledBorder16 = new TitledBorder(BorderFactory.createEmptyBorder(), "系统信息");
    border4 = BorderFactory.createEmptyBorder();
    titledBorder17 = new TitledBorder(border4, "系统信息");
  //  this.getContentPane().setBackground(new Color(148, 233, 255));
    this.setDefaultCloseOperation(EXIT_ON_CLOSE);
    this.setForeground(Color.black);
    this.setLocale(new java.util.Locale("ar", "", ""));
//    this.addKeyListener(new BOOK_this_keyAdapter(this));
    this.getContentPane().setLayout(null);
    jLabel3.setText("读者编号");
    jLabel3.setFont(new java.awt.Font("Dialog", 0, 16));

    //  Escjian esc = new Escjian();
    //jButton4.registerKeyboardAction(esc, KeyStroke.getKeyStroke(KeyEvent.VK_ESCAPE,   0),
    // JComponent.WHEN_IN_FOCUSED_WINDOW);

    //jTextField2.addActionListener(new BOOK_jTextField2_actionAdapter(this));
    //jTextField3.addActionListener(new BOOK_jTextField3_actionAdapter(this));//jButton1.addActionListener();
    component1.setBounds(new Rectangle( -1, 140, 615, 0));
    //jComboBox7.addItem("条形码");
    jScrollPane1.setFont(new java.awt.Font("Dialog", 0, 15));
    jScrollPane1.setBounds(new Rectangle(13, 106, 635, 261));
    jPanel1.setEnabled(false);
    jPanel1.setFont(new java.awt.Font("Dialog", 0, 15));
    jPanel1.setBorder(titledBorder8);
    jPanel1.setBounds(new Rectangle(12, 12, 322, 89));
    jPanel1.setLayout(null);
    jLabel1.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel1.setForeground(Color.black);
    jLabel1.setText("读者编号:");
    jLabel1.setBounds(new Rectangle(12, 22, 81, 32));
    jTextFieldDZBH.setFont(new java.awt.Font("Dialog", 0, 12));
    jTextFieldDZBH.setForeground(Color.red);
    jTextFieldDZBH.setBorder(BorderFactory.createEtchedBorder());
    jTextFieldDZBH.setText("");
    jTextFieldDZBH.setBounds(new Rectangle(107, 29, 171, 21));
    jButtonGH.setBounds(new Rectangle(371, 376, 79, 27));
    jButtonGH.setFont(new java.awt.Font("Dialog", 0, 13));
    jButtonGH.setBorder(BorderFactory.createRaisedBevelBorder());
    jButtonGH.setMnemonic('0');
    jButtonGH.setText("归还");
 //   jButtonGH.addActionListener(new BookList(this));

    jButton3.setBounds(new Rectangle(467, 375, 79, 28));
    jButton3.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton3.setToolTipText("Enter");
    jButton3.setMargin(new Insets(2, 14, 2, 14));
    jButton3.setText("取消");
    jButton3.addActionListener(new Esc(this));
    jButton5.setBounds(new Rectangle(565, 375, 82, 29));
    jButton5.setFont(new java.awt.Font("Dialog", 0, 13));
    jButton5.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton5.setText("退出");
    jButton5.addActionListener(new Esc(this)); //添加监听器
    //------按牛可以变化
    jButtonGH.setBorder(BorderFactory.createRaisedBevelBorder());
    jButtonGH.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {}
    });
    jButtonGH.addMouseListener(new MouseListener() {
      public void mouseExited(MouseEvent e) {
        jButtonGH.setBorder(BorderFactory.createRaisedBevelBorder());
      }

      public void mouseEntered(MouseEvent e) {
        jButtonGH.setBorder(BorderFactory.createBevelBorder(2));
      }

      public void mouseReleased(MouseEvent e) {}

      public void mousePressed(MouseEvent e) {
        jButtonGH.setBorder(BorderFactory.createLoweredBevelBorder());
      }

      public void mouseClicked(MouseEvent e) {}
    });

//jButton2.setBorder(BorderFactory.createRaisedBevelBorder());
//jButton2.addActionListener(new ActionListener(){public void actionPerformed(ActionEvent e){}});

    jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton3.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {}
    });
    jButton3.addMouseListener(new MouseListener() {
      public void mouseExited(MouseEvent e) {
        jButton3.setBorder(BorderFactory.createRaisedBevelBorder());
      }

      public void mouseEntered(MouseEvent e) {
        jButton3.setBorder(BorderFactory.createBevelBorder(2));
      }

      public void mouseReleased(MouseEvent e) {}

      public void mousePressed(MouseEvent e) {}

      public void mouseClicked(MouseEvent e) {
        jButton3.setBorder(BorderFactory.createLoweredBevelBorder());
      }
    });
    jButton5.setBorder(BorderFactory.createRaisedBevelBorder());
    jButton5.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {}
    });
    jButton5.addMouseListener(new MouseListener() {
      public void mouseExited(MouseEvent e) {
        jButton5.setBorder(BorderFactory.createRaisedBevelBorder());
      }

      public void mouseEntered(MouseEvent e) {
        jButton5.setBorder(BorderFactory.createBevelBorder(2));
      }

      public void mouseReleased(MouseEvent e) {}

      public void mousePressed(MouseEvent e) {}

      public void mouseClicked(MouseEvent e) {
        jButton5.setBorder(BorderFactory.createLoweredBevelBorder());
      }
    });

    jTable1.setEnabled(true);
    jTable1.setFont(new java.awt.Font("MS Sans Serif", 0, 11));
    jTable1.setForeground(Color.black);
    jTable1.setAutoscrolls(false);
    jTable1.setBorder(BorderFactory.createRaisedBevelBorder());
    jTable1.setInputVerifier(null);
    jTable1.setAutoResizeMode(JTable.AUTO_RESIZE_NEXT_COLUMN);
    //jLabel4.setEnabled(true);

    jLabel4.setFont(new java.awt.Font("Dialog", 0, 13));
    jLabel4.setText("姓名:");
    jLabel4.setBounds(new Rectangle(12, 44, 78, 38));

    jTextFieldXM.setFont(new java.awt.Font("Dialog", 0, 12));
    jTextFieldXM.setForeground(Color.red);
    jTextFieldXM.setBorder(BorderFactory.createEtchedBorder());
    jTextFieldXM.setText("");

    jTextFieldXM.setBounds(new Rectangle(107, 52, 171, 21));
    jPanel2.setBorder(titledBorder8);
    jPanel2.setBounds(new Rectangle(344, 12, 303, 88));
    jPanel2.setLayout(null);
    jLabel2.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
    jLabel2.setText("图书编号：");
    jLabel2.setBounds(new Rectangle(16, 24, 71, 16));
    jLabel5.setFont(new java.awt.Font("Dialog", Font.PLAIN, 13));
    jLabel5.setText("书名：");
    jLabel5.setBounds(new Rectangle(14, 52, 67, 15));
    jTextFieldTSBH.setBounds(new Rectangle(109, 20, 162, 25));
    jTextFieldSM.setBounds(new Rectangle(110, 47, 162, 21));
    this.getContentPane().add(jLabel3, null);
    this.getContentPane().add(component1, null);
    jPanel1.add(jLabel4, null);
    jPanel1.add(jTextFieldDZBH, null);
    jPanel1.add(jTextFieldXM, null);
    jPanel1.add(jLabel1, null);
    this.getContentPane().add(jButton3, null);
    this.getContentPane().add(jButtonGH, null);
    this.getContentPane().add(jScrollPane1, null);
    jScrollPane1.getViewport().add(jTable1, null);
    this.getContentPane().add(jButton5, null);
    this.getContentPane().add(jPanel2, null);
    jPanel2.add(jLabel2);
    jPanel2.add(jLabel5);
    jPanel2.add(jTextFieldTSBH);
    jPanel2.add(jTextFieldSM);
    this.getContentPane().add(jPanel1);
    String sq = "select *from jiehuan";

    bookdo(sq);
setTitle("还书窗口");
    this.setResizable(false);

  }









//class BOOK_this_keyAdapter extends java.awt.event.KeyAdapter {
//  BOOK adaptee;
//
//  BOOK_this_keyAdapter(BOOK adaptee) {
//    this.adaptee = adaptee;
//  }
//  public void keyPressed(KeyEvent e) {
//    adaptee.this_keyPressed(e);
//  }

public void bookdo(String book) {
  try {
    list.clear();
    Mydb mydb = new Mydb();
    ResultSet re = mydb.sqlcha(book);
    System.out.println(">>>>>"+book);
    while (re.next()) {
      ArrayList array = new ArrayList();
      array.add(re.getString(1));
      array.add(re.getString(2));
      array.add(re.getString(3));
      array.add(re.getString(4));
      array.add(re.getString(5));
      array.add(re.getString(6));
      array.add(re.getString(7));
      array.add(re.getString(8));
//
      list.add(array);
      modle.fireTableDataChanged();
    }
  }
  catch (SQLException ex) {
//    ex.printStackTrace();
    System.out.println("111111111111111");
  }

}
}