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

 

 

创建数据库代码：

 

DROP DATABASE IF EXISTS petShop;  
CREATE DATABASE petShop;  

USE petShop;  
/*创建表*/  
CREATE TABLE `petStore`(  
    id INT AUTO_INCREMENT NOT NULL PRIMARY KEY,  
    `name` CHAR(10) NULL,  
    `password` CHAR(10) NULL,  
    `balance` INT(4) NULL  
 )ENGINE=INNODB DEFAULT CHARSET=utf8;  
   
 CREATE TABLE `petOwner`(  
    id INT(4) AUTO_INCREMENT NOT NULL PRIMARY KEY,  
    `name` CHAR(10) NULL,  
    `password` CHAR(10) NULL,  
    `money` INT(4) NULL  
)ENGINE=INNODB DEFAULT CHARSET=utf8;  
  
CREATE TABLE `pet`(  
    id INT(4) AUTO_INCREMENT NOT NULL PRIMARY KEY,  
    `name` CHAR(10) NOT NULL,  
    `typeName` CHAR(10) NULL,  
    `health` INT(4) NULL,  
    `love` INT(4) NULL,  
    `birthday` TIMESTAMP NULL,  
    `owner_id` INT(4) NULL,  
    `store_id` INT(4) NULL  
)ENGINE=INNODB DEFAULT CHARSET=utf8;  
  
CREATE TABLE `account`(  
    `id` INT(4) AUTO_INCREMENT NOT NULL PRIMARY KEY,  
    `deal_type` INT(4) NULL,  
    `pet_id` INT(4) NULL,  
    `seller_id` INT(