使用JSP+servLet实现宠物管理系统

drop database if EXISTS`epet`; create database `epet`; use `epet`; /*创建pet表*/ create table `pet` ( petId int(10) not null primary key comment 'ID', petName varchar(50) not null comment '昵称', petBread varchar(50) not null comment '品种', petSex varchar(10) not null comment '性别', birthday TIMESTAMP null comment '出生日期', description varchar(400) comment '描述' )ENGINE=INNODB DEFAULT CHARSET=utf8; /*插入数据*/ insert into pet values (20,'aa','狗','雄','2015-05-26','聪明的拉布拉多犬'); insert into pet values (22,'bb','猫','雄','2015-05-26','可爱的加菲猫'); insert into pet values (52,'cc','鸟','雄','2015-05-26','活泼的鸟'); insert into pet values (33,'dd','鼠','雄','2015-05-26','可爱的小白鼠'); insert into pet values (46,'ee','猫','雄','2015-05-26','可爱的加菲猫'); /*查询*/ select * from pet