系统前台应用网页的功能包括：图书列表，图书详情，个人中心，整站搜索，用户订购。
系统后台管理网页的功能包括：系统设置，会员管理，图书管理，订单审核，入库管理，出库管理，财务报表。
2022-12-13 19:16:58
2.72MB
前端为jsp页面和ajax异步和后端交互
后端为ssm框架整合
数据库包含在压缩包内
运行环境 idea+mysql+jdk1.8。
包含阿里沙箱支付支付系统+邮件验证登录系统。
2022-12-06 20:38:36
84.41MB
1
基于SQL的数据库课程设计
1.图书销售统计
Create View OrderStat as
Select TOP 10 Book.ISBN , Lib.bName , Book.bClass , Book.bAuthor , Book.bPress , Lib.lNumber
From Book,Lib
Where Lib.bName=Book.bName
Order by Lib.lNumber DESC
2.图书退货统计
Create view RefundStat as
Select TOP 10 Book.ISBN,Lib.bName,Book.bClass,Book.bAuthor,Book.bPress,Refund.rNumber
From Book,Lib,Refund
Where Lib.bName=Book.bName and Refund.bName=Book.bName
Order by Refund.rNumber DESC
3.图书体日销售量统计
Create view DayStat as
select TOP 10 Orders.oDate as 日期 ,SUM(Orders.oNumber) as 数量
From Orders,Lib,Book
Where Lib.bName=Book.bName and Orders.bName=Book.bName
Group by Orders.oDate
Order by Orders.oDate ASC
4.库存信息量
Create view LibStat as
Select Book.ISBN,Lib.bName,Book.bClass,Book.bAuthor,Book.bPress,Lib.lNumber
From Lib,Book
Where Lib.bName=Book.bName
2022-06-27 15:06:33
70KB
1