精华内容
下载资源
问答
  • java药品管理系统

    2014-06-04 19:50:10
    java药品管理系统,包括登陆界面,药品查询,药品出库,药品入库,药品添加,删除,添加记录的查询,删除记录的查询等
  • java web药品管理系统

    热门讨论 2012-12-09 12:31:26
    java web药品管理系统
  • 药品管理系统需要实现的功能主要有四大模块,分别为药品库存管理、药品采购管理、药店销售收银管理、和系统用户管理。其中日常工作管理和药品库存管理是整个系统的核心。 日常工作管理:包括药品库存管理、药品采购...
  • 药品管理系统

    2013-04-29 22:43:56
    药品管理系统 java设计 希望对大家有用
  • Java药品信息管理系统源码,Java药品信息管理系统源码
  • 药品管理系统 药品管理系统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 KEY id (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 KEY id (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 KEY id (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 KEY id (id)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

    源码下载地址:http://www.bycxy123.com/

    展开全文
  • 6.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药品数据库管理系统

    热门讨论 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 数据库: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 KEY id (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 KEY id (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 KEY id (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 KEY id (id)
    ) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=gb2312;

     

     

    展开全文
  • PAGE 26 毕 业 论 文 题 目基于JAVA药品管理系统的设计和实现 专 业 班 级 姓 名 学 号 指导教师 日 期 摘 要 药品管理系统是现代化在线医药管理必不可少的基础设施与技术支撑环境本系统前台采用MyEclipse开发后台...
  • 库房药品管理系统主要功能 a.药品警戒线的设置: 设置库房房各种药品的最低库存界线,输入药品的临界数量,当库房药品的数量达到临界数量时,系统发出警告,方便制定用户计划。 b.药品管理: 对于新入库药品的信息...
  • 医院及药店的药品管理系统java 该系统包含药品采购管理,药品库存管理,药店销售收银管理等子模块,药客医药信息管理软件针对我国医药企业药品经营管理特点(尤其是中小型药店销售商)而特别设计,符合GSP管理规范,...
  • Java+Mysql实现 IDE:IDEA JDK:1.8 MySQL:8.0 包含数据库文件和源码
  • 使用Java,MySQL的网上药店,不登录账号时也可以查询各种药品信息,如果需要购买时,就必须登录才能加入购物车,然后再购物车中支付,支付成功后,管理员就能从后台看到订单,后台的主要功能有处理订单,商品管理,...
  • Javaswing实践 数据库实践 Java大作业实践可用 自己初学写的一个简单的药品存销管理系统 基本的增删改查
  • 库房药品管理系统主要功能 a.药品警戒线的设置: 设置库房房各种药品的最低库存界线,输入药品的临界数量,当库房药品的数量达到临界数量时,系统发出警告,方便制定用户计划。 b.药品管理: 对于新入库药品的信息...
  • 系统包含 大作业完整文档一份 2000字左右和源码和数据库; java大作业;互联网开发大作业;软件开发大作业 ; 本系统是用JAVA编写的,...系统包含:员工管理、药品管理、客户管理、药品出入库管理、查询等等功能模块
  • 摘 要 药品管理系统是现代化在线医药管理必不可少基础设施和技术支撑环境本系统前台采取MyEclipse开发后台采取MySql 作为数据库开发工具这些技术现在相对比较成熟方便产品维护本系统能够实现用户在线注册登录修改...
  • 武汉理工大学计算机能力拓展训练报告书 PAGE - 19 - 学 号 课 程 设 计 题 目 基于Java环境的医院 药品管理系统的设计 学 院 计算机科学与技术学院 专 业 计算机科学与技术专业 班 级 姓 名 指导教师 许 毅 2012 年 ...
  • 整理东西时,发现以前做的两个Java小项目,应该是刚学Java做课设时写的。 初学Java童鞋可以看看! 开发环境:IDEA+Mysql 8 实现基本的增、删、改、查,销售、统计等功能。 部分截图:
  • 这是一篇很规范很严谨的论文,值得大家学习和借鉴
  • 学 号 课 程 设 计 基于 Java 环境的医院 题 目 药品管理系统的设计 学 院 计算机科学与技术学院 专 业 计算机科学与技术专业 班 姓 名 指导教师 许 毅 2012 年 09 月 02 日 武汉理工大学计算机能力拓展训练报告书 ...
  • 大学毕业设计系统药品管理Java开发;Access数据库;中小型系统系统+毕业论文
  • 一、背景分析药品管理系统,是反映药品购进入库、在库管理、销售出库软件系统,是医院和医药销售企业药品流动信息的传递媒介和执行依据。然而我们在调研中发现,目前已开发出来的药品管理系统虽然在使用过程中提供了...

空空如也

空空如也

1 2 3 4 5 ... 7
收藏数 131
精华内容 52
关键字:

药品管理系统java

java 订阅