java基于SSM的easypay日用品购物网站的设计与实现

技术：
java+mysql+ssm+tomcat+eclipse

截图：









数据库表：
CREATE TABLE adminuser (
auid int(11) NOT NULL AUTO_INCREMENT,
username varchar(255) DEFAULT NULL,
password varchar(255) DEFAULT NULL,
uid int(11) NOT NULL,
PRIMARY KEY (auid)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8;

---

– Records of adminuser

---

INSERT INTO adminuser VALUES (‘1’, ‘admin’, ‘admin’, ‘0’);

---

– Table structure for billitem

---

DROP TABLE IF EXISTS billitem;
CREATE TABLE billitem (
billid int(11) NOT NULL AUTO_INCREMENT,
count int(11) DEFAULT NULL,
ptotal double DEFAULT NULL,
pid int(11) DEFAULT NULL,
PRIMARY KEY (billid),
UNIQUE KEY pid (pid),
KEY FK3510439A73B4E627 (pid),
CONSTRAINT FK3510439A73B4E627 FOREIGN KEY (pid) REFERENCES product (pid)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

---

– Records of billitem

---

---

– Table structure for category

---

DROP TABLE IF EXISTS category;
CREATE TABLE category (
cid int(11) NOT NULL AUTO_INCREMENT,
cname varchar(255) DEFAULT NULL,
PRIMARY KEY (cid)
) ENGINE=InnoDB AUTO_INCREMENT=9 DEFAULT CHARSET=utf8;

---

– Records of category

---

INSERT INTO category VALUES (‘1’, ‘数码产品’);
INSERT INTO category VALUES (‘2’, ‘服装’);
INSERT INTO category VALUES (‘3’, ‘鞋靴箱包’);
INSERT INTO category VALUES (‘4’, ‘食品零食’);
INSERT INTO category VALUES (‘5’, ‘珠宝配饰’);
INSERT INTO category VALUES (‘6’, ‘护肤彩妆’);
INSERT INTO category VALUES (‘7’, ‘图书书籍’);
INSERT INTO category VALUES (‘8’, ‘家居饰品’);

---

– Table structure for categorysecond

---

DROP TABLE IF EXISTS categorysecond;
CREATE TABLE categorysecond (
csid int(11) NOT NULL AUTO_INCREMENT,
csname varchar(255) DEFAULT NULL,
cid int(11) DEFAULT NULL,
PRIMARY KEY (csid),
KEY FK936FCAF2418BCBAF (cid),
CONSTRAINT FK936FCAF2418BCBAF FOREIGN KEY (cid) REFERENCES category (cid)
) ENGINE=InnoDB AUTO_INCREMENT=34 DEFAULT CHARSET=utf8;

---

– Records of categorysecond

---

INSERT INTO categorysecond VALUES (‘1’, ‘电脑’, ‘1’);
INSERT INTO categorysecond VALUES (‘2’, ‘手机’, ‘1’);
INSERT INTO categorysecond VALUES (‘3’, ‘家电’, ‘1’);
INSERT INTO categorysecond VALUES (‘4’, ‘数码配件’, ‘1’);
INSERT INTO categorysecond VALUES (‘5’, ‘外套’, ‘2’);
INSERT INTO categorysecond VALUES (‘6’, ‘毛呢大衣’, ‘2’);
INSERT INTO categorysecond VALUES (‘7’, ‘风衣’, ‘2’);
INSERT INTO categorysecond VALUES (‘8’, ‘裤子’, ‘2’);
INSERT INTO categorysecond VALUES (‘9’, ‘男鞋’, ‘3’);
INSERT INTO categorysecond VALUES (‘10’, ‘女鞋’, ‘3’);
INSERT INTO categorysecond VALUES (‘11’, ‘男包’, ‘3’);
INSERT INTO categorysecond VALUES (‘13’, ‘女包’, ‘3’);
INSERT INTO categorysecond VALUES (‘14’, ‘休闲食品’, ‘4’);
INSERT INTO categorysecond VALUES (‘15’, ‘生鲜食品’, ‘4’);
INSERT INTO categorysecond VALUES (‘16’, ‘粮油调味’, ‘4’);
INSERT INTO categorysecond VALUES (‘17’, ‘地方特产’, ‘4’);
INSERT INTO categorysecond VALUES (‘18’, ‘时尚饰品’, ‘5’);
INSERT INTO categorysecond VALUES (‘19’, ‘眼镜配饰’, ‘5’);
INSERT INTO categorysecond VALUES (‘20’, ‘首饰’, ‘5’);
INSERT INTO categorysecond VALUES (‘21’, ‘手链’, ‘5’);
INSERT INTO categorysecond VALUES (‘22’, ‘手套’, ‘6’);
INSERT INTO categorysecond VALUES (‘23’, ‘暖手宝’, ‘6’);
INSERT INTO categorysecond VALUES (‘24’, ‘化妆品’, ‘6’);
INSERT INTO categorysecond VALUES (‘25’, ‘护肤品’, ‘6’);
INSERT INTO categorysecond VALUES (‘26’, ‘教育系列’, ‘7’);
INSERT INTO categorysecond VALUES (‘27’, ‘考试系列’, ‘7’);
INSERT INTO categorysecond VALUES (‘28’, ‘计算机系列’, ‘7’);
INSERT INTO categorysecond VALUES (‘29’, ‘小说系列’, ‘7’);
INSERT INTO categorysecond VALUES (‘30’, ‘四件套’, ‘8’);
INSERT INTO categorysecond VALUES (‘31’, ‘八件套’, ‘8’);
INSERT INTO categorysecond VALUES (‘32’, ‘窗帘’, ‘8’);
INSERT INTO categorysecond VALUES (‘33’, ‘沙发’, ‘8’)