基于Java的药店管理系统(xfa114)_mysql_oracle代码分享

• 基于Java的药店管理系统mysql数据库创建语句
• 基于Java的药店管理系统oracle数据库创建语句
• 基于Java的药店管理系统sqlserver数据库创建语句
• 基于Java的药店管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 基于Java的药店管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

基于Java的药店管理系统mysql数据库版本源码：

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

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

厂商表创建语句如下：

create table t_cs(
	id int primary key auto_increment comment '主键',
	csName varchar(100) comment '厂商名称',
	dz varchar(100) comment '地址',
	fzr varchar(100) comment '负责人',
	jbxx text comment '基本信息'
) comment '厂商';

员工表创建语句如下：

create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	customerName varchar(100) comment '姓名',
	headPic varchar(100) comment '头像',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '',
	zw varchar(100) comment ''
) comment '员工';

公告表创建语句如下：

create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content text comment '内容',
	insertDate datetime comment '发起日期'
) comment '公告';

药品进货表创建语句如下：

create table t_jh(
	id int primary key auto_increment comment '主键',
	ypId int comment '药品',
	sl int comment '数量',
	fee int comment '进货单价',
	zj int comment '总价',
	showDate datetime comment '进货日期',
	fzr varchar(100) comment '负责人',
	lxdh varchar(100) comment '联系电话'
) comment '药品进货';

药品类别表创建语句如下：

create table t_types(
	id int primary key auto_increment comment '主键',
	typesName varchar(100) comment '药品类别'
) comment '药品类别';

药品销售表创建语句如下：

create table t_xs(
	id int primary key auto_increment comment '主键',
	ypId int comment '药品',
	sl int comment '数量',
	fee int comment '销售单价',
	zj int comment '总价',
	showDate datetime comment '销售日期',
	fzr varchar(100) comment '负责人',
	lxdh varchar(100) comment '联系电话',
	dfgs varchar(100) comment '对方公司',
	dffzr varchar(100) comment '对方负责人',
	dflxdh varchar(100) comment '对方联系电话'
) comment '药品销售';

药品表创建语句如下：

create table t_yp(
	id int primary key auto_increment comment '主键',
	ypName varchar(100) comment '药品名称',
	fee int comment '零售建议价',
	gg varchar(100) comment '规格',
	dw varchar(100) comment '单位',
	csId int comment '厂商',
	yf text comment '用法',
	typesId int comment '药品类别'
) comment '药品';

基于Java的药店管理系统oracle数据库版本源码：

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

create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

厂商表创建语句如下：

create table t_cs(
	id integer,
	csName varchar(100),
	dz varchar(100),
	fzr varchar(100),
	jbxx text
);
--厂商字段加注释
comment on column t_cs.id is '主键';
comment on column t_cs.csName is '厂商名称';
comment on column t_cs.dz is '地址';
comment on column t_cs.fzr is '负责人';
comment on column t_cs.jbxx is '基本信息';
--厂商表加注释
comment on table t_cs is '厂商';

员工表创建语句如下：

create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	headPic varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	zw 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.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '';
comment on column t_customer.zw is '';
--员工表加注释
comment on table t_customer is '员工';

公告表创建语句如下：

create table t_gonggao(
	id integer,
	title varchar(100),
	content text,
	insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.insertDate is '发起日期';
--公告表加注释
comment on table t_gonggao is '公告';

药品进货表创建语句如下：

create table t_jh(
	id integer,
	ypId int,
	sl int,
	fee int,
	zj int,
	showDate datetime,
	fzr varchar(100),
	lxdh varchar(100)
);
--药品进货字段加注释
comment on column t_jh.id is '主键';
comment on column t_jh.ypId is '药品';
comment on column t_jh.sl is '数量';
comment on column t_jh.fee is '进货单价';
comment on column t_jh.zj is '总价';
comment on column t_jh.showDate is '进货日期';
comment on column t_jh.fzr is '负责人';
comment on column t_jh.lxdh is '联系电话';
--药品进货表加注释
comment on table t_jh is '药品进货';

药品类别表创建语句如下：

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

药品销售表创建语句如下：

create table t_xs(
	id integer,
	ypId int,
	sl int,
	fee int,
	zj int,
	showDate datetime,
	fzr varchar(100),
	lxdh varchar(100),
	dfgs varchar(100),
	dffzr varchar(100),
	dflxdh varchar(100)
);
--药品销售字段加注释
comment on column t_xs.id is '主键';
comment on column t_xs.ypId is '药品';
comment on column t_xs.sl is '数量';
comment on column t_xs.fee is '销售单价';
comment on column t_xs.zj is '总价';
comment on column t_xs.showDate is '销售日期';
comment on column t_xs.fzr is '负责人';
comment on column t_xs.lxdh is '联系电话';
comment on column t_xs.dfgs is '对方公司';
comment on column t_xs.dffzr is '对方负责人';
comment on column t_xs.dflxdh is '对方联系电话';
--药品销售表加注释
comment on table t_xs is '药品销售';

药品表创建语句如下：

create table t_yp(
	id integer,
	ypName varchar(100),
	fee int,
	gg varchar(100),
	dw varchar(100),
	csId int,
	yf text,
	typesId int
);
--药品字段加注释
comment on column t_yp.id is '主键';
comment on column t_yp.ypName is '药品名称';
comment on column t_yp.fee is '零售建议价';
comment on column t_yp.gg is '规格';
comment on column t_yp.dw is '单位';
comment on column t_yp.csId is '厂商';
comment on column t_yp.yf is '用法';
comment on column t_yp.typesId is '药品类别';
--药品表加注释
comment on table t_yp is '药品';

oracle特有，对应序列如下：

create sequence s_t_cs;
create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_jh;
create sequence s_t_types;
create sequence s_t_xs;
create sequence s_t_yp;

基于Java的药店管理系统sqlserver数据库版本源码：

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

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

厂商表创建语句如下：

--厂商表注释
create table t_cs(
	id int identity(1,1) primary key not null,--主键
	csName varchar(100),--厂商名称
	dz varchar(100),--地址
	fzr varchar(100),--负责人
	jbxx text--基本信息
);

员工表创建语句如下：

--员工表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	headPic varchar(100),--头像
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--
	zw varchar(100)--
);

公告表创建语句如下：

--公告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content text,--内容
	insertDate datetime--发起日期
);

药品进货表创建语句如下：

--药品进货表注释
create table t_jh(
	id int identity(1,1) primary key not null,--主键
	ypId int,--药品
	sl int,--数量
	fee int,--进货单价
	zj int,--总价
	showDate datetime,--进货日期
	fzr varchar(100),--负责人
	lxdh varchar(100)--联系电话
);

药品类别表创建语句如下：

--药品类别表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName varchar(100)--药品类别
);

药品销售表创建语句如下：

--药品销售表注释
create table t_xs(
	id int identity(1,1) primary key not null,--主键
	ypId int,--药品
	sl int,--数量
	fee int,--销售单价
	zj int,--总价
	showDate datetime,--销售日期
	fzr varchar(100),--负责人
	lxdh varchar(100),--联系电话
	dfgs varchar(100),--对方公司
	dffzr varchar(100),--对方负责人
	dflxdh varchar(100)--对方联系电话
);

药品表创建语句如下：

--药品表注释
create table t_yp(
	id int identity(1,1) primary key not null,--主键
	ypName varchar(100),--药品名称
	fee int,--零售建议价
	gg varchar(100),--规格
	dw varchar(100),--单位
	csId int,--厂商
	yf text,--用法
	typesId int--药品类别
);

基于Java的药店管理系统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_cs")
public class Cs {
//主键
@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 csName;
//地址
private String dz;
//负责人
private String fzr;
//基本信息
private String jbxx;
public String getCsName() {return csName;}
public void setCsName(String csName) {this.csName = csName;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getJbxx() {return jbxx;}
public void setJbxx(String jbxx) {this.jbxx = jbxx;}
}

员工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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//
private String zw;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
}

公告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_gonggao")
public class Gonggao {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

药品进货javaBean创建语句如下：

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

//药品进货
@Table(name = "t_jh")
public class Jh {
//主键
@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 Long ypId;
//数量
private Integer sl;
//进货单价
private Integer fee;
//总价
private Integer zj;
//进货日期
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
public Long getYpId() {return ypId;}
public void setYpId(Long ypId) {this.ypId = ypId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}

药品类别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;}
}

药品销售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_xs")
public class Xs {
//主键
@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 Long ypId;
//数量
private Integer sl;
//销售单价
private Integer fee;
//总价
private Integer zj;
//销售日期
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
//对方公司
private String dfgs;
//对方负责人
private String dffzr;
//对方联系电话
private String dflxdh;
public Long getYpId() {return ypId;}
public void setYpId(Long ypId) {this.ypId = ypId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getDfgs() {return dfgs;}
public void setDfgs(String dfgs) {this.dfgs = dfgs;}
public String getDffzr() {return dffzr;}
public void setDffzr(String dffzr) {this.dffzr = dffzr;}
public String getDflxdh() {return dflxdh;}
public void setDflxdh(String dflxdh) {this.dflxdh = dflxdh;}
}

药品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 fee;
//规格
private String gg;
//单位
private String dw;
//厂商
private Long csId;
//用法
private String yf;
//药品类别
private Long typesId;
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
public Long getCsId() {return csId;}
public void setCsId(Long csId) {this.csId = csId;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Long getTypesId() {return typesId;}
public void setTypesId(Long typesId) {this.typesId = typesId;}
}

基于Java的药店管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

厂商javaBean创建语句如下：

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

//厂商
public class Cs  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//厂商名称
private String csName;
//地址
private String dz;
//负责人
private String fzr;
//基本信息
private String jbxx;
public String getCsName() {return csName;}
public void setCsName(String csName) {this.csName = csName;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getJbxx() {return jbxx;}
public void setJbxx(String jbxx) {this.jbxx = jbxx;}
}

员工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 headPic;
//电话
private String phone;
//年龄
private String age;
//
private String sex;
//
private String zw;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
}

公告javaBean创建语句如下：

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

//公告
public class Gonggao  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}

药品进货javaBean创建语句如下：

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

//药品进货
public class Jh  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品
private Long ypId;
//数量
private Integer sl;
//进货单价
private Integer fee;
//总价
private Integer zj;
//进货日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
public Long getYpId() {return ypId;}
public void setYpId(Long ypId) {this.ypId = ypId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
}

药品类别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;}
}

药品销售javaBean创建语句如下：

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

//药品销售
public class Xs  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//药品
private Long ypId;
//数量
private Integer sl;
//销售单价
private Integer fee;
//总价
private Integer zj;
//销售日期
@DateTimeFormat(pattern = "yyyy-MM-dd")
private Date showDate;
//负责人
private String fzr;
//联系电话
private String lxdh;
//对方公司
private String dfgs;
//对方负责人
private String dffzr;
//对方联系电话
private String dflxdh;
public Long getYpId() {return ypId;}
public void setYpId(Long ypId) {this.ypId = ypId;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public Integer getZj() {return zj;}
public void setZj(Integer zj) {this.zj = zj;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getDfgs() {return dfgs;}
public void setDfgs(String dfgs) {this.dfgs = dfgs;}
public String getDffzr() {return dffzr;}
public void setDffzr(String dffzr) {this.dffzr = dffzr;}
public String getDflxdh() {return dflxdh;}
public void setDflxdh(String dflxdh) {this.dflxdh = dflxdh;}
}

药品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 fee;
//规格
private String gg;
//单位
private String dw;
//厂商
private Long csId;
//用法
private String yf;
//药品类别
private Long typesId;
public String getYpName() {return ypName;}
public void setYpName(String ypName) {this.ypName = ypName;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getGg() {return gg;}
public void setGg(String gg) {this.gg = gg;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
public Long getCsId() {return csId;}
public void setCsId(Long csId) {this.csId = csId;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
public Long getTypesId() {return typesId;}
public void setTypesId(Long typesId) {this.typesId = typesId;}
}