首页分享宠物商城后台管理系统(springMVC+Mybatis+数据库)

宠物商城后台管理系统(springMVC+Mybatis+数据库)

来源：萌宠菠菠乐园时间：2024-12-16 04:46

mysql数据库

create database swager; use swager; #类别 create table Category( id int primary key auto_increment, name varchar(50) ); insert into Category(name) values('Category_name'); #标签 create table Tag( id int primary key auto_increment, name varchar(50) ); insert into Tag(name) values('Tag_name'); #宠物 create table Pet( id int primary key auto_increment, category_id int references category(id), name varchar(50), photoUrls varchar(256), tags int references Tag(id), status varchar(50) ); insert into Pet(category_id,name,photoUrls,tags,status) values (1,'Pet_name','photoUrls',1,'ok'); #订单 create table orders( id int primary key auto_increment, petId int references Pet(id), quantity int, shipDate datetime, status varchar(50), complete bit ); #用户 create table User( id int primary key auto_increment, username varchar(50), firstName varchar(50), lastName varchar(50), email varchar(50), password varchar(50), phone varchar(50), userStatus varchar(50) ); insert into User(username,firstName,lastName,email,password,phone,userStatus) values ('username','firstName','lastName','email','password','phone','userStatus'); create table ApiResponse( code int primary key auto_increment, type varchar(50), message varchar(50) ); select * from orders; select * from Category; select * from User; select * from Tag; select * from Pet; select * from ApiResponse;