用Delphi 2009+SQL2000（2005也可以用）做的图书管理系统

use L_M_S IF EXISTS(SELECT TABLE_NAME FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME = 'Users') drop table Users create table users( Number int identity not null, /*给记录编码*/ Users_id varchar(10) primary key not null, /*用户编码*/ Users_name varchar(20) not null, /*用户姓名*/ Pass_word varchar(6) not null, /*用户密码*/ Authority_id int not null , /*用户权限*/ Authority_name varchar(50), Remembered int not null default(0), /*标记是否记住密码*/ Sex varchar(10) not null, /*用户性别*/ Class varchar(20) not null, /*用户班级*/ Dep varchar(10) not null, /*用户系别*/ Tel varchar(20), /*用户电话*/ QQ varchar(20), /*用户QQ*/ Num varchar(10) default(0) /*记录用户的借书本数*/ ) insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xc07540200','祝锡永','admin1','管理员','0','男','信息平台老师','经管系','13857199052','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xc07540207','黄聪明','123456','普通用户','1','男','07信管（2）班','经管系','15858136011','290427572') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xc07540228','吴芳','123456','普通用户','1','女','07信管（1）班','经管系','15058139334','578857645') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xd07540121','关羽','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xd07540122','张飞','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xd07540123','赵云','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xd07540124','诸葛','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xd07540125','魏延','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xe07540121','郭嘉','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xe07540122','曹仁','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xe07540123','司马','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xe07540124','典韦','123456','普通用户','1','男','07信管（2）班','经管系','无','无') insert into Users(Users_id,Users_name,Pass_word,Authority_name,Authority_id,Sex,Class,Dep,Tel,QQ) values('Xe07540125','询','123456','普通用户','1','男','07信管（2）班','经管系','无','无') select * from Users