create database BookShop
go
use BookShop
go
--图书表
create table Book
(
BookID int identity(1,1) primary key,
BookName varchar(20),
BookAuthor varchar(20),
BookPrice money,
BookPublisher varchar(20)
)
--用户表
go
create table Users
(
UserID int identity(1,1) primary key,
UserName varchar(20),
)
--购书表
go
create table BuyBooks
(
BuyID int identity(1,1) primary key,
UserID int foreign key references Users(UserID),
BookID int foreign key references Book(BookID),
Num int,
OrderID int references BookOrders(OrderID)
)
go
--订单表
create table BookOrders
(
OrderID int identity(1,1) primary key,
OrderCode varchar(50),
UserID int foreign key references Users(UserID),
OrderMoney money,
OrderDate datetime
)
.rar （16个子文件） 
购物车小程序 WebTest App_Code 
PO.cs 3KB UserSession.cs 529B Database.cs 3KB DAO.cs 5KB BookView.aspx 2KB BookCar.aspx 4KB Web.Config 2KB BookEdit.aspx.cs 3KB BookEdit.aspx 2KB BookView.aspx.cs 3KB OrderPage.aspx.cs 2KB BookList.aspx 3KB BookCar.aspx.cs 6KB OrderPage.aspx 3KB BookList.aspx.cs 4KB SQL语句.sql 784B资源评论
