--图书入库信息表-book
CREATE TABLE BOOK(BookNo int PRIMARY KEY,
BookName Varchar(50),
BookClass Varchar(50),
BookPub Varchar(50),
Author Varchar(50),
BookTotal int,
Price int,
Isorin Varchar(50),
Bookbirth Date,
Bookdemo Varchar(300)
)
SELECT * FROM BOOK
-- 学生信息表-student
CREATE TABLE STUDENT(StuNo int PRIMARY KEY,
StuName Varchar(50),
StuPwd Varchar(50),
StuSex Varchar() ,
StuSpecial Varchar(50),
StuClass Varchar(50),
Permitted int default 6
)
ALTER TABLE STUDENT ADD CONSTRAINTS CK_StuSex CHECK (StuSex='男' OR StuSex='女')
select * from STUDENT
-- 管理员信息表-manager
CREATE TABLE Manager(ManagerNo int PRIMARY KEY,
ManagerName Varchar(50),
ManagerPassword Varchar(50)
)
select * from Manager
--借阅信息表- LibraryRecord
CREATE TABLE LibraryRecords( BookNO int,
StuNO int,
BookName Varchar(50),
BorrowTime Date,
ReturnTime Date,
ReletCount int DEFAULT 0,
PRIMARY KEY(BookNo,StuNo),
Foreign key (BookNo) references BOOK(Bookno),
Foreign key (StuNo) references STUDENT(Stuno)
)
select * from LibraryRecord
--图书挂失信息表- losebook
CREATE TABLE LOSEBOOK(LBNO int PRIMARY KEY,
StuNO int,
BookNO int,
BookName Varchar(50),
Price int,
Foreign key (BookNo) references BOOK(Bookno),
Foreign key (StuNo) references STUDENT(Stuno)
)
SELECT * FROM LOSEBOOK
--图书超期信息表exceedtime
CREATE TABLE ExceedTime(StuNO int ,
BookNO int ,
BookName Varchar(50),
DelayTime int,
Fine int
)
图书管理系统 swing 毕业设计 （185个子文件） 
ManagerAction.class 28KB ManagerDao.class 13KB StuAction.class 12KB HostWindow.class 11KB BookInfoFrame.class 10KB ManagerFrame.class 10KB TreeAction.class 9KB LibaryInfo.class 7KB StuDao.class 7KB PageAction.class 7KB UserManager.class 5KB LoginFrame.class 5KB TreeAction.class 5KB AlterPwdView.class 4KB UserAction.class 4KB UserDao.class 3KB QueryView.class 3KB UpdateAction.class 3KB SqlSen.class 3KB QueryText.class 3KB LibDao.class 3KB addStuFrame.class 3KB AboutView.class 3KB BookDao.class 3KB TreeInfoDao.class 3KB FunctionListener.class 3KB BookVo.class 3KB StuDao.class 3KB ManagerAction$11.class 3KB StudentVo.class 3KB ManagerAction$12.class 3KB StuAction$5.class 2KB AlterStuPassView.class 2KB BookVo.class 2KB DbcpTools.class 2KB MeMessage.class 2KB alterPassword.class 2KB QueryTextAction.class 2KB TreeAction$3.class 2KB StudentVo.class 2KB LibraryRecordVo.class 2KB LibraryRecordVo.class 2KB QueryView$1.class 1KB ExceedTimeVo.class 1KB LostBookVo.class 1KB PageTools.class 1KB PageTools.class 1KB AlterAction.class 1KB ManagerVo.class 1KB HostWindow$2.class 1KB HostWindow$timeThread.class 1KB ManagerFrame$timeThread.class 1KB LoseBookVo.class 1KB HostWindow$1.class 1KB TreeAction$2.class 1KB LoginFrame$2.class 1KB LoginFrame$1.class 1KB ManagerFrame$1.class 1KB StuAction$3.class 1KB StuAction$4.class 1KB ManagerAction$2.class 1KB ManagerAction$5.class 1KB ManagerAction$8.class 1KB ManageVo.class 959B LibaryInfo$1.class 956B ClaVo.class 908B ManagerAction$9.class 894B ManagerAction$6.class 894B ManagerAction$3.class 894B MyMouse.class 803B ManagerAction$10.class 745B ManagerAction$7.class 743B ManagerAction$1.class 743B ManagerAction$4.class 743B IManagerDao.class 729B DeptVo.class 729B TreeAction$1.class 710B Log.class 702B TreeAction$1.class 699B StuAction$1.class 685B StuAction$2.class 685B IStuDao.class 508B IUserDao.class 244B IBookDao.class 205B ITreeInfoDao.class 202B IStuDao.class 201B ILibDao.class 189B .classpath 536B
ojdbc14.jar 1.47MB log4j-1.2.14.jar 320KB commons-dbcp.jar 102KB commons-pool-1.4.jar 85KB ManagerAction.java 48KB ManagerDao.java 20KB HostWindow.java 15KB StuAction.java 15KB TreeAction.java 12KB ManagerFrame.java 11KB StuDao.java 10KB LibaryInfo.java 9KB共 185 条
- 1
- 2
资源评论
