querybook.java~8~

这是一个用jbuilder2005编写的图书管理系统

package bookmanage;

import java.awt.*;
import javax.swing.*;
import java.awt.BorderLayout;
import java.awt.Rectangle;
import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.sql.ResultSet;
import javax.swing.table.*;
import java.sql.SQLException;
import java.util.*;

/**
 * <p>Title: 图书管理系统</p>
 *
 * <p>Description: QueryBook是继承JDialog，主要是用来查询书的信息</p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: 浙江工业大学信息学院计算机系</p>
 *
 * @author 曾文秋
 * @version 1.0
 */
public class QueryBook
    extends JDialog {
  public QueryBook(Frame owner, String title, boolean modal) {
    super(owner, title, modal);
    try {
      setDefaultCloseOperation(DISPOSE_ON_CLOSE);
      jbInit();
      pack();
    }
    catch (Exception exception) {
      exception.printStackTrace();
    }
  }

  public QueryBook() {
    this(new Frame(), "QueryBook", false);
  }

  private void jbInit() throws Exception {
    this.getContentPane().setLayout(borderLayout1);
    jTextFieldName.setColumns(15);
    jButtonQurey.setText("查询");
    jButtonQurey.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonQurey_actionPerformed(e);
      }
    });
    jButtonQueryCancel.setText("退出");
    jButtonQueryCancel.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jButtonQueryCancel_actionPerformed(e);
      }
    });
    jPanel1.setLayout(flowLayout1);
    jComboBoxType.addActionListener(new ActionListener() {
      public void actionPerformed(ActionEvent e) {
        jComboBoxType_actionPerformed(e);
      }
    });
    jPanel1.add(jComboBoxType);
    jPanel1.add(jTextFieldName);
    jPanel1.add(jButtonQurey);
    this.getContentPane().add(jPanel1, java.awt.BorderLayout.NORTH);

    this.getContentPane().add(jButtonQueryCancel, java.awt.BorderLayout.SOUTH);
    this.getContentPane().add(jScrollPane1, java.awt.BorderLayout.CENTER);
    jScrollPane1.getViewport().add(jTable1);

  }

  BorderLayout borderLayout1 = new BorderLayout();
  JPanel jPanel1 = new JPanel();
  JTextField jTextFieldName = new JTextField();
  JButton jButtonQurey = new JButton();
  JButton jButtonQueryCancel = new JButton();
  JScrollPane jScrollPane1 = new JScrollPane();
  String title[]={"tag","ISBN","书名","索书号","出版社","是否可借"};
  DefaultTableModel model = new DefaultTableModel(title,0);
  JTable jTable1 = new JTable(model);
  String name[]={"按ISBN","按书名"};
  JComboBox jComboBoxType = new JComboBox(name);
  FlowLayout flowLayout1 = new FlowLayout();
  String type="按ISBN";
  String nname="";
  String strSQL="";
  ResultSet rs;
  //定义数据库操作对象
  private DBManager db = new DBManager();
  Vector tempvector = new Vector(1, 1);


  public void jButtonQueryCancel_actionPerformed(ActionEvent e) {
    this.dispose();
  }
  /**
   *
   * @param e ActionEvent
   * @todo 接着做，还没有做完---------------------------------
   *
   */
  public void jButtonQurey_actionPerformed(ActionEvent e) {
    nname=jTextFieldName.getText().trim();
    if(type.equals("")){
       JOptionPane.showMessageDialog(this, "查询方式不能为空!");
       return;
    }
    if(nname.equals("")){
      JOptionPane.showMessageDialog(this, "查询内容不能为空!");
       return;
    }
    if(type.equals("按ISBN")){
      strSQL="select tag,ISBN,name,bookAdress,publisher,isBorrow from bookADS_VIEW where ISBN='"+nname+"'";
      rs=db.getResult(strSQL);
     boolean isexist = false;
     try {
       isexist = rs.first();
     }
     catch (SQLException ex1) {
     }
     if (!isexist){
      JOptionPane.showMessageDialog(this, "图书馆中没有这本书！");
      jTextFieldName.setText("");
      return;
    }
    else{
      tempvector = new Vector(1, 1);
      //若存在，执行以下操作
      //清空model中的对象
      for (int n = model.getRowCount() - 1; n >= 0; n--)
        model.removeRow(n);
      try {
        rs.beforeFirst();
        while (rs.next()) {
          tempvector = new Vector(1, 1);
          tempvector.add(String.valueOf(rs.getInt("tag")));
          tempvector.add(rs.getString("ISBN"));
          tempvector.add(rs.getString("书名"));
          tempvector.add(rs.getString("索书号"));
          tempvector.add(rs.getString("出版社"));
          tempvector.add(rs.getString("是否可借"));
          model.addRow(tempvector);
        }
      }
      catch (SQLException ex) {
        JOptionPane.showMessageDialog(this, "ex.toString() :" + ex.toString());
      }
    }







    }
    if(type.equals("按书名")){

    }


  }

  public void jComboBoxType_actionPerformed(ActionEvent e) {
    type=(String)jComboBoxType.getSelectedItem().toString().trim();
  }
}