//圖書掛失信息查詢
import java.awt.*;
import javax.swing.*;
import javax.swing.table.*;
import java.awt.event.*;
import javax.swing.event.*;
import java.sql.*;
import java.io.*;
import java.util.*;

public class NotInfomationF extends JFrame implements ActionListener
{ public JToolBar JTB;
  public JButton btn2,btn7,btn8,btn9;
  public JPanel jp1;
  public JTable jta;
  public Statement stmt,stmt1,stmt2;
  public Connection con,con1,con2;
  public JFrame frame;
  public Object rowData[][];
  private  Toolkit tool;
  private  Dimension wndsize;
  public NotInfomationF()
  	{
  		JFrame.setDefaultLookAndFeelDecorated(true);
  	    frame=new JFrame("圖書掛失信息查詢");
  	    ImageIcon icon=new ImageIcon("images/home.gif");
  	    frame.setIconImage(icon.getImage());
        frame.setResizable(false);
  	    Font font1=new Font("宋體",Font.PLAIN,15);
  		Container content=frame.getContentPane();
        content.setLayout(null);
        tool=frame.getToolkit();
	    wndsize=tool.getScreenSize();
	    int width=tool.getScreenSize().width;
		int height=tool.getScreenSize().height;

        //--初始化工具欄各個組件--
		btn2=new JButton("全部信息",new ImageIcon("images/BOOKS04.gif"));
	    btn7=new JButton("打印預覽",new ImageIcon("images/text.gif"));
		btn8=new JButton("導出數據",new ImageIcon("images/save.gif"));
	    btn9=new JButton("退出",new ImageIcon("images/ren1.gif"));

	    //--設置工具欄各個組件的提示--
		btn2.setToolTipText("查詢全部掛失圖書信息");
	    btn7.setToolTipText("打印預覽");
	    btn8.setToolTipText("導出數據");
	    btn9.setToolTipText("退出");

	    //--為工具欄中各個組件添加事件--
	    btn2.addActionListener(this);
	    btn7.addActionListener(this);
		btn8.addActionListener(this);
	    btn9.addActionListener(this);

	    //--為工具欄中各個組件設置字體--
		btn2.setFont(font1);
		btn7.setFont(font1);
		btn8.setFont(font1);
		btn9.setFont(font1);

        //--添加工具欄各個組件--
        JTB=new JToolBar();
	    JTB.addSeparator();
		JTB.addSeparator();
		JTB.add(btn2);
		JTB.addSeparator();
	    JTB.add(btn7);
	    JTB.add(btn8);
	    JTB.addSeparator();
	    JTB.add(btn9);
	    JTB.setFont(font1);

	    JTB.setFloatable(false);
		JTB.setBorder(BorderFactory.createLoweredBevelBorder());
        JTB.setBounds(0,2,width-10,45);

        //--初始化基本設置各個組件--
        Object columnNames[]={"圖書編號","圖書條形碼","圖書名稱","讀者編號","讀者條形碼","讀者姓名","丟失數量","丟失時間","是否超期","超期天數","每日罰金","罰款總計","賠償金額","操作員"};
		rowData=new Object[100][14];
        jta=new JTable(rowData,columnNames);
        jta.setRowHeight(20);
        jta.setAutoResizeMode(JTable.AUTO_RESIZE_OFF);
        try{ view();}
	    catch(SQLException ed){}
        jta.setPreferredScrollableViewportSize(new Dimension(500,30));
		JScrollPane scrollPane=new JScrollPane(jta,
		                       JScrollPane.VERTICAL_SCROLLBAR_ALWAYS,
		                       JScrollPane.HORIZONTAL_SCROLLBAR_ALWAYS);

		//--設置各個組件的大小和位置--
		jta.setBounds(10,25,1000,height-140);
        scrollPane.setBounds(10,25,width-40,height-115);

		//--設置各個組件的字體--
		jta.setFont(font1);

		//--將各個組件添加到容器中--
		jp1=new JPanel();
		jp1.setLayout(null);
		jp1.add(scrollPane);
		jp1.setBorder(
			 	 	  BorderFactory.createCompoundBorder(
			 	 	  BorderFactory.createTitledBorder("查詢結果"),
	                  BorderFactory.createLoweredBevelBorder()));
        jp1.setBounds(8,45,width-20,height-80);

	    //--把各個組件添加到窗口中--
        content.add(JTB);
        content.add(jp1);
        frame.setSize(wndsize);
		frame.setLocationRelativeTo(null);
		frame.setVisible(true);
	}
	public void actionPerformed(ActionEvent e)
	{ Object obj=e.getSource();
	  if(obj==btn2)//全部信息按鈕事件
	  {try{ view();}
	   catch(SQLException ed){System.err.println(ed);}
	  }
	  if(obj==btn7)//打印預覽按鈕事件
	  {}
	  if(obj==btn8)//導出數據按鈕事件
	  {}
	  if(obj==btn9)//退出按鈕事件
	  {frame.dispose();}
	}

    public void view() throws SQLException
    { //--連接表格和數據庫--
                String frbh,frtxm,frname,fbbh,fbtxm,fbname,fcount,fdate,flate,fdays,fday,ftotal,fmoney,fzcy;
				int i=0;
				try{
					String strurl1 =
								    "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
					try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");}
					catch (ClassNotFoundException eg) {}
					con= DriverManager.getConnection(strurl1);
					stmt= con.createStatement();
					ResultSet rs = stmt.executeQuery("select * from 掛失圖書 ORDER BY 讀者編號");
					while(rs.next())
					{fbbh=rs.getString("圖書編號");fbtxm=rs.getString("圖書條形碼");fbname=rs.getString("圖書名稱");
				     frbh=rs.getString("讀者編號");frtxm=rs.getString("讀者條形碼");frname=rs.getString("讀者姓名");
	 		         fcount=rs.getString("丟失數量");fdate=rs.getString("丟失時間");flate=rs.getString("是否超期");
	 		         fdays=rs.getString("超期天數");fday=rs.getString("每日罰金");ftotal=rs.getString("罰款總計");
	 		         fmoney=rs.getString("賠償金額");fzcy=rs.getString("操作員");

					 rowData[i][0]=fbbh;rowData[i][1]=fbtxm;rowData[i][2]=fbname;
					 rowData[i][3]=frbh;rowData[i][4]=frtxm;rowData[i][5]=frname;rowData[i][6]=fcount;
					 rowData[i][7]=fdate;rowData[i][8]=flate;rowData[i][9]=fdays; rowData[i][10]=fday;
					 rowData[i][11]=ftotal;rowData[i][12]=fmoney;rowData[i][13]=fzcy;
					 i++;
		             }
		             jta.repaint();
	                 con.close();
				    }
				catch(Exception es){//JOptionPane.showMessageDialog(null, "數據庫中沒有成績信息", "警告",
							                                   //JOptionPane.WARNING_MESSAGE);
								es.printStackTrace();}
	}

	public static void main(String[]args)
		{   try {
		            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
		            }
		        catch(Exception e) {
		            e.printStackTrace();
		           }
			new NotInfomationF();
	}
}