chaxun1.java

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

package MyLibraryok.borrow.jiemian;

//////////////导入相关包
import java.awt.event.*;
import javax.swing.JOptionPane;

import java.sql.ResultSet;
import java.sql.SQLException;
import java.util.ArrayList;
import java.sql.Statement;
import java.sql.Connection;
import javax.swing.ListSelectionModel;
import MyLibraryok.Mydb.Mydb;

public class Chaxun1
    implements ActionListener {
  BorrowFram jiemian;

  Mydb mydb;
  Feifa feifa;
  ///////////构造方法 //////////////
  public Chaxun1(BorrowFram jiemian) {
    this.jiemian = jiemian;
  }

////////////////////////////事件方法/////////////////////////////////
  public void actionPerformed(ActionEvent e) {
    feifa = new Feifa();
    //////////查找
    if (e.getActionCommand().equals("查询1")) {
      if (jiemian.jTextField3.getText().length() > 0) {
        if (jiemian.jComboBox2.getSelectedItem() == " 图 书 编 号") { //非法判断
          String ss = "select * from books where 图书编号='" +
              jiemian.jTextField3.getText() + "'";

          chazhao(ss);
          System.out.println(ss);

        }
        else if (jiemian.jComboBox2.getSelectedItem() == " 图 书 名 称") {
          String str = "select* from books where 图书名称='" +
              jiemian.jTextField3.getText() + "'";
          chazhao(str);
          System.out.println(str);
        }
        else if (feifa.fbianhao(jiemian.jTextField3.getText())) { ///////非法判断
          jiemian.jTextField3.setText("");
          jiemian.jTextField3.requestFocus();
        }
        else if (feifa.fname(jiemian.jTextField3.getText())) { ///////非法判断
          jiemian.jTextField3.setText("");
          jiemian.jTextField3.requestFocus();
        }

      }
      else if (jiemian.jTextField3.getText().length() == 0
                 ) {
          JOptionPane.showMessageDialog(null, "请输入查询信息！", "信息提示：", 0);
          jiemian.jTextField3.requestFocus();
        }

    }
  }

////////////////////////////////////////查询方法//////////////////////////////////
  public void chazhao(String s) {
    jiemian.arraylist1.clear(); //清除表格
    jiemian.jtablemodle1.fireTableStructureChanged();
    Mydb db = new Mydb();
    try {
      ResultSet resultset1 = db.sqlcha(s);
      ResultSet resultset2 = db.sqlcha(s);
      if (resultset1.next()) {
        while (resultset2.next()) { /////////////////////提取数据库的数据
          ArrayList array = new ArrayList();
          array.add(resultset2.getString(1));
          array.add(resultset2.getString(2));
          array.add(resultset2.getString(3));
          array.add(resultset2.getString(4));
          array.add(resultset2.getString(5));
          array.add(resultset2.getString(6));
          array.add(resultset2.getString(7));
          //array.add(resultset2.getString(8));
          array.add(resultset2.getString(9));
          array.add(resultset2.getString(10));
          array.add(resultset2.getString(11));
          jiemian.arraylist1.add(array); ///////加入表格
          jiemian.jTable1.setVisible(true); //////显示
        }
      }
      else {
        JOptionPane.showMessageDialog(null, "没有此图书：", "信息提示：", 0);
      }
    }
    catch (SQLException ee) {}
  }

}