package mybook.book;

import java.awt.*;

import javax.swing.*;
import java.awt.Rectangle;
import java.awt.Font;
import javax.swing.BorderFactory;
import java.awt.Color;
import java.awt.event.ActionEvent;
import java.awt.event.ActionListener;
import mydbc.dbc.DBC;
import java.awt.Dimension;
import java.sql.ResultSet;
import java.sql.SQLException;

/**
 * <p>Title: </p>
 *
 * <p>Description: </p>
 *
 * <p>Copyright: Copyright (c) 2008</p>
 *
 * <p>Company: </p>
 *
 * @author not attributable
 * @version 1.0
 */
//該類用于對入庫圖書資料進(jìn)行編輯修改
public class FrBedit extends JFrame {
    int id = 0;
    JLabel lblBedit = new JLabel();
    JLabel lblBid = new JLabel();
    JLabel lblBname = new JLabel();
    JLabel lblBauthor = new JLabel();
    JLabel lblSort = new JLabel();
    JLabel lblPublisher = new JLabel();
    JLabel lblPrice = new JLabel();
    JLabel lblSsum = new JLabel();
    JLabel lblPreview = new JLabel();
    JTextField txtBname = new JTextField();
    JTextField txtBid = new JTextField();
    JTextField txtPublisher = new JTextField();
    JTextField txtPrice = new JTextField();
    JTextField txtSort = new JTextField();
    JTextField txtBsum = new JTextField();
    JTextField txtBauthor = new JTextField();
    JButton btnSure = new JButton();
    JButton btnCancel = new JButton();
    JTextArea txtBpreview = new JTextArea();
    //使用構(gòu)造方法接收圖書管理界面?zhèn)魅氲膱D書編號
    public FrBedit(int i) {
        id = i;
        try {
            jbInit();
        } catch (Exception exception) {
            exception.printStackTrace();
        }
    }

    private void jbInit() throws Exception {
        getContentPane().setLayout(null);
        setSize(new Dimension(388, 519));
        this.setTitle("圖書信息修改");
        lblBedit.setFont(new java.awt.Font("宋體", Font.BOLD, 16));
        lblBedit.setText("圖書信息修改");
        lblBedit.setBounds(new Rectangle(140, 17, 108, 32));
        lblBid.setText("圖書編號：");
        lblBid.setBounds(new Rectangle(63, 70, 60, 15));
        lblBname.setText("圖書名：");
        lblBname.setBounds(new Rectangle(63, 111, 60, 15));
        lblBauthor.setText("作者：");
        lblBauthor.setBounds(new Rectangle(63, 152, 60, 15));
        lblSort.setText("類型：");
        lblSort.setBounds(new Rectangle(63, 193, 60, 15));
        lblPublisher.setText("出版社：");
        lblPublisher.setBounds(new Rectangle(63, 234, 60, 15));
        lblPrice.setText("書價：");
        lblPrice.setBounds(new Rectangle(63, 275, 60, 15));
        lblSsum.setText("庫存量：");
        lblSsum.setBounds(new Rectangle(63, 316, 60, 15));
        lblPreview.setText("簡介：");
        lblPreview.setBounds(new Rectangle(63, 357, 60, 15));
        txtBname.setBounds(new Rectangle(155, 105, 185, 21));
        txtBid.setEnabled(false);
        txtBid.setBounds(new Rectangle(155, 64, 72, 21));
        txtPublisher.setBounds(new Rectangle(155, 228, 72, 21));
        txtPrice.setBounds(new Rectangle(155, 269, 72, 21));
        txtSort.setBounds(new Rectangle(155, 187, 72, 21));
        txtBsum.setBounds(new Rectangle(155, 310, 72, 21));
        txtBauthor.setBounds(new Rectangle(155, 146, 72, 21));
        btnSure.setBounds(new Rectangle(64, 435, 83, 25));
        btnSure.setToolTipText("");
        btnSure.setText("確定");
        btnSure.addActionListener(new FrBedit_btnSure_actionAdapter(this));
        btnCancel.setBounds(new Rectangle(196, 435, 83, 25));
        btnCancel.setText("取消");
        btnCancel.addActionListener(new FrBedit_btnCancel_actionAdapter(this));
        txtBpreview.setBorder(BorderFactory.createLineBorder(Color.black));
        txtBpreview.setBounds(new Rectangle(155, 354, 185, 61));
        this.getContentPane().add(lblBedit);
        this.getContentPane().add(lblPreview);
        this.getContentPane().add(lblPublisher);
        this.getContentPane().add(lblSort);
        this.getContentPane().add(lblBauthor);
        this.getContentPane().add(lblBname);
        this.getContentPane().add(lblSsum);
        this.getContentPane().add(lblPrice);
        this.getContentPane().add(btnSure);
        this.getContentPane().add(txtBid);
        this.getContentPane().add(lblBid);
        this.getContentPane().add(txtBname);
        this.getContentPane().add(txtBsum);
        this.getContentPane().add(txtBauthor);
        this.getContentPane().add(txtSort);
        this.getContentPane().add(txtPublisher);
        this.getContentPane().add(txtPrice);
        this.getContentPane().add(txtBpreview);
        this.getContentPane().add(btnCancel);
        this.display();
    }
    //該方法用于初始化時顯示選中的圖書信息
    public void display() {
        DBC dbc = DBC.getInstance();
        ResultSet rs = dbc.executeQuery("SELECT * FROM Books WHERE Bid =" + id);
        try {
            rs.next();
            txtBid.setText(id + "");
            txtBname.setText(rs.getString(2));
            txtBpreview.setText(rs.getString(3));
            txtSort.setText(rs.getString(4));
            txtPublisher.setText(rs.getString(5));
            txtBsum.setText(rs.getInt(6) + "");
            txtPrice.setText(rs.getInt(7) + "");
            txtBauthor.setText(rs.getString(8));
            rs.close();
        } catch (SQLException ex) {
            javax.swing.JOptionPane.showMessageDialog(this,
                    ex.getMessage().toString());
        }
    }
    //該方法用于退出修改編輯
    public void btnCancel_actionPerformed(ActionEvent e) {
        this.setVisible(false);
    }
    //該方法用于提交修改
    public void btnSure_actionPerformed(ActionEvent e) {
        DBC dbc = DBC.getInstance();
        if (dbc.executeUpdate("UPDATE Books SET Bname ='" + txtBname.getText() +
                              "',Bpreview ='" + txtBpreview.getText() +
                              "',Bsort ='" + txtSort.getText() +
                              "',Bpublisher ='" + txtPublisher.getText() +
                              "',Bsum = " + Integer.parseInt(txtBsum.getText()) +
                              ",Bprice =" + Integer.parseInt(txtPrice.getText()) +
                              ",Bauthor ='" +
                              txtBauthor.getText() + "' WHERE Bid =" + id)) {
            javax.swing.JOptionPane.showMessageDialog(this, "信息修改成功！");
            this.setVisible(false);
        } else {
            javax.swing.JOptionPane.showMessageDialog(this, "修改失敗！請重試。");
        }
    }
}


class FrBedit_btnSure_actionAdapter implements ActionListener {
    private FrBedit adaptee;
    FrBedit_btnSure_actionAdapter(FrBedit adaptee) {
        this.adaptee = adaptee;
    }

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


class FrBedit_btnCancel_actionAdapter implements ActionListener {
    private FrBedit adaptee;
    FrBedit_btnCancel_actionAdapter(FrBedit adaptee) {
        this.adaptee = adaptee;
    }

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