- 基于ssm药品管理系统mysql数据库创建语句
- 基于ssm药品管理系统oracle数据库创建语句
- 基于ssm药品管理系统sqlserver数据库创建语句
- 基于ssm药品管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于ssm药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于ssm药品管理系统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_ckrk(
id int primary key auto_increment comment '主键',
yaopinId int comment '药品',
sl int comment '数量',
types varchar(100) comment '类型',
content varchar(100) comment '详细记录',
insertDate datetime 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 '姓名',
gh varchar(100) comment '工号',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex 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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
ks varchar(100) comment '科室',
gh varchar(100) comment '工号',
zc varchar(100) comment '职称'
) comment '医生';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
pic varchar(100) comment '图片',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
供应商表创建语句如下：
create table t_gys(
id int primary key auto_increment comment '主键',
gysName varchar(100) comment '供应商名称',
address varchar(100) comment '地址',
lxr varchar(100) comment '供应商联系人',
phone varchar(100) comment '联系人电话',
yp varchar(100) comment '主营药品'
) comment '供应商';
患者表创建语句如下：
create table t_hz(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
hzName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
bs varchar(100) comment '病史',
sfz varchar(100) comment '身份证',
ybk varchar(100) comment '医保卡'
) comment '患者';
库存管理员表创建语句如下：
create table t_kcadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
kcadminName varchar(100) comment '姓名',
gh varchar(100) comment '工号',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '库存管理员';
药品订单表创建语句如下：
create table t_order(
id int primary key auto_increment comment '主键',
doctorId int comment '医生',
ddbh varchar(100) comment '订单编号',
hzId int comment '患者',
fee int comment '总金额',
ypqd varchar(100) comment '药品清单',
showDate datetime comment '日期',
status varchar(100) comment '状态'
) comment '药品订单';
药品退货表创建语句如下：
create table t_th(
id int primary key auto_increment comment '主键',
hzId int comment '患者',
ypqd varchar(100) comment '退货药品',
insertDate datetime comment '退货日期',
status varchar(100) comment '状态'
) comment '药品退货';
药品销售表创建语句如下：
create table t_xiaoshou(
id int primary key auto_increment comment '主键',
customerId int comment '销售',
yaopinId int comment '药品',
sl int comment '数量',
showDate datetime comment '销售日期',
kh varchar(100) comment '客户',
zje int comment '总金额'
) comment '药品销售';
药品表创建语句如下：
create table t_yaopin(
id int primary key auto_increment comment '主键',
gysId int comment '供应商',
yaopinName varchar(100) comment '药品',
gg varchar(100) comment '规格',
zy varchar(100) comment '作用',
content varchar(100) comment '详细说明',
pic varchar(100) comment '图片',
kc int comment '库存',
dj int comment '单价'
) comment '药品';
基于ssm药品管理系统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_ckrk(
id integer,
yaopinId int,
sl int,
types varchar(100),
content varchar(100),
insertDate datetime
);
--药品出库入库字段加注释
comment on column t_ckrk.id is '主键';
comment on column t_ckrk.yaopinId is '药品';
comment on column t_ckrk.sl is '数量';
comment on column t_ckrk.types is '类型';
comment on column t_ckrk.content is '详细记录';
comment on column t_ckrk.insertDate is '日期';
--药品出库入库表加注释
comment on table t_ckrk is '药品出库入库';
销售表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
gh varchar(100),
phone varchar(100),
age varchar(100),
sex 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.gh is '工号';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--销售表加注释
comment on table t_customer is '销售';
医生表创建语句如下：
create table t_doctor(
id integer,
username varchar(100),
password varchar(100),
doctorName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
ks varchar(100),
gh varchar(100),
zc 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.phone is '电话';
comment on column t_doctor.age is '年龄';
comment on column t_doctor.sex is '性别';
comment on column t_doctor.ks is '科室';
comment on column t_doctor.gh is '工号';
comment on column t_doctor.zc is '职称';
--医生表加注释
comment on table t_doctor is '医生';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
pic varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
供应商表创建语句如下：
create table t_gys(
id integer,
gysName varchar(100),
address varchar(100),
lxr varchar(100),
phone varchar(100),
yp varchar(100)
);
--供应商字段加注释
comment on column t_gys.id is '主键';
comment on column t_gys.gysName is '供应商名称';
comment on column t_gys.address is '地址';
comment on column t_gys.lxr is '供应商联系人';
comment on column t_gys.phone is '联系人电话';
comment on column t_gys.yp is '主营药品';
--供应商表加注释
comment on table t_gys is '供应商';
患者表创建语句如下：
create table t_hz(
id integer,
username varchar(100),
password varchar(100),
hzName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
bs varchar(100),
sfz varchar(100),
ybk varchar(100)
);
--患者字段加注释
comment on column t_hz.id is '主键';
comment on column t_hz.username is '账号';
comment on column t_hz.password is '密码';
comment on column t_hz.hzName is '姓名';
comment on column t_hz.phone is '电话';
comment on column t_hz.age is '年龄';
comment on column t_hz.sex is '性别';
comment on column t_hz.bs is '病史';
comment on column t_hz.sfz is '身份证';
comment on column t_hz.ybk is '医保卡';
--患者表加注释
comment on table t_hz is '患者';
库存管理员表创建语句如下：
create table t_kcadmin(
id integer,
username varchar(100),
password varchar(100),
kcadminName varchar(100),
gh varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--库存管理员字段加注释
comment on column t_kcadmin.id is '主键';
comment on column t_kcadmin.username is '账号';
comment on column t_kcadmin.password is '密码';
comment on column t_kcadmin.kcadminName is '姓名';
comment on column t_kcadmin.gh is '工号';
comment on column t_kcadmin.phone is '电话';
comment on column t_kcadmin.age is '年龄';
comment on column t_kcadmin.sex is '性别';
--库存管理员表加注释
comment on table t_kcadmin is '库存管理员';
药品订单表创建语句如下：
create table t_order(
id integer,
doctorId int,
ddbh varchar(100),
hzId int,
fee int,
ypqd varchar(100),
showDate datetime,
status varchar(100)
);
--药品订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.doctorId is '医生';
comment on column t_order.ddbh is '订单编号';
comment on column t_order.hzId is '患者';
comment on column t_order.fee is '总金额';
comment on column t_order.ypqd is '药品清单';
comment on column t_order.showDate is '日期';
comment on column t_order.status is '状态';
--药品订单表加注释
comment on table t_order is '药品订单';
药品退货表创建语句如下：
create table t_th(
id integer,
hzId int,
ypqd varchar(100),
insertDate datetime,
status varchar(100)
);
--药品退货字段加注释
comment on column t_th.id is '主键';
comment on column t_th.hzId is '患者';
comment on column t_th.ypqd is '退货药品';
comment on column t_th.insertDate is '退货日期';
comment on column t_th.status is '状态';
--药品退货表加注释
comment on table t_th is '药品退货';
药品销售表创建语句如下：
create table t_xiaoshou(
id integer,
customerId int,
yaopinId int,
sl int,
showDate datetime,
kh varchar(100),
zje int
);
--药品销售字段加注释
comment on column t_xiaoshou.id is '主键';
comment on column t_xiaoshou.customerId is '销售';
comment on column t_xiaoshou.yaopinId is '药品';
comment on column t_xiaoshou.sl is '数量';
comment on column t_xiaoshou.showDate is '销售日期';
comment on column t_xiaoshou.kh is '客户';
comment on column t_xiaoshou.zje is '总金额';
--药品销售表加注释
comment on table t_xiaoshou is '药品销售';
药品表创建语句如下：
create table t_yaopin(
id integer,
gysId int,
yaopinName varchar(100),
gg varchar(100),
zy varchar(100),
content varchar(100),
pic varchar(100),
kc int,
dj int
);
--药品字段加注释
comment on column t_yaopin.id is '主键';
comment on column t_yaopin.gysId is '供应商';
comment on column t_yaopin.yaopinName is '药品';
comment on column t_yaopin.gg is '规格';
comment on column t_yaopin.zy is '作用';
comment on column t_yaopin.content is '详细说明';
comment on column t_yaopin.pic is '图片';
comment on column t_yaopin.kc is '库存';
comment on column t_yaopin.dj is '单价';
--药品表加注释
comment on table t_yaopin is '药品';
oracle特有，对应序列如下：
create sequence s_t_ckrk;
create sequence s_t_customer;
create sequence s_t_doctor;
create sequence s_t_gg;
create sequence s_t_gys;
create sequence s_t_hz;
create sequence s_t_kcadmin;
create sequence s_t_order;
create sequence s_t_th;
create sequence s_t_xiaoshou;
create sequence s_t_yaopin;
基于ssm药品管理系统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_ckrk(
id int identity(1,1) primary key not null,--主键
yaopinId int,--药品
sl int,--数量
types varchar(100),--类型
content varchar(100),--详细记录
insertDate datetime--日期
);
销售表创建语句如下：
--销售表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
gh varchar(100),--工号
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
医生表创建语句如下：
--医生表注释
create table t_doctor(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
doctorName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
ks varchar(100),--科室
gh varchar(100),--工号
zc varchar(100)--职称
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
pic varchar(100),--图片
showDate datetime,--日期
v3 varchar(100)--内容
);
供应商表创建语句如下：
--供应商表注释
create table t_gys(
id int identity(1,1) primary key not null,--主键
gysName varchar(100),--供应商名称
address varchar(100),--地址
lxr varchar(100),--供应商联系人
phone varchar(100),--联系人电话
yp varchar(100)--主营药品
);
患者表创建语句如下：
--患者表注释
create table t_hz(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
hzName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
bs varchar(100),--病史
sfz varchar(100),--身份证
ybk varchar(100)--医保卡
);
库存管理员表创建语句如下：
--库存管理员表注释
create table t_kcadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
kcadminName varchar(100),--姓名
gh varchar(100),--工号
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
药品订单表创建语句如下：
--药品订单表注释
create table t_order(
id int identity(1,1) primary key not null,--主键
doctorId int,--医生
ddbh varchar(100),--订单编号
hzId int,--患者
fee int,--总金额
ypqd varchar(100),--药品清单
showDate datetime,--日期
status varchar(100)--状态
);
药品退货表创建语句如下：
--药品退货表注释
create table t_th(
id int identity(1,1) primary key not null,--主键
hzId int,--患者
ypqd varchar(100),--退货药品
insertDate datetime,--退货日期
status varchar(100)--状态
);
药品销售表创建语句如下：
--药品销售表注释
create table t_xiaoshou(
id int identity(1,1) primary key not null,--主键
customerId int,--销售
yaopinId int,--药品
sl int,--数量
showDate datetime,--销售日期
kh varchar(100),--客户
zje int--总金额
);
药品表创建语句如下：
--药品表注释
create table t_yaopin(
id int identity(1,1) primary key not null,--主键
gysId int,--供应商
yaopinName varchar(100),--药品
gg varchar(100),--规格
zy varchar(100),--作用
content varchar(100),--详细说明
pic varchar(100),--图片
kc int,--库存
dj int--单价
);
登录后主页.jpg?x-oss-process=style/00001)
基于ssm药品管理系统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_ckrk")
public class Ckrk {
//主键
@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 yaopinId;
//数量
private Integer sl;
//类型
private String types;
//详细记录
private String content;
//日期
private Date insertDate;
public Integer getYaopinId() {return yaopinId;}
public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}销售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 gh;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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;}
}医生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 phone;
//年龄
private String age;
//性别
private String sex;
//科室
private String ks;
//工号
private String gh;
//职称
private String zc;
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 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 getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
}公告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_gg")
public class Gg {
//主键
@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 v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}供应商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_gys")
public class Gys {
//主键
@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 gysName;
//地址
private String address;
//供应商联系人
private String lxr;
//联系人电话
private String phone;
//主营药品
private String yp;
public String getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getYp() {return yp;}
public void setYp(String yp) {this.yp = yp;}
}患者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_hz")
public class Hz {
//主键
@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 hzName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//病史
private String bs;
//身份证
private String sfz;
//医保卡
private String ybk;
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 getHzName() {return hzName;}
public void setHzName(String hzName) {this.hzName = hzName;}
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 getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getYbk() {return ybk;}
public void setYbk(String ybk) {this.ybk = ybk;}
}库存管理员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_kcadmin")
public class Kcadmin {
//主键
@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 kcadminName;
//工号
private String gh;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getKcadminName() {return kcadminName;}
public void setKcadminName(String kcadminName) {this.kcadminName = kcadminName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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;}
}药品订单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_order")
public class Order {
//主键
@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 doctorId;
//订单编号
private String ddbh;
//患者
private Integer hzId;
//总金额
private Integer fee;
//药品清单
private String ypqd;
//日期
private Date showDate;
//状态
private String status;
public Integer getDoctorId() {return doctorId;}
public void setDoctorId(Integer doctorId) {this.doctorId = doctorId;}
public String getDdbh() {return ddbh;}
public void setDdbh(String ddbh) {this.ddbh = ddbh;}
public Integer getHzId() {return hzId;}
public void setHzId(Integer hzId) {this.hzId = hzId;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getYpqd() {return ypqd;}
public void setYpqd(String ypqd) {this.ypqd = ypqd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}药品退货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_th")
public class Th {
//主键
@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 hzId;
//退货药品
private String ypqd;
//退货日期
private Date insertDate;
//状态
private String status;
public Integer getHzId() {return hzId;}
public void setHzId(Integer hzId) {this.hzId = hzId;}
public String getYpqd() {return ypqd;}
public void setYpqd(String ypqd) {this.ypqd = ypqd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}药品销售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_xiaoshou")
public class Xiaoshou {
//主键
@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 Integer yaopinId;
//数量
private Integer sl;
//销售日期
private Date showDate;
//客户
private String kh;
//总金额
private Integer zje;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYaopinId() {return yaopinId;}
public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
}药品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 Integer gysId;
//药品
private String yaopinName;
//规格
private String gg;
//作用
private String zy;
//详细说明
private String content;
//图片
private String pic;
//库存
private Integer kc;
//单价
private Integer dj;
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
public String getYaopinName() {return yaopinName;}
public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
}基于ssm药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
药品出库入库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药品出库入库
public class Ckrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品
private Integer yaopinId;
//数量
private Integer sl;
//类型
private String types;
//详细记录
private String content;
//日期
private Date insertDate;
public Integer getYaopinId() {return yaopinId;}
public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}销售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 gh;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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;}
}医生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 phone;
//年龄
private String age;
//性别
private String sex;
//科室
private String ks;
//工号
private String gh;
//职称
private String zc;
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 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 getKs() {return ks;}
public void setKs(String ks) {this.ks = ks;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getZc() {return zc;}
public void setZc(String zc) {this.zc = zc;}
}公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//公告
public class Gg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String v1;
//图片
private String pic;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}供应商javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//供应商
public class Gys extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//供应商名称
private String gysName;
//地址
private String address;
//供应商联系人
private String lxr;
//联系人电话
private String phone;
//主营药品
private String yp;
public String getGysName() {return gysName;}
public void setGysName(String gysName) {this.gysName = gysName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getYp() {return yp;}
public void setYp(String yp) {this.yp = yp;}
}患者javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//患者
public class Hz 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 hzName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//病史
private String bs;
//身份证
private String sfz;
//医保卡
private String ybk;
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 getHzName() {return hzName;}
public void setHzName(String hzName) {this.hzName = hzName;}
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 getBs() {return bs;}
public void setBs(String bs) {this.bs = bs;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
public String getYbk() {return ybk;}
public void setYbk(String ybk) {this.ybk = ybk;}
}库存管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//库存管理员
public class Kcadmin 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 kcadminName;
//工号
private String gh;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getKcadminName() {return kcadminName;}
public void setKcadminName(String kcadminName) {this.kcadminName = kcadminName;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
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;}
}药品订单javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药品订单
public class Order extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//医生
private Integer doctorId;
//订单编号
private String ddbh;
//患者
private Integer hzId;
//总金额
private Integer fee;
//药品清单
private String ypqd;
//日期
private Date showDate;
//状态
private String status;
public Integer getDoctorId() {return doctorId;}
public void setDoctorId(Integer doctorId) {this.doctorId = doctorId;}
public String getDdbh() {return ddbh;}
public void setDdbh(String ddbh) {this.ddbh = ddbh;}
public Integer getHzId() {return hzId;}
public void setHzId(Integer hzId) {this.hzId = hzId;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getYpqd() {return ypqd;}
public void setYpqd(String ypqd) {this.ypqd = ypqd;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}药品退货javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药品退货
public class Th extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//患者
private Integer hzId;
//退货药品
private String ypqd;
//退货日期
private Date insertDate;
//状态
private String status;
public Integer getHzId() {return hzId;}
public void setHzId(Integer hzId) {this.hzId = hzId;}
public String getYpqd() {return ypqd;}
public void setYpqd(String ypqd) {this.ypqd = ypqd;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}药品销售javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//药品销售
public class Xiaoshou extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//销售
private Integer customerId;
//药品
private Integer yaopinId;
//数量
private Integer sl;
//销售日期
private Date showDate;
//客户
private String kh;
//总金额
private Integer zje;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getYaopinId() {return yaopinId;}
public void setYaopinId(Integer yaopinId) {this.yaopinId = yaopinId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getKh() {return kh;}
public void setKh(String kh) {this.kh = kh;}
public Integer getZje() {return zje;}
public void setZje(Integer zje) {this.zje = zje;}
}药品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 Integer gysId;
//药品
private String yaopinName;
//规格
private String gg;
//作用
private String zy;
//详细说明
private String content;
//图片
private String pic;
//库存
private Integer kc;
//单价
private Integer dj;
public Integer getGysId() {return gysId;}
public void setGysId(Integer gysId) {this.gysId = gysId;}
public String getYaopinName() {return yaopinName;}
public void setYaopinName(String yaopinName) {this.yaopinName = yaopinName;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public String getZy() {return zy;}
public void setZy(String zy) {this.zy = zy;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public Integer getDj() {return dj;}
public void setDj(Integer dj) {this.dj = dj;}
}