- 广播电视台广告管理系统mysql数据库创建语句
- 广播电视台广告管理系统oracle数据库创建语句
- 广播电视台广告管理系统sqlserver数据库创建语句
- 广播电视台广告管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 广播电视台广告管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
广播电视台广告管理系统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_bcd(
id int primary key auto_increment comment '主键',
bcdName varchar(100) comment '播出单编号',
days varchar(100) comment '播放日',
beginDate datetime comment '开始时间',
endDate datetime comment '结束时间',
zzr varchar(100) comment '制作人',
shr varchar(100) comment '审核人',
status varchar(100) comment '状态'
) comment '播出单';
播出单列表表创建语句如下：
create table t_bcdlist(
id int primary key auto_increment comment '主键',
bcdId int comment '播出单',
ggId int comment '广告',
shousl int comment '收视率',
orderNum int comment '排序'
) comment '播出单列表';
催款表创建语句如下：
create table t_ck(
id int primary key auto_increment comment '主键',
customerId int comment '客户',
shxx varchar(100) comment '催款信息',
fee int 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 '联系电话',
lxr varchar(100) comment '联系人',
types varchar(100) comment '类型'
) comment '用户';
广告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
ggdwId int comment '广告段位',
ggName varchar(100) comment '广告名称',
content varchar(100) comment '广告内容',
ggyy varchar(100) comment '广告语言',
dyr varchar(100) comment '代言人',
pp varchar(100) comment '品牌',
shipin varchar(100) comment '视频',
status varchar(100) comment '状态',
backDat datetime comment '审核时间'
) comment '广告';
广告段位表创建语句如下：
create table t_ggdw(
id int primary key auto_increment comment '主键',
ggdwName varchar(100) comment '段位级别',
beginDate datetime comment '开始时间',
endDate datetime comment '结束时间',
fee int comment '金额'
) comment '广告段位';
合同表创建语句如下：
create table t_ht(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
htName varchar(100) comment '合同编号',
pic varchar(100) comment '图片',
file varchar(100) comment '附件',
content varchar(100) comment '内容描述',
status varchar(100) comment '状态',
back varchar(100) comment '评语'
) comment '合同';
收款表创建语句如下：
create table t_sk(
id int primary key auto_increment comment '主键',
customerId int comment '客户',
shxx varchar(100) comment '收款信息',
ggxx varchar(100) comment '广告信息',
fee int comment '金额'
) comment '收款';
退款表创建语句如下：
create table t_tk(
id int primary key auto_increment comment '主键',
customerId int comment '客户',
shxx varchar(100) comment '退款信息',
tkyy varchar(100) comment '退款原因',
fee int comment '金额'
) comment '退款';
员工表创建语句如下：
create table t_yg(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ygName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
zw varchar(100) comment '职位',
v1 varchar(100) comment '合同审核权限',
v2 varchar(100) comment '广告审核权限',
v3 varchar(100) comment '编播单审核权限',
v4 varchar(100) comment '财务权限'
) comment '员工';
广播电视台广告管理系统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_bcd(
id integer,
bcdName varchar(100),
days varchar(100),
beginDate datetime,
endDate datetime,
zzr varchar(100),
shr varchar(100),
status varchar(100)
);
--播出单字段加注释
comment on column t_bcd.id is '主键';
comment on column t_bcd.bcdName is '播出单编号';
comment on column t_bcd.days is '播放日';
comment on column t_bcd.beginDate is '开始时间';
comment on column t_bcd.endDate is '结束时间';
comment on column t_bcd.zzr is '制作人';
comment on column t_bcd.shr is '审核人';
comment on column t_bcd.status is '状态';
--播出单表加注释
comment on table t_bcd is '播出单';
播出单列表表创建语句如下：
create table t_bcdlist(
id integer,
bcdId int,
ggId int,
shousl int,
orderNum int
);
--播出单列表字段加注释
comment on column t_bcdlist.id is '主键';
comment on column t_bcdlist.bcdId is '播出单';
comment on column t_bcdlist.ggId is '广告';
comment on column t_bcdlist.shousl is '收视率';
comment on column t_bcdlist.orderNum is '排序';
--播出单列表表加注释
comment on table t_bcdlist is '播出单列表';
催款表创建语句如下：
create table t_ck(
id integer,
customerId int,
shxx varchar(100),
fee int
);
--催款字段加注释
comment on column t_ck.id is '主键';
comment on column t_ck.customerId is '客户';
comment on column t_ck.shxx is '催款信息';
comment on column t_ck.fee is '金额';
--催款表加注释
comment on table t_ck is '催款';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
lxr varchar(100),
types 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.lxr is '联系人';
comment on column t_customer.types is '类型';
--用户表加注释
comment on table t_customer is '用户';
广告表创建语句如下：
create table t_gg(
id integer,
ggdwId int,
ggName varchar(100),
content varchar(100),
ggyy varchar(100),
dyr varchar(100),
pp varchar(100),
shipin varchar(100),
status varchar(100),
backDat datetime
);
--广告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.ggdwId is '广告段位';
comment on column t_gg.ggName is '广告名称';
comment on column t_gg.content is '广告内容';
comment on column t_gg.ggyy is '广告语言';
comment on column t_gg.dyr is '代言人';
comment on column t_gg.pp is '品牌';
comment on column t_gg.shipin is '视频';
comment on column t_gg.status is '状态';
comment on column t_gg.backDat is '审核时间';
--广告表加注释
comment on table t_gg is '广告';
广告段位表创建语句如下：
create table t_ggdw(
id integer,
ggdwName varchar(100),
beginDate datetime,
endDate datetime,
fee int
);
--广告段位字段加注释
comment on column t_ggdw.id is '主键';
comment on column t_ggdw.ggdwName is '段位级别';
comment on column t_ggdw.beginDate is '开始时间';
comment on column t_ggdw.endDate is '结束时间';
comment on column t_ggdw.fee is '金额';
--广告段位表加注释
comment on table t_ggdw is '广告段位';
合同表创建语句如下：
create table t_ht(
id integer,
customerId int,
htName varchar(100),
pic varchar(100),
file varchar(100),
content varchar(100),
status varchar(100),
back varchar(100)
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.customerId is '用户';
comment on column t_ht.htName is '合同编号';
comment on column t_ht.pic is '图片';
comment on column t_ht.file is '附件';
comment on column t_ht.content is '内容描述';
comment on column t_ht.status is '状态';
comment on column t_ht.back is '评语';
--合同表加注释
comment on table t_ht is '合同';
收款表创建语句如下：
create table t_sk(
id integer,
customerId int,
shxx varchar(100),
ggxx varchar(100),
fee int
);
--收款字段加注释
comment on column t_sk.id is '主键';
comment on column t_sk.customerId is '客户';
comment on column t_sk.shxx is '收款信息';
comment on column t_sk.ggxx is '广告信息';
comment on column t_sk.fee is '金额';
--收款表加注释
comment on table t_sk is '收款';
退款表创建语句如下：
create table t_tk(
id integer,
customerId int,
shxx varchar(100),
tkyy varchar(100),
fee int
);
--退款字段加注释
comment on column t_tk.id is '主键';
comment on column t_tk.customerId is '客户';
comment on column t_tk.shxx is '退款信息';
comment on column t_tk.tkyy is '退款原因';
comment on column t_tk.fee is '金额';
--退款表加注释
comment on table t_tk is '退款';
员工表创建语句如下：
create table t_yg(
id integer,
username varchar(100),
password varchar(100),
ygName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
zw varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.phone is '电话';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.zw is '职位';
comment on column t_yg.v1 is '合同审核权限';
comment on column t_yg.v2 is '广告审核权限';
comment on column t_yg.v3 is '编播单审核权限';
comment on column t_yg.v4 is '财务权限';
--员工表加注释
comment on table t_yg is '员工';
oracle特有，对应序列如下：
create sequence s_t_bcd;
create sequence s_t_bcdlist;
create sequence s_t_ck;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_ggdw;
create sequence s_t_ht;
create sequence s_t_sk;
create sequence s_t_tk;
create sequence s_t_yg;
广播电视台广告管理系统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_bcd(
id int identity(1,1) primary key not null,--主键
bcdName varchar(100),--播出单编号
days varchar(100),--播放日
beginDate datetime,--开始时间
endDate datetime,--结束时间
zzr varchar(100),--制作人
shr varchar(100),--审核人
status varchar(100)--状态
);
播出单列表表创建语句如下：
--播出单列表表注释
create table t_bcdlist(
id int identity(1,1) primary key not null,--主键
bcdId int,--播出单
ggId int,--广告
shousl int,--收视率
orderNum int--排序
);
催款表创建语句如下：
--催款表注释
create table t_ck(
id int identity(1,1) primary key not null,--主键
customerId int,--客户
shxx varchar(100),--催款信息
fee int--金额
);
用户表创建语句如下：
--用户表注释
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),--联系电话
lxr varchar(100),--联系人
types varchar(100)--类型
);
广告表创建语句如下：
--广告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
ggdwId int,--广告段位
ggName varchar(100),--广告名称
content varchar(100),--广告内容
ggyy varchar(100),--广告语言
dyr varchar(100),--代言人
pp varchar(100),--品牌
shipin varchar(100),--视频
status varchar(100),--状态
backDat datetime--审核时间
);
广告段位表创建语句如下：
--广告段位表注释
create table t_ggdw(
id int identity(1,1) primary key not null,--主键
ggdwName varchar(100),--段位级别
beginDate datetime,--开始时间
endDate datetime,--结束时间
fee int--金额
);
合同表创建语句如下：
--合同表注释
create table t_ht(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
htName varchar(100),--合同编号
pic varchar(100),--图片
file varchar(100),--附件
content varchar(100),--内容描述
status varchar(100),--状态
back varchar(100)--评语
);
收款表创建语句如下：
--收款表注释
create table t_sk(
id int identity(1,1) primary key not null,--主键
customerId int,--客户
shxx varchar(100),--收款信息
ggxx varchar(100),--广告信息
fee int--金额
);
退款表创建语句如下：
--退款表注释
create table t_tk(
id int identity(1,1) primary key not null,--主键
customerId int,--客户
shxx varchar(100),--退款信息
tkyy varchar(100),--退款原因
fee int--金额
);
员工表创建语句如下：
--员工表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ygName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
zw varchar(100),--职位
v1 varchar(100),--合同审核权限
v2 varchar(100),--广告审核权限
v3 varchar(100),--编播单审核权限
v4 varchar(100)--财务权限
);
登录后主页.jpg?x-oss-process=style/00001)
广播电视台广告管理系统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_bcd")
public class Bcd {
//主键
@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 bcdName;
//播放日
private String days;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//制作人
private String zzr;
//审核人
private String shr;
//状态
private String status;
public String getBcdName() {return bcdName;}
public void setBcdName(String bcdName) {this.bcdName = bcdName;}
public String getDays() {return days;}
public void setDays(String days) {this.days = days;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getZzr() {return zzr;}
public void setZzr(String zzr) {this.zzr = zzr;}
public String getShr() {return shr;}
public void setShr(String shr) {this.shr = shr;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}播出单列表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_bcdlist")
public class Bcdlist {
//主键
@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 bcdId;
//广告
private Integer ggId;
//收视率
private Integer shousl;
//排序
private Integer orderNum;
public Integer getBcdId() {return bcdId;}
public void setBcdId(Integer bcdId) {this.bcdId = bcdId;}
public Integer getGgId() {return ggId;}
public void setGgId(Integer ggId) {this.ggId = ggId;}
public Integer getShousl() {return shousl;}
public void setShousl(Integer shousl) {this.shousl = shousl;}
public Integer getOrderNum() {return orderNum;}
public void setOrderNum(Integer orderNum) {this.orderNum = orderNum;}
}催款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_ck")
public class Ck {
//主键
@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 String shxx;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShxx() {return shxx;}
public void setShxx(String shxx) {this.shxx = shxx;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}用户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 phone;
//联系人
private String lxr;
//类型
private String types;
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 getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}广告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 Integer ggdwId;
//广告名称
private String ggName;
//广告内容
private String content;
//广告语言
private String ggyy;
//代言人
private String dyr;
//品牌
private String pp;
//视频
private String shipin;
//状态
private String status;
//审核时间
private Date backDat;
public Integer getGgdwId() {return ggdwId;}
public void setGgdwId(Integer ggdwId) {this.ggdwId = ggdwId;}
public String getGgName() {return ggName;}
public void setGgName(String ggName) {this.ggName = ggName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getGgyy() {return ggyy;}
public void setGgyy(String ggyy) {this.ggyy = ggyy;}
public String getDyr() {return dyr;}
public void setDyr(String dyr) {this.dyr = dyr;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getShipin() {return shipin;}
public void setShipin(String shipin) {this.shipin = shipin;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getBackDat() {return backDat;}
public void setBackDat(Date backDat) {this.backDat = backDat;}
}广告段位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_ggdw")
public class Ggdw {
//主键
@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 ggdwName;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//金额
private Integer fee;
public String getGgdwName() {return ggdwName;}
public void setGgdwName(String ggdwName) {this.ggdwName = ggdwName;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}合同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_ht")
public class Ht {
//主键
@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 String htName;
//图片
private String pic;
//附件
private String file;
//内容描述
private String content;
//状态
private String status;
//评语
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFile() {return file;}
public void setFile(String file) {this.file = file;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}收款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_sk")
public class Sk {
//主键
@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 String shxx;
//广告信息
private String ggxx;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShxx() {return shxx;}
public void setShxx(String shxx) {this.shxx = shxx;}
public String getGgxx() {return ggxx;}
public void setGgxx(String ggxx) {this.ggxx = ggxx;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}退款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_tk")
public class Tk {
//主键
@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 String shxx;
//退款原因
private String tkyy;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShxx() {return shxx;}
public void setShxx(String shxx) {this.shxx = shxx;}
public String getTkyy() {return tkyy;}
public void setTkyy(String tkyy) {this.tkyy = tkyy;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}员工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_yg")
public class Yg {
//主键
@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 ygName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//职位
private String zw;
//合同审核权限
private String v1;
//广告审核权限
private String v2;
//编播单审核权限
private String v3;
//财务权限
private String v4;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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;}
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;}
}广播电视台广告管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
播出单javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//播出单
public class Bcd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//播出单编号
private String bcdName;
//播放日
private String days;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//制作人
private String zzr;
//审核人
private String shr;
//状态
private String status;
public String getBcdName() {return bcdName;}
public void setBcdName(String bcdName) {this.bcdName = bcdName;}
public String getDays() {return days;}
public void setDays(String days) {this.days = days;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public String getZzr() {return zzr;}
public void setZzr(String zzr) {this.zzr = zzr;}
public String getShr() {return shr;}
public void setShr(String shr) {this.shr = shr;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}播出单列表javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//播出单列表
public class Bcdlist extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//播出单
private Integer bcdId;
//广告
private Integer ggId;
//收视率
private Integer shousl;
//排序
private Integer orderNum;
public Integer getBcdId() {return bcdId;}
public void setBcdId(Integer bcdId) {this.bcdId = bcdId;}
public Integer getGgId() {return ggId;}
public void setGgId(Integer ggId) {this.ggId = ggId;}
public Integer getShousl() {return shousl;}
public void setShousl(Integer shousl) {this.shousl = shousl;}
public Integer getOrderNum() {return orderNum;}
public void setOrderNum(Integer orderNum) {this.orderNum = orderNum;}
}催款javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//催款
public class Ck extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户
private Integer customerId;
//催款信息
private String shxx;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShxx() {return shxx;}
public void setShxx(String shxx) {this.shxx = shxx;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}用户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 phone;
//联系人
private String lxr;
//类型
private String types;
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 getLxr() {return lxr;}
public void setLxr(String lxr) {this.lxr = lxr;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}广告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 Integer ggdwId;
//广告名称
private String ggName;
//广告内容
private String content;
//广告语言
private String ggyy;
//代言人
private String dyr;
//品牌
private String pp;
//视频
private String shipin;
//状态
private String status;
//审核时间
private Date backDat;
public Integer getGgdwId() {return ggdwId;}
public void setGgdwId(Integer ggdwId) {this.ggdwId = ggdwId;}
public String getGgName() {return ggName;}
public void setGgName(String ggName) {this.ggName = ggName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getGgyy() {return ggyy;}
public void setGgyy(String ggyy) {this.ggyy = ggyy;}
public String getDyr() {return dyr;}
public void setDyr(String dyr) {this.dyr = dyr;}
public String getPp() {return pp;}
public void setPp(String pp) {this.pp = pp;}
public String getShipin() {return shipin;}
public void setShipin(String shipin) {this.shipin = shipin;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getBackDat() {return backDat;}
public void setBackDat(Date backDat) {this.backDat = backDat;}
}广告段位javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//广告段位
public class Ggdw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//段位级别
private String ggdwName;
//开始时间
private Date beginDate;
//结束时间
private Date endDate;
//金额
private Integer fee;
public String getGgdwName() {return ggdwName;}
public void setGgdwName(String ggdwName) {this.ggdwName = ggdwName;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}合同javaBean创建语句如下：
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;}
//用户
private Integer customerId;
//合同编号
private String htName;
//图片
private String pic;
//附件
private String file;
//内容描述
private String content;
//状态
private String status;
//评语
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getHtName() {return htName;}
public void setHtName(String htName) {this.htName = htName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFile() {return file;}
public void setFile(String file) {this.file = file;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}收款javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//收款
public class Sk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户
private Integer customerId;
//收款信息
private String shxx;
//广告信息
private String ggxx;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShxx() {return shxx;}
public void setShxx(String shxx) {this.shxx = shxx;}
public String getGgxx() {return ggxx;}
public void setGgxx(String ggxx) {this.ggxx = ggxx;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}退款javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//退款
public class Tk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户
private Integer customerId;
//退款信息
private String shxx;
//退款原因
private String tkyy;
//金额
private Integer fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getShxx() {return shxx;}
public void setShxx(String shxx) {this.shxx = shxx;}
public String getTkyy() {return tkyy;}
public void setTkyy(String tkyy) {this.tkyy = tkyy;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
}员工javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工
public class Yg 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 ygName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//职位
private String zw;
//合同审核权限
private String v1;
//广告审核权限
private String v2;
//编播单审核权限
private String v3;
//财务权限
private String v4;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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;}
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;}
}