- 瑞泰公司客户关系管理系统的设计与开发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_ckrk(
id int primary key auto_increment comment '主键',
cpId int comment '产品',
types varchar(100) comment '类型',
sl int comment '数量',
fzr varchar(100) comment '负责人',
insertDate datetime comment '操作日期'
) comment '出库入库';
产品信息表创建语句如下：
create table t_cp(
id int primary key auto_increment comment '主键',
cpName varchar(100) comment '产品名称',
pic varchar(100) comment '图片',
kc int comment '库存',
cfwz 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 '姓名',
pic varchar(100) comment '头像',
email varchar(100) comment '邮箱',
phone varchar(100) comment '电话'
) comment '客户经理';
反馈信息表创建语句如下：
create table t_fkxx(
id int primary key auto_increment comment '主键',
customerId int comment '客户经理',
title varchar(100) comment '反馈信息标题',
fj varchar(100) comment '附件',
content varchar(100) comment '说明',
insertDate datetime comment '发起日期',
back varchar(100) comment '回复',
status varchar(100) comment '状态'
) comment '反馈信息';
公告表创建语句如下：
create table t_gg(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '标题',
showDate datetime comment '日期',
v3 varchar(100) comment '内容'
) comment '公告';
合同表创建语句如下：
create table t_ht(
id int primary key auto_increment comment '主键',
customerId int comment '客户经理',
customerName varchar(100) comment '客户',
lxrName varchar(100) comment '联系人姓名',
phone varchar(100) comment '联系人电话',
htzt varchar(100) comment '合同名称',
fileUrl varchar(100) comment '合同附件',
pt varchar(100) comment '合同图片',
je varchar(100) comment '合同金额',
remark varchar(100) comment '合同备注',
htrq datetime comment '合同日期'
) comment '合同';
客户表创建语句如下：
create table t_kh(
id int primary key auto_increment comment '主键',
customerId int comment '客户经理',
customerName varchar(100) comment '客户名称',
dz varchar(100) comment '客户地址',
lxr varchar(100) comment '公司联系人',
lxdh varchar(100) comment '公司联系电话',
khdj varchar(100) comment '客户等级'
) comment '客户';
联系人表创建语句如下：
create table t_lxr(
id int primary key auto_increment comment '主键',
customerId int comment '客户经理',
lxrName varchar(100) comment '联系人姓名',
phone varchar(100) comment '电话',
xb varchar(100) comment '性别',
age varchar(100) comment '年龄',
zw varchar(100) comment '职位',
qq varchar(100) comment 'qq',
customerName varchar(100) comment '所属公司',
remark varchar(100) comment '备注'
) comment '联系人';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '客户经理',
txName varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime 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_ckrk(
id integer,
cpId int,
types varchar(100),
sl int,
fzr varchar(100),
insertDate datetime
);
--出库入库字段加注释
comment on column t_ckrk.id is '主键';
comment on column t_ckrk.cpId is '产品';
comment on column t_ckrk.types is '类型';
comment on column t_ckrk.sl is '数量';
comment on column t_ckrk.fzr is '负责人';
comment on column t_ckrk.insertDate is '操作日期';
--出库入库表加注释
comment on table t_ckrk is '出库入库';
产品信息表创建语句如下：
create table t_cp(
id integer,
cpName varchar(100),
pic varchar(100),
kc int,
cfwz varchar(100)
);
--产品信息字段加注释
comment on column t_cp.id is '主键';
comment on column t_cp.cpName is '产品名称';
comment on column t_cp.pic is '图片';
comment on column t_cp.kc is '库存';
comment on column t_cp.cfwz is '存放位置';
--产品信息表加注释
comment on table t_cp is '产品信息';
客户经理表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
pic varchar(100),
email 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.pic is '头像';
comment on column t_customer.email is '邮箱';
comment on column t_customer.phone is '电话';
--客户经理表加注释
comment on table t_customer is '客户经理';
反馈信息表创建语句如下：
create table t_fkxx(
id integer,
customerId int,
title varchar(100),
fj varchar(100),
content varchar(100),
insertDate datetime,
back varchar(100),
status varchar(100)
);
--反馈信息字段加注释
comment on column t_fkxx.id is '主键';
comment on column t_fkxx.customerId is '客户经理';
comment on column t_fkxx.title is '反馈信息标题';
comment on column t_fkxx.fj is '附件';
comment on column t_fkxx.content is '说明';
comment on column t_fkxx.insertDate is '发起日期';
comment on column t_fkxx.back is '回复';
comment on column t_fkxx.status is '状态';
--反馈信息表加注释
comment on table t_fkxx is '反馈信息';
公告表创建语句如下：
create table t_gg(
id integer,
v1 varchar(100),
showDate datetime,
v3 varchar(100)
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.v1 is '标题';
comment on column t_gg.showDate is '日期';
comment on column t_gg.v3 is '内容';
--公告表加注释
comment on table t_gg is '公告';
合同表创建语句如下：
create table t_ht(
id integer,
customerId int,
customerName varchar(100),
lxrName varchar(100),
phone varchar(100),
htzt varchar(100),
fileUrl varchar(100),
pt varchar(100),
je varchar(100),
remark varchar(100),
htrq datetime
);
--合同字段加注释
comment on column t_ht.id is '主键';
comment on column t_ht.customerId is '客户经理';
comment on column t_ht.customerName is '客户';
comment on column t_ht.lxrName is '联系人姓名';
comment on column t_ht.phone is '联系人电话';
comment on column t_ht.htzt is '合同名称';
comment on column t_ht.fileUrl is '合同附件';
comment on column t_ht.pt is '合同图片';
comment on column t_ht.je is '合同金额';
comment on column t_ht.remark is '合同备注';
comment on column t_ht.htrq is '合同日期';
--合同表加注释
comment on table t_ht is '合同';
客户表创建语句如下：
create table t_kh(
id integer,
customerId int,
customerName varchar(100),
dz varchar(100),
lxr varchar(100),
lxdh varchar(100),
khdj varchar(100)
);
--客户字段加注释
comment on column t_kh.id is '主键';
comment on column t_kh.customerId is '客户经理';
comment on column t_kh.customerName is '客户名称';
comment on column t_kh.dz is '客户地址';
comment on column t_kh.lxr is '公司联系人';
comment on column t_kh.lxdh is '公司联系电话';
comment on column t_kh.khdj is '客户等级';
--客户表加注释
comment on table t_kh is '客户';
联系人表创建语句如下：
create table t_lxr(
id integer,
customerId int,
lxrName varchar(100),
phone varchar(100),
xb varchar(100),
age varchar(100),
zw varchar(100),
qq varchar(100),
customerName varchar(100),
remark varchar(100)
);
--联系人字段加注释
comment on column t_lxr.id is '主键';
comment on column t_lxr.customerId is '客户经理';
comment on column t_lxr.lxrName is '联系人姓名';
comment on column t_lxr.phone is '电话';
comment on column t_lxr.xb is '性别';
comment on column t_lxr.age is '年龄';
comment on column t_lxr.zw is '职位';
comment on column t_lxr.qq is 'qq';
comment on column t_lxr.customerName is '所属公司';
comment on column t_lxr.remark is '备注';
--联系人表加注释
comment on table t_lxr is '联系人';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
txName varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '客户经理';
comment on column t_tongzhi.txName is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
oracle特有，对应序列如下：
create sequence s_t_ckrk;
create sequence s_t_cp;
create sequence s_t_customer;
create sequence s_t_fkxx;
create sequence s_t_gg;
create sequence s_t_ht;
create sequence s_t_kh;
create sequence s_t_lxr;
create sequence s_t_tongzhi;
瑞泰公司客户关系管理系统的设计与开发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_ckrk(
id int identity(1,1) primary key not null,--主键
cpId int,--产品
types varchar(100),--类型
sl int,--数量
fzr varchar(100),--负责人
insertDate datetime--操作日期
);
产品信息表创建语句如下：
--产品信息表注释
create table t_cp(
id int identity(1,1) primary key not null,--主键
cpName varchar(100),--产品名称
pic varchar(100),--图片
kc int,--库存
cfwz varchar(100)--存放位置
);
客户经理表创建语句如下：
--客户经理表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
pic varchar(100),--头像
email varchar(100),--邮箱
phone varchar(100)--电话
);
反馈信息表创建语句如下：
--反馈信息表注释
create table t_fkxx(
id int identity(1,1) primary key not null,--主键
customerId int,--客户经理
title varchar(100),--反馈信息标题
fj varchar(100),--附件
content varchar(100),--说明
insertDate datetime,--发起日期
back varchar(100),--回复
status varchar(100)--状态
);
公告表创建语句如下：
--公告表注释
create table t_gg(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--标题
showDate datetime,--日期
v3 varchar(100)--内容
);
合同表创建语句如下：
--合同表注释
create table t_ht(
id int identity(1,1) primary key not null,--主键
customerId int,--客户经理
customerName varchar(100),--客户
lxrName varchar(100),--联系人姓名
phone varchar(100),--联系人电话
htzt varchar(100),--合同名称
fileUrl varchar(100),--合同附件
pt varchar(100),--合同图片
je varchar(100),--合同金额
remark varchar(100),--合同备注
htrq datetime--合同日期
);
客户表创建语句如下：
--客户表注释
create table t_kh(
id int identity(1,1) primary key not null,--主键
customerId int,--客户经理
customerName varchar(100),--客户名称
dz varchar(100),--客户地址
lxr varchar(100),--公司联系人
lxdh varchar(100),--公司联系电话
khdj varchar(100)--客户等级
);
联系人表创建语句如下：
--联系人表注释
create table t_lxr(
id int identity(1,1) primary key not null,--主键
customerId int,--客户经理
lxrName varchar(100),--联系人姓名
phone varchar(100),--电话
xb varchar(100),--性别
age varchar(100),--年龄
zw varchar(100),--职位
qq varchar(100),--qq
customerName varchar(100),--所属公司
remark varchar(100)--备注
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--客户经理
txName varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
登录后主页.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_ckrk")
public class Ckrk {
//主键
@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 cpId;
//类型
private String types;
//数量
private Integer sl;
//负责人
private String fzr;
//操作日期
private Date insertDate;
public Integer getCpId() {return cpId;}
public void setCpId(Integer cpId) {this.cpId = cpId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
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_cp")
public class Cp {
//主键
@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 cpName;
//图片
private String pic;
//库存
private Integer kc;
//存放位置
private String cfwz;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getCfwz() {return cfwz;}
public void setCfwz(String cfwz) {this.cfwz = cfwz;}
}客户经理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 pic;
//邮箱
private String email;
//电话
private String phone;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}反馈信息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_fkxx")
public class Fkxx {
//主键
@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 title;
//附件
private String fj;
//说明
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
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;}
}公告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 String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}合同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 customerName;
//联系人姓名
private String lxrName;
//联系人电话
private String phone;
//合同名称
private String htzt;
//合同附件
private String fileUrl;
//合同图片
private String pt;
//合同金额
private String je;
//合同备注
private String remark;
//合同日期
private Date htrq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getLxrName() {return lxrName;}
public void setLxrName(String lxrName) {this.lxrName = lxrName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHtzt() {return htzt;}
public void setHtzt(String htzt) {this.htzt = htzt;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getPt() {return pt;}
public void setPt(String pt) {this.pt = pt;}
public String getJe() {return je;}
public void setJe(String je) {this.je = je;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getHtrq() {return htrq;}
public void setHtrq(Date htrq) {this.htrq = htrq;}
}客户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_kh")
public class Kh {
//主键
@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 customerName;
//客户地址
private String dz;
//公司联系人
private String lxr;
//公司联系电话
private String lxdh;
//客户等级
private String khdj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
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 getKhdj() {return khdj;}
public void setKhdj(String khdj) {this.khdj = khdj;}
}联系人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_lxr")
public class Lxr {
//主键
@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 lxrName;
//电话
private String phone;
//性别
private String xb;
//年龄
private String age;
//职位
private String zw;
//qq
private String qq;
//所属公司
private String customerName;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getLxrName() {return lxrName;}
public void setLxrName(String lxrName) {this.lxrName = lxrName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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;}
}瑞泰公司客户关系管理系统的设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
出库入库javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//出库入库
public class Ckrk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品
private Integer cpId;
//类型
private String types;
//数量
private Integer sl;
//负责人
private String fzr;
//操作日期
private Date insertDate;
public Integer getCpId() {return cpId;}
public void setCpId(Integer cpId) {this.cpId = cpId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getSl() {return sl;}
public void setSl(Integer sl) {this.sl = sl;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
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 Cp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String cpName;
//图片
private String pic;
//库存
private Integer kc;
//存放位置
private String cfwz;
public String getCpName() {return cpName;}
public void setCpName(String cpName) {this.cpName = cpName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public Integer getKc() {return kc;}
public void setKc(Integer kc) {this.kc = kc;}
public String getCfwz() {return cfwz;}
public void setCfwz(String cfwz) {this.cfwz = cfwz;}
}客户经理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 pic;
//邮箱
private String email;
//电话
private String phone;
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 getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}反馈信息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//反馈信息
public class Fkxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户经理
private Integer customerId;
//反馈信息标题
private String title;
//附件
private String fj;
//说明
private String content;
//发起日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getFj() {return fj;}
public void setFj(String fj) {this.fj = fj;}
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;}
}公告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 String v1;
//日期
private Date showDate;
//内容
private String v3;
public String getV1() {return v1;}
public void setV1(String v1) {this.v1 = v1;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
}合同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 customerName;
//联系人姓名
private String lxrName;
//联系人电话
private String phone;
//合同名称
private String htzt;
//合同附件
private String fileUrl;
//合同图片
private String pt;
//合同金额
private String je;
//合同备注
private String remark;
//合同日期
private Date htrq;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getLxrName() {return lxrName;}
public void setLxrName(String lxrName) {this.lxrName = lxrName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getHtzt() {return htzt;}
public void setHtzt(String htzt) {this.htzt = htzt;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getPt() {return pt;}
public void setPt(String pt) {this.pt = pt;}
public String getJe() {return je;}
public void setJe(String je) {this.je = je;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public Date getHtrq() {return htrq;}
public void setHtrq(Date htrq) {this.htrq = htrq;}
}客户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//客户
public class Kh extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户经理
private Integer customerId;
//客户名称
private String customerName;
//客户地址
private String dz;
//公司联系人
private String lxr;
//公司联系电话
private String lxdh;
//客户等级
private String khdj;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getDz() {return dz;}
public void setDz(String dz) {this.dz = dz;}
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 getKhdj() {return khdj;}
public void setKhdj(String khdj) {this.khdj = khdj;}
}联系人javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//联系人
public class Lxr extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户经理
private Integer customerId;
//联系人姓名
private String lxrName;
//电话
private String phone;
//性别
private String xb;
//年龄
private String age;
//职位
private String zw;
//qq
private String qq;
//所属公司
private String customerName;
//备注
private String remark;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getLxrName() {return lxrName;}
public void setLxrName(String lxrName) {this.lxrName = lxrName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getXb() {return xb;}
public void setXb(String xb) {this.xb = xb;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getZw() {return zw;}
public void setZw(String zw) {this.zw = zw;}
public String getQq() {return qq;}
public void setQq(String qq) {this.qq = qq;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}通知javaBean创建语句如下：
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;}
//客户经理
private Integer customerId;
//标题
private String txName;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTxName() {return txName;}
public void setTxName(String txName) {this.txName = txName;}
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;}
}