chaxun.java~2~

来自「java+sql 图书管理系统」· JAVA~2~ 代码 · 共 110 行

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 Chaxun
    implements ActionListener {
  BorrowFram jiemian;

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

////////////////////////////事件方法/////////////////////////////////
  public void actionPerformed(ActionEvent e) {
    feifa = new Feifa();
    //////////查找
    if (e.getActionCommand().equals("查询2")) {
      if (jiemian.jTextField6.getText().length() > 0) {
        if (jiemian.jComboBox1.getSelectedItem() == " 读 者 编 号") { //非法判断
          String ss = "select * from jiehuan where 读者编号='" +
              jiemian.jTextField6.getText() + "'";

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

        }
        else if (jiemian.jComboBox1.getSelectedItem() == " 读 者 姓 名") {
          String str = "select* from jiehuan where 读者姓名='" +
              jiemian.jTextField6.getText() + "'";
          chazhao(str);
          System.out.println(str);
        }
        else if (jiemian.jComboBox1.getSelectedItem() == " 图 书 编 号") {
          String str = "select* from jiehuan where 图书编号='" +
              jiemian.jTextField6.getText() + "'";
          chazhao(str);
          System.out.println(str);
        }
        else if (jiemian.jComboBox1.getSelectedItem() == " 图 书 名 称") {
          String str = "select* from jiehuan where 图书名称='" +
              jiemian.jTextField6.getText() + "'";
          chazhao(str);
          System.out.println(str);
        }



        else if (feifa.fbianhao(jiemian.jTextField6.getText())) { ///////非法判断
          jiemian.jTextField6.setText("");
          jiemian.jTextField6.requestFocus();
        }
        else if (feifa.fname(jiemian.jTextField6.getText())) { ///////非法判断
          jiemian.jTextField6.setText("");
          jiemian.jTextField6.requestFocus();

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

    }
  }

////////////////////////////////////////查询方法//////////////////////////////////
  public void chazhao(String s) {
    jiemian.arraylist.clear(); //清除表格
    jiemian.jtablemodle.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(2));
        //array.add(resultset2.getString(3));
          array.add(resultset2.getString(4));
          array.add(resultset2.getString(6));
          array.add(resultset2.getString(7));
          array.add(resultset2.getString(8));
          array.add(resultset2.getString(9));
          jiemian.arraylist.add(array); ///////加入表格
          jiemian.jTable2.setVisible(true); //////显示
        }
      }
      else {
        JOptionPane.showMessageDialog(null, "没有此条信息：", "信息提示：", 0);
      }
    }
    catch (SQLException ee) {}
  }

}