package zcgl;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import javax.swing.BorderFactory;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import java.sql.ResultSet;
import java.sql.*;

public class ZcLbView extends JFrame {
    public ZcLbView() {
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        jPanel1.setBorder(BorderFactory.createEtchedBorder());
        jPanel1.setBounds(new Rectangle(68, 51, 276, 172));
        jPanel1.setLayout(null);
        jLabel2.setText("主類名稱");
        jLabel2.setBounds(new Rectangle(41, 58, 51, 19));
        txtZlName.setBounds(new Rectangle(106, 56, 107, 19));
        jLabel3.setText("子類編號");
        jLabel3.setBounds(new Rectangle(41, 91, 53, 24));
        txtSubId.setBounds(new Rectangle(106, 90, 107, 21));
        jLabel4.setText("子類名稱");
        jLabel4.setBounds(new Rectangle(41, 128, 57, 23));
        txtSubName.setBounds(new Rectangle(106, 125, 107, 24));
        btnAdd.setBounds(new Rectangle(57, 245, 69, 27));
        btnAdd.setText("添加");
        btnAdd.addActionListener(new ZcLbView_btnAdd_actionAdapter(this));
        btnDel.setBounds(new Rectangle(128, 246, 69, 27));
        btnDel.setText("刪除");
        btnDel.addActionListener(new ZcLbView_btnDel_actionAdapter(this));
        btnModify.setBounds(new Rectangle(199, 245, 69, 27));
        btnModify.setText("修改");
        btnModify.addActionListener(new ZcLbView_btnModify_actionAdapter(this));
        jButton1.setBounds(new Rectangle(271, 245, 69, 27));
        jButton1.setText("查詢");
        jButton1.addActionListener(new ZcLbView_jButton1_actionAdapter(this));
        this.getContentPane().add(jPanel1);
        txtZlId.setBounds(new Rectangle(106, 24, 107, 19));
        jPanel1.add(txtZlId);
        jPanel1.add(jLabel1);
        jPanel1.add(jLabel2);
        jPanel1.add(txtZlName);
        jPanel1.add(jLabel3);
        jPanel1.add(txtSubId);
        jPanel1.add(txtSubName);
        jPanel1.add(jLabel4);
        this.getContentPane().add(btnDel);
        this.getContentPane().add(btnAdd);
        this.getContentPane().add(btnModify);
        this.getContentPane().add(jButton1);
        jLabel1.setBounds(new Rectangle(41, 27, 67, 15));
        jLabel1.setText("主類編號");
    }

    JPanel jPanel1 = new JPanel();
    JLabel jLabel1 = new JLabel();
    JTextField txtZlId = new JTextField();
    JLabel jLabel2 = new JLabel();
    JTextField txtZlName = new JTextField();
    JLabel jLabel3 = new JLabel();
    JTextField txtSubId = new JTextField();
    JLabel jLabel4 = new JLabel();
    JTextField txtSubName = new JTextField();
    JButton btnAdd = new JButton();
    JButton btnDel = new JButton();
    JButton btnModify = new JButton();
    JButton jButton1 = new JButton();
    public void btnAdd_actionPerformed(ActionEvent e) {
        ZcLbBean bean = new ZcLbBean();
        bean.setZlId(Integer.parseInt(txtZlId.getText()));
        bean.setZlName(txtZlName.getText());
        bean.setSubId(Integer.parseInt(txtSubId.getText()));
        bean.setSubName(txtSubName.getText());
        if (bean.insert()) {
            JOptionPane.showMessageDialog(this, "插入成功！");
        } else {
            JOptionPane.showMessageDialog(this, "插入失敗！");
        }

    }

    public void btnDel_actionPerformed(ActionEvent e) {
        ZcLbBean bean = new ZcLbBean();
        bean.setZlId(Integer.parseInt(txtZlId.getText()));
        if (bean.isNull()) {
            JOptionPane.showMessageDialog(this, "沒有此記錄！");
            return;
        }

        if (bean.del()) {
            JOptionPane.showMessageDialog(this, "刪除成功！");
        } else {
            JOptionPane.showMessageDialog(this, "刪除失敗！");
        }

    }

    public void btnModify_actionPerformed(ActionEvent e) {
        ZcLbBean bean = new ZcLbBean();
        bean.setZlId(Integer.parseInt(txtZlId.getText()));
        bean.setZlName(txtZlName.getText());
        bean.setSubId(Integer.parseInt(txtSubId.getText()));
        bean.setSubName(txtSubName.getText());
        if (bean.isNull()) {
           JOptionPane.showMessageDialog(this, "沒有此記錄！");
           return;
       }

        if (bean.modify()) {
            JOptionPane.showMessageDialog(this, "修改成功！");
        } else {
            JOptionPane.showMessageDialog(this, "修改失敗！");
        }

    }

    public void jButton1_actionPerformed(ActionEvent e) {
        ResultSet rs=null;
       rs= new DbCon().execute("select * from CATEGORY where cateid="+txtZlId.getText());
    try {
        if (rs.next()) {
            txtZlName.setText(rs.getString("catename").trim());
            txtSubId.setText(String.valueOf(rs.getInt("subcateid")));
            txtSubName.setText(rs.getString("subcatename").trim());

        }
    } catch (SQLException ex) {
    }

   }


}


class ZcLbView_jButton1_actionAdapter implements ActionListener {
    private ZcLbView adaptee;
    ZcLbView_jButton1_actionAdapter(ZcLbView adaptee) {
        this.adaptee = adaptee;
    }

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


class ZcLbView_btnModify_actionAdapter implements ActionListener {
    private ZcLbView adaptee;
    ZcLbView_btnModify_actionAdapter(ZcLbView adaptee) {
        this.adaptee = adaptee;
    }

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


class ZcLbView_btnDel_actionAdapter implements ActionListener {
    private ZcLbView adaptee;
    ZcLbView_btnDel_actionAdapter(ZcLbView adaptee) {
        this.adaptee = adaptee;
    }

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


class ZcLbView_btnAdd_actionAdapter implements ActionListener {
    private ZcLbView adaptee;
    ZcLbView_btnAdd_actionAdapter(ZcLbView adaptee) {
        this.adaptee = adaptee;
    }

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