chaxunlist.java

java+sql 图书管理系统

package MyLibraryok.readers;


//////////////导入相关包
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 Chaxunlist implements ActionListener {
    Jiemian jiemian;
    Mydb mydb;
    Feifa feifa;
    ///////////构造方法 //////////////
    public Chaxunlist(Jiemian jiemian) {
        this.jiemian = jiemian;
    }

    public void actionPerformed(ActionEvent e) {
        Feifa feifa = new Feifa();
        //////////查询
        if (e.getActionCommand().equals("查询")) {
            if (jiemian.jTextField7.getText().length() == 0
                && jiemian.jTextField8.getText().length() == 0) {
                JOptionPane.showMessageDialog(null, "请输入任一查询信息！！！", "信息提示：", 0);
                jiemian.jTextField7.requestFocus();
            } else if (jiemian.jTextField7.getText().length() > 0) { //非法判断
                if (feifa.fbianhao(jiemian.jTextField7.getText().trim())) {
                    jiemian.jTextField7.setText("");
                    jiemian.jTextField7.requestFocus();
                } else {
                    String ss = "select * from reader where 读者编号='" +
                                jiemian.jTextField7.getText() + "'";

                    chazhao(ss); //执行查找方法
                    System.out.println(ss);
                }
            }

            else if (jiemian.jTextField8.getText().length() > 0) {
                if (feifa.fname(jiemian.jTextField8.getText().trim())) {
                    jiemian.jTextField8.setText("");
                    jiemian.jTextField8.requestFocus();
                }

                else {
                    String str = "select* from reader where 读者姓名='" +
                                 jiemian.jTextField8.getText() + "'";
                    chazhao(str); //执行查找方法
                    System.out.println(str);
                }
            }
        }

        ////////////删除
        else if (e.getActionCommand().equals("删除")) {
            int a = jiemian.jTable.getSelectedRow();
            if (a != -1) { //判断是否选种
                shanchu(a); //执行删除方法
                jiemian.jTextField7.setText("");
                jiemian.jTextField8.setText("");

            } else {
                JOptionPane.showMessageDialog(null, "请选择您要删除的行！！！", "信息提示：",
                                              0);
                jiemian.jTextField7.requestFocus();
            }

        }

        ////////刷新
        else if (e.getActionCommand().equals("刷新")) {
            String ss = "select * from reader"; //////////////////调用查询方法
            chazhao(ss); //执行查找方法
            jiemian.jTextField7.setText("");
            jiemian.jTextField8.setText("");
        }
        /////////退出
        else if (e.getActionCommand().equals("退出")) {
            int s = JOptionPane.showConfirmDialog(null, "你确定要结束吗？？？",
                                                  "结束程序",
                                                  JOptionPane.YES_NO_OPTION);
            if (s == JOptionPane.YES_OPTION) { //判断是否退出

                jiemian.dispose(); //界面关闭
            }
        }

    }

////////////////////////////////////////查询方法//////////////////////////////////
    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(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));
                    jiemian.arraylist.add(array); ///////加入arraylist表格中
                    jiemian.jTable.setVisible(true); //////显示
                }
            } else {
                JOptionPane.showMessageDialog(null, "没有找到该读者！！！", "信息提示：",
                                              0);
            }
        } catch (SQLException ee) {}
    }

//////////////////////////删除方法///////////////////////////////////////////////////
    public void shanchu(int a) {
        Mydb mydb;

        int s = JOptionPane.showConfirmDialog(null, "你确实要删除吗？？？", "信息提示",
                                              JOptionPane.YES_NO_OPTION);
        if (s == JOptionPane.YES_OPTION) {
            mydb = new Mydb(); /////////SQL语句
            String ss = "delete reader where 读者姓名='" +
                        jiemian.jTextField8.getText() + "'";
            String ss1 = "delete reader where 读者编号='" +
                         jiemian.jTextField7.getText() + "'";
            String ss2 = "delete reader where 读者编号='" +
                         String.valueOf(jiemian.jTable.getValueAt(a, 0)) +
                         "'";
            try {
                mydb.sqlzen(ss);
                mydb.sqlzen(ss1);
                mydb.sqlzen(ss2);

                JOptionPane.showMessageDialog(null, "信息已删除：", "信息提示：", 0);
                jiemian.arraylist.remove(a); //刷新表格内容
                jiemian.jtablemodle.fireTableStructureChanged(); //
            } catch (SQLException sss) {}
        }
    }
}