/*
 * ServiceFrame.java
 *
 * Created on 2007年1月19日, 上午5:48
 */

package javaapplication1;
import java.awt.Toolkit;
import java.sql.*;
import java.util.*;
import javax.swing.table.DefaultTableModel;
import javax.swing.*;

/**
 *
 * @author  lab
 */
public class ServiceFrame extends javax.swing.JFrame {
    String staffID = "";
    /** Creates new form ServiceFrame */
    public ServiceFrame(String ID) {
        this.staffID = ID;
        connectDB();
        init();
        initComponents();
        this.setTitle("服務管理");
        //-------設置窗口位置居中---------------------------------------------------------------        
        int locationX=(int)(Toolkit.getDefaultToolkit().getScreenSize().getWidth()-getSize().getWidth())/2; 
        int locationY=(int)(Toolkit.getDefaultToolkit().getScreenSize().getHeight()-getSize().getHeight())/2;
        setLocation(locationX,locationY);
        //--------------------------------------------------------------------------------------
    }
    
    /** This method is called from within the constructor to
     * initialize the form.
     * WARNING: Do NOT modify this code. The content of this method is
     * always regenerated by the Form Editor.
     */
    // <editor-fold defaultstate="collapsed" desc=" 生成的代碼 ">//GEN-BEGIN:initComponents
    private void initComponents() {
        jTabbedPane4 = new javax.swing.JTabbedPane();
        jScrollPane2 = new javax.swing.JScrollPane();
        accountTable = new javax.swing.JTable();
        jScrollPane3 = new javax.swing.JScrollPane();
        bankCardTable = new javax.swing.JTable();
        jScrollPane4 = new javax.swing.JScrollPane();
        netMemberTable = new javax.swing.JTable();
        jScrollPane1 = new javax.swing.JScrollPane();
        depositorTable = new javax.swing.JTable();
        jScrollPane5 = new javax.swing.JScrollPane();
        rateTable = new javax.swing.JTable();
        jMenuBar1 = new javax.swing.JMenuBar();
        jMenu1 = new javax.swing.JMenu();
        newAccount = new javax.swing.JMenuItem();
        newBankCard = new javax.swing.JMenuItem();
        jMenu2 = new javax.swing.JMenu();
        setPassword = new javax.swing.JMenu();
        setAccountPassword = new javax.swing.JMenuItem();
        setOperatePassword = new javax.swing.JMenuItem();
        setBankCardPassword = new javax.swing.JMenuItem();
        setRate = new javax.swing.JMenuItem();
        jMenu3 = new javax.swing.JMenu();
        currentDeposit = new javax.swing.JMenuItem();
        fixedDeposit = new javax.swing.JMenuItem();
        jMenu4 = new javax.swing.JMenu();
        currentFetch = new javax.swing.JMenuItem();
        fixedFetch = new javax.swing.JMenuItem();
        jMenu5 = new javax.swing.JMenu();
        transfer = new javax.swing.JMenuItem();
        jMenu6 = new javax.swing.JMenu();
        accountLost = new javax.swing.JMenuItem();
        bankCardLost = new javax.swing.JMenuItem();
        jMenu7 = new javax.swing.JMenu();
        jMenu8 = new javax.swing.JMenu();
        cancelAccountLost = new javax.swing.JMenuItem();
        cancelBankCardLost = new javax.swing.JMenuItem();
        deleteAccount = new javax.swing.JMenuItem();
        deleteBankCard = new javax.swing.JMenuItem();

        setDefaultCloseOperation(javax.swing.WindowConstants.EXIT_ON_CLOSE);
        jTabbedPane4.addChangeListener(new javax.swing.event.ChangeListener() {
            public void stateChanged(javax.swing.event.ChangeEvent evt) {
                jTabbedPane4StateChanged(evt);
            }
        });

        accountTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "帳號", "帳號狀態", "帳號類型", "帳號余額", "利息", "開戶日期"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane2.setViewportView(accountTable);

        jTabbedPane4.addTab("\u5e10\u6237\u4fe1\u606f", jScrollPane2);

        bankCardTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null},
                {null, null, null, null}
            },
            new String [] {
                "卡號", "卡狀態", "帳號", "發卡日期"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane3.setViewportView(bankCardTable);

        jTabbedPane4.addTab("\u501f\u8bb0\u5361\u4fe1\u606f", jScrollPane3);

        netMemberTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null},
                {null, null, null, null, null, null}
            },
            new String [] {
                "用戶名", "銀行帳號", "住址", "固定電話", "移動電話", "郵箱"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane4.setViewportView(netMemberTable);

        jTabbedPane4.addTab("\u7f51\u4e0a\u50a8\u6237\u4fe1\u606f", jScrollPane4);

        depositorTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null},
                {null, null, null, null, null}
            },
            new String [] {
                "姓名", "性別", "證件號", "地址", "電話"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false, false, false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane1.setViewportView(depositorTable);

        jTabbedPane4.addTab("\u50a8\u6237\u4fe1\u606f", jScrollPane1);

        rateTable.setModel(new javax.swing.table.DefaultTableModel(
            new Object [][] {
                {null, null},
                {null, null},
                {null, null},
                {null, null}
            },
            new String [] {
                "存款年限", "利率"
            }
        ) {
            boolean[] canEdit = new boolean [] {
                false, false
            };

            public boolean isCellEditable(int rowIndex, int columnIndex) {
                return canEdit [columnIndex];
            }
        });
        jScrollPane5.setViewportView(rateTable);

        jTabbedPane4.addTab("\u5229\u7387", jScrollPane5);

        jMenu1.setText("\u65b0\u5efa");
        newAccount.setText("\u5e10\u53f7");
        newAccount.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                newAccountActionPerformed(evt);
            }
        });

        jMenu1.add(newAccount);

        newBankCard.setText("\u501f\u8bb0\u5361");
        newBankCard.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                newBankCardActionPerformed(evt);
            }
        });

        jMenu1.add(newBankCard);

        jMenuBar1.add(jMenu1);

        jMenu2.setText("\u8bbe\u7f6e");
        jMenu2.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                jMenu2ActionPerformed(evt);
            }
        });

        setPassword.setText("\u5e10\u53f7\u5bc6\u7801");
        setAccountPassword.setText("\u4fee\u6539\u94f6\u884c\u5e10\u53f7");
        setAccountPassword.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                setAccountPasswordActionPerformed(evt);
            }
        });

        setPassword.add(setAccountPassword);

        setOperatePassword.setText("\u4fee\u6539\u64cd\u4f5c\u5e10\u53f7");
        setOperatePassword.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                setOperatePasswordActionPerformed(evt);
            }
        });

        setPassword.add(setOperatePassword);

        jMenu2.add(setPassword);

        setBankCardPassword.setText("\u4fee\u6539\u501f\u8bb0\u5361\u5bc6\u7801");
        setBankCardPassword.addActionListener(new java.awt.event.ActionListener() {
            public void actionPerformed(java.awt.event.ActionEvent evt) {
                setBankCardPasswordActionPerformed(evt);
            }