tushuguanli.rar

  • PUDN用户
    了解作者
  • Visual C++
    开发工具
  • 625KB
    文件大小
  • rar
    文件格式
  • 0
    收藏次数
  • 1 积分
    下载积分
  • 8
    下载次数
  • 2009-11-26 23:03
    上传日期
一个.NET加MSSQL写的图书馆管理系统,写的很不错,代码效率很高。虽然界面简单,但是功能全面,适合学习。
tushuguanli.rar
内容介绍
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书丢失_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书丢失] DROP CONSTRAINT 图书丢失_图书编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书罚款_图书信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书罚款] DROP CONSTRAINT FK_图书罚款_图书信息 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书归还_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书归还] DROP CONSTRAINT 图书归还_图书编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书借阅_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书借阅] DROP CONSTRAINT 图书借阅_图书编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书征订_图书信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书征订] DROP CONSTRAINT FK_图书征订_图书信息 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书注销_图书编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书注销] DROP CONSTRAINT 图书注销_图书编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[期刊丢失_期刊编号_fk]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[期刊丢失] DROP CONSTRAINT 期刊丢失_期刊编号_fk GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_期刊罚款_期刊信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[期刊罚款] DROP CONSTRAINT FK_期刊罚款_期刊信息 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_期刊罚款_读者信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[期刊罚款] DROP CONSTRAINT FK_期刊罚款_读者信息 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_图书罚款_读者信息]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[图书罚款] DROP CONSTRAINT FK_图书罚款_读者信息 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[FK_读者信息_读者类型]') and OBJECTPROPERTY(id, N'IsForeignKey') = 1) ALTER TABLE [dbo].[读者信息] DROP CONSTRAINT FK_读者信息_读者类型 GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_图书借阅]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sf_图书借阅] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_图书归还]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sf_图书归还] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_图书征订]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[sf_图书征订] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[书架]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[书架] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[供应商]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[供应商] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[出版社]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[出版社] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书丢失]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书丢失] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书信息]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书信息] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书借阅]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书借阅] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书归还]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书归还] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书征订]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书征订] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[图书注销]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[图书注销] GO if exi�
评论
    相关推荐
    • mssql系列
      NULL 博文链接:https://michaelzqm.iteye.com/blog/758085
    • MSSQL 分页
      NULL 博文链接:https://snowing11812.iteye.com/blog/1979057
    • mssql_driver
      mssql_driver
    • mssql注入套装
      mssql注入套装
    • MSSQL精华
      很值得一看~~~ 有兴趣的朋友可以看看
    • MSSQL 分页
      NULL 博文链接:https://snowing11812.iteye.com/blog/1979057
    • MSSQL 分页
      NULL 博文链接:https://snowing11812.iteye.com/blog/1979057
    • navicat mssql
      navicat mssql是一款数据库客户端,可视化管理数据库工具,可以连接MSSQLServer
    • mssql jar
      mssql数据库驱动包
    • MSSQL JDBC Driver
      MSSQL 2000 JDBC Driver MSSQL 2005 JDBC Driver