基于大数据分析的精准营销系统研究及实现

基于大数据分析的精准营销系统研究及实现登录注册界面

基于大数据分析的精准营销系统研究及实现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_shop(
	id int primary key auto_increment comment '主键',
	shopName varchar(100) comment '商品名称',
	shopPic varchar(100) comment '图片',
	v1 varchar(100) comment '颜色',
	v2 varchar(100) comment '尺寸',
	v3 varchar(100) comment '价格',
	v4 varchar(100) comment '货源地'
) comment '商品';

图片上传表创建语句如下:


create table t_tp(
	id int primary key auto_increment comment '主键',
	openId varchar(100) comment '用户',
	pic varchar(100) comment '图片',
	insertDate datetime comment '日期'
) comment '图片上传';

用户表创建语句如下:


create table t_user(
	id int primary key auto_increment comment '主键',
	nickName varchar(100) comment '姓名',
	openid varchar(100) comment 'openid',
	headPic varchar(100) comment '头像'
) comment '用户';

消息表创建语句如下:


create table t_xiaoxi(
	id int primary key auto_increment comment '主键',
	openid varchar(100) comment 'openid',
	message varchar(100) comment 'message'
) 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_shop(
	id integer,
	shopName varchar(100),
	shopPic varchar(100),
	v1 varchar(100),
	v2 varchar(100),
	v3 varchar(100),
	v4 varchar(100)
);
--商品字段加注释
comment on column t_shop.id is '主键';
comment on column t_shop.shopName is '商品名称';
comment on column t_shop.shopPic is '图片';
comment on column t_shop.v1 is '颜色';
comment on column t_shop.v2 is '尺寸';
comment on column t_shop.v3 is '价格';
comment on column t_shop.v4 is '货源地';
--商品表加注释
comment on table t_shop is '商品';

图片上传表创建语句如下:


create table t_tp(
	id integer,
	openId varchar(100),
	pic varchar(100),
	insertDate datetime
);
--图片上传字段加注释
comment on column t_tp.id is '主键';
comment on column t_tp.openId is '用户';
comment on column t_tp.pic is '图片';
comment on column t_tp.insertDate is '日期';
--图片上传表加注释
comment on table t_tp is '图片上传';

用户表创建语句如下:


create table t_user(
	id integer,
	nickName varchar(100),
	openid varchar(100),
	headPic varchar(100)
);
--用户字段加注释
comment on column t_user.id is '主键';
comment on column t_user.nickName is '姓名';
comment on column t_user.openid is 'openid';
comment on column t_user.headPic is '头像';
--用户表加注释
comment on table t_user is '用户';

消息表创建语句如下:


create table t_xiaoxi(
	id integer,
	openid varchar(100),
	message varchar(100)
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.openid is 'openid';
comment on column t_xiaoxi.message is 'message';
--消息表加注释
comment on table t_xiaoxi is '消息';

oracle特有,对应序列如下:


create sequence s_t_shop;
create sequence s_t_tp;
create sequence s_t_user;
create sequence s_t_xiaoxi;

基于大数据分析的精准营销系统研究及实现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_shop(
	id int identity(1,1) primary key not null,--主键
	shopName varchar(100),--商品名称
	shopPic varchar(100),--图片
	v1 varchar(100),--颜色
	v2 varchar(100),--尺寸
	v3 varchar(100),--价格
	v4 varchar(100)--货源地
);

图片上传表创建语句如下:


--图片上传表注释
create table t_tp(
	id int identity(1,1) primary key not null,--主键
	openId varchar(100),--用户
	pic varchar(100),--图片
	insertDate datetime--日期
);

用户表创建语句如下:


--用户表注释
create table t_user(
	id int identity(1,1) primary key not null,--主键
	nickName varchar(100),--姓名
	openid varchar(100),--openid
	headPic varchar(100)--头像
);

消息表创建语句如下:


--消息表注释
create table t_xiaoxi(
	id int identity(1,1) primary key not null,--主键
	openid varchar(100),--openid
	message varchar(100)--message
);

基于大数据分析的精准营销系统研究及实现登录后主页

基于大数据分析的精准营销系统研究及实现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_shop")
public class Shop {
//主键
@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 shopName;
//图片
private String shopPic;
//颜色
private String v1;
//尺寸
private String v2;
//价格
private String v3;
//货源地
private String v4;
public String getShopName() {return shopName;}
public void setShopName(String shopName) {this.shopName = shopName;}
public String getShopPic() {return shopPic;}
public void setShopPic(String shopPic) {this.shopPic = shopPic;}
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;}
}

图片上传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_tp")
public class Tp {
//主键
@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 openId;
//图片
private String pic;
//日期
private Date insertDate;
public String getOpenId() {return openId;}
public void setOpenId(String openId) {this.openId = openId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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_user")
public class User {
//主键
@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 nickName;
//openid
private String openid;
//头像
private String headPic;
public String getNickName() {return nickName;}
public void setNickName(String nickName) {this.nickName = nickName;}
public String getOpenid() {return openid;}
public void setOpenid(String openid) {this.openid = openid;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

消息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;}
//openid
private String openid;
//message
private String message;
public String getOpenid() {return openid;}
public void setOpenid(String openid) {this.openid = openid;}
public String getMessage() {return message;}
public void setMessage(String message) {this.message = message;}
}

基于大数据分析的精准营销系统研究及实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

商品javaBean创建语句如下:


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

//商品
public class Shop  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//商品名称
private String shopName;
//图片
private String shopPic;
//颜色
private String v1;
//尺寸
private String v2;
//价格
private String v3;
//货源地
private String v4;
public String getShopName() {return shopName;}
public void setShopName(String shopName) {this.shopName = shopName;}
public String getShopPic() {return shopPic;}
public void setShopPic(String shopPic) {this.shopPic = shopPic;}
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;}
}

图片上传javaBean创建语句如下:


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

//图片上传
public class Tp  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private String openId;
//图片
private String pic;
//日期
private Date insertDate;
public String getOpenId() {return openId;}
public void setOpenId(String openId) {this.openId = openId;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
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 User  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String nickName;
//openid
private String openid;
//头像
private String headPic;
public String getNickName() {return nickName;}
public void setNickName(String nickName) {this.nickName = nickName;}
public String getOpenid() {return openid;}
public void setOpenid(String openid) {this.openid = openid;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
}

消息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;}
//openid
private String openid;
//message
private String message;
public String getOpenid() {return openid;}
public void setOpenid(String openid) {this.openid = openid;}
public String getMessage() {return message;}
public void setMessage(String message) {this.message = message;}
}

源代码下载点这里

评论