todayreturninfo.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.*;
import java.util.Date;
import java.text.SimpleDateFormat;

public class TodayReturnInfo extends JFrame implements ActionListener
{ public JToolBar JTB;
  public JButton btn2,btn7,btn8,btn9;
  public JLabel statusLB,statusLB1,statusLB2,statusLB3;
  public JPanel jp1,statusPane,statusPane1,statusPane2,statusPane3;
  public JTable jta;
  public Date nowTime;
  public SimpleDateFormat matter;
  public Statement stmt,stmt1,stmt2;
  public Connection con,con1,con2;
  public JFrame frame;
  public Object rowData[][];
  private  Toolkit tool;
  private  Dimension wndsize;
  public TodayReturnInfo()
  	{
  		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/BOOKS01.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[1000][12];
		        jta=new JTable(rowData,columnNames);
		        jta.setRowHeight(20);
		        jta.setAutoResizeMode(JTable.AUTO_RESIZE_SUBSEQUENT_COLUMNS);
		        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{ setnull();}
			   catch(SQLException ed){System.err.println(ed);}
			   try{ view();}
			   catch(SQLException ed){System.err.println(ed);}
			  }
			  if(obj==btn7)//打印预览按钮事件
			  {}
			  if(obj==btn8)//导出数据按钮事件
			  {}
			  if(obj==btn9)//退出按钮事件
			  {frame.dispose();}
			}
		/////////////////////设置归还图书信息表格为空///////////////////////////////////////////////////////////////////
		public void setnull() throws SQLException
		{int i=0;
		 try{
		     String strurl =
		        "jdbc:odbc:driver={Microsoft Access Driver (*.mdb)};DBQ=DataBase/Library.mdb";
		     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
		     con= DriverManager.getConnection(strurl);
		     stmt = con.createStatement();
		     ResultSet rs=stmt.executeQuery("SELECT * From 罚款统计 ");
		     while(rs.next())
		    {
		     rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
		 	 rowData[i][3]=null;rowData[i][4]=null;rowData[i][5]=null;
		 	 rowData[i][6]=null;rowData[i][7]=null;rowData[i][8]=null;
		 	 rowData[i][9]=null;rowData[i][10]=null;rowData[i][11]=null;
		 	 i++;
		 	 validate();
		    }
		    rowData[i][0]=null;rowData[i][1]=null;rowData[i][2]=null;
		   	rowData[i][3]=null;rowData[i][4]=null;rowData[i][5]=null;
		    rowData[i][6]=null;rowData[i][7]=null;rowData[i][8]=null;
		 	rowData[i][9]=null;rowData[i][10]=null;rowData[i][11]=null;
		    jta.repaint();
		   }

		catch(Exception g)
		{g.printStackTrace();}

		}
		////////////////////查询归还图书全部信息/////////////////////////////////////////////////////////////////
		    public void view() throws SQLException
		    { //--连接表格和数据库--
		           String frbh,frtxm,frname,fbbh,fbtxm,fbname,fchao,fdays,fday,ftotal,fdate,fzcy;
						int i=0;
						nowTime=new Date();
			            matter=new SimpleDateFormat("yyyy-MM-dd");
						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 罚款统计 where 罚款日期='"+matter.format(nowTime)+"' ORDER BY 读者编号");
							while(rs.next())
							{frbh=rs.getString("读者编号");frtxm=rs.getString("读者条形码");frname=rs.getString("读者姓名");
			 		         fbbh=rs.getString("图书编号");fbtxm=rs.getString("图书条形码");fbname=rs.getString("图书名称");
			 		         fchao=rs.getString("是否超期");fdays=rs.getString("超期天数");fday=rs.getString("每日罚金");ftotal=rs.getString("罚款总额");
			 		         fdate=rs.getString("罚款日期");fzcy=rs.getString("操作员");

		                     rowData[i][0]=frbh;rowData[i][1]=frtxm;rowData[i][2]=frname;
		                     rowData[i][3]=fbbh;rowData[i][4]=fbtxm;rowData[i][5]=fbname;
		 					 rowData[i][6]=fchao;rowData[i][7]=fdays;rowData[i][8]=fday;rowData[i][9]=ftotal;
		 					 rowData[i][10]=fdate;rowData[i][11]=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 TodayReturnInfo();
			}
}