notinfomationf.java

本系统是采用JAVA作为前台开发工具

//图书挂失信息查询
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();
	}
}