客户关系管理系统的开发与设计

客户关系管理系统的开发与设计登录注册界面

客户关系管理系统的开发与设计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_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 '性别',
	typs varchar(100) comment '类型',
	fzkhId int comment '负责客户',
	v1 varchar(100) comment '客户类别',
	v2 varchar(100) comment '客户状态'
) comment '用户';

通告表创建语句如下:


create table t_gonggao(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '日期'
) comment '通告';

消息表创建语句如下:


create table t_xiaoxi(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	toId int comment '接收方',
	types varchar(100) comment '类型',
	title varchar(100) comment '消息',
	insertDate datetime comment '日期',
	status varchar(100) comment '状态'
) comment '消息';

邮件表创建语句如下:


create table t_youjian(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	toId int comment '接收方',
	types varchar(100) comment '类型',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	fileUrl varchar(100) comment '附件',
	insertDate datetime comment '日期',
	status 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	typs varchar(100),
	fzkhId int,
	v1 varchar(100),
	v2 varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.typs is '类型';
comment on column t_customer.fzkhId is '负责客户';
comment on column t_customer.v1 is '客户类别';
comment on column t_customer.v2 is '客户状态';
--用户表加注释
comment on table t_customer is '用户';

通告表创建语句如下:


create table t_gonggao(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate varchar(100)
);
--通告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.pic is '图片';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.showDate is '日期';
--通告表加注释
comment on table t_gonggao is '通告';

消息表创建语句如下:


create table t_xiaoxi(
	id integer,
	customerId int,
	toId int,
	types varchar(100),
	title varchar(100),
	insertDate datetime,
	status varchar(100)
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.customerId is '用户';
comment on column t_xiaoxi.toId is '接收方';
comment on column t_xiaoxi.types is '类型';
comment on column t_xiaoxi.title is '消息';
comment on column t_xiaoxi.insertDate is '日期';
comment on column t_xiaoxi.status is '状态';
--消息表加注释
comment on table t_xiaoxi is '消息';

邮件表创建语句如下:


create table t_youjian(
	id integer,
	customerId int,
	toId int,
	types varchar(100),
	title varchar(100),
	content varchar(100),
	fileUrl varchar(100),
	insertDate datetime,
	status varchar(100)
);
--邮件字段加注释
comment on column t_youjian.id is '主键';
comment on column t_youjian.customerId is '用户';
comment on column t_youjian.toId is '接收方';
comment on column t_youjian.types is '类型';
comment on column t_youjian.title is '标题';
comment on column t_youjian.content is '内容';
comment on column t_youjian.fileUrl is '附件';
comment on column t_youjian.insertDate is '日期';
comment on column t_youjian.status is '状态';
--邮件表加注释
comment on table t_youjian is '邮件';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_gonggao;
create sequence s_t_xiaoxi;
create sequence s_t_youjian;

客户关系管理系统的开发与设计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_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),--性别
	typs varchar(100),--类型
	fzkhId int,--负责客户
	v1 varchar(100),--客户类别
	v2 varchar(100)--客户状态
);

通告表创建语句如下:


--通告表注释
create table t_gonggao(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate varchar(100)--日期
);

消息表创建语句如下:


--消息表注释
create table t_xiaoxi(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	toId int,--接收方
	types varchar(100),--类型
	title varchar(100),--消息
	insertDate datetime,--日期
	status varchar(100)--状态
);

邮件表创建语句如下:


--邮件表注释
create table t_youjian(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	toId int,--接收方
	types varchar(100),--类型
	title varchar(100),--标题
	content varchar(100),--内容
	fileUrl varchar(100),--附件
	insertDate datetime,--日期
	status varchar(100)--状态
);

客户关系管理系统的开发与设计登录后主页

客户关系管理系统的开发与设计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_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 age;
//性别
private String sex;
//类型
private String typs;
//负责客户
private Integer fzkhId;
//客户类别
private String v1;
//客户状态
private String v2;
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 getTyps() {return typs;}
public void setTyps(String typs) {this.typs = typs;}
public Integer getFzkhId() {return fzkhId;}
public void setFzkhId(Integer fzkhId) {this.fzkhId = fzkhId;}
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;}
}

通告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_gonggao")
public class Gonggao {
//主键
@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 title;
//图片
private String pic;
//内容
private String content;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

消息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_xiaoxi")
public class Xiaoxi {
//主键
@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 Integer toId;
//类型
private String types;
//消息
private String title;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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;}
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_youjian")
public class Youjian {
//主键
@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 Integer toId;
//类型
private String types;
//标题
private String title;
//内容
private String content;
//附件
private String fileUrl;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

客户关系管理系统的开发与设计spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

用户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 age;
//性别
private String sex;
//类型
private String typs;
//负责客户
private Integer fzkhId;
//客户类别
private String v1;
//客户状态
private String v2;
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 getTyps() {return typs;}
public void setTyps(String typs) {this.typs = typs;}
public Integer getFzkhId() {return fzkhId;}
public void setFzkhId(Integer fzkhId) {this.fzkhId = fzkhId;}
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;}
}

通告javaBean创建语句如下:


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;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private String showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

消息javaBean创建语句如下:


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

//消息
public class Xiaoxi  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//接收方
private Integer toId;
//类型
private String types;
//消息
private String title;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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;}
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 Youjian  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//接收方
private Integer toId;
//类型
private String types;
//标题
private String title;
//内容
private String content;
//附件
private String fileUrl;
//日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

评论