更多成品,定做java毕业设计,请咨询管理员qq:2812491287

宠物医疗系统

宠物医疗系统登录注册界面

宠物医疗系统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');

宠物就诊表创建语句如下:


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 '宠物就诊';

会员表创建语句如下:


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 '会员';

医生表创建语句如下:


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 '医生';

药品表创建语句如下:


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 '药品';

宠物医疗系统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 '超级管理员';

宠物就诊表创建语句如下:


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 '宠物就诊';

会员表创建语句如下:


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.customerName is '姓名';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.levels is '会员等级';
--会员表加注释
comment on table t_customer is '会员';

医生表创建语句如下:


create table t_doctor(
	id integer,
	username varchar(100),
	password varchar(100),
	doctorName varchar(100),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	pic varchar(100),
	remark varchar(100)
);
--医生字段加注释
comment on column t_doctor.id is '主键';
comment on column t_doctor.username is '账号';
comment on column t_doctor.password is '密码';
comment on column t_doctor.doctorName is '姓名';
comment on column t_doctor.age is '年龄';
comment on column t_doctor.sex is '性别';
comment on column t_doctor.phone is '电话';
comment on column t_doctor.pic is '头像';
comment on column t_doctor.remark is '医生特长';
--医生表加注释
comment on table t_doctor is '医生';

药品表创建语句如下:


create table t_yaopin(
	id integer,
	title varchar(100),
	jg int,
	hyjg int,
	kc int,
	pic varchar(100),
	zy varchar(100)
);
--药品字段加注释
comment on column t_yaopin.id is '主键';
comment on column t_yaopin.title is '药品名称';
comment on column t_yaopin.jg is '价格';
comment on column t_yaopin.hyjg is '高级会员价格';
comment on column t_yaopin.kc is '库存';
comment on column t_yaopin.pic is '图片';
comment on column t_yaopin.zy is '作用';
--药品表加注释
comment on table t_yaopin is '药品';

oracle特有,对应序列如下:


create sequence s_t_chongwu;
create sequence s_t_customer;
create sequence s_t_doctor;
create sequence s_t_yaopin;

宠物医疗系统sqlserver数据库版本源码:

超级管理员表创建语句如下:


--超级管理员
create table t_admin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--超级管理员账号
	password varchar(100)--超级管理员密码
);
insert into t_admin(username,password) values('admin','123456');

宠物就诊表创建语句如下:


--宠物就诊表注释
create table t_chongwu(
	id int identity(1,1) primary key not null,--主键
	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)--费用描述
);

会员表创建语句如下:


--会员表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	levels varchar(100)--会员等级
);

医生表创建语句如下:


--医生表注释
create table t_doctor(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	doctorName varchar(100),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	pic varchar(100),--头像
	remark varchar(100)--医生特长
);

药品表创建语句如下:


--药品表注释
create table t_yaopin(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--药品名称
	jg int,--价格
	hyjg int,--高级会员价格
	kc int,--库存
	pic varchar(100),--图片
	zy varchar(100)--作用
);

宠物医疗系统登录后主页

宠物医疗系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

宠物就诊javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//宠物就诊
@Table(name = "t_chongwu")
public class Chongwu {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//宠物编号
private String chongwuNum;
//昵称
private String nickName;
//性别
private String sex;
//年龄
private String age;
//品种
private String pz;
//紧急联系电话
private String phone;
//病情描述
private String bq;
//状态
private String status;
//医生
private String doctorName;
//治疗结果
private String remark;
//挂号日期
private Date insertDate;
//处理日期
private Date endDate;
//费用
private Integer fy;
//费用描述
private String fyms;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getChongwuNum() {return chongwuNum;}
public void setChongwuNum(String chongwuNum) {this.chongwuNum = chongwuNum;}
public String getNickName() {return nickName;}
public void setNickName(String nickName) {this.nickName = nickName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getDoctorName() {return doctorName;}
public void setDoctorName(String doctorName) {this.doctorName = doctorName;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
public String getFyms() {return fyms;}
public void setFyms(String fyms) {this.fyms = fyms;}
}

会员javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//会员
@Table(name = "t_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//会员等级
private String levels;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getLevels() {return levels;}
public void setLevels(String levels) {this.levels = levels;}
}

医生javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//医生
@Table(name = "t_doctor")
public class Doctor {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String doctorName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//医生特长
private String remark;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getDoctorName() {return doctorName;}
public void setDoctorName(String doctorName) {this.doctorName = doctorName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

药品javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//药品
@Table(name = "t_yaopin")
public class Yaopin {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品名称
private String title;
//价格
private Integer jg;
//高级会员价格
private Integer hyjg;
//库存
private Integer kc;
//图片
private String pic;
//作用
private String zy;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
public Integer getHyjg() {return hyjg;}
public void setHyjg(Integer hyjg) {this.hyjg = hyjg;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

宠物医疗系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

宠物就诊javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//宠物就诊
public class Chongwu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//宠物编号
private String chongwuNum;
//昵称
private String nickName;
//性别
private String sex;
//年龄
private String age;
//品种
private String pz;
//紧急联系电话
private String phone;
//病情描述
private String bq;
//状态
private String status;
//医生
private String doctorName;
//治疗结果
private String remark;
//挂号日期
private Date insertDate;
//处理日期
private Date endDate;
//费用
private Integer fy;
//费用描述
private String fyms;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getChongwuNum() {return chongwuNum;}
public void setChongwuNum(String chongwuNum) {this.chongwuNum = chongwuNum;}
public String getNickName() {return nickName;}
public void setNickName(String nickName) {this.nickName = nickName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getBq() {return bq;}
public void setBq(String bq) {this.bq = bq;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getDoctorName() {return doctorName;}
public void setDoctorName(String doctorName) {this.doctorName = doctorName;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
public String getFyms() {return fyms;}
public void setFyms(String fyms) {this.fyms = fyms;}
}

会员javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//会员
public class Customer  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//会员等级
private String levels;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getLevels() {return levels;}
public void setLevels(String levels) {this.levels = levels;}
}

医生javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//医生
public class Doctor  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String doctorName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//头像
private String pic;
//医生特长
private String remark;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getDoctorName() {return doctorName;}
public void setDoctorName(String doctorName) {this.doctorName = doctorName;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

药品javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//药品
public class Yaopin  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品名称
private String title;
//价格
private Integer jg;
//高级会员价格
private Integer hyjg;
//库存
private Integer kc;
//图片
private String pic;
//作用
private String zy;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
public Integer getHyjg() {return hyjg;}
public void setHyjg(Integer hyjg) {this.hyjg = hyjg;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
}

评论