Javaweb图书借阅管理系统

create table users( username varchar(20) primary key, password varchar(20), confirmpassword varchar(20), email varchar(20) ); create table books( bookNo int primary key, bookName varchar(20), bookAuthor varchar(20), bookPrice float, bookFirstType varchar(20), bookSecondType varchar(20), numberOFread int, timeOFupload varchar(20), statusOFborrow varchar(20), username varchar(20), constraint FK_1 foreign key(username) references users(username) ); insert into users (username,password,confirmpassword,email) values ('LK',123456,123456,123456789); insert into users (username,password,confirmpassword,email) values ('LLL',123456,123456,123456789); insert into users (username,password,confirmpassword,email) values ('null','','',''); insert into books values(1,'听你的','张皓宸',41.5,'青春文学','爱情',17,'20180501','yes','LK'); insert into books values(2,'余生很长，何必慌张','林熙',28.1,'青春文学','爱情',20,'20180301','yes','LK'); insert into books values(3,'默读','priest',33.4,'青春文学','悬疑',60,'20180201','yes','LLL'); insert into books values(4,'七根凶简','尾鱼',28.7,'青春文学','悬疑',5,'20180301','no','null'); insert into books values(5,'张公案','大风刮过',65.2,'青春文学','悬疑',46,'20170101','no','null'); insert into books values(6,'你的名字','新海诚',23.5,'青春文学','国外青春文学','15','20170110','no','null'); insert into books values(7,'星之声','新海诚',19.8,'青春文学','国外青春文学','85','20151001','no','null'); insert into books values(8,'素描的诀窍','伯特·多德森',65.2,'艺术','绘画','15','20170110','no','null'); insert into books values(9,'Python从入门到实践','埃里克·马瑟斯',62.0,'科技','计算机','35','20160701','no','null'); insert into books values(10,'深度学习','伊恩·古德费洛',126.0,'科技','计算机','54','20170701','no','null'); insert into books values(11,'时间简史','史蒂芬·霍金',31.1,'科技','科普读物','53','20140601','no','null'); insert into books values(12,'果壳中的宇宙','史蒂芬·霍金',29.0,'科技','科普读物','7','20140601','no','null'); insert into books values(13,'图解本草纲目','李时珍',19.7,'科技','医学','81','20130901','no','null'); insert into books values(14,'原则','瑞·达利欧',60.8,'经管','管理学','125','20180101','no','null'); insert into books values(15,'见识','吴军',30.0,'经管','管理学','256','20180301','no','null'); insert into books values(16,'深度工作','卡尔·纽波特',27.0,'经管','管理学','89','20170901','no','null'); insert into books values(17,'秘密花园','乔汉娜贝斯福',31.5,'艺术','绘画','48','20150601','no','null'); insert into books values(18,'钢琴基础教程','李晓平',23.8,'艺术','音乐','48','20150601','no','null'); insert into books values(19,'千年金融史','威廉·戈兹曼',52.3,'经管','金融','67','20170501','no','null'); insert into books values(20,'证券分析','本杰明·格雷厄姆',78.0,'经管','金融','6','20130401','no','null'); select * from books ORDER BY numberOFread; select * from books WHERE bookName like'%时%'; show variables like '%char%';