Java毕业设计_宠物医疗系统

宠物医疗系统

宠物医疗系统mysql数据库创建语句
宠物医疗系统oracle数据库创建语句
宠物医疗系统sqlserver数据库创建语句
宠物医疗系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
宠物医疗系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
高质量编程视频：shangyepingtai.xin

宠物医疗系统mysql数据库版本源码：

超级管理员表创建语句如下：
create table t_admin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘超级管理员账号’,
password varchar(100) comment ‘超级管理员密码’
) comment ‘超级管理员’;
insert into t_admin(username,password) values(‘admin’,‘123456’);
SQLCopy
宠物就诊表创建语句如下：
create table t_chongwu(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘用户’,
chongwuNum varchar(100) comment ‘宠物编号’,
nickName varchar(100) comment ‘昵称’,
sex varchar(100) comment ‘性别’,
age varchar(100) comment ‘年龄’,
pz varchar(100) comment ‘品种’,
phone varchar(100) comment ‘紧急联系电话’,
bq varchar(100) comment ‘病情描述’,
status varchar(100) comment ‘状态’,
doctorName varchar(100) comment ‘医生’,
remark varchar(100) comment ‘治疗结果’,
insertDate datetime comment ‘挂号日期’,
endDate datetime comment ‘处理日期’,
fy int comment ‘费用’,
fyms varchar(100) comment ‘费用描述’
) comment ‘宠物就诊’;
SQLCopy
会员表创建语句如下：
create table t_customer(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
customerName varchar(100) comment ‘姓名’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’,
levels varchar(100) comment ‘会员等级’
) comment ‘会员’;
SQLCopy
医生表创建语句如下：
create table t_doctor(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
doctorName varchar(100) comment ‘姓名’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’,
pic varchar(100) comment ‘头像’,
remark varchar(100) comment ‘医生特长’
) comment ‘医生’;
SQLCopy
药品表创建语句如下：
create table t_yaopin(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘药品名称’,
jg int comment ‘价格’,
hyjg int comment ‘高级会员价格’,
kc int comment ‘库存’,
pic varchar(100) comment ‘图片’,
zy varchar(100) comment ‘作用’
) comment ‘药品’;
SQLCopy

宠物医疗系统oracle数据库版本源码：

超级管理员表创建语句如下：
create table t_admin(
id integer,
username varchar(100),
password varchar(100)
);
insert into t_admin(id,username,password) values(1,‘admin’,‘123456’);
–超级管理员字段加注释
comment on column t_admin.id is ‘主键’;
comment on column t_admin.username is ‘超级管理员账号’;
comment on column t_admin.password is ‘超级管理员密码’;
–超级管理员表加注释
comment on table t_admin is ‘超级管理员’;
SQLCopy
宠物就诊表创建语句如下：
create table t_chongwu(
id integer,
customerId int,
chongwuNum varchar(100),
nickName varchar(100),
sex varchar(100),
age varchar(100),
pz varchar(100),
phone varchar(100),
bq varchar(100),
status varchar(100),
doctorName varchar(100),
remark varchar(100),
insertDate datetime,
endDate datetime,
fy int,
fyms varchar(100)
);
–宠物就诊字段加注释
comment on column t_chongwu.id is ‘主键’;
comment on column t_chongwu.customerId is ‘用户’;
comment on column t_chongwu.chongwuNum is ‘宠物编号’;
comment on column t_chongwu.nickName is ‘昵称’;
comment on column t_chongwu.sex is ‘性别’;
comment on column t_chongwu.age is ‘年龄’;
comment on column t_chongwu.pz is ‘品种’;
comment on column t_chongwu.phone is ‘紧急联系电话’;
comment on column t_chongwu.bq is ‘病情描述’;
comment on column t_chongwu.status is ‘状态’;
comment on column t_chongwu.doctorName is ‘医生’;
comment on column t_chongwu.remark is ‘治疗结果’;
comment on column t_chongwu.insertDate is ‘挂号日期’;
comment on column t_chongwu.endDate is ‘处理日期’;
comment on column t_chongwu.fy is ‘费用’;
comment on column t_chongwu.fyms is ‘费用描述’;
–宠物就诊表加注释
comment on table t_chongwu is ‘宠物就诊’;
SQLCopy
会员表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
levels varchar(100)
);
–会员字段加注释
comment on column t_customer.id is ‘主键’;
comment on column t_customer.username is ‘账号’;
comment on column t_customer.password is ‘密码’;
comment on column t_customer.cus