javaweb图书借阅管理系统

USE [master] GO /****** Object: Database [BMSWeb] Script Date: 06/18/2018 21:26:20 ******/ CREATE DATABASE [BMSWeb] ON PRIMARY ( NAME = N'BMSWeb', FILENAME = N'D:\sqlsever\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\BMSWeb.mdf' , SIZE = 2304KB , MAXSIZE = UNLIMITED, FILEGROWTH = 1024KB ) LOG ON ( NAME = N'BMSWeb_log', FILENAME = N'D:\sqlsever\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\BMSWeb_log.LDF' , SIZE = 576KB , MAXSIZE = 2048GB , FILEGROWTH = 10%) GO ALTER DATABASE [BMSWeb] SET COMPATIBILITY_LEVEL = 100 GO IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) begin EXEC [BMSWeb].[dbo].[sp_fulltext_database] @action = 'enable' end GO ALTER DATABASE [BMSWeb] SET ANSI_NULL_DEFAULT OFF GO ALTER DATABASE [BMSWeb] SET ANSI_NULLS OFF GO ALTER DATABASE [BMSWeb] SET ANSI_PADDING OFF GO ALTER DATABASE [BMSWeb] SET ANSI_WARNINGS OFF GO ALTER DATABASE [BMSWeb] SET ARITHABORT OFF GO ALTER DATABASE [BMSWeb] SET AUTO_CLOSE ON GO ALTER DATABASE [BMSWeb] SET AUTO_CREATE_STATISTICS ON GO ALTER DATABASE [BMSWeb] SET AUTO_SHRINK OFF GO ALTER DATABASE [BMSWeb] SET AUTO_UPDATE_STATISTICS ON GO ALTER DATABASE [BMSWeb] SET CURSOR_CLOSE_ON_COMMIT OFF GO ALTER DATABASE [BMSWeb] SET CURSOR_DEFAULT GLOBAL GO ALTER DATABASE [BMSWeb] SET CONCAT_NULL_YIELDS_NULL OFF GO ALTER DATABASE [BMSWeb] SET NUMERIC_ROUNDABORT OFF GO ALTER DATABASE [BMSWeb] SET QUOTED_IDENTIFIER OFF GO ALTER DATABASE [BMSWeb] SET RECURSIVE_TRIGGERS OFF GO ALTER DATABASE [BMSWeb] SET ENABLE_BROKER GO ALTER DATABASE [BMSWeb] SET AUTO_UPDATE_STATISTICS_ASYNC OFF GO ALTER DATABASE [BMSWeb] SET DATE_CORRELATION_OPTIMIZATION OFF GO ALTER DATABASE [BMSWeb] SET TRUSTWORTHY OFF GO ALTER DATABASE [BMSWeb] SET ALLOW_SNAPSHOT_ISOLATION OFF GO ALTER DATABASE [BMSWeb] SET PARAMETERIZATION SIMPLE GO ALTER DATABASE [BMSWeb] SET READ_COMMITTED_SNAPSHOT OFF GO ALTER DATABASE [BMSWeb] SET HONOR_BROKER_PRIORITY OFF GO ALTER DATABASE [BMSWeb] SET READ_WRITE GO ALTER DATABASE [BMSWeb] SET RECOVERY SIMPLE GO ALTER DATABASE [BMSWeb] SET MULTI_USER GO ALTER DATABASE [BMSWeb] SET PAGE_VERIFY CHECKSUM GO ALTER DATABASE [BMSWeb] SET DB_CHAINING OFF GO USE [BMSWeb] GO /****** Object: Table [dbo].[publishing] Script Date: 06/18/2018 21:26:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[publishing]( [pubid] [int] NOT NULL, [pubname] [varchar](50) NOT NULL, PRIMARY KEY CLUSTERED ( [pubid] 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 SET ANSI_PADDING OFF GO INSERT [dbo].[publishing] ([pubid], [pubname]) VALUES (1, N'清华大学出版') /****** Object: Table [dbo].[borrowinfo] Script Date: 06/18/2018 21:26:22 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[borrowinfo]( [id] [int] IDENTITY(1,1) NOT NULL, [bookid] [int] NOT NULL, [readerid] [int] NOT NULL, [borrowdate] [datetime] NULL, [returndate] [datetime] NULL, [renew] [char](100) NULL, [fine] [decimal](18, 0) 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 SET ANSI_PADDING OFF GO SET IDENTITY_INSERT [dbo].[borrowinfo] ON INSERT [dbo].[borrowinfo] ([id], [bookid], [readerid], [borrowdate], [returndate], [renew], [fine]) VALUES (39, 123, 121, CAST(0x0000A901016D52A8 AS DateTime), CAST(0x0000A901016E7B24 AS DateTime), N'2018-07-16 22:10:06 ', CAST(0 AS Decimal(18, 0))) INSERT [dbo].[borrowinfo] ([id], [bookid], [readerid], [borrowdate], [returndate], [renew], [fine]) VALUES (40, 123, 121, CAST(0x0000A901016E903C AS DateTime), CAST(0x0000A901016E9BF4 AS DateTime), N'2018-07-16 22:14:37 �