- 基于spring的果酱公司门户网站mysql数据库创建语句
- 基于spring的果酱公司门户网站oracle数据库创建语句
- 基于spring的果酱公司门户网站sqlserver数据库创建语句
- 基于spring的果酱公司门户网站spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于spring的果酱公司门户网站spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于spring的果酱公司门户网站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_cpjs(
id int primary key auto_increment comment '主键',
typesId int comment '产品分类',
cpjsName varchar(100) comment '产品名称',
v2 varchar(100) comment '产品简介',
v3 varchar(100) comment '产品图片',
v4 varchar(100) comment '规格',
v5 varchar(100) comment '大小',
v6 varchar(100) comment '包装',
v7 varchar(100) comment '产地'
) comment '产品介绍';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
name varchar(100) comment '姓名',
phone varchar(100) comment '手机',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
address varchar(100) comment '家庭住址',
idcard varchar(100) comment '身份证',
insertDate datetime comment '入库日期',
headPic varchar(100) comment ''
) comment '用户';
宠物表创建语句如下：
create table t_cw(
id int primary key auto_increment comment '主键',
cwName varchar(100) comment '宠物别名',
zl varchar(100) comment '种类',
pz varchar(100) comment '品种',
sex varchar(100) comment '性别',
ms varchar(100) comment '毛色',
jkzt varchar(100) comment '健康状态',
llfw varchar(100) comment '流浪范围',
hjdz varchar(100) comment '获救地址',
cwnl varchar(100) comment '宠物年龄',
status varchar(100) comment '状态',
customerId int comment '用户',
syrxm varchar(100) comment '收养人姓名',
syrsex varchar(100) comment '性别',
syrsfz varchar(100) comment '身份证',
ly varchar(100) comment '理由',
jtzz varchar(100) comment '家庭住址',
jtcy varchar(100) comment '家庭成员',
syrdh varchar(100) comment '收养人电话',
jjdz varchar(100) comment '交接地址'
) comment '宠物';
管理层表创建语句如下：
create table t_glc(
id int primary key auto_increment comment '主键',
name varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '家庭住址',
insertDate datetime comment '日期'
) comment '管理层';
公司简介表创建语句如下：
create table t_gsjj(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '公司名称',
v2 varchar(100) comment '公司简介'
) comment '公司简介';
客户简介表创建语句如下：
create table t_khxx(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '客户名称',
v2 varchar(100) comment '客户简介'
) comment '客户简介';
评论表创建语句如下：
create table t_pinglun(
id int primary key auto_increment comment '主键',
wdxxId int comment '评论信息',
customerId int comment '评论人',
content varchar(100) comment '评论内容',
insertDate datetime comment '评论日期'
) comment '评论';
视频表创建语句如下：
create table t_radios(
id int primary key auto_increment comment '主键',
typesId int comment '类型',
radiosTitle varchar(100) comment '描述',
radiosUrl varchar(100) comment '地址'
) comment '视频';
热点表创建语句如下：
create table t_rd(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
url varchar(100) comment '连接地址'
) comment '热点';
类型表创建语句如下：
create table t_types(
id int primary key auto_increment comment '主键',
typesName varchar(100) comment '类型'
) comment '类型';
我的好友表创建语句如下：
create table t_wdhy(
id int primary key auto_increment comment '主键',
customerId int comment '我',
hhId int comment '好友',
insertDate datetime comment '关注日期'
) comment '我的好友';
我的消息表创建语句如下：
create table t_wdxx(
id int primary key auto_increment comment '主键',
customerId int comment '我',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
zan int comment '赞',
insertDate datetime comment '发布日期'
) comment '我的消息';
员工表创建语句如下：
create table t_yg(
id int primary key auto_increment comment '主键',
name varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
address varchar(100) comment '家庭住址',
insertDate datetime comment '日期'
) comment '员工';
基于spring的果酱公司门户网站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_cpjs(
id integer,
typesId int,
cpjsName varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100)
);
--产品介绍字段加注释
comment on column t_cpjs.id is '主键';
comment on column t_cpjs.typesId is '产品分类';
comment on column t_cpjs.cpjsName is '产品名称';
comment on column t_cpjs.v2 is '产品简介';
comment on column t_cpjs.v3 is '产品图片';
comment on column t_cpjs.v4 is '规格';
comment on column t_cpjs.v5 is '大小';
comment on column t_cpjs.v6 is '包装';
comment on column t_cpjs.v7 is '产地';
--产品介绍表加注释
comment on table t_cpjs is '产品介绍';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
name varchar(100),
phone varchar(100),
sex varchar(100),
age varchar(100),
address varchar(100),
idcard varchar(100),
insertDate datetime,
headPic 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.name is '姓名';
comment on column t_customer.phone is '手机';
comment on column t_customer.sex is '性别';
comment on column t_customer.age is '年龄';
comment on column t_customer.address is '家庭住址';
comment on column t_customer.idcard is '身份证';
comment on column t_customer.insertDate is '入库日期';
comment on column t_customer.headPic is '';
--用户表加注释
comment on table t_customer is '用户';
宠物表创建语句如下：
create table t_cw(
id integer,
cwName varchar(100),
zl varchar(100),
pz varchar(100),
sex varchar(100),
ms varchar(100),
jkzt varchar(100),
llfw varchar(100),
hjdz varchar(100),
cwnl varchar(100),
status varchar(100),
customerId int,
syrxm varchar(100),
syrsex varchar(100),
syrsfz varchar(100),
ly varchar(100),
jtzz varchar(100),
jtcy varchar(100),
syrdh varchar(100),
jjdz varchar(100)
);
--宠物字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.cwName is '宠物别名';
comment on column t_cw.zl is '种类';
comment on column t_cw.pz is '品种';
comment on column t_cw.sex is '性别';
comment on column t_cw.ms is '毛色';
comment on column t_cw.jkzt is '健康状态';
comment on column t_cw.llfw is '流浪范围';
comment on column t_cw.hjdz is '获救地址';
comment on column t_cw.cwnl is '宠物年龄';
comment on column t_cw.status is '状态';
comment on column t_cw.customerId is '用户';
comment on column t_cw.syrxm is '收养人姓名';
comment on column t_cw.syrsex is '性别';
comment on column t_cw.syrsfz is '身份证';
comment on column t_cw.ly is '理由';
comment on column t_cw.jtzz is '家庭住址';
comment on column t_cw.jtcy is '家庭成员';
comment on column t_cw.syrdh is '收养人电话';
comment on column t_cw.jjdz is '交接地址';
--宠物表加注释
comment on table t_cw is '宠物';
管理层表创建语句如下：
create table t_glc(
id integer,
name varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100),
insertDate datetime
);
--管理层字段加注释
comment on column t_glc.id is '主键';
comment on column t_glc.name is '姓名';
comment on column t_glc.age is '年龄';
comment on column t_glc.sex is '性别';
comment on column t_glc.phone is '电话';
comment on column t_glc.address is '家庭住址';
comment on column t_glc.insertDate is '日期';
--管理层表加注释
comment on table t_glc is '管理层';
公司简介表创建语句如下：
create table t_gsjj(
id integer,
v1 varchar(100),
v2 varchar(100)
);
--公司简介字段加注释
comment on column t_gsjj.id is '主键';
comment on column t_gsjj.v1 is '公司名称';
comment on column t_gsjj.v2 is '公司简介';
--公司简介表加注释
comment on table t_gsjj is '公司简介';
客户简介表创建语句如下：
create table t_khxx(
id integer,
v1 varchar(100),
v2 varchar(100)
);
--客户简介字段加注释
comment on column t_khxx.id is '主键';
comment on column t_khxx.v1 is '客户名称';
comment on column t_khxx.v2 is '客户简介';
--客户简介表加注释
comment on table t_khxx is '客户简介';
评论表创建语句如下：
create table t_pinglun(
id integer,
wdxxId int,
customerId int,
content varchar(100),
insertDate datetime
);
--评论字段加注释
comment on column t_pinglun.id is '主键';
comment on column t_pinglun.wdxxId is '评论信息';
comment on column t_pinglun.customerId is '评论人';
comment on column t_pinglun.content is '评论内容';
comment on column t_pinglun.insertDate is '评论日期';
--评论表加注释
comment on table t_pinglun is '评论';
视频表创建语句如下：
create table t_radios(
id integer,
typesId int,
radiosTitle varchar(100),
radiosUrl varchar(100)
);
--视频字段加注释
comment on column t_radios.id is '主键';
comment on column t_radios.typesId is '类型';
comment on column t_radios.radiosTitle is '描述';
comment on column t_radios.radiosUrl is '地址';
--视频表加注释
comment on table t_radios is '视频';
热点表创建语句如下：
create table t_rd(
id integer,
title varchar(100),
url varchar(100)
);
--热点字段加注释
comment on column t_rd.id is '主键';
comment on column t_rd.title is '标题';
comment on column t_rd.url is '连接地址';
--热点表加注释
comment on table t_rd is '热点';
类型表创建语句如下：
create table t_types(
id integer,
typesName varchar(100)
);
--类型字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '类型';
--类型表加注释
comment on table t_types is '类型';
我的好友表创建语句如下：
create table t_wdhy(
id integer,
customerId int,
hhId int,
insertDate datetime
);
--我的好友字段加注释
comment on column t_wdhy.id is '主键';
comment on column t_wdhy.customerId is '我';
comment on column t_wdhy.hhId is '好友';
comment on column t_wdhy.insertDate is '关注日期';
--我的好友表加注释
comment on table t_wdhy is '我的好友';
我的消息表创建语句如下：
create table t_wdxx(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
zan int,
insertDate datetime
);
--我的消息字段加注释
comment on column t_wdxx.id is '主键';
comment on column t_wdxx.customerId is '我';
comment on column t_wdxx.title is '标题';
comment on column t_wdxx.pic is '图片';
comment on column t_wdxx.content is '内容';
comment on column t_wdxx.zan is '赞';
comment on column t_wdxx.insertDate is '发布日期';
--我的消息表加注释
comment on table t_wdxx is '我的消息';
员工表创建语句如下：
create table t_yg(
id integer,
name varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
address varchar(100),
insertDate datetime
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.name is '姓名';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.phone is '电话';
comment on column t_yg.address is '家庭住址';
comment on column t_yg.insertDate is '日期';
--员工表加注释
comment on table t_yg is '员工';
oracle特有，对应序列如下：
create sequence s_t_cpjs;
create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_glc;
create sequence s_t_gsjj;
create sequence s_t_khxx;
create sequence s_t_pinglun;
create sequence s_t_radios;
create sequence s_t_rd;
create sequence s_t_types;
create sequence s_t_wdhy;
create sequence s_t_wdxx;
create sequence s_t_yg;
基于spring的果酱公司门户网站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_cpjs(
id int identity(1,1) primary key not null,--主键
typesId int,--产品分类
cpjsName varchar(100),--产品名称
v2 varchar(100),--产品简介
v3 varchar(100),--产品图片
v4 varchar(100),--规格
v5 varchar(100),--大小
v6 varchar(100),--包装
v7 varchar(100)--产地
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
name varchar(100),--姓名
phone varchar(100),--手机
sex varchar(100),--性别
age varchar(100),--年龄
address varchar(100),--家庭住址
idcard varchar(100),--身份证
insertDate datetime,--入库日期
headPic varchar(100)--
);
宠物表创建语句如下：
--宠物表注释
create table t_cw(
id int identity(1,1) primary key not null,--主键
cwName varchar(100),--宠物别名
zl varchar(100),--种类
pz varchar(100),--品种
sex varchar(100),--性别
ms varchar(100),--毛色
jkzt varchar(100),--健康状态
llfw varchar(100),--流浪范围
hjdz varchar(100),--获救地址
cwnl varchar(100),--宠物年龄
status varchar(100),--状态
customerId int,--用户
syrxm varchar(100),--收养人姓名
syrsex varchar(100),--性别
syrsfz varchar(100),--身份证
ly varchar(100),--理由
jtzz varchar(100),--家庭住址
jtcy varchar(100),--家庭成员
syrdh varchar(100),--收养人电话
jjdz varchar(100)--交接地址
);
管理层表创建语句如下：
--管理层表注释
create table t_glc(
id int identity(1,1) primary key not null,--主键
name varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100),--家庭住址
insertDate datetime--日期
);
公司简介表创建语句如下：
--公司简介表注释
create table t_gsjj(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--公司名称
v2 varchar(100)--公司简介
);
客户简介表创建语句如下：
--客户简介表注释
create table t_khxx(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--客户名称
v2 varchar(100)--客户简介
);
评论表创建语句如下：
--评论表注释
create table t_pinglun(
id int identity(1,1) primary key not null,--主键
wdxxId int,--评论信息
customerId int,--评论人
content varchar(100),--评论内容
insertDate datetime--评论日期
);
视频表创建语句如下：
--视频表注释
create table t_radios(
id int identity(1,1) primary key not null,--主键
typesId int,--类型
radiosTitle varchar(100),--描述
radiosUrl varchar(100)--地址
);
热点表创建语句如下：
--热点表注释
create table t_rd(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
url varchar(100)--连接地址
);
类型表创建语句如下：
--类型表注释
create table t_types(
id int identity(1,1) primary key not null,--主键
typesName varchar(100)--类型
);
我的好友表创建语句如下：
--我的好友表注释
create table t_wdhy(
id int identity(1,1) primary key not null,--主键
customerId int,--我
hhId int,--好友
insertDate datetime--关注日期
);
我的消息表创建语句如下：
--我的消息表注释
create table t_wdxx(
id int identity(1,1) primary key not null,--主键
customerId int,--我
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
zan int,--赞
insertDate datetime--发布日期
);
员工表创建语句如下：
--员工表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
name varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
address varchar(100),--家庭住址
insertDate datetime--日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于spring的果酱公司门户网站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_cpjs")
public class Cpjs {
//主键
@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 typesId;
//产品名称
private String cpjsName;
//产品简介
private String v2;
//产品图片
private String v3;
//规格
private String v4;
//大小
private String v5;
//包装
private String v6;
//产地
private String v7;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getCpjsName() {return cpjsName;}
public void setCpjsName(String cpjsName) {this.cpjsName = cpjsName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//
private String headPic;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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_cw")
public class Cw {
//主键
@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 cwName;
//种类
private String zl;
//品种
private String pz;
//性别
private String sex;
//毛色
private String ms;
//健康状态
private String jkzt;
//流浪范围
private String llfw;
//获救地址
private String hjdz;
//宠物年龄
private String cwnl;
//状态
private String status;
//用户
private Integer customerId;
//收养人姓名
private String syrxm;
//性别
private String syrsex;
//身份证
private String syrsfz;
//理由
private String ly;
//家庭住址
private String jtzz;
//家庭成员
private String jtcy;
//收养人电话
private String syrdh;
//交接地址
private String jjdz;
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getZl() {return zl;}
public void setZl(String zl) {this.zl = zl;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getMs() {return ms;}
public void setMs(String ms) {this.ms = ms;}
public String getJkzt() {return jkzt;}
public void setJkzt(String jkzt) {this.jkzt = jkzt;}
public String getLlfw() {return llfw;}
public void setLlfw(String llfw) {this.llfw = llfw;}
public String getHjdz() {return hjdz;}
public void setHjdz(String hjdz) {this.hjdz = hjdz;}
public String getCwnl() {return cwnl;}
public void setCwnl(String cwnl) {this.cwnl = cwnl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSyrxm() {return syrxm;}
public void setSyrxm(String syrxm) {this.syrxm = syrxm;}
public String getSyrsex() {return syrsex;}
public void setSyrsex(String syrsex) {this.syrsex = syrsex;}
public String getSyrsfz() {return syrsfz;}
public void setSyrsfz(String syrsfz) {this.syrsfz = syrsfz;}
public String getLy() {return ly;}
public void setLy(String ly) {this.ly = ly;}
public String getJtzz() {return jtzz;}
public void setJtzz(String jtzz) {this.jtzz = jtzz;}
public String getJtcy() {return jtcy;}
public void setJtcy(String jtcy) {this.jtcy = jtcy;}
public String getSyrdh() {return syrdh;}
public void setSyrdh(String syrdh) {this.syrdh = syrdh;}
public String getJjdz() {return jjdz;}
public void setJjdz(String jjdz) {this.jjdz = jjdz;}
}管理层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_glc")
public class Glc {
//主键
@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 name;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//家庭住址
private String address;
//日期
private Date insertDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
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_gsjj")
public class Gsjj {
//主键
@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 String v2;
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_khxx")
public class Khxx {
//主键
@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 String v2;
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_pinglun")
public class Pinglun {
//主键
@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 wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}视频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_radios")
public class Radios {
//主键
@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 typesId;
//描述
private String radiosTitle;
//地址
private String radiosUrl;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getRadiosTitle() {return radiosTitle;}
public void setRadiosTitle(String radiosTitle) {this.radiosTitle = radiosTitle;}
public String getRadiosUrl() {return radiosUrl;}
public void setRadiosUrl(String radiosUrl) {this.radiosUrl = radiosUrl;}
}热点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_rd")
public class Rd {
//主键
@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 url;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}类型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_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}我的好友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_wdhy")
public class Wdhy {
//主键
@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 hhId;
//关注日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHhId() {return hhId;}
public void setHhId(Integer hhId) {this.hhId = hhId;}
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_wdxx")
public class Wdxx {
//主键
@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 pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
private Date insertDate;
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 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 Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
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_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 name;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//家庭住址
private String address;
//日期
private Date insertDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}基于spring的果酱公司门户网站spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
产品介绍javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//产品介绍
public class Cpjs extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品分类
private Integer typesId;
//产品名称
private String cpjsName;
//产品简介
private String v2;
//产品图片
private String v3;
//规格
private String v4;
//大小
private String v5;
//包装
private String v6;
//产地
private String v7;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getCpjsName() {return cpjsName;}
public void setCpjsName(String cpjsName) {this.cpjsName = cpjsName;}
public String getV2() {return v2;}
public void setV2(String v2) {this.v2 = v2;}
public String getV3() {return v3;}
public void setV3(String v3) {this.v3 = v3;}
public String getV4() {return v4;}
public void setV4(String v4) {this.v4 = v4;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
}用户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 name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//
private String headPic;
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 getName() {return name;}
public void setName(String name) {this.name = name;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getIdcard() {return idcard;}
public void setIdcard(String idcard) {this.idcard = idcard;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
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 Cw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//宠物别名
private String cwName;
//种类
private String zl;
//品种
private String pz;
//性别
private String sex;
//毛色
private String ms;
//健康状态
private String jkzt;
//流浪范围
private String llfw;
//获救地址
private String hjdz;
//宠物年龄
private String cwnl;
//状态
private String status;
//用户
private Integer customerId;
//收养人姓名
private String syrxm;
//性别
private String syrsex;
//身份证
private String syrsfz;
//理由
private String ly;
//家庭住址
private String jtzz;
//家庭成员
private String jtcy;
//收养人电话
private String syrdh;
//交接地址
private String jjdz;
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getZl() {return zl;}
public void setZl(String zl) {this.zl = zl;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getMs() {return ms;}
public void setMs(String ms) {this.ms = ms;}
public String getJkzt() {return jkzt;}
public void setJkzt(String jkzt) {this.jkzt = jkzt;}
public String getLlfw() {return llfw;}
public void setLlfw(String llfw) {this.llfw = llfw;}
public String getHjdz() {return hjdz;}
public void setHjdz(String hjdz) {this.hjdz = hjdz;}
public String getCwnl() {return cwnl;}
public void setCwnl(String cwnl) {this.cwnl = cwnl;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSyrxm() {return syrxm;}
public void setSyrxm(String syrxm) {this.syrxm = syrxm;}
public String getSyrsex() {return syrsex;}
public void setSyrsex(String syrsex) {this.syrsex = syrsex;}
public String getSyrsfz() {return syrsfz;}
public void setSyrsfz(String syrsfz) {this.syrsfz = syrsfz;}
public String getLy() {return ly;}
public void setLy(String ly) {this.ly = ly;}
public String getJtzz() {return jtzz;}
public void setJtzz(String jtzz) {this.jtzz = jtzz;}
public String getJtcy() {return jtcy;}
public void setJtcy(String jtcy) {this.jtcy = jtcy;}
public String getSyrdh() {return syrdh;}
public void setSyrdh(String syrdh) {this.syrdh = syrdh;}
public String getJjdz() {return jjdz;}
public void setJjdz(String jjdz) {this.jjdz = jjdz;}
}管理层javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//管理层
public class Glc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//家庭住址
private String address;
//日期
private Date insertDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
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 Gsjj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//公司名称
private String v1;
//公司简介
private String v2;
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 Khxx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//客户名称
private String v1;
//客户简介
private String v2;
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 Pinglun extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//评论信息
private Integer wdxxId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getWdxxId() {return wdxxId;}
public void setWdxxId(Integer wdxxId) {this.wdxxId = wdxxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}视频javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//视频
public class Radios extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private Integer typesId;
//描述
private String radiosTitle;
//地址
private String radiosUrl;
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public String getRadiosTitle() {return radiosTitle;}
public void setRadiosTitle(String radiosTitle) {this.radiosTitle = radiosTitle;}
public String getRadiosUrl() {return radiosUrl;}
public void setRadiosUrl(String radiosUrl) {this.radiosUrl = radiosUrl;}
}热点javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//热点
public class Rd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//连接地址
private String url;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getUrl() {return url;}
public void setUrl(String url) {this.url = url;}
}类型javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//类型
public class Types extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}我的好友javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//我的好友
public class Wdhy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//我
private Integer customerId;
//好友
private Integer hhId;
//关注日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHhId() {return hhId;}
public void setHhId(Integer hhId) {this.hhId = hhId;}
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 Wdxx 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 pic;
//内容
private String content;
//赞
private Integer zan;
//发布日期
private Date insertDate;
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 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 Integer getZan() {return zan;}
public void setZan(Integer zan) {this.zan = zan;}
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 Yg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String name;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//家庭住址
private String address;
//日期
private Date insertDate;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}