querybook.java~13~

这是一个用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;
    }
    System.out.println(type);
    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("name"));
            tempvector.add(rs.getString("bookAdress"));
            tempvector.add(rs.getString("publisher"));
            tempvector.add(rs.getString("isBorrow"));
            model.addRow(tempvector);
          }
        }
        catch (SQLException ex) {
          JOptionPane.showMessageDialog(this, "ex.toString() :" + ex.toString());
        }
      }
    }
    if(type.equals("按书名")){

      strSQL="select tag,ISBN,name,bookAdress,publisher,isBorrow from bookADS_VIEW where name='"+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("name"));
            tempvector.add(rs.getString("bookAdress"));
            tempvector.add(rs.getString("publisher"));
            tempvector.add(rs.getString("isBorrow"));
            model.addRow(tempvector);
          }
        }
        catch (SQLException ex) {
          JOptionPane.showMessageDialog(this, "ex.toString() :" + ex.toString());
        }
      }

    }


  }

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