VueÏîÄ¿£º²ËÅ©¹ÜÀí ¡¾maven + spring boot + RESTFul + SSM+vue + axios¡¿

#Êг¡±í
CREATE TABLE tb_market(
  market_id INT PRIMARY KEY AUTO_INCREMENT,
  market_name VARCHAR(50) COMMENT 'ũóÊг¡'
);
INSERT INTO tb_market(market_id,market_name) VALUES(1,'ãðÑôÏØÉ϶«¿¤Å©Ã³Êг¡');
INSERT INTO tb_market(market_id,market_name) VALUES(2,'ÐËÑôũóÊг¡');
INSERT INTO tb_market(market_id,market_name) VALUES(3,'ÃÎϪũóÊг¡');

#²ËÅ©±í
CREATE TABLE tb_farmer(
  fid INT PRIMARY KEY AUTO_INCREMENT,
  fname VARCHAR(50) COMMENT '²ËÅ©Ãû³Æ',
  age INT COMMENT '²ËÅ©ÄêÁä',
  photo VARCHAR(100) COMMENT 'Í·Ïñ',
  market_id INT COMMENT 'ËùÊôÊг¡'
);

INSERT INTO tb_farmer(fid,fname,age,photo,market_id) 
VALUES
(1,'ÕÅÈý',18,'https://tva2.sinaimg.cn/crop.0.0.996.996.1024/a818cb9ajw8ezq0h4qg8wj20ro0rptar.jpg',1),
(2,'ÕÅÈýÈý',18,'https://tvax1.sinaimg.cn/crop.0.0.512.512.1024/b8b96874ly8g4ngp1u0xdj20e80e8t9p.jpg',1),
(3,'ÀîËÄ',19,'https://tva3.sinaimg.cn/crop.0.44.421.421.1024/676e7956jw8f9ic2cdnouj20bp0e6q3j.jpg',2),
(4,'ÀîËÄËÄ',19,'https://tvax3.sinaimg.cn/crop.0.0.664.664.1024/007qwBaUly8g9xod0ja57j30ig0ig3zk.jpg',2),
(5,'ÍõÎå',20,'https://tvax3.sinaimg.cn/crop.0.0.439.439.1024/007d3wpply8ftn74yyy94j30c80c775i.jpg',3),
(6,'ÍõÎåÎå',21,'https://tvax2.sinaimg.cn/crop.0.114.500.500.1024/006r3Xirly8fuil9ib0cxj30dw0joaat.jpg',3)
;