---该语句仅仅适用于Sql2005下执行,Sql2000可以直接附件DB_51aspx下的数据库文件
CREATE DATABASE MyLibrary
GO
USE MyLibrary
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Power]') AND type in (N'U'))
BEGIN
CREATE TABLE [Power](
[ID] [int] NOT NULL,
[Name] [varchar](50) NOT NULL,
CONSTRAINT [PK_Power] PRIMARY KEY CLUSTERED
(
[ID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Proc_BookDelete]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
create PROCEDURE [Proc_BookDelete]
(@BookID [int])
AS DELETE [MyLibrary].[dbo].[Book]
WHERE
( [BookID] = @BookID)'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Proc_BookList]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
create PROCEDURE [Proc_BookList]
AS SELECT *
FROM [dbo].[Book]
ORDER BY BookID'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Proc_BookModify]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
create PROCEDURE [Proc_BookModify]
(@BookID [int],
@BookName [varchar](50),
@BookISBN [varchar](50),
@BookAuthor [varchar](50),
@BookPublish [varchar](50),
@BookPublishDate [datetime],
@BookClassify [varchar](50),
@BookSubject [varchar](50),
@BookIndex [varchar](50),
@BookPrice [money],
@BookPageNum [int],
@BookSeries [varchar](50),
@BookDescription [text])
AS UPDATE [MyLibrary].[dbo].[Book]
SET [BookName] =@BookName,
[BookISBN] =@BookISBN,
[BookAuthor] =@BookAuthor,
[BookPublish] =@BookPublish,
[BookPublishDate]=@BookPublishDate,
[BookClassify] =@BookClassify,
[BookSubject] =@BookSubject,
[BookIndex] =@BookIndex,
[BookPrice] =@BookPrice,
[BookPageNum] =@BookPageNum,
[BookSeries] =@BookSeries,
[BookDescription]=@BookDescription
WHERE
( [BookID] = @BookID)
'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Proc_BookDetail]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
create PROCEDURE [Proc_BookDetail]
@BookID [int]
AS SELECT *
FROM [dbo].[Book]
where BookID=@BookID'
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Book]') AND type in (N'U'))
BEGIN
CREATE TABLE [Book](
[BookID] [int] IDENTITY(1,1) NOT NULL,
[BookName] [varchar](50) NOT NULL,
[BookISBN] [varchar](50) NOT NULL,
[BookAuthor] [varchar](50) NOT NULL,
[BookPublish] [varchar](50) NOT NULL,
[BookPublishDate] [datetime] NOT NULL,
[BookClassify] [varchar](50) NOT NULL,
[BookSubject] [varchar](50) NOT NULL,
[BookIndex] [varchar](50) NOT NULL,
[BookPrice] [money] NOT NULL,
[BookPageNum] [int] NOT NULL,
[BookSeries] [varchar](50) NULL,
[BookDescription] [text] NULL,
CONSTRAINT [PK_Book] PRIMARY KEY CLUSTERED
(
[BookID] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
END
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
IF NOT EXISTS (SELECT * FROM sys.objects WHERE object_id = OBJECT_ID(N'[Proc_BookConditionQuery]') AND type in (N'P', N'PC'))
BEGIN
EXEC dbo.sp_executesql @statement = N'
CREATE PROCEDURE [Proc_BookConditionQuery]
(@Classify [varchar](50),
@Type [varchar](10),
@Content [varchar](50),
@Mode [int]
)
AS
begin
declare @sql nvarchar(1000) --生成的sql语句
if @Classify=''所有书刊''
begin
if @Mode=1
begin
set @sql=''select * from Book where ''+@Type+'' like ''''''+@Content+''%'''''�
没有合适的资源?快使用搜索试试~ 我知道了~
一个非常简单的个人图书管理系统
共85个文件
cs:32个
aspx:23个
gif:23个
4星 · 超过85%的资源 需积分: 5 64 下载量 168 浏览量
2010-04-25
11:35:44
上传
评论 4
收藏 180KB RAR 举报
温馨提示
一个非常简单的个人图书管理系统,可以进行用户分级管理及图书借阅、归还登记,采用Asp.net三层开发 用户管理 添加用户 用户维护 书刊管理 添加书刊 书刊维护 高级搜索 个人信息 修改密码 App_Code下为分层处理代码 登陆页是:/adminLogin.aspx 默认管理帐号/密码:51aspx/51aspx 普通用户帐号/密码:test/51aspx DB_51aspx下为数据库文件,附加即可
资源推荐
资源详情
资源评论
收起资源包目录
个人图书管理系统.rar (85个子文件)
个人图书管理系统
App_Code
DataAccessHelper
GetSafeData.cs 3KB
SQLString.cs 467B
DataAccessLayer
DataBase.cs 8KB
ModifyPassword.aspx.cs 1KB
adminMain.aspx 2KB
ModifyPassword.aspx 2KB
BusinessLogicLayer
Borrow.cs 6KB
Users.cs 11KB
Book.cs 12KB
Reader
ReaderBorrowHistory.aspx 3KB
ReaderBorrowHistory.aspx.cs 773B
ReaderInformation.aspx.cs 2KB
ReaderExpireCuiHuan.aspx.cs 983B
ReaderLoginMain.aspx.cs 423B
ReaderInformation.aspx 3KB
ReaderNotLogin.aspx 1KB
ReaderCurrentBorrow.aspx.cs 977B
ReaderExpireCuiHuan.aspx 3KB
ReaderNotLogin.aspx.cs 422B
ReaderLogin.aspx 2KB
ReaderLogin.aspx.cs 1KB
ReaderLoginMain.aspx 1KB
ReaderCurrentBorrow.aspx 3KB
from.gif 5KB
adminMain.aspx.cs 410B
adminLogin.aspx 2KB
Controls
ReaderTop.ascx 834B
AdminLeft.ascx 2KB
AdminLeft.ascx.cs 426B
ReaderTop.ascx.cs 426B
ReaderLogin.ascx 1KB
ReaderLogin.ascx.cs 428B
Web.Config 2KB
adminLogin.aspx.cs 2KB
BookManage
BookSearch.aspx.cs 1003B
BookDetails.aspx 6KB
ReaderBookAdvancedSearch.aspx.cs 2KB
ReaderBookAdvancedSearch.aspx 5KB
BookLists.aspx 3KB
AdminBookAdvancedSearch.aspx.cs 2KB
BookSearchResult.aspx.cs 1KB
BookSearchResult.aspx 2KB
BookAdd.aspx 6KB
AdminBookAdvancedSearch.aspx 5KB
BookLists.aspx.cs 2KB
BookAdd.aspx.cs 2KB
ReaderBookDetails.aspx 4KB
BookSearch.aspx 5KB
BookDetails.aspx.cs 3KB
ReaderBookDetails.aspx.cs 2KB
DB_51aspx
MyLibrary.sql 29KB
MyLibrary_Log.LDF 1024KB
MyLibrary_Data.MDF 1024KB
UsersManage
UserAdd.aspx 5KB
UserDetails.aspx 4KB
UserAdd.aspx.cs 2KB
UserLists.aspx.cs 4KB
UserDetails.aspx.cs 2KB
UserLists.aspx 5KB
Images
RESET.GIF 1KB
CONFIRM.GIF 505B
Close.GIF 1KB
SubmitScore.GIF 1KB
movetoolright1.gif 171B
RETURN.GIF 1KB
from.gif 5KB
Setup.gif 5KB
online_right.gif 923B
Borrow.GIF 1KB
QUERY.GIF 1KB
ReturnBook.GIF 1KB
online_left.gif 1KB
Login.GIF 1KB
movetool1.gif 922B
search.GIF 1KB
online_middle.gif 670B
FangKuai.gif 2KB
mm.gif 322B
ADD.GIF 1KB
name.gif 988B
Update.GIF 1KB
Borrow
ReturnBook.aspx 2KB
BorrowBook.aspx.cs 3KB
BorrowBook.aspx 2KB
ReturnBook.aspx.cs 1KB
共 85 条
- 1
资源评论
- 一心一义2014-05-03几乎没多大价值,太小了cslgrdn2016-04-03学生用的,用来做课题的
- huihui1216162012-05-25用。net+sql实现的一个简单的图书管理系统,基本功能都有的,初学者可以下载下来参考学习。
cslgrdn
- 粉丝: 3
- 资源: 4
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功