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)
values(656,'旺财','狗狗',100,85,to_date('2015-11-11','yyyy-mm-dd'),366,215);
insert into pet(ID,NAME,TYPENAME,LOVE,BITHDAY,OWNER_ID,STORE_ID)
values(657,'小白','蛇',100,75,to_date('201512-12','yyyy-mm-dd'),367,216);
SELECT * FROM PET;
DELETE PET;
create table Petowner(
ID NUMBER,
NAME VARCHAR2(50),
PASSWORD VARCHAR2(50),
MONEY NUMBER(10,2)
);
insert into Petowner(ID,NAME,PASSWORD,MONEY)
values(361,'小红'，'6661',150);
insert into Petowner(ID,NAME,PASSWORD,MONEY)
values(362,'前前'，'6662',200);
insert into Petowner(ID,NAME,PASSWORD,MONEY)
values(363,'小静'，'6663',80);
insert into Petowner(ID,NAME,PASSWORD,MONEY)
values(364,'菲菲'，'6664',163);
insert into Petowner(ID,NAME,PASSWORD,MONEY)
values(365,'夏雨'，'6665',45);
select * from Petowner;
delete Petowner;
create table Petstore(
ID NUMBER,
NAME VARCHAR2(50),
PASSWORD VARCHAR2(50),
MONEY NUMBER(10,2)
);
insert into Petstore(ID,NAME,PASSWORD,MONEY)
values(001,'安徽第一宠物店'，'1101',4300);
insert into Petstore (ID,NAME,PASSWORD,BALANCE)
values(002,'北京西苑','1102',5507);
insert into Petstore(ID,NAME,PASSWORD,BALANCE)
values(003,'重庆观音桥','1103',8954);
SELECT * FROM PETSTORE;
DELETE PETSTORE;
create table Account(
ID NUMBER,
DEAL_TYPE NUMBER,
PET_ID NUMBER,
SELLER_ID,
BUYER_ID,NUMBER,
PRICE NUMBER,
DEAL_TIME DATE
);
PetStore.zip （89个子文件） 
所有的数据库脚本.txt 2KB
PetStore 
.project 379B petownertrade.log 6KB shoptrade.log 6KB src com account AccountAll.java 4KB Interface Sellable.java 160B Breedable.java 169B PetOwnerService.java 166B PetStoreService.java 348B Buyable.java 189B PetOwnerServiceImpl.java 4KB PetStoreServiceImpl.java 6KB Accountable.java 352B shop Store.java 1KB frame shop ShopFrame.java 11KB TableModelEvent_Example.java 3KB StoreAccountTable.java 3KB pet BuyPet.java 8KB user PetOwnerAccountTable.java 3KB PetOwnerFrame.java 13KB register RegisterFrame.java 9KB RegisterSuccess.java 2KB login LoginCheck.java 2KB TestMain.java 238B LoginCheck2.java 2KB Login.java 6KB exception ExceptionAll.java 863B pet PetOwner.java 2KB Test.java 825B Pet.java 2KB Account.java 2KB dao Tes.java 499B PetOwnerDao.java 5KB Dao.java 812B PetStoreDao.java 7KB PetDao.java 3KB user User.java 57B test startPetShop.java 56B Main.java 334B socket connection SocketConnect.java 1KB tool ScreenFocus.java 869B server Services.java 53B log4j.properties 2KB lib 
log4j-1.2.16.jar 470KB ojdbc7.jar 3.24MB shopexception.log 7KB .settings org.eclipse.jdt.core.prefs 598B org.eclipse.core.resources.prefs 69B .classpath 413B bin com account AccountAll.class 4KB Interface PetOwnerServiceImpl.class 5KB Sellable.class 145B PetStoreService.class 455B Breedable.class 186B Buyable.class 176B Accountable.class 330B PetStoreServiceImpl.class 7KB PetOwnerService.class 257B shop Store.class 1KB frame shop TableModelEvent_Example.class 2KB StoreAccountTable.class 4KB ShopFrame.class 11KB pet BuyPet.class 9KB user PetOwnerFrame.class 12KB PetOwnerAccountTable.class 4KB register RegisterSuccess.class 2KB RegisterFrame.class 7KB login LoginCheck.class 3KB Login.class 6KB LoginCheck2.class 2KB TestMain.class 632B exception ExceptionAll.class 942B pet Account.class 2KB PetOwner.class 3KB Pet.class 3KB Test.class 371B dao PetStoreDao.class 7KB Dao.class 1KB PetOwnerDao.class 5KB Tes.class 1024B PetDao.class 5KB user User.class 255B test startPetShop.class 279B Main.class 671B socket connection SocketConnect.class 2KB tool ScreenFocus.class 1KB server Services.class 271B log4j.properties 2KB
宠物商店详细设计说明书.doc 843KB资源评论
