The Front Use website:
Run on Tomcat
Database:mysql
Tables and produce of mysql
The admin of the System can login the system to crud the clothes int the database.
All the clothes info in table cloth
CREATE TABLE `cloth` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`name` varchar(50) NOT NULL,
`type` tinyint(4) NOT NULL COMMENT ‘0-cocat 1-pants’,
`size` varchar(50) NOT NULL COMMENT ‘XL’,
`gender` varchar(50) NOT NULL COMMENT ‘all,female male’,
`brand` varchar(50) DEFAULT NULL COMMENT ‘NIKE’,
`situation` varchar(50) DEFAULT NULL COMMENT ‘business/sports/home’,
`season` varchar(50) DEFAULT NULL COMMENT ‘1-spring 2-summer 3-fall 4-winter’,
`color` varchar(50) DEFAULT NULL,
`image` varchar(50) DEFAULT NULL,
PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=417 DEFAULT CHARSET=utf8;
Name is cloth name
Type ‘0-cocat 1-pants’
Situation is for business or sports or normalwear
Season
Color
The table femalesizechart and malesizechart is the standard size and measurements of a woman’s bust, waist, and hips and men’s chest waist and arm mapping
The table user is the admin account and password
The table season is the mapping of season and temperature
Table choosehis is the history of the user to choose suitable cloth
CREATE TABLE `choosehis` (
`id` int(11) NOT NULL,
`coatid` int(11) NOT NULL,
`pantsid` int(11) NOT NULL,
`time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
PRIMARY KEY (`id`),
KEY `f_coatid` (`coatid`),
KEY `f_pantsid` (`pantsid`),
CONSTRAINT `f_coatid` FOREIGN KEY (`coatid`) REFERENCES `cloth` (`id`),
CONSTRAINT `f_pantsid` FOREIGN KEY (`pantsid`) REFERENCES `cloth` (`id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
User’s Manuel
For admin
url: http://localhost:8088/clothes/admin.do
accout:admin
password:admin
login in and to manager the clothes in database include crud;
For user
url: http://localhost:8088/clothes/
input user’s info to get suitable cloth
And then get some comb pairs
The user choose one comb and add the info to the table choosehis