borrowbook.java

JAVA编写的图书馆管理系统

					rowData1[i][0]=dzxm;
					rowData1[i][1]=dzbh;
					rowData1[i][2]=txm;
					rowData1[i][3]=xb;
					rowData1[i][4]=sf;
				    rowData1[i][5]=yxzj;
					rowData1[i][6]=zjhm;
					rowData1[i][7]=zcrq;
					rowData1[i][8]=zxrq;
					rowData1[i][9]=csrq;
					rowData1[i][10]=lxdh;
					rowData1[i][11]=lxdz;
					rowData1[i][12]=dzzt;
					rowData1[i][13]=zcqx;
					rowData1[i][14]=jycs;
					rowData1[i][15]=czy;
					i++;
				}
				jta1.repaint();
				con.close();
			  }
			  catch(Exception es)
			  {es.printStackTrace();}
	   }
/////////////////////设置图书资料表格为空///////////////////////////////////////////////////////////////////
public void setnull1() 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;
 	 rowData[i][12]=null;rowData[i][13]=null;rowData[i][14]=null;
 	 rowData[i][15]=null;rowData[i][16]=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;
 	rowData[i][12]=null;rowData[i][13]=null;rowData[i][14]=null;
 	rowData[i][15]=null;rowData[i][16]=null;
    jta.repaint();
   }

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

}
//查询图书资料代码///////////////////////////////////////////////////////////////////////
    public void Query1() throws SQLException
    { int i=0;
	  String fajin=jtf13.getText().trim();
      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 rs1 = stmt.executeQuery("select * from 图书资料 ORDER BY 编号");
	  while(rs1.next())
	  { String bookname=rs1.getString(1);
		String bianhao=rs1.getString(2);
		String bookcode=rs1.getString(3);
		String fenlei=rs1.getString(4);
		String zuozhe=rs1.getString(5);
		String type=rs1.getString(6);
		String price=rs1.getString(7);
		String press=rs1.getString(8);
		String page=rs1.getString(9);
		String sheefname=rs1.getString(10);
		String chuban=rs1.getString(11);
		String ruku=rs1.getString(12);
		String stock=rs1.getString(13);
		String borrow=rs1.getString(14);
		String status=rs1.getString(15);
		String oparator=rs1.getString(16);
		String key=rs1.getString(17);
	    if(jtf14.getSelectedIndex()==0)
		{if(fenlei.equals(fajin))
		 {rowData[i][0]=bookname;
		  rowData[i][1]=bianhao;
		  rowData[i][2]=bookcode;
		  rowData[i][3]=fenlei;
		  rowData[i][4]=zuozhe;
		  rowData[i][5]=type;
		  rowData[i][6]=price;
		  rowData[i][7]=press;
		  rowData[i][8]=page;
	      rowData[i][9]=sheefname;
		  rowData[i][10]=chuban;
		  rowData[i][11]=ruku;
		  rowData[i][12]=stock;
		  rowData[i][13]=borrow;
		  rowData[i][14]=status;
		  rowData[i][15]=oparator;
		  rowData[i][16]=key;
		  i++;
		 }
		 jta.repaint();
		}
		if(jtf14.getSelectedIndex()==1)
	    { if(bookcode.equals(fajin))
		 {
		  rowData[i][0]=bookname;
		  rowData[i][1]=bianhao;
		  rowData[i][2]=bookcode;
		  rowData[i][3]=fenlei;
		  rowData[i][4]=zuozhe;
		  rowData[i][5]=type;
		  rowData[i][6]=price;
		  rowData[i][7]=press;
	      rowData[i][8]=page;
		  rowData[i][9]=sheefname;
		  rowData[i][10]=chuban;
		  rowData[i][11]=ruku;
		  rowData[i][12]=stock;
		  rowData[i][13]=borrow;
		  rowData[i][14]=status;
		  rowData[i][15]=oparator;
		  rowData[i][16]=key;
		  i++;
		 }
		 jta.repaint();
		}
		if(jtf14.getSelectedIndex()==2)
		{ if(bookname.equals(fajin))
		 {
		  rowData[i][0]=bookname;
		  rowData[i][1]=bianhao;
		  rowData[i][2]=bookcode;
		  rowData[i][3]=fenlei;
		  rowData[i][4]=zuozhe;
		  rowData[i][5]=type;
		  rowData[i][6]=price;
		  rowData[i][7]=press;
	      rowData[i][8]=page;
		  rowData[i][9]=sheefname;
		  rowData[i][10]=chuban;
		  rowData[i][11]=ruku;
		  rowData[i][12]=stock;
		  rowData[i][13]=borrow;
		  rowData[i][14]=status;
		  rowData[i][15]=oparator;
		  rowData[i][16]=key;
		  i++;
		 }
		 jta.repaint();
		}
		if(jtf14.getSelectedIndex()==3)
				{ if(zuozhe.equals(fajin))
				 {
				  rowData[i][0]=bookname;
				  rowData[i][1]=bianhao;
				  rowData[i][2]=bookcode;
				  rowData[i][3]=fenlei;
				  rowData[i][4]=zuozhe;
				  rowData[i][5]=type;
				  rowData[i][6]=price;
				  rowData[i][7]=press;
			      rowData[i][8]=page;
				  rowData[i][9]=sheefname;
				  rowData[i][10]=chuban;
				  rowData[i][11]=ruku;
				  rowData[i][12]=stock;
				  rowData[i][13]=borrow;
				  rowData[i][14]=status;
				  rowData[i][15]=oparator;
		          rowData[i][16]=key;
				  i++;
				 }
				 jta.repaint();
		}
		if(jtf14.getSelectedIndex()==4)
				{ if(type.equals(fajin))
				 {
				  rowData[i][0]=bookname;
				  rowData[i][1]=bianhao;
				  rowData[i][2]=bookcode;
				  rowData[i][3]=fenlei;
				  rowData[i][4]=zuozhe;
				  rowData[i][5]=type;
				  rowData[i][6]=price;
				  rowData[i][7]=press;
			      rowData[i][8]=page;
				  rowData[i][9]=sheefname;
				  rowData[i][10]=chuban;
				  rowData[i][11]=ruku;
				  rowData[i][12]=stock;
				  rowData[i][13]=borrow;
				  rowData[i][14]=status;
				  rowData[i][15]=oparator;
		          rowData[i][16]=key;
				  i++;
				 }
				 jta.repaint();
		}
		if(jtf14.getSelectedIndex()==5)
				{ if(press.equals(fajin))
				 {
				  rowData[i][0]=bookname;
				  rowData[i][1]=bianhao;
				  rowData[i][2]=bookcode;
				  rowData[i][3]=fenlei;
				  rowData[i][4]=zuozhe;
				  rowData[i][5]=type;
				  rowData[i][6]=price;
				  rowData[i][7]=press;
			      rowData[i][8]=page;
				  rowData[i][9]=sheefname;
				  rowData[i][10]=chuban;
				  rowData[i][11]=ruku;
				  rowData[i][12]=stock;
				  rowData[i][13]=borrow;
				  rowData[i][14]=status;
				  rowData[i][15]=oparator;
		          rowData[i][16]=key;
				  i++;
				 }
				 jta.repaint();
		}
		if(jtf14.getSelectedIndex()==6)
				{ if(sheefname.equals(fajin))
				 {
				  rowData[i][0]=bookname;
				  rowData[i][1]=bianhao;
				  rowData[i][2]=bookcode;
				  rowData[i][3]=fenlei;
				  rowData[i][4]=zuozhe;
				  rowData[i][5]=type;
				  rowData[i][6]=price;
				  rowData[i][7]=press;
			      rowData[i][8]=page;
				  rowData[i][9]=sheefname;
				  rowData[i][10]=chuban;
				  rowData[i][11]=ruku;
				  rowData[i][12]=stock;
				  rowData[i][13]=borrow;
				  rowData[i][14]=status;
				  rowData[i][15]=oparator;
		          rowData[i][16]=key;
				  i++;
				 }
				 jta.repaint();
		}
	  }
      con.close();
	}
/////////////////////////////////////////////////////////////////////////////////////////////////
	public static void main(String[]args)
		{   try {
		            UIManager.setLookAndFeel("com.sun.java.swing.plaf.windows.WindowsLookAndFeel");
		            }
		        catch(Exception e) {
		            e.printStackTrace();
		           }
			new BorrowBook();
	}
}