java+oracle毕业设计createtablebooks(IDnumber(3),BookNamevarchar2(20),Pressvarchar2(20),Authorvarchar2(20),PressDateDate,Pricenumber(5,2),Comvarchar2(20),books_countnumber(2),borrowed_countnumber(2),constraintID_Contraint_PKprimarykey(ID));createsequenceID_Sequence;//*******************************createtablebookBrowse(IDnumber(3),StudentNamevarchar2(40),BookNamevarchar2(40),ReturnDateDate,BorrowDateDate,Comvarchar2(40),Is_Returnedchar(2),//设置默认直为‘否’constraintID_BookBrowse_Containtprimarykey(ID));createsequenceID_Browse_Sequence;//************************************createtableUserTable(IDnumber(3),UserNamevarchar2(40),Passwordvarchar2(40),Powervarchar2(40),constraintID_User_Containtprimarykey(ID));//******************************createsequenceID_User_Sequence;
1