--图书入库信息表-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
LoseBookVo.class 1KB
ManagerFrame$timeThread.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$5.class 1KB
ManagerAction$8.class 1KB
ManagerAction$2.class 1KB
ManageVo.class 959B
LibaryInfo$1.class 956B
ClaVo.class 908B
ManagerAction$6.class 894B
ManagerAction$3.class 894B
ManagerAction$9.class 894B
MyMouse.class 803B
ManagerAction$10.class 745B
ManagerAction$4.class 743B
ManagerAction$7.class 743B
ManagerAction$1.class 743B
IManagerDao.class 729B
DeptVo.class 729B
TreeAction$1.class 710B
Log.class 702B
TreeAction$1.class 699B
StuAction$2.class 685B
StuAction$1.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
资源评论
漂泊在外的孤独患者
- 粉丝: 3
- 资源: 10
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功