package 畢業設計;

import java.awt.*;
import javax.swing.*;
import javax.swing.border.TitledBorder;
import java.awt.event.ComponentEvent;
import java.awt.event.ComponentAdapter;
import javax.swing.table.*;
import java.util.Vector;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.awt.event.MouseEvent;
import java.awt.event.MouseAdapter;

public class dlgPublish extends JDialog {

    JTable tblDisplay = new JTable();
    JTextField txtPublish = new JTextField();
    JButton btnSearch = new JButton();
    JButton btnUpdate = new JButton();
    JButton btnDelete = new JButton();
    JButton btnExit = new JButton();
    JButton btnAdd = new JButton();
    DefaultTableModel dt;
    Vector vtColName = new Vector();
    Vector vt;
    JScrollPane jScrollPane1 = new JScrollPane();
    public dlgPublish() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(326, 471));
        this.setTitle("出版社維護");
        tblDisplay.setBounds(new Rectangle(20, 25, 274, 281));
        tblDisplay.addMouseListener(new dlgPublish_tblDisplay_mouseAdapter(this));
        btnSearch.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnUpdate.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAdd.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnDelete.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnExit.setFont(new java.awt.Font("Dialog", Font.PLAIN, 15));
        btnAdd.setBounds(new Rectangle(133, 368, 75, 27));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new dlgPublish_btnAdd_actionAdapter(this));
        btnExit.setBounds(new Rectangle(224, 404, 75, 28));
        btnExit.setText("退出");
        btnExit.addActionListener(new dlgPublish_btnExit_actionAdapter(this));
        btnDelete.setBounds(new Rectangle(132, 405, 76, 28));
        btnDelete.setText("刪除");
        btnDelete.addActionListener(new dlgPublish_btnDelete_actionAdapter(this));
        btnUpdate.setBounds(new Rectangle(223, 367, 76, 28));
        btnUpdate.setText("更新");
        btnUpdate.addActionListener(new dlgPublish_btnUpdate_actionAdapter(this));
        btnSearch.setBounds(new Rectangle(19, 384, 97, 30));
        btnSearch.setText("模糊查詢");
        btnSearch.addActionListener(new dlgPublish_btnSearch_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(15, 13, 293, 300));
        this.getContentPane().add(btnDelete);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(txtPublish);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnSearch);
        this.getContentPane().add(btnUpdate);
        this.getContentPane().add(jScrollPane1);
        this.setResizable(false);
        jScrollPane1.getViewport().add(tblDisplay);
        txtPublish.setText("");
        txtPublish.setBounds(new Rectangle(14, 324, 290, 32));
        vtColName.add("編號");
        vtColName.add("出版社名");
        DisplayAllPublish();
        //  tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
        tblDisplay.getTableHeader().setReorderingAllowed(false);
    }

    //***************************顯示所有出版社***********************************
     public void DisplayAllPublish() {
         PublishConDB publishDB = new PublishConDB();
         vt = publishDB.SearchAll();
         publishDB.ClosePublishDB();
         dt = new DefaultTableModel(vt, vtColName);
         tblDisplay.setModel(dt);
     }

    //***************************顯示窗口***********************************
     public void ShowPublish() {
         Dimension screenSize = Toolkit.getDefaultToolkit().getScreenSize();
         Dimension dlgSize = this.getSize();
         if (dlgSize.height > screenSize.height) {
             dlgSize.height = screenSize.height;
         }
         if (dlgSize.width > screenSize.width) {
             dlgSize.width = screenSize.width;
         }
         this.setLocation((screenSize.width - dlgSize.width) / 2,
                          (screenSize.height - dlgSize.height) / 2);
         this.setModal(true);
         this.setVisible(true);
     }

    //****************************退出按鈕事件**********************************
     public void btnExit_actionPerformed(ActionEvent e) {
         this.dispose();
     }

    //***************************查找按鈕事件***********************************
     public void btnSearch_actionPerformed(ActionEvent e) {
         PublishConDB publishDB = new PublishConDB();
         if (txtPublish.getText().equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入內容");
         } else {
             vt = publishDB.SearchPublish(txtPublish.getText());
             publishDB.ClosePublishDB();
             if (vt.size() < 1) {
                 dt = new DefaultTableModel(vt, vtColName);
                 tblDisplay.setModel(dt);
                 JOptionPane.showMessageDialog(this, "找不到記錄!");
             } else {
                 dt = new DefaultTableModel(vt, vtColName);
                 tblDisplay.setModel(dt);
             }
         }
     }

    //******************************添加按鈕事件********************************
     public void btnAdd_actionPerformed(ActionEvent e) {
         if (txtPublish.getText().equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入一個出版社名稱!");
         } else {
             PublishConDB publishDB = new PublishConDB();
             boolean Success;
             Success = publishDB.AddPublish(txtPublish.getText());
             if (!Success) {
                 publishDB.ClosePublishDB();
                 JOptionPane.showMessageDialog(this, "添加失敗!");
                 return;
             }
             publishDB.ClosePublishDB();
             DisplayAllPublish();
             JOptionPane.showMessageDialog(this, "出版社添加成功!");
         }
     }

    //******************************更新按鈕事件********************************
     public void btnUpdate_actionPerformed(ActionEvent e) {
         if (tblDisplay.getSelectedRow() < 0) {
             JOptionPane.showMessageDialog(this, "請選擇你要更新的出版社!");
         } else if (txtPublish.getText().equals("")) {
             JOptionPane.showMessageDialog(this, "請輸入一個出版社名稱!");
         } else {
             int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.
                     getSelectedRow(), 0).toString());
             PublishConDB publishDB = new PublishConDB();
             boolean Success;
             Success = publishDB.UpdatePublish(Id, txtPublish.getText());
             if (!Success) {
                 publishDB.ClosePublishDB();
                 JOptionPane.showMessageDialog(this, "更新失敗!");
                 return;
             }
             publishDB.ClosePublishDB();
             DisplayAllPublish();
             JOptionPane.showMessageDialog(this, "出版社更新成功!");
         }
     }

    //*****************************刪除按鈕事件*********************************
     public void btnDelete_actionPerformed(ActionEvent e) {
         if (tblDisplay.getSelectedRow() < 0) {
             JOptionPane.showMessageDialog(this, "請選擇你要刪除的出版社!");
         } else {
             int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.
                     getSelectedRow(), 0).toString());
             PublishConDB publishDB = new PublishConDB();
             publishDB.DeletePublish(Id);
             publishDB.ClosePublishDB();
             DisplayAllPublish();
             txtPublish.setText("");
             JOptionPane.showMessageDialog(this, "刪除成功!");
         }
     }

    //*****************************鼠標點擊表格事件*********************************
     public void tblDisplay_mouseClicked(MouseEvent e) {
         txtPublish.setText(tblDisplay.getValueAt(tblDisplay.getSelectedRow(),
                                                  1).toString());
     }
}


class dlgPublish_btnDelete_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnDelete_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnDelete_actionPerformed(e);
    }
}


class dlgPublish_btnUpdate_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnUpdate_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnUpdate_actionPerformed(e);
    }
}


class dlgPublish_btnAdd_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnAdd_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnAdd_actionPerformed(e);
    }
}


class dlgPublish_btnSearch_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnSearch_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnSearch_actionPerformed(e);
    }
}


class dlgPublish_tblDisplay_mouseAdapter extends MouseAdapter {
    private dlgPublish adaptee;
    dlgPublish_tblDisplay_mouseAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void mouseClicked(MouseEvent e) {
        adaptee.tblDisplay_mouseClicked(e);
    }
}


class dlgPublish_btnExit_actionAdapter implements ActionListener {
    private dlgPublish adaptee;
    dlgPublish_btnExit_actionAdapter(dlgPublish adaptee) {
        this.adaptee = adaptee;
    }

    public void actionPerformed(ActionEvent e) {
        adaptee.btnExit_actionPerformed(e);
    }
}