图书管理系统jsp+sql

CREATE TABLE [dbo].[readercategory] ( [id] [int] NOT NULL , [categoryname] [varchar] (20) COLLATE Chinese_PRC_CI_AS NULL , [numborrow] [int] NULL , [pubnish] [int] NULL , [remark] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO insert into readercategory (id ,categoryname,numborrow,pubnish,remark) values (1,'一级',10,0.4,' ') insert into readercategory (id ,categoryname,numborrow,pubnish,remark) values (2,'二级',20,0.5, ' ' ) insert into readercategory (id ,categoryname,numborrow,pubnish,remark) values (3,'三级',30,0.6,' ') insert into readercategory (id ,categoryname,numborrow,pubnish,remark) values (4,'四级',40,0.7,' ') insert into readercategory (id ,categoryname,numborrow,pubnish,remark) values (5,'五级',60,0.8,' ') select *from readercategory CREATE TABLE [dbo].[reader] ( [id] [int] NOT NULL , [name] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [readercategoryid] [int] NULL , [sex] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [address] [varchar] (50) COLLATE Chinese_PRC_CI_AS NULL , [remark] [varchar] (1024) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO insert into reader (id,name ,readercategoryid,sex,address,remark) values (1,'student1',1,'男','ccutxingxinglx','') insert into reader (id,name ,readercategoryid,sex,address,remark) values (2,'student2',2,'男','ccutxingxinglx','') insert into reader (id,name ,readercategoryid,sex,address,remark) values (3,'student3',2,'女','ccutxingxinglx','') insert into reader (id,name ,readercategoryid,sex,address,remark) values (4,'student4',2,'女','ccutxingxinglx','') insert into reader (id,name ,readercategoryid,sex,address,remark) values (12,'student12',4,'男','ccutxingxinglx','') insert into reader (id,name ,readercategoryid,sex,address,remark) values (10,'student10',3,'男','ccutxingxinglx','') insert into reader (id,name ,readercategoryid,sex,address,remark) values (9,'student9',5,'男','ccutxingxinglx','') select *from reader