//圖書刪除條件
import java.awt.*;
import javax.swing.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;

public class DeleteBook extends JFrame implements ActionListener
{   private JLabel MoneyLabel,ViewLabel;
	private JTextField MoneyTextField;
	private JRadioButton YesBtn,NoBtn;
	private ButtonGroup choice;
	private JButton ModifyBtn,CancelBtn;
    private JPanel panel;
	private JFrame frame;
	private Connection con;
    private Statement stmt;
    private String yesORno;
    private Book bookr;
	public DeleteBook(Book bookr)
	{   JFrame.setDefaultLookAndFeelDecorated(true);
	    frame=new JFrame("圖書資料刪除");
	    Font font1=new Font("宋體",Font.PLAIN,13);
	    Container content=frame.getContentPane();
	    content.setLayout(null);
	    ImageIcon icon=new ImageIcon("images/home.gif");
	    frame.setIconImage(icon.getImage());
        frame.setResizable(false);
        this.bookr=bookr;

        //--初始化各個組件--
		MoneyLabel=new JLabel("請輸入信息:");
		ViewLabel=new JLabel("請選擇條件:");

        choice=new ButtonGroup();
        YesBtn=new JRadioButton("圖書編號");
        YesBtn.setSelected(true);
        choice.add(YesBtn);
        NoBtn=new JRadioButton("條形碼");
        choice.add(NoBtn);

		MoneyTextField=new JTextField();

		ModifyBtn=new JButton("查 詢");
		CancelBtn=new JButton("取 消");

		//--設置各個組件的事件--
        ModifyBtn.addActionListener(this);
		CancelBtn.addActionListener(this);
		YesBtn.addActionListener(this);
		NoBtn.addActionListener(this);

        //--設置各個組件的大小和位置--
        MoneyLabel.setBounds(10,15,100,25);
        MoneyTextField.setBounds(110,15,150,25);
        ViewLabel.setBounds(10,50,100,25);
        YesBtn.setBounds(105,50,90,25);
		NoBtn.setBounds(190,50,80,25);
        ModifyBtn.setBounds(40,90,80,25);
        CancelBtn.setBounds(160,90,80,25);

        //--設置各個組件的字體--
        MoneyLabel.setFont(font1);
        MoneyTextField.setFont(font1);
	    ViewLabel.setFont(font1);
	    YesBtn.setFont(font1);
		NoBtn.setFont(font1);
		ModifyBtn.setFont(font1);
		CancelBtn.setFont(font1);

        //--添加各個組件--
        panel=new JPanel();
        panel.setLayout(null);
        panel.setBorder(
			 	 		 BorderFactory.createCompoundBorder(
			 	 		 BorderFactory.createEtchedBorder(),
	                     BorderFactory.createLoweredBevelBorder()));
	    panel.setBounds(10,10,280,130);
		panel.add(MoneyLabel);
		panel.add(MoneyTextField);
	    panel.add(ViewLabel);
	    panel.add(YesBtn);
	    panel.add(NoBtn);
		panel.add( ModifyBtn);
		panel.add(CancelBtn);
		content.add(panel);

        //--初始化窗體--
		frame.pack();
		frame.setLocationRelativeTo(null);
		frame.setBounds(400,150,305,180);
		frame.setVisible(true);
	}

	public void actionPerformed(ActionEvent e)
	{  Object obj=e.getSource();
	  if(obj==CancelBtn)
	    { int m=JOptionPane.showConfirmDialog(this, "您確定要放棄刪除圖書資料嗎？", "確認對話框",JOptionPane.YES_NO_OPTION);
		  if(m==JOptionPane.YES_OPTION)
		  {frame.dispose();}
        }
	  if(obj== ModifyBtn)
	    { try{ DeleteBook1();}
	      catch(SQLException ed){}
         }
	}

    public void DeleteBook1() throws SQLException
    { int i,j,k;
	  String fajin=MoneyTextField.getText().trim();
      String tsmc,bh,txm,flf,zz,lx,jg,cbs,ym,sjmc,cbrq,rkrq,kcl,jycs,tszt,czy,zy;
      String strurl =
	  	             "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
	  try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
	  catch (ClassNotFoundException e) {}
	  con= DriverManager.getConnection(strurl);
	  Statement stmt = con.createStatement();
	  ResultSet rs = stmt.executeQuery("select * from 圖書資料 ");
	  while(rs.next())
	  { tsmc=rs.getString("圖書名稱");bh=rs.getString("編號");txm=rs.getString("條形碼");
	    flf=rs.getString("分類法");zz=rs.getString("作者");lx=rs.getString("類型");
	    jg=rs.getString("價格");cbs=rs.getString("出版社");ym=rs.getString("頁碼");
	    sjmc=rs.getString("書架名稱");cbrq=String.valueOf(rs.getDate("出版日期"));
	    rkrq=String.valueOf(rs.getDate("入庫日期"));kcl=rs.getString("庫存量");jycs=rs.getString("借閱次數(shù)");
	    tszt=rs.getString("圖書狀態(tài)");czy=rs.getString("操作員");zy=rs.getString("摘要");
	    if(YesBtn.isSelected())
		{if(bh.equals(fajin))
		 {bookr.jtfd1.setText(tsmc);bookr.jtfd2.setText(bh);bookr.jtfd3.setText(txm);
		  bookr.jtfd6.setText(flf);bookr.jtfd5.setText(zz);
		  bookr.jtfd7.setText(jg);bookr.jtfd9.setText(ym);
		  bookr.jtfd11.setText(cbrq);bookr.jtfd12.setText(rkrq);
		  bookr.jtfd13.setText(kcl);bookr.jtfd14.setText(czy);bookr.jta.setText(zy);
		  for(i=0;i<=bookr.jtfd4.getItemCount();i++)
		  		  {if(lx.equals((String)bookr.jtfd4.getItemAt(i)))
		  		   {bookr.jtfd4.setSelectedIndex(i);}
		  		   i++;
		  	      }
		  	      for(j=0;j<=bookr.jtfd8.getItemCount();j++)
		  	      {if(cbs.equals((String)bookr.jtfd8.getItemAt(j)))
		  		  		   {bookr.jtfd8.setSelectedIndex(j);}
		  		  		   j++;
		  	      }
		  	      for(k=0;k<=bookr.jtfd10.getItemCount();k++)
		  	      {if(sjmc.equals((String)bookr.jtfd10.getItemAt(k)))
		  		  		   {bookr.jtfd10.setSelectedIndex(k);}
		  		  		   k++;
	      }
		  bookr.btn5.setVisible(true);
          bookr.btn6.setVisible(false);
		 }
		}
		if(NoBtn.isSelected())
	    { if(txm.equals(fajin))
		 {bookr.jtfd1.setText(tsmc);bookr.jtfd2.setText(bh);bookr.jtfd3.setText(txm);
		  bookr.jtfd6.setText(flf);bookr.jtfd5.setText(zz);bookr.jtfd7.setText(jg);
		  bookr.jtfd9.setText(ym);bookr.jtfd11.setText(cbrq);bookr.jtfd12.setText(rkrq);
		  bookr.jtfd13.setText(kcl);bookr.jtfd14.setText(czy);bookr.jta.setText(zy);
		  for(i=0;i<=bookr.jtfd4.getItemCount();i++)
		  		  {if(lx.equals((String)bookr.jtfd4.getItemAt(i)))
		  		   {bookr.jtfd4.setSelectedIndex(i);}
		  		   i++;
		  	      }
		  	      for(j=0;j<=bookr.jtfd8.getItemCount();j++)
		  	      {if(cbs.equals((String)bookr.jtfd8.getItemAt(j)))
		  		  		   {bookr.jtfd8.setSelectedIndex(j);}
		  		  		   j++;
		  	      }
		  	      for(k=0;k<=bookr.jtfd10.getItemCount();k++)
		  	      {if(sjmc.equals((String)bookr.jtfd10.getItemAt(k)))
		  		  		   {bookr.jtfd10.setSelectedIndex(k);}
		  		  		   k++;
	      }
		  bookr.btn2.setVisible(true);
          bookr.btn7.setVisible(false);
		 }
		}
	  }

	}
}