基于java的商贸管理系统功能截图

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_by(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	byh varchar(100) comment '报运号',
	fj varchar(100) comment '报运附件',
	hws varchar(100) comment '货物数',
	zyg varchar(100) comment '装运港',
	shr varchar(100) comment '收货人',
	dz varchar(100) comment '地址',
	ysfs varchar(100) comment '运输方式',
	lrrq datetime comment '录入日期'
) comment '报运';

create table t_cj(
	id int primary key auto_increment comment '主键',
	cjName varchar(100) comment '厂家',
	lx varchar(100) comment '类型',
	lxr varchar(100) comment '联系人',
	lxdh varchar(100) comment '联系电话',
	dz varchar(100) comment '地址',
	yhy varchar(100) 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic varchar(100) comment '头像',
	bm varchar(100) comment '部门',
	zw varchar(100) comment '职位',
	jsId int(11) comment '角色'
) comment '用户';

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

create table t_ht(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	fj varchar(100) comment '合同附件',
	hws varchar(100) comment '货物数',
	khmc varchar(100) comment '客户名称',
	jq datetime comment '交期',
	cq datetime comment '船期',
	qdrq datetime comment '签单日期',
	zje varchar(100) comment '总金额',
	status varchar(100) comment '状态'
) comment '合同';

create table t_js(
	id int primary key auto_increment comment '主键',
	jsName varchar(100) comment '',
	v1 varchar(100) comment '用户管理权限',
	v2 varchar(100) comment '合同管理权限',
	v3 varchar(100) comment '报运管理权限',
	v4 varchar(100) comment '厂家管理权限',
	v5 varchar(100) comment '角色管理权限',
	v6 varchar(100) comment '统计权限'
) comment '角色';

create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	title varchar(1000) comment '内容',
	insertDate datetime comment '发起日期'
) comment '通知';


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_by(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	byh varchar(100) comment '报运号',
	fj varchar(100) comment '报运附件',
	hws varchar(100) comment '货物数',
	zyg varchar(100) comment '装运港',
	shr varchar(100) comment '收货人',
	dz varchar(100) comment '地址',
	ysfs varchar(100) comment '运输方式',
	lrrq datetime comment '录入日期'
) comment '报运';

create table t_cj(
	id int primary key auto_increment comment '主键',
	cjName varchar(100) comment '厂家',
	lx varchar(100) comment '类型',
	lxr varchar(100) comment '联系人',
	lxdh varchar(100) comment '联系电话',
	dz varchar(100) comment '地址',
	yhy varchar(100) 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic varchar(100) comment '头像',
	bm varchar(100) comment '部门',
	zw varchar(100) comment '职位',
	jsId int(11) comment '角色'
) comment '用户';

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

create table t_ht(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	fj varchar(100) comment '合同附件',
	hws varchar(100) comment '货物数',
	khmc varchar(100) comment '客户名称',
	jq datetime comment '交期',
	cq datetime comment '船期',
	qdrq datetime comment '签单日期',
	zje varchar(100) comment '总金额',
	status varchar(100) comment '状态'
) comment '合同';

create table t_js(
	id int primary key auto_increment comment '主键',
	jsName varchar(100) comment '',
	v1 varchar(100) comment '用户管理权限',
	v2 varchar(100) comment '合同管理权限',
	v3 varchar(100) comment '报运管理权限',
	v4 varchar(100) comment '厂家管理权限',
	v5 varchar(100) comment '角色管理权限',
	v6 varchar(100) comment '统计权限'
) comment '角色';

create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	title varchar(1000) comment '内容',
	insertDate datetime comment '发起日期'
) comment '通知';

create table t_by(
	id integer,
	hth varchar(100),
	byh varchar(100),
	fj varchar(100),
	hws varchar(100),
	zyg varchar(100),
	shr varchar(100),
	dz varchar(100),
	ysfs varchar(100),
	lrrq datetime
);
--报运字段加注释
comment on column t_by.id is '主键';
comment on column t_by.id is '主键唯一ID';
comment on column t_by.hth is '合同号';
comment on column t_by.byh is '报运号';
comment on column t_by.fj is '报运附件';
comment on column t_by.hws is '货物数';
comment on column t_by.zyg is '装运港';
comment on column t_by.shr is '收货人';
comment on column t_by.dz is '地址';
comment on column t_by.ysfs is '运输方式';
comment on column t_by.lrrq is '录入日期';
--报运表加注释
comment on table t_by is '报运';

create table t_cj(
	id integer,
	cjName varchar(100),
	lx varchar(100),
	lxr varchar(100),
	lxdh varchar(100),
	dz varchar(100),
	yhy varchar(100)
);
--厂家字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.id is '主键唯一ID';
comment on column t_cj.cjName is '厂家';
comment on column t_cj.lx is '类型';
comment on column t_cj.lxr is '联系人';
comment on column t_cj.lxdh is '联系电话';
comment on column t_cj.dz is '地址';
comment on column t_cj.yhy is '验货员';
--厂家表加注释
comment on table t_cj is '厂家';

create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	pic varchar(100),
	bm varchar(100),
	zw varchar(100),
	jsId int(11)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.id is '主键唯一ID';
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 column t_customer.pic is '头像';
comment on column t_customer.bm is '部门';
comment on column t_customer.zw is '职位';
comment on column t_customer.jsId is '角色';
--用户表加注释
comment on table t_customer is '用户';

create table t_gonggao(
	id integer,
	title varchar(1000),
	content text,
	insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.id is '主键唯一ID';
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_ht(
	id integer,
	hth varchar(100),
	fj varchar(100),
	hws varchar(100),
	khmc varchar(100),
	jq datetime,
	cq datetime,
	qdrq datetime,
	zje varchar(100),
	status varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.id is '主键唯一ID';
comment on column t_ht.hth is '合同号';
comment on column t_ht.fj is '合同附件';
comment on column t_ht.hws is '货物数';
comment on column t_ht.khmc is '客户名称';
comment on column t_ht.jq is '交期';
comment on column t_ht.cq is '船期';
comment on column t_ht.qdrq is '签单日期';
comment on column t_ht.zje is '总金额';
comment on column t_ht.status is '状态';
--合同表加注释
comment on table t_ht is '合同';

create table t_js(
	id integer,
	jsName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--角色字段加注释
comment on column t_js.id is '主键';
comment on column t_js.id is '主键唯一ID';
comment on column t_js.jsName is '';
comment on column t_js.v1 is '用户管理权限';
comment on column t_js.v2 is '合同管理权限';
comment on column t_js.v3 is '报运管理权限';
comment on column t_js.v4 is '厂家管理权限';
comment on column t_js.v5 is '角色管理权限';
comment on column t_js.v6 is '统计权限';
--角色表加注释
comment on table t_js is '角色';

create table t_ly(
	id integer,
	customerId int(11),
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.id is '主键唯一ID';
comment on column t_ly.customerId is '用户';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

create table t_tongzhi(
	id integer,
	customerId int(11),
	title varchar(1000),
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.id is '主键唯一ID';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';


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_by(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	byh varchar(100) comment '报运号',
	fj varchar(100) comment '报运附件',
	hws varchar(100) comment '货物数',
	zyg varchar(100) comment '装运港',
	shr varchar(100) comment '收货人',
	dz varchar(100) comment '地址',
	ysfs varchar(100) comment '运输方式',
	lrrq datetime comment '录入日期'
) comment '报运';

create table t_cj(
	id int primary key auto_increment comment '主键',
	cjName varchar(100) comment '厂家',
	lx varchar(100) comment '类型',
	lxr varchar(100) comment '联系人',
	lxdh varchar(100) comment '联系电话',
	dz varchar(100) comment '地址',
	yhy varchar(100) 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic varchar(100) comment '头像',
	bm varchar(100) comment '部门',
	zw varchar(100) comment '职位',
	jsId int(11) comment '角色'
) comment '用户';

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

create table t_ht(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	fj varchar(100) comment '合同附件',
	hws varchar(100) comment '货物数',
	khmc varchar(100) comment '客户名称',
	jq datetime comment '交期',
	cq datetime comment '船期',
	qdrq datetime comment '签单日期',
	zje varchar(100) comment '总金额',
	status varchar(100) comment '状态'
) comment '合同';

create table t_js(
	id int primary key auto_increment comment '主键',
	jsName varchar(100) comment '',
	v1 varchar(100) comment '用户管理权限',
	v2 varchar(100) comment '合同管理权限',
	v3 varchar(100) comment '报运管理权限',
	v4 varchar(100) comment '厂家管理权限',
	v5 varchar(100) comment '角色管理权限',
	v6 varchar(100) comment '统计权限'
) comment '角色';

create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	title varchar(1000) comment '内容',
	insertDate datetime comment '发起日期'
) comment '通知';

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_by(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	byh varchar(100) comment '报运号',
	fj varchar(100) comment '报运附件',
	hws varchar(100) comment '货物数',
	zyg varchar(100) comment '装运港',
	shr varchar(100) comment '收货人',
	dz varchar(100) comment '地址',
	ysfs varchar(100) comment '运输方式',
	lrrq datetime comment '录入日期'
) comment '报运';

create table t_cj(
	id int primary key auto_increment comment '主键',
	cjName varchar(100) comment '厂家',
	lx varchar(100) comment '类型',
	lxr varchar(100) comment '联系人',
	lxdh varchar(100) comment '联系电话',
	dz varchar(100) comment '地址',
	yhy varchar(100) 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic varchar(100) comment '头像',
	bm varchar(100) comment '部门',
	zw varchar(100) comment '职位',
	jsId int(11) comment '角色'
) comment '用户';

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

create table t_ht(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	fj varchar(100) comment '合同附件',
	hws varchar(100) comment '货物数',
	khmc varchar(100) comment '客户名称',
	jq datetime comment '交期',
	cq datetime comment '船期',
	qdrq datetime comment '签单日期',
	zje varchar(100) comment '总金额',
	status varchar(100) comment '状态'
) comment '合同';

create table t_js(
	id int primary key auto_increment comment '主键',
	jsName varchar(100) comment '',
	v1 varchar(100) comment '用户管理权限',
	v2 varchar(100) comment '合同管理权限',
	v3 varchar(100) comment '报运管理权限',
	v4 varchar(100) comment '厂家管理权限',
	v5 varchar(100) comment '角色管理权限',
	v6 varchar(100) comment '统计权限'
) comment '角色';

create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	title varchar(1000) comment '内容',
	insertDate datetime comment '发起日期'
) comment '通知';

create table t_by(
	id integer,
	hth varchar(100),
	byh varchar(100),
	fj varchar(100),
	hws varchar(100),
	zyg varchar(100),
	shr varchar(100),
	dz varchar(100),
	ysfs varchar(100),
	lrrq datetime
);
--报运字段加注释
comment on column t_by.id is '主键';
comment on column t_by.id is '主键唯一ID';
comment on column t_by.hth is '合同号';
comment on column t_by.byh is '报运号';
comment on column t_by.fj is '报运附件';
comment on column t_by.hws is '货物数';
comment on column t_by.zyg is '装运港';
comment on column t_by.shr is '收货人';
comment on column t_by.dz is '地址';
comment on column t_by.ysfs is '运输方式';
comment on column t_by.lrrq is '录入日期';
--报运表加注释
comment on table t_by is '报运';

create table t_cj(
	id integer,
	cjName varchar(100),
	lx varchar(100),
	lxr varchar(100),
	lxdh varchar(100),
	dz varchar(100),
	yhy varchar(100)
);
--厂家字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.id is '主键唯一ID';
comment on column t_cj.cjName is '厂家';
comment on column t_cj.lx is '类型';
comment on column t_cj.lxr is '联系人';
comment on column t_cj.lxdh is '联系电话';
comment on column t_cj.dz is '地址';
comment on column t_cj.yhy is '验货员';
--厂家表加注释
comment on table t_cj is '厂家';

create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	pic varchar(100),
	bm varchar(100),
	zw varchar(100),
	jsId int(11)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.id is '主键唯一ID';
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 column t_customer.pic is '头像';
comment on column t_customer.bm is '部门';
comment on column t_customer.zw is '职位';
comment on column t_customer.jsId is '角色';
--用户表加注释
comment on table t_customer is '用户';

create table t_gonggao(
	id integer,
	title varchar(1000),
	content text,
	insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.id is '主键唯一ID';
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_ht(
	id integer,
	hth varchar(100),
	fj varchar(100),
	hws varchar(100),
	khmc varchar(100),
	jq datetime,
	cq datetime,
	qdrq datetime,
	zje varchar(100),
	status varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.id is '主键唯一ID';
comment on column t_ht.hth is '合同号';
comment on column t_ht.fj is '合同附件';
comment on column t_ht.hws is '货物数';
comment on column t_ht.khmc is '客户名称';
comment on column t_ht.jq is '交期';
comment on column t_ht.cq is '船期';
comment on column t_ht.qdrq is '签单日期';
comment on column t_ht.zje is '总金额';
comment on column t_ht.status is '状态';
--合同表加注释
comment on table t_ht is '合同';

create table t_js(
	id integer,
	jsName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--角色字段加注释
comment on column t_js.id is '主键';
comment on column t_js.id is '主键唯一ID';
comment on column t_js.jsName is '';
comment on column t_js.v1 is '用户管理权限';
comment on column t_js.v2 is '合同管理权限';
comment on column t_js.v3 is '报运管理权限';
comment on column t_js.v4 is '厂家管理权限';
comment on column t_js.v5 is '角色管理权限';
comment on column t_js.v6 is '统计权限';
--角色表加注释
comment on table t_js is '角色';

create table t_ly(
	id integer,
	customerId int(11),
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.id is '主键唯一ID';
comment on column t_ly.customerId is '用户';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

create table t_tongzhi(
	id integer,
	customerId int(11),
	title varchar(1000),
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.id is '主键唯一ID';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';

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_by(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	byh varchar(100) comment '报运号',
	fj varchar(100) comment '报运附件',
	hws varchar(100) comment '货物数',
	zyg varchar(100) comment '装运港',
	shr varchar(100) comment '收货人',
	dz varchar(100) comment '地址',
	ysfs varchar(100) comment '运输方式',
	lrrq datetime comment '录入日期'
) comment '报运';

create table t_cj(
	id int primary key auto_increment comment '主键',
	cjName varchar(100) comment '厂家',
	lx varchar(100) comment '类型',
	lxr varchar(100) comment '联系人',
	lxdh varchar(100) comment '联系电话',
	dz varchar(100) comment '地址',
	yhy varchar(100) 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 '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	pic varchar(100) comment '头像',
	bm varchar(100) comment '部门',
	zw varchar(100) comment '职位',
	jsId int(11) comment '角色'
) comment '用户';

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

create table t_ht(
	id int primary key auto_increment comment '主键',
	hth varchar(100) comment '合同号',
	fj varchar(100) comment '合同附件',
	hws varchar(100) comment '货物数',
	khmc varchar(100) comment '客户名称',
	jq datetime comment '交期',
	cq datetime comment '船期',
	qdrq datetime comment '签单日期',
	zje varchar(100) comment '总金额',
	status varchar(100) comment '状态'
) comment '合同';

create table t_js(
	id int primary key auto_increment comment '主键',
	jsName varchar(100) comment '',
	v1 varchar(100) comment '用户管理权限',
	v2 varchar(100) comment '合同管理权限',
	v3 varchar(100) comment '报运管理权限',
	v4 varchar(100) comment '厂家管理权限',
	v5 varchar(100) comment '角色管理权限',
	v6 varchar(100) comment '统计权限'
) comment '角色';

create table t_ly(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	content text comment '内容',
	insertDate datetime comment '发起日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

create table t_tongzhi(
	id int primary key auto_increment comment '主键',
	customerId int(11) comment '用户',
	title varchar(1000) comment '内容',
	insertDate datetime comment '发起日期'
) comment '通知';

create table t_by(
	id integer,
	hth varchar(100),
	byh varchar(100),
	fj varchar(100),
	hws varchar(100),
	zyg varchar(100),
	shr varchar(100),
	dz varchar(100),
	ysfs varchar(100),
	lrrq datetime
);
--报运字段加注释
comment on column t_by.id is '主键';
comment on column t_by.id is '主键唯一ID';
comment on column t_by.hth is '合同号';
comment on column t_by.byh is '报运号';
comment on column t_by.fj is '报运附件';
comment on column t_by.hws is '货物数';
comment on column t_by.zyg is '装运港';
comment on column t_by.shr is '收货人';
comment on column t_by.dz is '地址';
comment on column t_by.ysfs is '运输方式';
comment on column t_by.lrrq is '录入日期';
--报运表加注释
comment on table t_by is '报运';

create table t_cj(
	id integer,
	cjName varchar(100),
	lx varchar(100),
	lxr varchar(100),
	lxdh varchar(100),
	dz varchar(100),
	yhy varchar(100)
);
--厂家字段加注释
comment on column t_cj.id is '主键';
comment on column t_cj.id is '主键唯一ID';
comment on column t_cj.cjName is '厂家';
comment on column t_cj.lx is '类型';
comment on column t_cj.lxr is '联系人';
comment on column t_cj.lxdh is '联系电话';
comment on column t_cj.dz is '地址';
comment on column t_cj.yhy is '验货员';
--厂家表加注释
comment on table t_cj is '厂家';

create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	pic varchar(100),
	bm varchar(100),
	zw varchar(100),
	jsId int(11)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.id is '主键唯一ID';
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 column t_customer.pic is '头像';
comment on column t_customer.bm is '部门';
comment on column t_customer.zw is '职位';
comment on column t_customer.jsId is '角色';
--用户表加注释
comment on table t_customer is '用户';

create table t_gonggao(
	id integer,
	title varchar(1000),
	content text,
	insertDate datetime
);
--公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.id is '主键唯一ID';
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_ht(
	id integer,
	hth varchar(100),
	fj varchar(100),
	hws varchar(100),
	khmc varchar(100),
	jq datetime,
	cq datetime,
	qdrq datetime,
	zje varchar(100),
	status varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.id is '主键唯一ID';
comment on column t_ht.hth is '合同号';
comment on column t_ht.fj is '合同附件';
comment on column t_ht.hws is '货物数';
comment on column t_ht.khmc is '客户名称';
comment on column t_ht.jq is '交期';
comment on column t_ht.cq is '船期';
comment on column t_ht.qdrq is '签单日期';
comment on column t_ht.zje is '总金额';
comment on column t_ht.status is '状态';
--合同表加注释
comment on table t_ht is '合同';

create table t_js(
	id integer,
	jsName varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100),
	v5 varchar(100),
	v6 varchar(100)
);
--角色字段加注释
comment on column t_js.id is '主键';
comment on column t_js.id is '主键唯一ID';
comment on column t_js.jsName is '';
comment on column t_js.v1 is '用户管理权限';
comment on column t_js.v2 is '合同管理权限';
comment on column t_js.v3 is '报运管理权限';
comment on column t_js.v4 is '厂家管理权限';
comment on column t_js.v5 is '角色管理权限';
comment on column t_js.v6 is '统计权限';
--角色表加注释
comment on table t_js is '角色';

create table t_ly(
	id integer,
	customerId int(11),
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.id is '主键唯一ID';
comment on column t_ly.customerId is '用户';
comment on column t_ly.content is '内容';
comment on column t_ly.insertDate is '发起日期';
comment on column t_ly.back is '回复';
comment on column t_ly.status is '状态';
--留言表加注释
comment on table t_ly is '留言';

create table t_tongzhi(
	id integer,
	customerId int(11),
	title varchar(1000),
	insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.id is '主键唯一ID';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '内容';
comment on column t_tongzhi.insertDate is '发起日期';
--通知表加注释
comment on table t_tongzhi is '通知';

--报运表注释
create table t_by(
	id int identity(1,1) primary key not null,--主键
	hth varchar(100),--合同号
	byh varchar(100),--报运号
	fj varchar(100),--报运附件
	hws varchar(100),--货物数
	zyg varchar(100),--装运港
	shr varchar(100),--收货人
	dz varchar(100),--地址
	ysfs varchar(100),--运输方式
	lrrq datetime--录入日期
);

--厂家表注释
create table t_cj(
	id int identity(1,1) primary key not null,--主键
	cjName varchar(100),--厂家
	lx varchar(100),--类型
	lxr varchar(100),--联系人
	lxdh varchar(100),--联系电话
	dz varchar(100),--地址
	yhy varchar(100)--验货员
);

--用户表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	customerName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100),--性别
	pic varchar(100),--头像
	bm varchar(100),--部门
	zw varchar(100),--职位
	jsId int(11)--角色
);

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

--合同表注释
create table t_ht(
	id int identity(1,1) primary key not null,--主键
	hth varchar(100),--合同号
	fj varchar(100),--合同附件
	hws varchar(100),--货物数
	khmc varchar(100),--客户名称
	jq datetime,--交期
	cq datetime,--船期
	qdrq datetime,--签单日期
	zje varchar(100),--总金额
	status varchar(100)--状态
);

--角色表注释
create table t_js(
	id int identity(1,1) primary key not null,--主键
	jsName varchar(100),--
	v1 varchar(100),--用户管理权限
	v2 varchar(100),--合同管理权限
	v3 varchar(100),--报运管理权限
	v4 varchar(100),--厂家管理权限
	v5 varchar(100),--角色管理权限
	v6 varchar(100)--统计权限
);

--留言表注释
create table t_ly(
	id int identity(1,1) primary key not null,--主键
	customerId int(11),--用户
	content text,--内容
	insertDate datetime,--发起日期
	back text,--回复
	status varchar(100)--状态
);

--通知表注释
create table t_tongzhi(
	id int identity(1,1) primary key not null,--主键
	customerId int(11),--用户
	title varchar(1000),--内容
	insertDate datetime--发起日期
);

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

//报运
public class By  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//合同号
private String hth;
//报运号
private String byh;
//报运附件
private String fj;
//货物数
private String hws;
//装运港
private String zyg;
//收货人
private String shr;
//地址
private String dz;
//运输方式
private String ysfs;
//录入日期
private Date lrrq;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getHth() {return hth;}
public void setHth(String hth) {this.hth = hth;}
public String getByh() {return byh;}
public void setByh(String byh) {this.byh = byh;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getHws() {return hws;}
public void setHws(String hws) {this.hws = hws;}
public String getZyg() {return zyg;}
public void setZyg(String zyg) {this.zyg = zyg;}
public String getShr() {return shr;}
public void setShr(String shr) {this.shr = shr;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getYsfs() {return ysfs;}
public void setYsfs(String ysfs) {this.ysfs = ysfs;}
public Date getLrrq() {return lrrq;}
public void setLrrq(Date lrrq) {this.lrrq = lrrq;}
}
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;}
//主键唯一ID
private int id;
//厂家
private String cjName;
//类型
private String lx;
//联系人
private String lxr;
//联系电话
private String lxdh;
//地址
private String dz;
//验货员
private String yhy;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getCjName() {return cjName;}
public void setCjName(String cjName) {this.cjName = cjName;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public String getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
public String getYhy() {return yhy;}
public void setYhy(String yhy) {this.yhy = yhy;}
}
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;}
//主键唯一ID
private int id;
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//头像
private String pic;
//部门
private String bm;
//职位
private String zw;
//角色
private int jsId;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
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 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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getBm() {return bm;}
public void setBm(String bm) {this.bm = bm;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public int getJsId() {return jsId;}
public void setJsId(int jsId) {this.jsId = jsId;}
}
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;}
//主键唯一ID
private int id;
//标题
private String title;
//内容
private String content;
//发起日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
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;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//合同
public class Ht  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//合同号
private String hth;
//合同附件
private String fj;
//货物数
private String hws;
//客户名称
private String khmc;
//交期
private Date jq;
//船期
private Date cq;
//签单日期
private Date qdrq;
//总金额
private String zje;
//状态
private String status;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getHth() {return hth;}
public void setHth(String hth) {this.hth = hth;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
public String getHws() {return hws;}
public void setHws(String hws) {this.hws = hws;}
public String getKhmc() {return khmc;}
public void setKhmc(String khmc) {this.khmc = khmc;}
public Date getJq() {return jq;}
public void setJq(Date jq) {this.jq = jq;}
public Date getCq() {return cq;}
public void setCq(Date cq) {this.cq = cq;}
public Date getQdrq() {return qdrq;}
public void setQdrq(Date qdrq) {this.qdrq = qdrq;}
public String getZje() {return zje;}
public void setZje(String zje) {this.zje = zje;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//角色
public class Js  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//
private String jsName;
//用户管理权限
private String v1;
//合同管理权限
private String v2;
//报运管理权限
private String v3;
//厂家管理权限
private String v4;
//角色管理权限
private String v5;
//统计权限
private String v6;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public String getJsName() {return jsName;}
public void setJsName(String jsName) {this.jsName = jsName;}
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//留言
public class Ly  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯��ID
private int id;
//用户
private int customerId;
//内容
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int customerId) {this.customerId = customerId;}
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;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//通知
public class Tongzhi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//主键唯一ID
private int id;
//用户
private int customerId;
//内容
private String title;
//发起日期
private Date insertDate;
public int getId() {return id;}
public void setId(int id) {this.id = id;}
public int getCustomerId() {return customerId;}
public void setCustomerId(int customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}