技术:
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’)