package 畢業(yè)設(shè)計(jì);

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 dlgSort extends JDialog {

    JTable tblDisplay = new JTable();
    JTextField txtSort = 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 dlgSort() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(326, 471));
        tblDisplay.setBounds(new Rectangle(20, 25, 274, 281));
        tblDisplay.addMouseListener(new dlgSort_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 dlgSort_btnAdd_actionAdapter(this));
        btnExit.setBounds(new Rectangle(224, 404, 75, 28));
        btnExit.setText("退出");
        btnExit.addActionListener(new dlgSort_btnExit_actionAdapter(this));
        btnDelete.setBounds(new Rectangle(132, 405, 76, 28));
        btnDelete.setText("刪除");
        btnDelete.addActionListener(new dlgSort_btnDelete_actionAdapter(this));
        btnUpdate.setBounds(new Rectangle(223, 367, 76, 28));
        btnUpdate.setText("更新");
        btnUpdate.addActionListener(new dlgSort_btnUpdate_actionAdapter(this));
        btnSearch.setBounds(new Rectangle(19, 384, 97, 30));
        btnSearch.setText("模糊查詢");
        btnSearch.addActionListener(new dlgSort_btnSearch_actionAdapter(this));
        jScrollPane1.setBounds(new Rectangle(15, 13, 293, 300));
        this.getContentPane().add(btnDelete);
        this.getContentPane().add(btnExit);
        this.getContentPane().add(txtSort);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnSearch);
        this.getContentPane().add(btnUpdate);
        this.getContentPane().add(jScrollPane1);
        jScrollPane1.getViewport().add(tblDisplay);
        txtSort.setText("");
        txtSort.setBounds(new Rectangle(14, 324, 290, 32));
        vtColName.add("編號(hào)");
        vtColName.add("圖書類別");
        DisplayAllSort();
        tblDisplay.setAutoResizeMode(tblDisplay.AUTO_RESIZE_OFF);
        tblDisplay.getTableHeader().setReorderingAllowed(false);
    }

    public void DisplayAllSort()
    {
        SortConDB SortDB = new SortConDB();
        vt = SortDB.SearchAll();
        SortDB.CloseSortDB();
        dt = new DefaultTableModel(vt, vtColName);
        tblDisplay.setModel(dt);
    }
    public void ShowSort()
    {
        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) {
        SortConDB SortDB = new SortConDB();
        if(txtSort.getText().equals(""))
        {
            JOptionPane.showMessageDialog(this, "請(qǐng)輸入內(nèi)容");
        }
        else
        {
            vt = SortDB.SearchSort(txtSort.getText());
            SortDB.CloseSortDB();
            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(txtSort.getText().equals(""))
            JOptionPane.showMessageDialog(this, "請(qǐng)輸入一個(gè)出版社名稱!");
        else
        {
            SortConDB SortDB = new SortConDB();
            SortDB.AddSort(txtSort.getText());
            SortDB.CloseSortDB();
            DisplayAllSort();
            JOptionPane.showMessageDialog(this, "出版社添加成功!");
        }
    }

    public void btnUpdate_actionPerformed(ActionEvent e) {
        if(tblDisplay.getSelectedRow()<0)
        {
            JOptionPane.showMessageDialog(this, "請(qǐng)選擇你要更新的出版社!");
        }
        else if(txtSort.getText().equals(""))
        {
            JOptionPane.showMessageDialog(this, "請(qǐng)輸入一個(gè)出版社名稱!");
        }
        else
        {
            int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.getSelectedRow(), 0).toString());
            SortConDB SortDB = new SortConDB();
            SortDB.UpdateSort(Id, txtSort.getText());
            SortDB.CloseSortDB();
            DisplayAllSort();
            JOptionPane.showMessageDialog(this, "出版社更新成功!");
        }
    }

    public void btnDelete_actionPerformed(ActionEvent e) {
        if(tblDisplay.getSelectedRow()<0)
        {
            JOptionPane.showMessageDialog(this, "請(qǐng)選擇你要?jiǎng)h除的出版社!");
        }
        else
        {
            int Id = Integer.parseInt(tblDisplay.getValueAt(tblDisplay.getSelectedRow(), 0).toString());
            SortConDB SortDB = new SortConDB();
            SortDB.DeleteSort(Id);
            SortDB.CloseSortDB();
            DisplayAllSort();
            txtSort.setText("");
            JOptionPane.showMessageDialog(this, "刪除成功!");
        }
    }

    public void tblDisplay_mouseClicked(MouseEvent e) {
        txtSort.setText(tblDisplay.getValueAt(tblDisplay.getSelectedRow(), 1).toString());
    }

}


class dlgSort_btnDelete_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnDelete_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnUpdate_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnUpdate_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnAdd_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnAdd_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnSearch_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnSearch_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_tblDisplay_mouseAdapter extends MouseAdapter {
    private dlgSort adaptee;
    dlgSort_tblDisplay_mouseAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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


class dlgSort_btnExit_actionAdapter implements ActionListener {
    private dlgSort adaptee;
    dlgSort_btnExit_actionAdapter(dlgSort adaptee) {
        this.adaptee = adaptee;
    }

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