当前位置：首页 > news >正文

图书管理系统源码，图书管理系统开发，图书借阅系统源码配置和运行图解源码已附加

news 2026/2/9 5:20:23

配置简介和软件条件

数据库附件配置

vs应用程序web.config配置数据库链接字符串

数据库文件脚本代码

配置简介和软件条件

所需要的软件是Vs2017以上数据库是Sqlserver2012以上，如果数据库附件不了可以使用数据库脚本附件数据库脚本会在文章末尾写出来。可以直接复制到数据库哪里创建TushuManger执行

首先拿到源码后解压文件会得到8个目录，除了文件夹以外另外两个.ldf和.mdf文件是数据库

源码可以直接点击文件夹TuShuManger文件里面的TuShuManger.sln

数据库附件配置

打开sqlerver2019右键数据库哪里选择附件后，添加上对应的数据库.mdf文件

vs应用程序web.config配置数据库链接字符串

打开目录里面的TuShuManger.sln后点击文件web.config,然后配置里面参数，datasource是数据库服务器地址，Initial Catalog是数据库名称

数据库文件脚本代码

USE [TuShuManger]
GO
/****** Object:  Table [dbo].[ReaderManger]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReaderManger]([Id] [int] IDENTITY(1,1) NOT NULL,[rmnum] [nvarchar](max) NULL,[rmname] [nvarchar](max) NULL,[rmljnum] [nvarchar](max) NULL,[rmphone] [nvarchar](max) NULL,[rmsex] [nvarchar](max) NULL,[rmsr] [nvarchar](max) NULL,[rmcatgoryid] [nvarchar](max) NULL,[rmyx] [nvarchar](max) NULL,[rmyue] [nvarchar](max) NULL,[rmbj] [nvarchar](max) NULL,[rmyxq] [nvarchar](max) NULL,[rmsfz] [nvarchar](max) NULL,[rmemail] [nvarchar](max) NULL,[rmaddress] [nvarchar](max) NULL,[rmbeiz] [nvarchar](max) NULL,[idate] [nvarchar](max) NULL,[xtdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmphone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmsex'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'生日' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmsr'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者类别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmcatgoryid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'院系' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmyx'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'余额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmyue'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'班级' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmbj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'有效期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmyxq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'身份证号码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmsfz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'电子邮件' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmemail'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'通讯地址' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmaddress'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'rmbeiz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登记日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'idate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'条数时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger', @level2type=N'COLUMN',@level2name=N'xtdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderManger'
GO
/****** Object:  Table [dbo].[ReaderCatgory]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[ReaderCatgory]([Id] [int] IDENTITY(1,1) NOT NULL,[rname] [nvarchar](max) NULL,[rnum] [nvarchar](max) NULL,[rday] [nvarchar](max) NULL,[rxnum] [nvarchar](max) NULL,[idate] [nvarchar](max) NULL,[xtdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者类型名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory', @level2type=N'COLUMN',@level2name=N'rname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'借书次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory', @level2type=N'COLUMN',@level2name=N'rnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'借书天数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory', @level2type=N'COLUMN',@level2name=N'rday'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'续借次数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory', @level2type=N'COLUMN',@level2name=N'rxnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'添加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory', @level2type=N'COLUMN',@level2name=N'idate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'条数时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory', @level2type=N'COLUMN',@level2name=N'xtdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者分类表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'ReaderCatgory'
GO
/****** Object:  Table [dbo].[OutDate]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[OutDate]([Id] [int] IDENTITY(1,1) NOT NULL,[onum] [nvarchar](max) NULL,[xtdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'超期罚款金额' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OutDate', @level2type=N'COLUMN',@level2name=N'onum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'条数时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OutDate', @level2type=N'COLUMN',@level2name=N'xtdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'超期罚款金额表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'OutDate'
GO
/****** Object:  Table [dbo].[DataBaseTable]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[DataBaseTable]([Id] [int] IDENTITY(1,1) NOT NULL,[bname] [nvarchar](max) NULL,[bnum] [nvarchar](max) NULL,[Parent] [nvarchar](max) NULL,[bidate] [nvarchar](max) NULL,[btdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
/****** Object:  Table [dbo].[BoReturn]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BoReturn]([Id] [int] IDENTITY(1,1) NOT NULL,[brbnum] [nvarchar](max) NULL,[brbname] [nvarchar](max) NULL,[brrnum] [nvarchar](max) NULL,[brrname] [nvarchar](max) NULL,[brbdate] [nvarchar](max) NULL,[brrdate] [nvarchar](max) NULL,[brsj] [nvarchar](max) NULL,[bryqts] [nvarchar](max) NULL,[bryqfj] [nvarchar](max) NULL,[brcbs] [nvarchar](max) NULL,[brzt] [nvarchar](max) NULL,[brhsrq] [nvarchar](max) NULL,[brtdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brbnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brbname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brrnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'读者姓名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brrname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'借出日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brbdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'应还日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brrdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brsj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逾期天数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'bryqts'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'逾期罚金' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'bryqfj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'状态' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brzt'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'还书日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brhsrq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库条数增加时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn', @level2type=N'COLUMN',@level2name=N'brtdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书借还查询表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BoReturn'
GO
/****** Object:  Table [dbo].[BookManger]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookManger]([Id] [int] IDENTITY(1,1) NOT NULL,[bmmnum] [nvarchar](max) NULL,[bmmname] [nvarchar](max) NULL,[bmimg] [nvarchar](max) NULL,[bmtxm] [nvarchar](max) NULL,[bmssh] [nvarchar](max) NULL,[bmisbn] [nvarchar](max) NULL,[bmsl] [nvarchar](max) NULL,[bmbc] [nvarchar](max) NULL,[bmdj] [nvarchar](max) NULL,[bmzz] [nvarchar](max) NULL,[bmyz] [nvarchar](max) NULL,[bmzs] [nvarchar](max) NULL,[bmys] [nvarchar](max) NULL,[bmcatgoryid] [nvarchar](max) NULL,[bmcbs] [nvarchar](max) NULL,[bmidate] [nvarchar](max) NULL,[bmbeiz] [nvarchar](max) NULL,[bmtdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmmnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmmname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书图片' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmimg'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书条形码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmtxm'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书索书号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmssh'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书ISBN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmisbn'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书数量' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmsl'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书版次' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmbc'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书单价' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmdj'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书作者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmzz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书译者' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmyz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书字数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmzs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书页数' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmys'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书分类id' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmcatgoryid'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书出版社' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmcbs'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'备注' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmbeiz'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登记日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger', @level2type=N'COLUMN',@level2name=N'bmtdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookManger'
GO
/****** Object:  Table [dbo].[BookCatgory]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[BookCatgory]([Id] [int] IDENTITY(1,1) NOT NULL,[bname] [nvarchar](max) NULL,[bnum] [nvarchar](max) NULL,[Parent] [nvarchar](max) NULL,[bidate] [nvarchar](max) NULL,[btdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书分类名称' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCatgory', @level2type=N'COLUMN',@level2name=N'bname'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书分离编号' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCatgory', @level2type=N'COLUMN',@level2name=N'bnum'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'预留字段可删除' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCatgory', @level2type=N'COLUMN',@level2name=N'Parent'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'注册时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCatgory', @level2type=N'COLUMN',@level2name=N'bidate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库插入时间' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCatgory', @level2type=N'COLUMN',@level2name=N'btdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'图书分类表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'BookCatgory'
GO
/****** Object:  Table [dbo].[AdminUser]    Script Date: 11/28/2023 20:43:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
CREATE TABLE [dbo].[AdminUser]([Id] [int] IDENTITY(1,1) NOT NULL,[username] [nvarchar](max) NULL,[password] [nvarchar](max) NULL,[qq] [nvarchar](max) NULL,[email] [nvarchar](max) NULL,[phone] [nvarchar](max) NULL,[sex] [nvarchar](max) NULL,[idate] [nvarchar](max) NULL,[xtdate] [datetime] NULL,
PRIMARY KEY CLUSTERED 
([Id] ASC
)WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]
) ON [PRIMARY]
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户名' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'username'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'密码' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'password'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'qq' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'qq'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'邮箱' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'email'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'手机' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'phone'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'性别' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'sex'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'登记日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'idate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'数据库插入日期' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser', @level2type=N'COLUMN',@level2name=N'xtdate'
GO
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'用户管理员表' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'AdminUser'
GO
/****** Object:  Default [DF__AdminUser__xtdat__1BFD2C07]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[AdminUser] ADD  DEFAULT (getdate()) FOR [xtdate]
GO
/****** Object:  Default [DF__BookCatgo__btdat__1CF15040]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[BookCatgory] ADD  DEFAULT (getdate()) FOR [btdate]
GO
/****** Object:  Default [DF__BookMange__bmtda__1DE57479]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[BookManger] ADD  DEFAULT (getdate()) FOR [bmtdate]
GO
/****** Object:  Default [DF__BoReturn__brtdat__1ED998B2]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[BoReturn] ADD  DEFAULT (getdate()) FOR [brtdate]
GO
/****** Object:  Default [DF__DataBaseT__btdat__1FCDBCEB]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[DataBaseTable] ADD  DEFAULT (getdate()) FOR [btdate]
GO
/****** Object:  Default [DF__OutDate__xtdate__20C1E124]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[OutDate] ADD  DEFAULT (getdate()) FOR [xtdate]
GO
/****** Object:  Default [DF__ReaderCat__xtdat__21B6055D]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[ReaderCatgory] ADD  DEFAULT (getdate()) FOR [xtdate]
GO
/****** Object:  Default [DF__ReaderMan__xtdat__22AA2996]    Script Date: 11/28/2023 20:43:54 ******/
ALTER TABLE [dbo].[ReaderManger] ADD  DEFAULT (getdate()) FOR [xtdate]
GO

图书管理系统源码，图书管理系统开发，图书借阅系统源码配置和运行图解源码已附加

目录配置简介和软件条件数据库附件配置 vs应用程序web.config配置数据库链接字符串数据库文件脚本代码配置简介和软件条件所需要的软件是Vs2017以上数据库是Sqlserver2012以上，如果数据库附件不了可以使用数据库脚本附件数据库脚本会在文章末尾写出来。可以…...

编程日记 2023/11/30 4:29:54

FFmpeg介绍

官方网站：http://www.ffmpeg.org/ 项目组成 libavformat 封装模块，封装了Protocol层和Demuxer、Muxer层，使得协议和格式对于开发者来说是透明的。FFmpeg能否支持一种封装格式的视频的封装与解封装，完全取决于这个库&#xff0c…...

编程日记 2023/11/30 4:28:53

修改网卡PHY的灯-RK3568

文章目录前言1.定制PHY的灯2.通过命令修改LED状态3.修改驱动效果前言前面我们已经移植了网卡到开发板上面，也能够正常的进行通信，但是，我们会发现座子上面的灯并没有全部亮起来，而且这些灯的含义是什么，并没有讲解到，这里，就此问题，展开学习。 PHY 有一个重要的功能…...

编程日记 2023/11/30 4:27:53

11月29日作业

作业： 自己封装一个矩形类(Rect)，拥有私有属性:宽度(width)、高度(height)， 定义公有成员函数: 初始化函数:void init(int w, int h) 更改宽度的函数:set_w(int w) 更改高度的函数:set_h(int h) 输出该矩形的周长和面积函数:void show(…...

编程日记 2023/11/30 4:26:52

【从删库到跑路 | MySQL总结篇】表的增删查改（进阶下）

个人主页：兜里有颗棉花糖欢迎点赞👍 收藏✨ 留言✉ 加关注💓本文由兜里有颗棉花糖原创收录于专栏【MySQL学习专栏】🎈 本专栏旨在分享学习MySQL的一点学习心得，欢迎大家在评论区讨论💌 目录一、联合…...

编程日记 2023/11/30 4:24:49

【机器学习 | 可视化系列】可视化系列之决策树可视化

🤵‍♂️ 个人主页: AI_magician 📡主页地址： 作者简介：CSDN内容合伙人，全栈领域优质创作者。 👨‍💻景愿：旨在于能和更多的热爱计算机的伙伴一起成长！！&…...

编程日记 2023/11/30 4:23:49

配置阿里云的yum仓库

目录配置阿里云的yum源清理官方yum源下载阿里云的yum源 centos7下载阿里云yum源： 清理yum缓存：yum cleam all 生成自己的yum缓存：yum makecache 使用centos自带的官方yum源下载很慢，那今天来跟大家说说配置阿里云的yum仓…...

编程日记 2023/11/30 4:22:47

Kubernetes之kubeadm日志展示篇—K8S私有云worker节点gluster安装部署

文章目录一. 服务器信息1.1 环境准备1.2 配置hosts解析记录二. 安装与部署2.1 配置仓库 （所有节点）2.2 安装服务 （所有节点）2.3 启动服务 （所有节点）2.4 配置资源池 （主节点）2.5 创…...

编程日记 2023/11/30 4:21:46

P3368 【模板】树状数组 2 （区间修改，单点查询）

本题链接：【模板】树状数组 2 - 洛谷题目： 输入 5 5 1 5 4 2 3 1 2 4 2 2 3 1 1 5 -1 1 3 5 7 2 4 输出 6 10 思路： 根据题意，这里是需要区间添加值，单点查询值。如果区间添加值中暴力去一个个加值，肯定…...

编程日记 2023/11/30 4:20:45

智慧城市运营管理平台解决方案：PPT全文61页，附下载

关键词：智慧城市建设方案，智慧城市解决方案，智慧城市的发展前景和趋势，智慧城市建设内容，智慧城市运营管理平台一、智慧城市运营平台建设背景随着城市化进程的加速，城市面临着诸多挑战，如环…...

编程日记 2023/11/30 4:19:44

Vue性能优化方法

一、前言 1.1 为什么需要性能优化用户体验：优化性能可以提升用户体验，降低加载时间和响应时间，让用户更快地看到页面内容。SEO优化：搜索引擎更喜欢快速响应的网站，优化性能可以提高网站的排名。节约成本&#xff1…...

编程日记 2023/11/30 4:17:41

关于网站的favicon.ico图标的设置需要注意的几点

01-必须在网页的head标签中放上对icon图标的说明语句： 比如下面这样的语句： <link rel"shortcut icon" href"/favicon.ico">否则，浏览器虽然能读到图标，但是不会把图标显示在标签上。 02-为了和本地开…...

编程日记 2023/11/30 4:16:40

PHP中关于func_get_args()方法

首先呢这个函数出现的是比较早的,大致应该是PHP4出现的, func_get_args — 返回一个包含函数参数列表的数组说明 func_get_args(): array 获取函数参数列表的数组。该函数可以配合 func_get_arg() 和 func_num_args() 一起使用，从而使得用户自定义函数可以接…...

编程日记 2023/11/30 4:15:39

EMA训练微调

就是取前几个epoch的weight的平均值，可以缓解微调时的灾难性遗忘（因为新数据引导，模型权重逐渐，偏离训练时学到的数据分布，忘记之前学好的先验知识） class EMA():def __init__(self, model, decay):self.…...

编程日记 2023/11/30 4:13:37

版本说明 Ubuntu 18.04.6Zookeeper 3.5.9Kafka 2.7.0JDK8 集群配置操作系统ip域名Zookeeper 端口Kafka 端口Ubuntu 18.04.6192.168.50.131kafka1.com21819092Ubuntu 18.04.6192.168.50.132kafka2.com21819092Ubuntu 18.04.6192.168.50.133kafka3.com21819092 安装 vim, cu…...

编程日记 2023/11/30 4:12:35

交叉编译

1. 交叉开发交叉编译： 在电脑把程序编写编译调试好再下载到嵌入式产品中运行编译： gcc 之前编译环境和运行环境是一样的交叉编译： 编译把编译代码和运行分开编译代码在虚拟机中运行…...

编程日记 2023/11/30 4:10:34

数据结构与算法之递归: LeetCode 46. 全排列 (Typescript版)

全排列 https://leetcode.cn/problems/permutations/ 描述给定一个不含重复数字的数组 nums ，返回其所有可能的全排列。你可以按任意顺序返回答案。示例 1 输入：nums [1,2,3] 输出：[[1,2,3],[1,3,2],[2,1,3],[2,3,1],[3,1,2],[3,…...

编程日记 2023/11/30 4:09:32

SQL中 JOIN 的两种连接类型：内连接（自然连接、自连接、交叉连接）、外连接（左外连接、右外连接、全外连接）

SQL中 JOIN 的两种连接类型：内连接（自然连接、自连接、交叉连接）、外连接（左外连接、右外连接、全外连接） 1. 自然连接（natural join）（内连接） 学生表 mysql> sele…...

编程日记 2023/11/30 4:07:30

微信小程序记住密码，让登录解放双手

密码是用户最重要的数据，也是系统最需要保护的数据，我们在登录的时候需要用账号密码请求登录接口，如果用户勾选记住密码，那么下一次登录时，我们需要将账号密码回填到输入框，用户可以直接登录系统。我们分别…...

编程日记 2023/11/30 4:05:27

国内划片机行业四大企业之博捷芯：技术驱动，领跑未来

在国内划片机行业中，公司以其卓越的技术实力和持续的创新精神，迅速崭露头角。作为国内划片机行业的四大企业之一，公司以其专业、高品质的划片机设备和解决方案，引领着行业的发展。公司自创立以来，一直专注于划片机设备…...

编程日记 2023/11/30 4:04:26

观成科技：隐蔽隧道工具Ligolo-ng加密流量分析

1.工具介绍 Ligolo-ng是一款由go编写的高效隧道工具，该工具基于TUN接口实现其功能，利用反向TCP/TLS连接建立一条隐蔽的通信信道，支持使用Let’s Encrypt自动生成证书。Ligolo-ng的通信隐蔽性体现在其支持多种连接方式，适应复杂网…...

编程新知 2026/2/8 4:37:24

Objective-C常用命名规范总结

【OC】常用命名规范总结文章目录【OC】常用命名规范总结1.类名（Class Name)2.协议名（Protocol Name)3.方法名（Method Name)4.属性名（Property Name）5.局部变量/实例变量（Local / Instance Variables&…...

编程新知 2025/12/14 22:33:06

在Ubuntu中设置开机自动运行（sudo）指令的指南

在Ubuntu系统中，有时需要在系统启动时自动执行某些命令，特别是需要 sudo权限的指令。为了实现这一功能，可以使用多种方法，包括编写Systemd服务、配置 rc.local文件或使用 cron任务计划。本文将详细介绍这些方法，并提供…...

编程新知 2025/12/23 11:20:24

vue3 定时器-定义全局方法 vue+ts

1.创建ts文件路径：src/utils/timer.ts 完整代码： import { onUnmounted } from vuetype TimerCallback (...args: any[]) > voidexport function useGlobalTimer() {const timers: Map<number, NodeJS.Timeout> new Map()// 创建定时器con…...

编程新知 2025/8/9 0:31:20