用mysql做宠物商店项目_使用Java实现数据库编程 项目（宠物商店）

创建数据库代码：

DROP DATABASE IF EXISTS petShop;

CREATE DATABASE petShop;

USE petShop;

/*创建表*/

CREATE TABLE `petStore`(

id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,

`name` CHAR() NULL,

`password` CHAR() NULL,

`balance` INT() NULL

)ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `petOwner`(

id INT() AUTO_INCREMENT NOT NULL PRIMARY KEY,

`name` CHAR() NULL,

`password` CHAR() NULL,

`money` INT() NULL

)ENGINE=INNODB DEFAULT CHARSET=utf8;

CREATE TABLE `pet`(

id INT() AUTO_INCREMENT NOT NULL PRIMARY KEY,

`name` CHAR() NOT NULL,

`typeName` CHAR() NULL,

`health` INT() NULL,

`love` INT() NULL,

`birthday` TIMESTAMP NULL,

`owner_id` INT() NULL,

`store_id` INT() NULL

)ENGINE=INNODB DEFAULT CHARSET=utf8;