- 医院医疗器械管理系统mysql数据库创建语句
- 医院医疗器械管理系统oracle数据库创建语句
- 医院医疗器械管理系统sqlserver数据库创建语句
- 医院医疗器械管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 医院医疗器械管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
医院医疗器械管理系统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_doctor(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
doctor varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '',
zw varchar(100) comment '职位',
ks varchar(100) comment '科室'
) comment '医生';
器械表创建语句如下：
create table t_qx(
id int primary key auto_increment comment '主键',
qxName varchar(100) comment '器械编号',
fl varchar(100) comment '分类',
mc varchar(100) comment '名称',
jg varchar(100) comment '价格',
sl varchar(100) comment '数量',
ly varchar(100) comment '来源地址',
content1 text comment '使用描述',
showDate1 datetime comment '入库时间',
showDate2 datetime comment '出库时间',
whfy int comment '维护费用',
whsj varchar(100) comment '维修时间',
synx varchar(100) comment '使用年限'
) comment '器械';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
insertDate datetime comment '日期',
remark text comment '内容'
) comment '通知';
器械维修报备表创建语句如下：
create table t_wx(
id int primary key auto_increment comment '主键',
qxName varchar(100) comment '器械编号',
showDate datetime comment '维修开始日期',
endDate datetime comment '维修结束日期',
remark text comment '维修备注',
fee int comment '维修费用',
czr varchar(100) comment '操作人'
) comment '器械维修报备';
器械销毁报备表创建语句如下：
create table t_xh(
id int primary key auto_increment comment '主键',
qxName varchar(100) comment '器械编号',
showDate datetime comment '销毁日期',
remark text comment '销毁备注',
czr 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_doctor(
id integer,
username varchar(100),
password varchar(100),
doctor varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
zw varchar(100),
ks 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.doctor is '姓名';
comment on column t_doctor.phone is '电话';
comment on column t_doctor.age is '年龄';
comment on column t_doctor.sex is '';
comment on column t_doctor.zw is '职位';
comment on column t_doctor.ks is '科室';
--医生表加注释
comment on table t_doctor is '医生';
器械表创建语句如下：
create table t_qx(
id integer,
qxName varchar(100),
fl varchar(100),
mc varchar(100),
jg varchar(100),
sl varchar(100),
ly varchar(100),
content1 text,
showDate1 datetime,
showDate2 datetime,
whfy int,
whsj varchar(100),
synx varchar(100)
);
--器械字段加注释
comment on column t_qx.id is '主键';
comment on column t_qx.qxName is '器械编号';
comment on column t_qx.fl is '分类';
comment on column t_qx.mc is '名称';
comment on column t_qx.jg is '价格';
comment on column t_qx.sl is '数量';
comment on column t_qx.ly is '来源地址';
comment on column t_qx.content1 is '使用描述';
comment on column t_qx.showDate1 is '入库时间';
comment on column t_qx.showDate2 is '出库时间';
comment on column t_qx.whfy is '维护费用';
comment on column t_qx.whsj is '维修时间';
comment on column t_qx.synx is '使用年限';
--器械表加注释
comment on table t_qx is '器械';
通知表创建语句如下：
create table t_tongzhi(
id integer,
title varchar(100),
insertDate datetime,
remark text
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.insertDate is '日期';
comment on column t_tongzhi.remark is '内容';
--通知表加注释
comment on table t_tongzhi is '通知';
器械维修报备表创建语句如下：
create table t_wx(
id integer,
qxName varchar(100),
showDate datetime,
endDate datetime,
remark text,
fee int,
czr varchar(100)
);
--器械维修报备字段加注释
comment on column t_wx.id is '主键';
comment on column t_wx.qxName is '器械编号';
comment on column t_wx.showDate is '维修开始日期';
comment on column t_wx.endDate is '维修结束日期';
comment on column t_wx.remark is '维修备注';
comment on column t_wx.fee is '维修费用';
comment on column t_wx.czr is '操作人';
--器械维修报备表加注释
comment on table t_wx is '器械维修报备';
器械销毁报备表创建语句如下：
create table t_xh(
id integer,
qxName varchar(100),
showDate datetime,
remark text,
czr varchar(100)
);
--器械销毁报备字段加注释
comment on column t_xh.id is '主键';
comment on column t_xh.qxName is '器械编号';
comment on column t_xh.showDate is '销毁日期';
comment on column t_xh.remark is '销毁备注';
comment on column t_xh.czr is '操作人';
--器械销毁报备表加注释
comment on table t_xh is '器械销毁报备';
oracle特有，对应序列如下：
create sequence s_t_doctor;
create sequence s_t_qx;
create sequence s_t_tongzhi;
create sequence s_t_wx;
create sequence s_t_xh;
医院医疗器械管理系统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_doctor(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
doctor varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--
zw varchar(100),--职位
ks varchar(100)--科室
);
器械表创建语句如下：
--器械表注释
create table t_qx(
id int identity(1,1) primary key not null,--主键
qxName varchar(100),--器械编号
fl varchar(100),--分类
mc varchar(100),--名称
jg varchar(100),--价格
sl varchar(100),--数量
ly varchar(100),--来源地址
content1 text,--使用描述
showDate1 datetime,--入库时间
showDate2 datetime,--出库时间
whfy int,--维护费用
whsj varchar(100),--维修时间
synx varchar(100)--使用年限
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
insertDate datetime,--日期
remark text--内容
);
器械维修报备表创建语句如下：
--器械维修报备表注释
create table t_wx(
id int identity(1,1) primary key not null,--主键
qxName varchar(100),--器械编号
showDate datetime,--维修开始日期
endDate datetime,--维修结束日期
remark text,--维修备注
fee int,--维修费用
czr varchar(100)--操作人
);
器械销毁报备表创建语句如下：
--器械销毁报备表注释
create table t_xh(
id int identity(1,1) primary key not null,--主键
qxName varchar(100),--器械编号
showDate datetime,--销毁日期
remark text,--销毁备注
czr varchar(100)--操作人
);
登录后主页.jpg?x-oss-process=style/00001)
医院医疗器械管理系统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_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 doctor;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//职位
private String zw;
//科室
private String ks;
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 getDoctor() {return doctor;}
public void setDoctor(String doctor) {this.doctor = doctor;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
}器械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_qx")
public class Qx {
//主键
@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 qxName;
//分类
private String fl;
//名称
private String mc;
//价格
private String jg;
//数量
private String sl;
//来源地址
private String ly;
//使用描述
private String content1;
//入库时间
private Date showDate1;
//出库时间
private Date showDate2;
//维护费用
private Integer whfy;
//维修时间
private String whsj;
//使用年限
private String synx;
public String getQxName() {return qxName;}
public void setQxName(String qxName) {this.qxName = qxName;}
public String getFl() {return fl;}
public void setFl(String fl) {this.fl = fl;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getLy() {return ly;}
public void setLy(String ly) {this.ly = ly;}
public String getContent1() {return content1;}
public void setContent1(String content1) {this.content1 = content1;}
public Date getShowDate1() {return showDate1;}
public void setShowDate1(Date showDate1) {this.showDate1 = showDate1;}
public Date getShowDate2() {return showDate2;}
public void setShowDate2(Date showDate2) {this.showDate2 = showDate2;}
public Integer getWhfy() {return whfy;}
public void setWhfy(Integer whfy) {this.whfy = whfy;}
public String getWhsj() {return whsj;}
public void setWhsj(String whsj) {this.whsj = whsj;}
public String getSynx() {return synx;}
public void setSynx(String synx) {this.synx = synx;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 Date insertDate;
//内容
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_wx")
public class Wx {
//主键
@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 qxName;
//维修开始日期
private Date showDate;
//维修结束日期
private Date endDate;
//维修备注
private String remark;
//维修费用
private Integer fee;
//操作人
private String czr;
public String getQxName() {return qxName;}
public void setQxName(String qxName) {this.qxName = qxName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
}器械销毁报备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_xh")
public class Xh {
//主键
@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 qxName;
//销毁日期
private Date showDate;
//销毁备注
private String remark;
//操作人
private String czr;
public String getQxName() {return qxName;}
public void setQxName(String qxName) {this.qxName = qxName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
}医院医疗器械管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
医生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 doctor;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//职位
private String zw;
//科室
private String ks;
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 getDoctor() {return doctor;}
public void setDoctor(String doctor) {this.doctor = doctor;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
}器械javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//器械
public class Qx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//器械编号
private String qxName;
//分类
private String fl;
//名称
private String mc;
//价格
private String jg;
//数量
private String sl;
//来源地址
private String ly;
//使用描述
private String content1;
//入库时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate1;
//出库时间
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate2;
//维护费用
private Integer whfy;
//维修时间
private String whsj;
//使用年限
private String synx;
public String getQxName() {return qxName;}
public void setQxName(String qxName) {this.qxName = qxName;}
public String getFl() {return fl;}
public void setFl(String fl) {this.fl = fl;}
public String getMc() {return mc;}
public void setMc(String mc) {this.mc = mc;}
public String getJg() {return jg;}
public void setJg(String jg) {this.jg = jg;}
public String getSl() {return sl;}
public void setSl(String sl) {this.sl = sl;}
public String getLy() {return ly;}
public void setLy(String ly) {this.ly = ly;}
public String getContent1() {return content1;}
public void setContent1(String content1) {this.content1 = content1;}
public Date getShowDate1() {return showDate1;}
public void setShowDate1(Date showDate1) {this.showDate1 = showDate1;}
public Date getShowDate2() {return showDate2;}
public void setShowDate2(Date showDate2) {this.showDate2 = showDate2;}
public Integer getWhfy() {return whfy;}
public void setWhfy(Integer whfy) {this.whfy = whfy;}
public String getWhsj() {return whsj;}
public void setWhsj(String whsj) {this.whsj = whsj;}
public String getSynx() {return synx;}
public void setSynx(String synx) {this.synx = synx;}
}通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知
public class Tongzhi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//日期
private Date insertDate;
//内容
private String remark;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Wx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//器械编号
private String qxName;
//维修开始日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//维修结束日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date endDate;
//维修备注
private String remark;
//维修费用
private Integer fee;
//操作人
private String czr;
public String getQxName() {return qxName;}
public void setQxName(String qxName) {this.qxName = qxName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
}器械销毁报备javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//器械销毁报备
public class Xh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//器械编号
private String qxName;
//销毁日期
private Date showDate;
//销毁备注
private String remark;
//操作人
private String czr;
public String getQxName() {return qxName;}
public void setQxName(String qxName) {this.qxName = qxName;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getCzr() {return czr;}
public void setCzr(String czr) {this.czr = czr;}
}