chaxunjmlistener.java

java+sql 图书管理系统

package MyLibraryok.books.untitled1;

import java.awt.event.ActionListener;
import java.awt.event.ActionEvent;
import java.awt.event.*;
import java.sql.*;
import MyLibraryok.Mydb.Mydb;


/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2006</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
public class ChaXunJMListener implements ActionListener, ItemListener {
    ChaXunJM chx;
    public ChaXunJMListener(ChaXunJM chx) {
      this.chx = chx;
        try {
            jbInit();
        } catch (Exception ex) {
            ex.printStackTrace();
        }
    }




//    public void bookd(String book1) {
//try {
//tu1.list.clear();
//Mydb mydb = new Mydb();
//ResultSet re = mydb.sqlcha(book1);
//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));
//   array.add(re.getString(9));
//   array.add(re.getString(10));
//   array.add(re.getString(11));
//   array.add(re.getString(12));
//
//   tu1.list.add(array);
//   tu1.modle.fireTableDataChanged();
//}
//} catch (SQLException ex) {
//}
//
//}

    public void actionPerformed(ActionEvent e) {

            TushuManage tu1 = chx.tushuma;

            if (e.getSource() == chx.jButton1) {


                String chx1 = "select *from books where 图书编号='" +
                              chx.jTextField1.getText() + "' or 作者='" +
                              chx.jTextField2.getText() + "'or 条形码='" +
                              chx.jTextField3.getText() + "'or 图书名称='" +
                              chx.jTextField4.getText() + "'or 定价='" +
                              chx.jTextField5.getText() + "'or 存放位置='" +
                              chx.jTextField6.getText() + "'or 类别='" +
                              chx.jTextField7.getText() + "'or 借出图书='" +
                              chx.jTextField8.getText() + "'or 库存图书='" +
                              chx.jTextField9.getText() + "'";
            System.out.println(chx1);
              tu1.bookdo(chx1);
              System.out.println("6015950905");

                try {
                    Mydb mydb = new Mydb();
//                tu1.bookdo(dds);
//                TushuManage tug=new TushuManage();
                    String dds ="select *from books where 图书编号='" +
                              chx.jTextField1.getText() + "' or 作者='" +
                              chx.jTextField2.getText() + "'or 条形码='" +
                              chx.jTextField3.getText() + "'or 图书名称='" +
                              chx.jTextField4.getText() + "'or 定价='" +
                              chx.jTextField5.getText() + "'or 存放位置='" +
                              chx.jTextField6.getText() + "'or 类别='" +
                              chx.jTextField7.getText() + "'or 借出图书='" +
                              chx.jTextField8.getText() + "'or 库存图书='" +
                              chx.jTextField9.getText() + "'";


                    ResultSet resul = mydb.sqlcha(dds);

                    System.out.println("168+909+");

                    while (resul.next()) {

                        //tu1.toFront();

                        //System.out.println("================"+resul.getString(1));
                        tu1.jTextBiaoHao.setText(resul.getString(1));
                        System.out.println("829485847656595418741");
                        tu1.jTextTiaoXingMa.setText(resul.getString(2));
                        tu1.jTextShuMing.setText(resul.getString(3));
                        tu1.jTextDingJia.setText(resul.getString(4));
                        tu1.jTextLeiBie.setText(resul.getString(5));
                        tu1.jTextZuoZhe.setText(resul.getString(6));
                        tu1.jTextChuBanShe.setText(resul.getString(7));
                        tu1.jTextCunFang.setText(resul.getString(8));
                        tu1.jTextKuCunTushu.setText(resul.getString(9));
                        tu1.jTextJieChunTushu.setText(resul.getString(10));
                        tu1.jTextRuKuShijian.setText(resul.getString(11));
                        tu1.jTextField1.setText(resul.getString(12));
//                        tu1.setVisible(false);
                    }
                } catch (SQLException ex1) {
                    System.out.println("kdjskjfds " + ex1.getMessage());
                }

                chx.setVisible(false);
//                tu1.dispose();

            }

    }

    public void itemStateChanged(ItemEvent e) {
        if (e.getSource() == chx.jCheckBox1) {

            chx.jTextField1.setEditable(true);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField1.setText("");
        } else if (e.getSource() == chx.jCheckBox4) {
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(true);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField2.setText("");
        } else if (e.getSource() == chx.jCheckBox3) {
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(true);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField3.setText("");
        } else if (e.getSource() == chx.jCheckBox2) {
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(true);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField4.setText("");
        } else if (e.getSource() == chx.jCheckBox7) {
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(true);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField5.setText("");
        } else if (e.getSource() == chx.jCheckBox8) {
            chx.jTextField6.setEditable(true);
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            //chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField6.setText("");
        } else if (e.getSource() == chx.jCheckBox10) {
            chx.jTextField7.setEditable(true);
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            // chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField7.setText("");
        } else if (e.getSource() == chx.jCheckBox12) {
            chx.jTextField8.setEditable(true);
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            //chx.jTextField8.setEditable(false);
            chx.jTextField9.setEditable(false);

            chx.jTextField8.setText("");
        } else if (e.getSource() == chx.jCheckBox13) {
            chx.jTextField9.setEditable(true);
            chx.jTextField1.setEditable(false);
            chx.jTextField2.setEditable(false);
            chx.jTextField3.setEditable(false);
            chx.jTextField4.setEditable(false);
            chx.jTextField5.setEditable(false);
            chx.jTextField6.setEditable(false);
            chx.jTextField7.setEditable(false);
            chx.jTextField8.setEditable(false);
            //chx.jTextField9.setEditable(false);

            chx.jTextField9.setText("");

        }

    }

    private void jbInit() throws Exception {
    }

}