springboot快速实现自己的服务器接口

springboot快速开发后台与接口(文末附代码)

数据库表设计与创建

工具下载

• mysql下载5.7以下，新旧版本有差异
  • 安装时记得设置初始密码
• navicat下载,密码xzrr

创建数据库

/*
Navicat MySQL Data Transfer

Source Server         : wxdemo
Source Server Version : 50725
Source Host           : localhost:3306
Source Database       : supermansirts

Target Server Type    : MYSQL
Target Server Version : 50725
File Encoding         : 65001

Date: 2019-03-30 21:10:37
*/

SET FOREIGN_KEY_CHECKS=0;

-- ---------男士衬衫三张表实际使用需要改-------------------
-- Table structure for tb_minfo
-- ----------------------------
DROP TABLE IF EXISTS `tb_minfo`;
CREATE TABLE `tb_minfo` (
  `m_id` int(10) NOT NULL AUTO_INCREMENT,
  `shirt_id` int(10) NOT NULL,
  `record_id` int(10) NOT NULL,
  `user_name` varchar(200) NOT NULL,
  `user_pass` int(30) NOT NULL DEFAULT '0',
  `user_himg` varchar(200) DEFAULT NULL,
  `nick_name` varchar(50) DEFAULT NULL,
  `m_shape` varchar(50) DEFAULT '标准体',
  `m_abdomen` varchar(50) DEFAULT '扁腹',
  `m_shoulder` varchar(50) DEFAULT '耸肩',
  PRIMARY KEY (`m_id`),
  UNIQUE KEY `UK_N` (`user_name`),
  KEY `record_id` (`record_id`)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of tb_minfo
-- ----------------------------
INSERT INTO `tb_minfo` VALUES ('3', '0', '0', '18822179535', '123456', 'https://ss0.bdstatic.com/-0U0b8Sm1A5BphGlnYG/kmarketingadslogo/49b8e752ae9dbb3a5ed375f1185d7683_250_250.jpg', 'superman1553929794077', '标准体', '扁腹', '耸肩');
INSERT INTO `tb_minfo` VALUES ('4', '0', '0', '15534510036', '123456', 'https://ss0.bdstatic.com/-0U0b8Sm1A5BphGlnYG/kmarketingadslogo/49b8e752ae9dbb3a5ed375f1185d7683_250_250.jpg', 'superman1553930598372', '标准体', '扁腹', '耸肩');

-- ----------------------------
-- Table structure for tb_order
-- ----------------------------
DROP TABLE IF EXISTS `tb_order`;
CREATE TABLE `tb_order` (
  `record_id` int(10) NOT NULL AUTO_INCREMENT,
  `record_time` datetime DEFAULT NULL,
  `record_num` varchar(200) DEFAULT NULL,
  `record_img` varchar(30) DEFAULT NULL,
  `record_season` varchar(50) DEFAULT '夏季',
  `record_scene` varchar(50) DEFAULT '日常'