图书管理系统(java控制台项目).zip

create database BookManagerSystem --创建用户登录表：login create table loginSystem( userName varchar(50), pwd varchar(50) ) insert into loginSystem values('zhangsan','123456'); insert into loginSystem values('lisi','123456'); select * from loginSystem; --创建bookInfo表(书籍信息表) create table bookinfo( bookId int identity(1001,1) primary key, bookName varchar(50), bookPrice money, bookIntegrals int, bookAmount int ) insert into bookinfo(bookName,bookPrice,bookIntegrals,bookAmount) select '三国演义',100,10,50 union select '水浒传',120,15,30 union select '红楼梦',120,15,30 select * from bookinfo --创建读者表：reader表 create table reader( readId int identity(101,1) primary key, readerName varchar(50), readerIntegrals int, borrowAmount int ) insert into reader select '张三',200,3 union select '李四',300,5 go select * from reader --借阅表：borrow create table borrow( readerId int references reader(readId), --外键 bookId int references bookinfo(bookId),--外键 bookAmount int, borrowAmount date ) insert into borrow values(101,1001,2,getdate());