C#图书管理系统源码(含数据库)-附自己设计的界面

create database Book use Book create table Book ( Id int not null identity(1,1) primary key, BookName varchar(30) not null, Name varchar(20) not null, Nub int not null, Ms float not null, Txt varchar(100) not null, ) create table Usead ( Id int not null identity(1,1) primary key, enter varchar(30) not null, Pwd varchar(20) not null, Name varchar(20) not null, Numb varchar(20) not null, Mn float not null default 0, Up varchar(20) not null default '普通用户', ) create table Mnselect ( Id int not null identity(1,1) primary key, enter varchar(30) not null, Mn float not null, GM varchar(20) not null, time datetime not null default getdate(), ) create table BookBor ( Id int not null identity(1,1) primary key, enter varchar(30) not null, BookName varchar(30) not null, time datetime not null default getdate(), ) select *from Usead select * from BookBor select * from Book select Id as 编号,BookName as 书名,Name as 作者,Nub as 数量,ms as 价格,Txt as 介绍 from Book insert into Book values('水浒传','施耐庵',50,59.9,'北宋年间奸臣当道，民不聊生。') insert into Book values('西游记','吴承恩',60,59.9,'师徒四人一起斩妖除魔，前往西天。') insert into Book values('斗破苍穹','我吃西红柿',200,59.9,'萧炎一路成长成为斗帝。') insert into Book values('斗罗大陆','唐家三少',200,59.9,'唐三转世步步走向巅峰。') insert into Book values('龙族','江南',200,59.9,'路明非一次次与恶龙战斗。') insert into Book values('吞噬星空','我吃西红柿',200,59.9,'慢慢成长成为绝世高手。') insert into Book values('校园狂少','巅峰的神',200,59.9,'张狂不可一世的他开始建立自己的帝国。') insert into Book values('封魔师','陨落星辰',200,59.9,'哥妹两人相依为命成为绝代高手。') insert into Book values('小猪佩琪','社会人',200,59.9,'小猪佩琪身上纹，掌声送给社会人。') insert into Book values('英雄联盟','拳头',200,59.9,'在符文之地，魔法就是一切。') insert into Book values('海贼王','认不得',200,59.9,'要成为海贼王的男人。') insert into Book values('火影忍者','日本人',200,59.9,'召唤的蛤蟆光是个大。') insert into Book values('金瓶梅','武大郎',200,59.9,'此处不可描述。') insert into Book values('C#程序设计','卢卫中',200,59.9,'能够进行桌面应用的开发。') insert into Book values('奥特曼','AOtom',200,59.9,'成为光来拯救人类。') insert into Book values('孙子兵法','孙武',200,59.9,'光就是打不怂。') insert into Book values('红楼梦','曹雪芹&高鹗',200,59.9,'不知道讲了个什么你自己去看。') insert into Book values('本草纲目','李时珍',200,59.9,'吃撒治撒，都常一边。') insert into Book values('平凡的世界','路遥',100,60.65,'这是一部社会生活的长篇小说。') insert into Book values('穆斯林的葬礼','霍达',100,60.65,'家族三代人命运的沉浮。') insert into Book values('挪威的森林','村上春树',100,60.65,'风靡全亚洲百分之百的恋爱小说。') insert into Book values('基督山伯爵','大仲马',100,60.65,'找宝藏，成为巨富的故事。') insert into Book values('教父','马里奥-普佐',100,60.65,'美国出版社史上的头号畅销书。') insert into Book values('苏菲的世界','乔斯坦-贾德',100,60.65,'世界最易读懂得哲学书。') insert into Book values('麦田里的守望者','塞林格',100,60.65,'现代经典小说”之一。') insert into Book values('万历十五年','黄仁宇',100,60.65,'讲述了当时的朝廷现状。') insert into Book values('美的历程','李泽厚',100,60.65,'概况描述和美学把握。') insert into Book values('围城','钱钟书',100,60.65,'讽刺小说。') insert into Book values('活着','余华',100,60.65,'一部有深度的书。') insert into Book values('许三观卖血记','余华',100,60.65,'表达了人在面对厄运时求生的欲望。') insert into Book values('牛虻','伏尼契',100,60.65,'自己的革命信仰，甘愿被命运折磨。') insert into Book values('呼啸山庄','艾米莉',100,60.65,'勃朗特毕生的唯一力作。') insert into Book values('尘埃落定','阿来',100,60.65,'该小说获第五届茅盾文学奖。') insert into Book values('拿破仑全传','刘乐土',100,60.65,'讲述拿破仑的传奇一生。') insert into Book values('破碎的四月','卡达乔戈',100,60.65,'一个民族几百年的固绕和悲剧性') select Id as 用户编号,enter as 账号,Pwd as 密码,Name as 姓名,Numb as 身份证,Mn as 余额,Up as 权限 from Usead insert into Usead values('Usead','Usead1','管理员','管理员编号1',0,'管理员') insert into Usead values('Usead1','Usead1','管理员','管理员编号2',0,'管理员') insert into Usead values('Usead2','Usead1','管理员','管理员编号3',0,'管理员') insert into Usead values('Usead3','Usead1','管理员','管理员编号4',0,'管理员') insert into Usead values('Usead4','Usead1','管理员','管理员编号5',0,'管理员') insert into Usead values('Usead5','Usead1','管理员','管理员编号6',0,'管理员') insert into Usead values('Usead6','Usead1','管理员','管理员编号7',0,'管理员') insert into Usead values('Usead7','Usead1','管理员','管理员编号8',0,'管理员') insert into Usead values('Usead8','Usead1','管理员','管理员编号9',0,'管理员') insert into Usead values('xm1995','19950205','小明','610481199805062452',0,'普通用户') insert into Usead values('xiaowang','1998056','小王','610481199805062452',0,'普通用户') insert into Usead values('zhaosi5','19453452','赵四','610481199212122452',0,'普通用户') insert into Usead values('taisen8','19945312','泰森','610481199212122452',0,'普通用户') insert into Usead values('lakesi','19453212','拉克丝','610481199212122452',0,'普通用户') insert into Usead values('cuisit5','14533112','崔斯特','610481199212122452',0,'普通用户') insert into Usead values('lina001','1453142','李娜','610481199212122452',0,'普通用户') insert into Usead values('wangjun','1931212','王军','610481199212122452',0,'普通用户') insert into Usead values('liujie1','1453412','刘杰','610481199212122452',0,'普通用户') insert into Usead values('wanggang','4534412','王刚','610481199212122452',0,'普通用户') insert into Usead values('zhangql','14534532','张强','610481199212122452',0,'普通用户') insert into Usead values('ruiwen','1455512','瑞雯','610481199212122452',0,'普通用户') insert into Usead values('weijia','1444422','维嘉','610481199212122452',0,'普通用户') insert into Usead values('pulangke','1121212','普朗克','610481199212122452',0,'普通用户') insert into Usead values('kaier2','1111212','凯尔','610481199212122452',0,'普通用户') insert into Usead values('aixi66','1333212','艾希','610481199212122452',0,'普通用户') insert into Usead values('bulici','192223312','布里茨','610481199212122452',0,'普通用户') insert into Usead values('moganna','19556612','莫甘娜','610481199212122452',0,'普通用户') insert into Usead values('lamosi','16665212','拉莫斯','610481199212122452',0,'普通用户') insert into Usead values('jilan789','1444512','基兰','610481199212122452',0,'普通用户') insert into Usead values('yifulin','19664412','伊芙琳','610481199212122452',0,'普通用户') insert into Usead values('tuqi33','19123412','图奇','610481199212122452',0,'普通用户') insert into Usead values('bobi88','19453412','波比','610481199212122452',0,'普通用户') insert into Usead values('kainan','1991212','凯南','610481199212122452',0,'普通用户') insert into Usead values('akali99','1445312','阿卡丽','610481199212122452',0,'普通用户') insert into Usead values('jialiao','19978212','加里奥','610481199212122452',0,'普通用户') insert into Usead values('kaerma','17864122','卡尔玛','610481199212122452',0,'普通用户') select enter as 用户名,Name as 姓名 from Usead where enter like 'zhaosi5' and Name='赵四' select enter as 用户名,Mn as 增加金额,GM as 操作管理员,time as 操作时间 from Mnselect insert into Mnselect values('赵四',80,'Usead',default) select enter as 用户名,Pwd as 密码,Name as 姓名,Numb as 身份证,Mn as 余额,Up as 等级 from Usead where Name='赵四'