【正文】 /*================*/ /* Table: limite*/ /*================*/ create table limite（usernamevarchar(20)not null，Administrator_idvarchar(50)null，user_limitevarchar(2)not null，constraint PK_LIMITE primary key(username))go/*================*/ /* Table: model*/ /*================*/ create table model（model_idvarchar(10)not null，usernamevarchar(20)null，modelnamevarchar(20)not null，remarkvarchar(20)not null，constraint PK_MODEL primary key(model_id))go/*================*/ /* Table: orders*/ /*================*/ create table orders（Order_idvarchar(50)not null，bookIDvarchar(50)null，Usernamevarchar(20)null，Ship_idvarchar(50)null，shipaddressvarchar(50)not null，Order_datedatetimenot null，Book_idvarchar(50)not null，quantityintnot null，statusvarchar(2)not null，constraint PK_ORDERS primary key(Order_id))go/*================*/ /* Table: publish*/ /*================*/ create table publish（Pub_idvarchar(50)not null，Pub_namevarchar(50)not null，Pub_phonevarchar(15)not null，Pub_addvarchar(50)not null，constraint PK_PUBLISH primary key(Pub_id))go/*================*/ /* Table: sales*/ /*================*/ create table sales（Sale_idvarchar(50)not null，Order_idvarchar(50)null，Sale_datedatetimenull，Salervarchar(20)not null，Sale_statusvarchar(2)null，constraint PK_SALES primary key(Sale_id))go/*================*/ /* Table: shipped*/ /*================*/ create table shipped（Ship_idvarchar(50)not null，Sale_idvarchar(50)null，receive_namevarchar(10)not null，receive_addressvarchar(50)not null，Ship_datedatetimenot null，Ship_manvarchar(10)not null，receive_postcodevarchar(6)not null，receive_telephonevarchar(20)not null，constraint PK_SHIPPED primary key(Ship_id))go/*================*/ /* Table: shoppingcar*/ /*================*/ create table shoppingcar（shoppingcaridvarchar(10)not null，Smalltype_idvarchar(50)null，bookIDvarchar(50)null，Usernamevarchar(20)null，totalpricedouble precisionnot null，constraint PK_SHOPPINGCAR primary key(shoppingcarid))go/*================*/ /* Table: users*/ /*================*/ create table users（Usernamevarchar(20)not null，lim_usernamevarchar(20)null，Passwordvarchar(10)not null，degreevarchar(2)not null，Phonevarchar(15)null，“Emall”varchar(30)null，Addressvarchar(100)not null，True_namevarchar(10)not null，Postcodevarchar(6)not null，constraint PK_USERS primary key(Username))goalter table Administratorsadd constraint FK_ADMINIST_REFERENCE_USERS foreign key(Username)references users(Username)goalter table Re_statusadd constraint FK_RE_STATU_REFERENCE_ADMINIST foreign key(Administrator_id)references Administrators(Administrator_id)goalter table booksadd constraint FK_BOOKS_REFERENCE_BOOKTYPE foreign key(Smalltype_id)references booktype(Smalltype_id)goalter table booksadd constraint FK_BOOKS_REFERENCE_PUBLISH foreign key(Pub_id)references publish(Pub_id)goalter table booktypeadd constraint FK_BOOKTYPE_REFERENCE_BOOKTYPE foreign key(Smalltype_id)references booktype2(Smalltype_id)goalter table leaveWordsadd constraint FK_LEAVEWOR_REFERENCE_USERS foreign key(use_Username)references users(Username)goalter table limiteadd constraint FK_LIMITE_REFERENCE_ADMINIST foreign key(Administrator_id)references Administrators(Administrator_id)goalter table modeladd constraint FK_MODEL_REFERENCE_LIMITE foreign key(username)references limite(username)goalter table ordersadd constraint FK_ORDERS_REFERENCE_SHIPPED foreign key(Ship_id)references shipped(Ship_id)goalter table ordersadd constraint FK_ORDERS_REFERENCE_BOOKS foreign key(bookID)references books(bookID)goalter table ordersadd constraint FK_ORDERS_REFERENCE_USERS foreign key(Username)references users(Username)goalter table salesadd constraint FK_SALES_REFERENCE_ORDERS foreign key(Order_id)references orders(Order_id)goalter table shippedadd constraint FK_SHIPPED_REFERENCE_SALES foreign key(Sale_id)references sales(Sale_id)goalter table shoppingcaradd constraint FK_SHOPPING_REFERENCE_BOOKTYPE foreign key(Smalltype_id)references booktype2(Smalltype_id)goalter table shoppingcaradd constraint FK_SHOPPING_REFERENCE_BOOKS foreign key(bookID)references books(bookID)goalter table shoppingcaradd constraint FK_SHOPPING_REFERENCE_USERS foreign key(Username)references users(Username)goalter table usersadd constraint FK_USERS_REFERENCE_LIMITE foreign key(lim_username)references limite(username)goDB類：using System。using 。/// 提供訪問SQL Server的基本方法/// public class DB { public DB(){ }//connStr為訪問SQL Server2000的連接字符串//下面是臨時調(diào)試使用的方法，直接設(shè)置聯(lián)接字符串。database=bookstore。region 獲取查詢結(jié)果，DataSet GetSqlDataSet(string sqlString)/// /// 獲取查詢結(jié)果。try { //實例化連接對象SqlConnection，對象名為sqlConn SqlConnection sqlConn = new SqlConnection(connStr)。//(ds)是數(shù)據(jù)接口（SqlDataAdapter）提供的方法//具體作用為：//打開與數(shù)據(jù)庫的連接//將查詢的SQL語句發(fā)送到數(shù)據(jù)庫服務(wù)器 //接受返回的查詢結(jié)果//并將結(jié)