jsp 宠物管理系统

SET IDENTITY_INSERT vets ON; INSERT INTO vets(id,name) VALUES (1, 'James Carter'); INSERT INTO vets(id,name) VALUES (2, '马上好'); INSERT INTO vets(id,name) VALUES (3, 'Linda Douglas'); INSERT INTO vets(id,name) VALUES (4, '李大力'); INSERT INTO vets(id,name) VALUES (5, '张扬'); SET IDENTITY_INSERT vets OFF; SET IDENTITY_INSERT specialties ON; INSERT INTO specialties(id,name) VALUES (1, '放射科'); INSERT INTO specialties(id,name) VALUES (2, '外科'); INSERT INTO specialties(id,name) VALUES (3, '牙科'); INSERT INTO specialties(id,name) VALUES (4, '内科'); INSERT INTO specialties(id,name) VALUES (5, '神经科'); INSERT INTO vet_specialties VALUES (1, 5); INSERT INTO vet_specialties VALUES (2, 1); INSERT INTO vet_specialties VALUES (2, 4); INSERT INTO vet_specialties VALUES (3, 2); INSERT INTO vet_specialties VALUES (3, 3); INSERT INTO vet_specialties VALUES (4, 2); INSERT INTO vet_specialties VALUES (5, 1); SET IDENTITY_INSERT specialties OFF; SET IDENTITY_INSERT types ON; INSERT INTO types(id,name) VALUES (1, '猫'); INSERT INTO types(id,name) VALUES (2, '狗'); INSERT INTO types(id,name) VALUES (3, '蜥蜴'); INSERT INTO types(id,name) VALUES (4, '蛇'); INSERT INTO types(id,name) VALUES (5, '鸟'); INSERT INTO types(id,name) VALUES (6, '鼠'); SET IDENTITY_INSERT types OFF; SET IDENTITY_INSERT owners ON; INSERT INTO owners(id,name,address,city,telephone) VALUES (1, 'George Franklin', '110 W. Liberty St.', 'Madison', '6085551023'); INSERT INTO owners(id,name,address,city,telephone) VALUES (2, '王先生', '638 Cardinal Ave.', '济南', '6085551749'); INSERT INTO owners(id,name,address,city,telephone) VALUES (3, '赵耀', '2693 Commerce St.', '广州', '6085558763'); INSERT INTO owners(id,name,address,city,telephone) VALUES (4, '张大发', '563 Friendly St.', '天津', '6085553198'); INSERT INTO owners(id,name,address,city,telephone) VALUES (5, '宋丹东', '2387 S. Fair Way', '哈尔滨', '6085552765'); INSERT INTO owners(id,name,address,city,telephone) VALUES (6, '动物园', '西直门外大街', '北京', '6085552654'); SET IDENTITY_INSERT owners OFF; SET IDENTITY_INSERT pets ON; INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (1, 'Leo', '2000-09-07', 1, 1); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (2, '好家伙', '2002-08-06', 6, 2); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (3, '露露', '2001-04-17', 2, 3); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (4, '呆呆', '2000-03-07', 2, 3); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (5, '阿里', '2000-11-30', 3, 4); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (6, '大腕儿', '2000-01-20', 4, 5); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (7, '小虎', '1995-09-04', 2, 6); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (8, '沙沙', '1995-09-04', 4, 6); INSERT INTO pets(id,name,birth_date,type_id,owner_id) VALUES (9, 'Lucky', '1999-08-06', 5, 2); SET IDENTITY_INSERT pets OFF; SET IDENTITY_INSERT visits ON; INSERT INTO visits(id,pet_id,visit_date,description) VALUES (1, 7, '1996-03-04', 'X光'); INSERT INTO visits(id,pet_id,visit_date,description) VALUES (2, 3, '1996-03-04', 'X光'); INSERT INTO visits(id,pet_id,visit_date,description) VALUES (3, 6, '1996-06-04', '肠炎'); INSERT INTO visits(id,pet_id,visit_date,description) VALUES (4, 7, '1996-09-04', '手术'); SET IDENTITY_INSERT visits OFF; INSERT INTO employee(name,password) VALUES ('clerk','clerk'); INSERT INTO employee(name,password) VALUES ('accp','accp');