用java写的一个图书馆管理系统,应该说功能相当全面.包含所有源代码,从数据库的建立到客户端.

				CREATE TABLE UserTable(ID int identity, UserName char(40), Password char(40),
				Power char(40), CONSTRAINT ID_User_Containt PRIMARY KEY (ID));
				
				CREATE TABLE books(ID int identity, BookName char(40), Press char(40), Author char(40), 
				PressDate char(20), Price char(20), Com char(40), books_count char(4), 
				borrowed_count char(4), CONSTRAINT ID_Contraint_PK PRIMARY KEY (ID));
				
				CREATE TABLE bookBrowse(ID int identity, StudentName char(40), BookName char(40), 
				ReturnDate char(20), BorrowDate char(20), Com char(40), Is_Returned char(4), 
				CONSTRAINT ID_BookBrowse_Containt PRIMARY KEY (ID));           
				           
				select *from bookbrowse
				
				insert into books(BookName, Press, Author,PressDate, Price, Com, books_count,borrowed_count) values('df','fsd','dfd','fsd','dfs','dfs','d','dsf')