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) {}
        }
    }
}