程序代写代做代考 arm database The Front Use website:

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