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

 

 

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;

 页面

项目下载链接：https://github.com/weibanggang/Petmanagementsystem.git