药品管理系统
药品管理系统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 varch