oracle

网上图书管理系统(java)用Web方法开发的管理系统挂接在电子系网站上

create table books (
ID number(3),
BookName varchar2(20),
Press varchar2(20),
Author varchar2(20),
PressDate Date,
Price number(5,2),
Com varchar2(20),
books_count number(2),
borrowed_count number(2),
constraint ID_Contraint_PK primary key ( ID ));

create sequence ID_Sequence;
//*******************************
create table bookBrowse (
ID number(3),
StudentName varchar2(40),
BookName varchar2(40),
ReturnDate Date,
BorrowDate Date,
Com varchar2(40),
Is_Returned char(2),//设置默认直为‘否’
constraint ID_BookBrowse_Containt primary key ( ID ));

create sequence ID_Browse_Sequence;
//************************************
create table UserTable(
ID number(3),
UserName varchar2(40),
Password varchar2(40),
Power varchar2(40),
constraint ID_User_Containt primary key ( ID ));
//******************************
create sequence ID_User_Sequence;