宠物商店详细设计说明书(5)

③宠物数据库操作类：PetDaoImpl

④宠物商店账目信息数据库操作类 ：AccountDaoImpl

iv.

4.1库表关系图

4.1.1 库表描述

名称 宠物表 用户表 商店表

1. 宠物表

概念结构设计

实现 Pet PetOwner PetStore

2. 主人表

3 商店表

4.1.2 数据库脚本 CREATE TABLE PET( ID NUMBER,

NAME VARCHAR2(50); TYPENAME VARCHAR(20); HEALTH NUMBER,

LOVE NUMBER, BIRTHDAY DATE, OWNER_ID NUMBER, STORE_ID NUMBER)；

CREATE SEQUENCE SEQ_NAME STATR WITH 1 INCREMENT BY 1 NOMAXVALUE CACHE 10;

select to_char(BIRTHDAY,'mm-dd-yyyy')from pet； insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)

values(651,'小花','狗狗

',90,89,to_date('2015-02-14','yyyy-mm-dd'),361,985);

insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)

values(652,'贝贝','喵咪

',100,95,to_date('2015-05-05','yyyy-mm-dd'),362,211);

insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)

values(653,'小环','企鹅

',98,100,to_date('2015-08-08','yyyy-mm-dd'),363,212);

insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)

values(654,'麦克','鹦鹉

',100,100,to_date('2015-09-09','yyyy-mm-dd'),364,213);

insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)

values(655,'爱丽丝','仓鼠

',100,95,to_date('2015-10-01','yyyy-mm-dd'),365,214);

insert into

pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID