基于SpringMVC+MyBatis的服装专卖店网站的设计与实现
(一)基本信息
本项目是二级项目,利用目前较流行的第三方框架(BootStrap+SpringMVC+ MyBatis)进行开发,数据库服务器使用MySQL,Web服务器使用Tomcat。
项目场景:随着网络电子商务的发展,只依赖传统专卖店的模式跟不上时代的进步,公司提出了建设网络平台,可以进行在线销售,并且要线上线下相结合,可以共享门店商品和客户信息。
项目面向用户:普通客户和后台管理人员。
项目主要功能:客户通过网站浏览商品、搜索商品、管理购物车、查看商品详情、下订单、模拟支付,客户可以管理自己的个人信息和订单信息。后台管理人员完成商品信息的查询和管理、订单的查询和处理,以及网上销售相关的统计数据。
管理员:http://localhost:8080/springmvc_mybatis/admin/home
数据库表:
CREATE TABLE r_goodscolor
(
goods_id
int(11) NOT NULL,
color_id
int(11) NOT NULL,
PRIMARY KEY (goods_id
,color_id
),
KEY c_id
(color_id
),
CONSTRAINT c_id
FOREIGN KEY (color_id
) REFERENCES t_color
(color_id
),
CONSTRAINT g_id
FOREIGN KEY (goods_id
) REFERENCES t_goods
(goods_id
)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
CREATE TABLE r_goodssize
(
goods_id
int(11) NOT NULL,
size_id
int(11) NOT NULL,
PRIMARY KEY (goods_id
,size_id
),
KEY size_id
(size_id
),
CONSTRAINT goods_id
FOREIGN KEY (goods_id
) REFERENCES t_goods
(goods_id
),
CONSTRAINT size_id
FOREIGN KEY (size_id
) REFERENCES t_size
(size_id
)
CREATE TABLE t_address
(
addr_id
int(11) NOT NULL AUTO_INCREMENT,
user_id
int(11) NOT NULL,
addr_province
varchar(20) NOT NULL,
addr_city
varchar(20) NOT NULL,
addr_area
varchar(50) NOT NULL,
addr_content
varchar(100) NOT NULL,
addr_receiver
varchar(20) NOT NULL,
addr_tel
varchar(30) NOT NULL,
addr_isdefault
tinyint(4) NOT NULL,
PRIMARY KEY (addr_id
),
KEY addr_userid
(user_id
),
CONSTRAINT addr_userid
FOREIGN KEY (user_id
) REFERENCES t_user
(user_id
)
) ENGINE=InnoDB AUTO_INCREMENT=41 DEFAULT CHARSET=utf8;
CREATE TABLE t_category
(
cate_id
int(11) NOT NULL AUTO_INCREMENT,
cate_name
varchar(100) NOT NULL,
cate_pic
varchar(50) DEFAULT NULL,
PRIMARY KEY (cate_id
)
) ENGINE=InnoDB AUTO_INCREMENT=16 DEFAULT CHARSET=utf8;
CREATE TABLE t_color
(
color_id
int(11) NOT NULL AUTO_INCREMENT,
color_name
varchar(50) NOT NULL,
PRIMARY KEY (color_id
),
UNIQUE KEY color_name
(color_name
)
) ENGINE=InnoDB AUTO_INCREMENT=27 DEFAULT CHARSET=utf8;
CREATE TABLE t_order
(
order_id
int(11) NOT NULL AUTO_INCREMENT,
order_code
varchar(50) NOT NULL,
user_id
int(11) NOT NULL,
order_status
int(11) NOT NULL,
order_address
varchar(200) NOT NULL,
order_postalfee
float NOT NULL,
order_date
date NOT NULL,
order_postcode
varchar(50) DEFAULT NULL,
order_postname
varchar(50) DEFAULT NULL,
PRIMARY KEY (order_id
),
KEY uid
(user_id
) USING BTREE,
CONSTRAINT t_order_ibfk_1
FOREIGN KEY (user_id
) REFERENCES t_user
(user_id
)
) ENGINE=InnoDB AUTO_INCREMENT=121 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT COMMENT='InnoDB free: 6144 kB; (goods_id
) REFER mybatis/t_goods
; ';
CREATE TABLE t_orderdetail
(
odetail_id
int(11) NOT NULL AUTO_INCREMENT,
order_id
int(11) NOT NULL,
goods_id
int(11) DEFAULT NULL,
odetail_name
varchar(100) NOT NULL,
odetail_size
varchar(50) NOT NULL,
odetail_color
varchar(50) NOT NULL,
odetail_price
float NOT NULL,
odetail_num
int(11) NOT NULL,
odetail_pic
varchar(50) NOT NULL,
PRIMARY KEY (odetail_id
),
KEY order_id
(order_id
),
KEY t_orderdetail_ibfk_2
(goods_id
),
CONSTRAINT t_orderdetail_ibfk_1
FOREIGN KEY (order_id
) REFERENCES t_order
(order_id
),
CONSTRAINT t_orderdetail_ibfk_2
FOREIGN KEY (goods_id
) REFERENCES t_goods
(goods_id
) ON DELETE SET NULL
) ENGINE=InnoDB AUTO_INCREMENT=160 DEFAULT CHARSET=utf8 ROW_FORMAT=COMPACT;
截图
在这里插入图片描述