tushuguan.rar_java sql 系统_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(20), Press char(20), Author char(20), PressDate char(10), Price char(10), Com char(20), books_count char(2), borrowed_count char(2), CONSTRAINT ID_Contraint_PK PRIMARY KEY (ID)); CREATE TABLE bookBrowse(ID int identity, StudentName char(40), BookName char(40), ReturnDate char(10), BorrowDate char(10), Com char(40), Is_Returned char(2), CONSTRAINT ID_BookBrowse_Containt PRIMARY KEY (ID));