-
java药品管理系统
2014-06-04 19:50:10java药品管理系统,包括登陆界面,药品查询,药品出库,药品入库,药品添加,删除,添加记录的查询,删除记录的查询等 -
java web药品管理系统
2012-12-09 12:31:26java web药品管理系统 -
基于Java的药品管理系统
2018-11-03 22:55:44药品管理系统需要实现的功能主要有四大模块,分别为药品库存管理、药品采购管理、药店销售收银管理、和系统用户管理。其中日常工作管理和药品库存管理是整个系统的核心。 日常工作管理:包括药品库存管理、药品采购... -
药品管理系统
2013-04-29 22:43:56药品管理系统 java设计 希望对大家有用 -
Java药品信息管理系统源码
2018-04-24 23:50:49Java药品信息管理系统源码,Java药品信息管理系统源码 -
Java毕业设计_药品管理系统
2020-09-30 11:45:28药品管理系统 药品管理系统mysql数据库创建语句 药品管理系统oracle数据库创建语句 药品管理系统sqlserver数据库创建语句 药品管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计 药品管理系统spring+...药品管理系统
药品管理系统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_cj(
id int primary key auto_increment comment ‘主键’,
cjName varchar(100) comment ‘类型名称’,
lxdh varchar(100) comment ‘联系电话’
) comment ‘厂家’;
SQLCopy
出入库表创建语句如下:create table t_crk(
id int primary key auto_increment comment ‘主键’,
ypId int comment ‘药品’,
crk varchar(100) comment ‘出库入库’,
num int 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 ‘电话’
) comment ‘用户’;
SQLCopy
供货商表创建语句如下:create table t_ghs(
id int primary key auto_increment comment ‘主键’,
ghsName varchar(100) comment ‘供货商名称’,
lxdh varchar(100) comment ‘联系电话’
) comment ‘供货商’;
SQLCopy
科室表创建语句如下:create table t_ks(
id int primary key auto_increment comment ‘主键’,
ksName varchar(100) comment ‘供货商名称’,
lxdh varchar(100) comment ‘联系电话’
) comment ‘科室’;
SQLCopy
普通管理员表创建语句如下:create table t_ptadmin(
id int primary key auto_increment comment ‘主键’,
username varchar(100) comment ‘账号’,
password varchar(100) comment ‘密码’,
ptadminName varchar(100) comment ‘姓名’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’,
phone varchar(100) comment ‘电话’
) comment ‘普通管理员’;
SQLCopy
分类表创建语句如下:create table t_types(
id int primary key auto_increment comment ‘主键’,
typesName varchar(100) comment ‘类型名称’
) comment ‘分类’;
SQLCopy
药品表创建语句如下:create table t_yp(
id int primary key auto_increment comment ‘主键’,
ypName varchar(100) comment ‘药品名称’,
typesId int comment ‘分类’,
cjId int comment ‘厂家’,
ksId int comment ‘科室’,
ghsId int comment ‘供货商’,
gg varchar(100) comment ‘规格’,
yl varchar(100) comment ‘用量’,
pic varchar(100) comment ‘图片’,
yxq datetime comment ‘有效期’,
aqz int comment ‘安全值’,
num int 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_cj(
id integer,
cjName varchar(100),
lxdh varchar(100)
);
–厂家字段加注释
comment on column t_cj.id is ‘主键’;
comment on column t_cj.cjName is ‘类型名称’;
comment on column t_cj.lxdh is ‘联系电话’;
–厂家表加注释
comment on table t_cj is ‘厂家’;
SQLCopy
出入库表创建语句如下:create table t_crk(
id integer,
ypId int,
crk varchar(100),
num int
);
–出入库字段加注释
comment on column t_crk.id is ‘主键’;
comment on column t_crk.ypId is ‘药品’;
comment on column t_crk.crk is ‘出库入库’;
comment on column t_crk.num is ‘数量’;
–出入库表加注释
comment on table t_crk 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)
);
–用户字段加注释
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 table t_customer is ‘用户’;
SQLCopy
供货商表创建语句如下:create table t_ghs(
id integer,
ghsName varchar(100),
lxdh varchar(100)
);
–供货商字段加注释
comment on column t_ghs.id is ‘主键’;
comment on column t_ghs.ghsName is ‘供货商名称’;
comment on column t_ghs.lxdh is ‘联系电话’;
–供货商表加注释
comment on table t_ghs is ‘供货商’;
SQLCopy
科室表创建语句如下:create table t_ks(
id integer,
ksName varchar(100),
lxdh varchar(100)
);
–科室字段加注释
comment on column t_ks.id is ‘主键’;
comment on column t_ks.ksName is ‘供货商名称’;
comment on column t_ks.lxdh is ‘联系电话’;
–科室表加注释
comment on table t_ks is ‘科室’;
SQLCopy
普通管理员表创建语句如下:create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
–普通管理员字段加注释
comment on column t_ptadmin.id is ‘主键’;
comment on column t_ptadmin.username is ‘账号’;
comment on column t_ptadmin.password is ‘密码’;
comment on column t_ptadmin.ptadminName is ‘姓名’;
comment on column t_ptadmin.age is ‘年龄’;
comment on column t_ptadmin.sex is ‘性别’;
comment on column t_ptadmin.phone is ‘电话’;
–普通管理员表加注释
comment on table t_ptadmin is ‘普通管理员’;
SQLCopy
分类表创建语句如下:create table t_types(
id integer,
typesName varchar(100)
);
–分类字段加注释
comment on column t_types.id is ‘主键’;
comment on column t_types.typesName is ‘类型名称’;
–分类表加注释
comment on table t_types is ‘分类’;
SQLCopy
药品表创建语句如下:create table t_yp(
id integer,
ypName varchar(100),
typesId int,
cjId int,
ksId int,
ghsId int,
gg varchar(100),
yl varchar(100),
pic varchar(100),
yxq datetime,
aqz int,
num int
);
–药品字段加注释
comment on column t_yp.id is ‘主键’;
comment on column t_yp.ypName is ‘药品名称’;
comment on column t_yp.typesId is ‘分类’;
comment on column t_yp.cjId is ‘厂家’;
comment on column t_yp.ksId is ‘科室’;
comment on column t_yp.ghsId is ‘供货商’;
comment on column t_yp.gg is ‘规格’;
comment on column t_yp.yl is ‘用量’;
comment on column t_yp.pic is ‘图片’;
comment on column t_yp.yxq is ‘有效期’;
comment on column t_yp.aqz is ‘安全值’;
comment on column t_yp.num is ‘数量’;
–药品表加注释
comment on table t_yp is ‘药品’;
SQLCopy
oracle特有,对应序列如下:create sequence s_t_cj;
create sequence s_t_crk;
create sequence s_t_customer;
create sequence s_t_ghs;
create sequence s_t_ks;
create sequence s_t_ptadmin;
create sequence s_t_types;
create sequence s_t_yp;
SQLCopy
药品管理系统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’);
SQLCopy
厂家表创建语句如下:–厂家表注释
create table t_cj(
id int identity(1,1) primary key not null,–主键
cjName varchar(100),–类型名称
lxdh varchar(100)–联系电话
);
SQLCopy
出入库表创建语句如下:–出入库表注释
create table t_crk(
id int identity(1,1) primary key not null,–主键
ypId int,–药品
crk varchar(100),–出库入库
num int–数量
);
SQLCopy
用户表创建语句如下:–用户表注释
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)–电话
);
SQLCopy
供货商表创建语句如下:–供货商表注释
create table t_ghs(
id int identity(1,1) primary key not null,–主键
ghsName varchar(100),–供货商名称
lxdh varchar(100)–联系电话
);
SQLCopy
科室表创建语句如下:–科室表注释
create table t_ks(
id int identity(1,1) primary key not null,–主键
ksName varchar(100),–供货商名称
lxdh varchar(100)–联系电话
);
SQLCopy
普通管理员表创建语句如下:–普通管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,–主键
username varchar(100),–账号
password varchar(100),–密码
ptadminName varchar(100),–姓名
age varchar(100),–年龄
sex varchar(100),–性别
phone varchar(100)–电话
);
SQLCopy
分类表创建语句如下:–分类表注释
create table t_types(
id int identity(1,1) primary key not null,–主键
typesName varchar(100)–类型名称
);
SQLCopy
药品表创建语句如下:–药品表注释
create table t_yp(
id int identity(1,1) primary key not null,–主键
ypName varchar(100),–药品名称
typesId int,–分类
cjId int,–厂家
ksId int,–科室
ghsId int,–供货商
gg varchar(100),–规格
yl varchar(100),–用量
pic varchar(100),–图片
yxq datetime,–有效期
aqz int,–安全值
num int–数量
);
SQLCopy
药品管理系统登录后主页
药品管理系统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_cj”)
public class Cj {
//主键
@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 cjName;
//联系电话
private String lxdh;
public String getCjName() {return cjName;}
public void setCjName(String cjName) {this.cjName = cjName;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}
JavaCopy
出入库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_crk”)
public class Crk {
//主键
@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 ypId;
//出库入库
private String crk;
//数量
private Integer num;
public Integer getYpId() {return ypId;}
public void setYpId(Integer ypId) {this.ypId = ypId;}
public String getCrk() {return crk;}
public void setCrk(String crk) {this.crk = crk;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}
JavaCopy
用户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;
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;}
}
JavaCopy
供货商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_ghs”)
public class Ghs {
//主键
@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 ghsName;
//联系电话
private String lxdh;
public String getGhsName() {return ghsName;}
public void setGhsName(String ghsName) {this.ghsName = ghsName;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}
JavaCopy
科室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_ks”)
public class Ks {
//主键
@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 ksName;
//联系电话
private String lxdh;
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}
JavaCopy
普通管理员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_ptadmin”)
public class Ptadmin {
//主键
@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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}
JavaCopy
分类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_types”)
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}
JavaCopy
药品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_yp”)
public class Yp {
//主键
@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 ypName;
//分类
private Integer typesId;
//厂家
private Integer cjId;
//科室
private Integer ksId;
//供货商
private Integer ghsId;
//规格
private String gg;
//用量
private String yl;
//图片
private String pic;
//有效期
private Date yxq;
//安全值
private Integer aqz;
//数量
private Integer num;
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getCjId() {return cjId;}
public void setCjId(Integer cjId) {this.cjId = cjId;}
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
public Integer getGhsId() {return ghsId;}
public void setGhsId(Integer ghsId) {this.ghsId = ghsId;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public String getYl() {return yl;}
public void setYl(String yl) {this.yl = yl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getYxq() {return yxq;}
public void setYxq(Date yxq) {this.yxq = yxq;}
public Integer getAqz() {return aqz;}
public void setAqz(Integer aqz) {this.aqz = aqz;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}
JavaCopy
药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
厂家javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//厂家
public class Cj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String cjName;
//联系电话
private String lxdh;
public String getCjName() {return cjName;}
public void setCjName(String cjName) {this.cjName = cjName;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}
JavaCopy
出入库javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//出入库
public class Crk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品
private Integer ypId;
//出库入库
private String crk;
//数量
private Integer num;
public Integer getYpId() {return ypId;}
public void setYpId(Integer ypId) {this.ypId = ypId;}
public String getCrk() {return crk;}
public void setCrk(String crk) {this.crk = crk;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}
JavaCopy
用户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;
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;}
}
JavaCopy
供货商javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//供货商
public class Ghs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//供货商名称
private String ghsName;
//联系电话
private String lxdh;
public String getGhsName() {return ghsName;}
public void setGhsName(String ghsName) {this.ghsName = ghsName;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}
JavaCopy
科室javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//科室
public class Ks extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//供货商名称
private String ksName;
//联系电话
private String lxdh;
public String getKsName() {return ksName;}
public void setKsName(String ksName) {this.ksName = ksName;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}
JavaCopy
普通管理员javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//普通管理员
public class Ptadmin 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 ptadminName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}
JavaCopy
分类javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//分类
public class Types extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型名称
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}
JavaCopy
药品javaBean创建语句如下:package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;//药品
public class Yp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品名称
private String ypName;
//分类
private Integer typesId;
//厂家
private Integer cjId;
//科室
private Integer ksId;
//供货商
private Integer ghsId;
//规格
private String gg;
//用量
private String yl;
//图片
private String pic;
//有效期
private Date yxq;
//安全值
private Integer aqz;
//数量
private Integer num;
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getCjId() {return cjId;}
public void setCjId(Integer cjId) {this.cjId = cjId;}
public Integer getKsId() {return ksId;}
public void setKsId(Integer ksId) {this.ksId = ksId;}
public Integer getGhsId() {return ghsId;}
public void setGhsId(Integer ghsId) {this.ghsId = ghsId;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public String getYl() {return yl;}
public void setYl(String yl) {this.yl = yl;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Date getYxq() {return yxq;}
public void setYxq(Date yxq) {this.yxq = yxq;}
public Integer getAqz() {return aqz;}
public void setAqz(Integer aqz) {this.aqz = aqz;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
}
JavaCopy -
基于Java药品管理系统
2020-07-29 21:44:58技术:java、jsp 数据库:mysql web服务器:Tomcat 集成开发工具:myeclipse 截图: 数据库表: CREATE TABLE admin ( id int(4) NOT NULL auto_increment, name varchar(50) NOT NULL, pwd varchar(50) ...介绍:
技术:java、jsp
数据库:mysql
web服务器:Tomcat
集成开发工具:myeclipse截图:
数据库表:
CREATE TABLE
admin
(
id
int(4) NOT NULL auto_increment,
name
varchar(50) NOT NULL,
pwd
varchar(50) default NULL,
quanxian
int(4) default NULL,
PRIMARY KEY (name
),
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;/*Data for the table
admin
*/insert into
admin
(id
,name
,pwd
,quanxian
) values (2,‘111’,‘111’,-1),(1,‘admin’,‘024admin’,-1);/*Table structure for table
dingdan
*/DROP TABLE IF EXISTS
dingdan
;CREATE TABLE
dingdan
(
id
int(4) NOT NULL auto_increment,
supplierid
varchar(50) default NULL,
zuangtai
int(4) default ‘0’,
times
varchar(50) default ‘2008-5-20’,
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;/*Data for the table
dingdan
*/insert into
dingdan
(id
,supplierid
,zuangtai
,times
) values (1,‘3’,0,‘2008-5-20’),(2,‘3’,1,‘2008-5-20’),(3,‘2’,0,‘2008-5-20’);/*Table structure for table
leibie
*/DROP TABLE IF EXISTS
leibie
;CREATE TABLE
leibie
(
id
int(4) NOT NULL auto_increment,
leibie
varchar(50) NOT NULL,
PRIMARY KEY (leibie
),
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;/*Data for the table
leibie
*/insert into
leibie
(id
,leibie
) values (1,‘方便面类’),(2,‘服装类’),(3,‘玻璃产品类’),(4,‘qq’),(5,‘aa’),(6,‘2222’);/*Table structure for table
sandd
*/DROP TABLE IF EXISTS
sandd
;CREATE TABLE
sandd
(
id
int(4) NOT NULL auto_increment,
dingdanid
int(4) default NULL,
shangpinid
int(4) default NULL,
sums
int(4) default NULL,
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;源码下载地址:http://www.bycxy123.com/
-
JAVA药品管理系统毕业设计论文
2017-06-21 15:10:236.3.1 药品以及药品管理模块测试要点 47 6.3.2 销售管理测试要点 47 6.3.3 进货管理测试要点 47 6.3.4 职工信息测试要点 46 6.4 部分测试图 47 6.5 测试结论 49 总结 50 参考文献 51 附录:部分程序代码 52 -
JAVA 药店药品管理系统
2012-04-22 21:52:12完整的药店管理源代码 附带数据库 初学者最好的借鉴 -
JSP JAVA药品销售管理系统
2019-04-19 13:07:09分为管理员和客户两个角色,其中系统管理员部分的主要功能包括修改登录密码、客户信息管理、药品类别管理、药品信息管理以及订单信息管理等,客户部分的功能包括修改个人信息、浏览药品信息、药品信息查询以及订单... -
java药品数据库管理系统
2010-03-09 14:30:12这是一个运用数据库、JAVA实现的简单的药品数据库管理系统,主要是针对中小型药店的进销存信息进行管理。包括对进货的药品信息进行详细记录,包括进货时间、经手人、厂家以及药品数量等,对各种药品的销售情况进行... -
java毕业设计_基于ssm药品管理系统
2020-03-19 19:42:59基于ssm药品管理系统mysql数据库创建语句 基于ssm药品管理系统oracle数据库创建语句 基于ssm药品管理系统sqlserver数据库创建语句 基于ssm药品管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计 基于...基于ssm药品管理系统mysql数据库创建语句
基于ssm药品管理系统oracle数据库创建语句
基于ssm药品管理系统sqlserver数据库创建语句
基于ssm药品管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
基于ssm药品管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
基于ssm药品管理系统登录注册界面
基于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’);
SQLCopy
药品出库入库表创建语句如下: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 ‘药品出库入库’;
SQLCopy
销售表创建语句如下: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 ‘销售’;
SQLCopy
医生表创建语句如下: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 ‘医生’;
SQLCopy
公告表创建语句如下: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 ‘公告’;
SQLCopy
供应商表创建语句如下: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 ‘供应商’;
SQLCopy
患者表创建语句如下: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 ‘患者’;
SQLCopy
库存管理员表创建语句如下: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 ‘库存管理员’;
SQLCopy
药品订单表创建语句如下: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 ‘药品订单’;
SQLCopy
药品退货表创建语句如下: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 ‘药品退货’;
SQLCopy
药品销售表创建语句如下: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 ‘药品销售’;
SQLCopy
药品表创建语句如下: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 ‘药品’;
SQLCopy
基于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 ‘超级管理员’;
SQLCopy
药品出库入库表创建语句如下: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 ‘药品出库入库’;
SQLCopy
销售表创建语句如下: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 ‘销售’;
SQLCopy
医生表创建语句如下: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 ‘医生’;
SQLCopy
公告表创建语句如下: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 ‘公告’;
SQLCopy
供应商表创建语句如下: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 ‘供应商’;
SQLCopy
患者表创建语句如下: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 ‘患者’;
SQLCopy
库存管理员表创建语句如下: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 ‘库存管理员’;
SQLCopy
药品订单表创建语句如下: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 ‘药品订单’;
SQLCopy
药品退货表创建语句如下: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 ‘药品退货’;
SQLCopy
药品销售表创建语句如下: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 ‘药品销售’;
SQLCopy
药品表创建语句如下: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 ‘药品’;
SQLCopy
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;
SQLCopy
基于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’);
SQLCopy
药品出库入库表创建语句如下:–药品出库入库表注释
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–日期
);
SQLCopy
销售表创建语句如下:–销售表注释
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)–性别
);
SQLCopy
医生表创建语句如下:–医生表注释
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)–职称
);
SQLCopy
公告表创建语句如下:–公告表注释
create table t_gg(
id int identity(1,1) primary key not null,–主键
v1 varchar(100),–标题
pic varchar(100),–图片
showDate datetime,–日期
v3 varchar(100)–内容
);
SQLCopy
供应商表创建语句如下:–供应商表注释
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)–主营药品
);
SQLCopy
患者表创建语句如下:–患者表注释
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)–医保卡
);
SQLCopy
库存管理员表创建语句如下:–库存管理员表注释
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)–性别
);
SQLCopy
药品订单表创建语句如下:–药品订单表注释
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)–状态
);
SQLCopy
药品退货表创建语句如下:–药品退货表注释
create table t_th(
id int identity(1,1) primary key not null,–主键
hzId int,–患者
ypqd varchar(100),–退货药品
insertDate datetime,–退货日期
status varchar(100)–状态
);
SQLCopy
药品销售表创建语句如下:–药品销售表注释
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–总金额
);
SQLCopy
药品表创建语句如下:–药品表注释
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–单价
);
SQLCopy
基于ssm药品管理系统登录后主页
基于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;}
}
JavaCopy
销售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;}
}
JavaCopy
医生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;}
}
JavaCopy
公告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;}
}
JavaCopy
供应商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;}
}
JavaCopy
患者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;}
}
JavaCopy
库存管理员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;}
}
JavaCopy
药品订单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;}
}
JavaCopy
药品退货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;}
}
JavaCopy
药品销售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;}
}
JavaCopy
药品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;}
}
JavaCopy
基于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;}
}
JavaCopy
销售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;}
}
JavaCopy
医生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;}
}
JavaCopy
公告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;}
}
JavaCopy
供应商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;}
}
JavaCopy
患者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;}
}
JavaCopy
库存管理员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;}
}
JavaCopy
药品订单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;}
}
JavaCopy
药品退货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;}
}
JavaCopy
药品销售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;}
}
JavaCopy
药品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;}
}
-
基于Java jsp药品管理系统
2020-12-07 08:56:04技术:java、jsp 数据库:mysql web服务器:Tomcat 集成开发工具:myeclipse 截图: 数据库表: CREATE TABLEadmin(idint(4) NOT NULL auto_increment,namevarchar(50) NOT NULL,pwdvarchar(50) ...介绍:
技术:java、jsp
数据库:mysql
web服务器:Tomcat
集成开发工具:myeclipse截图:
数据库表:
CREATE TABLE
admin
(id
int(4) NOT NULL auto_increment,name
varchar(50) NOT NULL,pwd
varchar(50) default NULL,quanxian
int(4) default NULL,
PRIMARY KEY (name
),
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=gb2312;/*Data for the table
admin
*/insert into
admin
(id
,name
,pwd
,quanxian
) values (2,‘111’,‘111’,-1),(1,‘admin’,‘024admin’,-1);/*Table structure for table
dingdan
*/DROP TABLE IF EXISTS
dingdan
;CREATE TABLE
dingdan
(id
int(4) NOT NULL auto_increment,supplierid
varchar(50) default NULL,zuangtai
int(4) default ‘0’,times
varchar(50) default ‘2008-5-20’,
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=gb2312;/*Data for the table
dingdan
*/insert into
dingdan
(id
,supplierid
,zuangtai
,times
) values (1,‘3’,0,‘2008-5-20’),(2,‘3’,1,‘2008-5-20’),(3,‘2’,0,‘2008-5-20’);/*Table structure for table
leibie
*/DROP TABLE IF EXISTS
leibie
;CREATE TABLE
leibie
(id
int(4) NOT NULL auto_increment,leibie
varchar(50) NOT NULL,
PRIMARY KEY (leibie
),
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=7 DEFAULT CHARSET=gb2312;/*Data for the table
leibie
*/insert into
leibie
(id
,leibie
) values (1,‘方便面类’),(2,‘服装类’),(3,‘玻璃产品类’),(4,‘qq’),(5,‘aa’),(6,‘2222’);/*Table structure for table
sandd
*/DROP TABLE IF EXISTS
sandd
;CREATE TABLE
sandd
(id
int(4) NOT NULL auto_increment,dingdanid
int(4) default NULL,shangpinid
int(4) default NULL,sums
int(4) default NULL,
UNIQUE KEYid
(id
)
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312; -
《基于JAVA药品管理系统的设计和实现》.doc
2020-01-17 13:11:43PAGE 26 毕 业 论 文 题 目基于JAVA药品管理系统的设计和实现 专 业 班 级 姓 名 学 号 指导教师 日 期 摘 要 药品管理系统是现代化在线医药管理必不可少的基础设施与技术支撑环境本系统前台采用MyEclipse开发后台... -
基于java的药品库房管理系统
2020-10-18 20:21:56库房药品管理系统主要功能 a.药品警戒线的设置: 设置库房房各种药品的最低库存界线,输入药品的临界数量,当库房药品的数量达到临界数量时,系统发出警告,方便制定用户计划。 b.药品管理: 对于新入库药品的信息... -
医院及药店的药品管理系统
2018-07-08 21:18:57医院及药店的药品管理系统java 该系统包含药品采购管理,药品库存管理,药店销售收银管理等子模块,药客医药信息管理软件针对我国医药企业药品经营管理特点(尤其是中小型药店销售商)而特别设计,符合GSP管理规范,... -
Java实现的药品销售管理系统(Java课程设计)
2021-03-01 19:22:29Java+Mysql实现 IDE:IDEA JDK:1.8 MySQL:8.0 包含数据库文件和源码 -
药品销售系统Java+SSH+MySQL
2021-02-25 14:12:42使用Java,MySQL的网上药店,不登录账号时也可以查询各种药品信息,如果需要购买时,就必须登录才能加入购物车,然后再购物车中支付,支付成功后,管理员就能从后台看到订单,后台的主要功能有处理订单,商品管理,... -
Java swing 数据库 Java实践药品存销管理系统.zip
2020-10-20 22:25:42Javaswing实践 数据库实践 Java大作业实践可用 自己初学写的一个简单的药品存销管理系统 基本的增删改查 -
基于java jsp的药品库房管理系统
2020-11-30 09:12:53库房药品管理系统主要功能 a.药品警戒线的设置: 设置库房房各种药品的最低库存界线,输入药品的临界数量,当库房药品的数量达到临界数量时,系统发出警告,方便制定用户计划。 b.药品管理: 对于新入库药品的信息... -
java大作业 药品管理系统设计与实现【文档+源码+数据库】
2021-01-29 13:20:16系统包含 大作业完整文档一份 2000字左右和源码和数据库; java大作业;互联网开发大作业;软件开发大作业 ; 本系统是用JAVA编写的,...系统包含:员工管理、药品管理、客户管理、药品出入库管理、查询等等功能模块 -
基于JAVA的药品统一标准管理系统.doc
2020-09-20 19:31:14摘 要 药品管理系统是现代化在线医药管理必不可少基础设施和技术支撑环境本系统前台采取MyEclipse开发后台采取MySql 作为数据库开发工具这些技术现在相对比较成熟方便产品维护本系统能够实现用户在线注册登录修改... -
《基于Java环境的医院药品管理系统的设计(含源文件)》_医院药品数量管理制度
2020-01-17 13:11:37武汉理工大学计算机能力拓展训练报告书 PAGE - 19 - 学 号 课 程 设 计 题 目 基于Java环境的医院 药品管理系统的设计 学 院 计算机科学与技术学院 专 业 计算机科学与技术专业 班 级 姓 名 指导教师 许 毅 2012 年 ... -
Java实现药品销售管理系统
2021-03-01 18:03:41整理东西时,发现以前做的两个Java小项目,应该是刚学Java做课设时写的。 初学Java童鞋可以看看! 开发环境:IDEA+Mysql 8 实现基本的增、删、改、查,销售、统计等功能。 部分截图: -
药品管理系统毕业设计论文JAVA Swing
2011-07-06 13:31:26这是一篇很规范很严谨的论文,值得大家学习和借鉴 -
基于java环境的医院药品管理系统的设计(含源文件).pdf
2020-08-20 00:32:17学 号 课 程 设 计 基于 Java 环境的医院 题 目 药品管理系统的设计 学 院 计算机科学与技术学院 专 业 计算机科学与技术专业 班 姓 名 指导教师 许 毅 2012 年 09 月 02 日 武汉理工大学计算机能力拓展训练报告书 ... -
中小型系统药品管理系统+毕业论文
2021-01-27 10:49:09大学毕业设计系统,药品管理;Java开发;Access数据库;中小型系统,系统+毕业论文 -
基于JAVA和ACCESS数据库实现的药品销售管理系统
2019-07-19 23:02:00一、背景分析药品管理系统,是反映药品购进入库、在库管理、销售出库软件系统,是医院和医药销售企业药品流动信息的传递媒介和执行依据。然而我们在调研中发现,目前已开发出来的药品管理系统虽然在使用过程中提供了...