基于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_ckdj(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘管理员’,
ckdjName varchar(100) comment ‘设备名称’,
v1 varchar(100) comment ‘对接人’,
v2 varchar(100) comment ‘出库人’,
showDate datetime comment ‘出库时间’,
v3 int comment ‘数量’,
v4 varchar(100) comment ‘种类’,
v5 int comment ‘价格’,
gd varchar(100) comment ‘工地’,
v6 varchar(100) comment ‘库房’,
v7 varchar(100) comment ‘货架’,
remark varchar(100) 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 ‘姓名’,
phone varchar(100) comment ‘电话’,
age varchar(100) comment ‘年龄’,
sex varchar(100) comment ‘性别’
) comment ‘普通管理员’;
SQLCopy
公告表创建语句如下:
create table t_gg(
id int primary key auto_increment comment ‘主键’,
title varchar(100) comment ‘标题’,
pic varchar(100) comment ‘图片’,
cotnent varchar(100) comment ‘内容’,
showDate datetime comment ‘日期’
) comment ‘公告’;
SQLCopy
入库登记表创建语句如下:
create table t_rkdj(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘管理员’,
rkdjName varchar(100) comment ‘设备名称’,
v1 varchar(100) comment ‘对接人’,
v2 varchar(100) comment ‘入库人’,
showDate datetime comment ‘入库时间’,
v3 int comment ‘数量’,
v4 varchar(100) comment ‘种类’,
v5 int comment ‘价格’,
gd varchar(100) comment ‘工地’,
v6 varchar(100) comment ‘库房’,
v7 varchar(100) comment ‘货架’,
remark varchar(100) comment ‘备注’
) comment ‘入库登记’;
SQLCopy
上报维修表创建语句如下:
create table t_sbwx(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘上报人’,
title varchar(100) comment ‘标题’,
insertDate datetime comment ‘上报时间’,
types varchar(100) comment ‘类型’,
pic varchar(100) comment ‘图片’,
status varchar(100) comment ‘状态’,
back varchar(100) comment ‘回复’,
remark varchar(100) comment ‘备注说明’
) comment ‘上报维修’;
SQLCopy
申请设备表创建语句如下:
create table t_sqsb(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘上报人’,
title varchar(100) comment ‘标题’,
sb varchar(100) comment ‘设备’,
sl int comment ‘数量’,
insertDate datetime comment ‘申请时间’,
status varchar(100) comment ‘状态’,
remark varchar(100) comment ‘申请说明’,
back varchar(100) comment ‘回复’
) comment ‘申请设备’;
SQLCopy
管理员消息表创建语句如下:
create table t_xiaoxi(
id int primary key auto_increment comment ‘主键’,
customerId int comment ‘管理员’,
title varchar(100) comment ‘标题’,
remark varchar(100) comment ‘内容’,
insertDate datetime 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_ckdj(
id integer,
customerId int,
ckdjName varchar(100),
v1 varchar(100),
v2 varchar(100),
showDate datetime,
v3 int,
v4 varchar(100),
v5 int,
gd varchar(100),
v6 varchar(100),
v7 varchar(100),
remark varchar(100)
);
–出库登记字段加注释
comment on column t_ckdj.id is ‘主键’;
comment on column t_ckdj.customerId is ‘管理员’;
comment on column t_ckdj.ckdjName is ‘设备名称’;
comment on column t_ckdj.v1 is ‘对接人’;
comment on column t_ckdj.v2 is ‘出库人’;
comment on column t_ckdj.showDate is ‘出库时间’;
comment on column t_ckdj.v3 is ‘数量’;
comment on column t_ckdj.v4 is ‘种类’;
comment on column t_ckdj.v5 is ‘价格’;
comment on column t_ckdj.gd is ‘工地’;
comment on column t_ckdj.v6 is ‘库房’;
comment on column t_ckdj.v7 is ‘货架’;
comment on column t_ckdj.remark is ‘备注’;
–出库登记表加注释
comment on table t_ckdj is ‘出库登记’;
SQLCopy
普通管理员表创建语句如下:
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName 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.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_gg(
id integer,
title varchar(100),
pic varchar(100),
cotnent varchar(100),
showDate datetime
);
–公告字段加注释
comment on column t_gg.id is ‘主键’;
comment on column t_gg.title is ‘标题’;
comment on column t_gg.pic is ‘图片’;
comment on column t_gg.cotnent is ‘内容’;
comment on column t_gg.showDate is ‘日期’;
–公告表加注释
comment on table t_gg is ‘公告’;
SQLCopy
入库登记表创建语句如下:
create table t_rkdj(
id integer,
customerId int,
rkdjName varchar(100),
v1 varchar(100),
v2 varchar(100),
showDate datetime,
v3 int,
v4 varchar(100),
v5 int,
gd varchar(100),
v6 varchar(100),
v7 varchar(100),
remark varchar(100)
);
–入库登记字段加注释
comment on column t_rkdj.id is ‘主键’;
comment on column t_rkdj.customerId is ‘管理员’;
comment on column t_rkdj.rkdjName is ‘设备名称’;
comment on column t_rkdj.v1 is ‘对接人’;
comment on column t_rkdj.v2 is ‘入库人’;
comment on column t_rkdj.showDate is ‘入库时间’;
comment on column t_rkdj.v3 is ‘数量’;
comment on column t_rkdj.v4 is ‘种类’;
comment on column t_rkdj.v5 is ‘价格’;
comment on column t_rkdj.gd is ‘工地’;
comment on column t_rkdj.v6 is ‘库房’;
comment on column t_rkdj.v7 is ‘货架’;
comment on column t_rkdj.remark is ‘备注’;
–入库登记表加注释
comment on table t_rkdj is ‘入库登记’;
SQLCopy
上报维修表创建