基于oracle的圖書管理系統(tǒng)數(shù)據(jù)庫分析與設(shè)計(jì)畢業(yè)論文(編輯修改稿)
2025-07-15 16:15 本頁面
【文章內(nèi)容簡介】 建借書表create table tBorrow(cUsersNo char(6)not null,cUserName char(10) not null,cBooksISBN char(13) not null,cBookName char(20) not null ,cUsersBorrow int,)primary key( cUsersNo,cBooksISBN)建還書表create table tReturn(cUsersNo char(6)not null,cUserName char(10) not null,cBooksISBN char(13) not null,cBookName char(20) not null,cBorrowTime char(10) not nullcReturnTime char(10) not null，）primary key( cUsersNo,cBooksISBN)管理員注冊(cè)insert into tAdmin values(39。07041139。,39。12345639。,39。李志敏39。, 39。男39。，39。201162739。)。insert into tAdmin values(39。07044839。,39。12345639。,39。趙林寧39。, 39。女39。，39。201162739。)。管理員注銷delete from tAdmin where cAdminID =39。07041139。增加讀者insert into tUser(cUsersID,cUsersPwd,cUsersNo,cUsersName, cUsersSex, cUsersDepart,cUsersClass,cUsersTel)values(39。07042139。,39。12345639。,39。2008407042139。,39。鄭春龍39。,39。男39。,39。計(jì)科系39。,39。08070439。,39。1513867089539。)。insert into tUser(cUsersID,cUsersPwd,cUsersNo,cUsersName, cUsersSex, cUsersDepart,cUsersClass,cUsersTel)values(39。07043339。,39。12345639。,39。2008407043339。,39。晉亞麗39。,39。女39。,39。計(jì)科系39。,39。08070439。,39。1523862563939。)。刪除讀者delete from tUser where cUsersID =39。2008407042139。修改讀者信息update tUser set cUsersName=39。張三39。, cUsersSex=39。男39。 where cUsersID =39。2008407043339。 圖書信息增加圖書insert into book(cBooksISBN, cBooksName, cBooksAuthor, cBooksType, cBooksPrice, cBooksPublisher, cBooksStore)values (39。978780206237339。,39?！秶恰?9。,39。三毛39。,39。小說39。,39。39。,39。人民日?qǐng)?bào)出版社39。,3)。insert into book(cBooksISBN, cBooksName, cBooksAuthor, cBooksType, cBooksPrice, cBooksPublisher, cBooksStore)values (39。362565458562539。,39。Java程序設(shè)計(jì)39。,39。張墨華39。,39。計(jì)算機(jī)39。,39。39。,39。清華大學(xué)出
試題試卷相關(guān)推薦
鄂ICP備17016276號(hào)-1