- 基于BootStrap的晴雅花艺交流论坛的开发mysql数据库创建语句
- 基于BootStrap的晴雅花艺交流论坛的开发oracle数据库创建语句
- 基于BootStrap的晴雅花艺交流论坛的开发sqlserver数据库创建语句
- 基于BootStrap的晴雅花艺交流论坛的开发spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于BootStrap的晴雅花艺交流论坛的开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于BootStrap的晴雅花艺交流论坛的开发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_bk(
id int primary key auto_increment comment '主键',
bkName 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 '头像',
level varchar(100) comment '层级',
isft varchar(100) comment '发帖权限',
ispl varchar(100) comment '评论权限',
mb1 varchar(100) comment '密保1',
mb2 varchar(100) comment '密保2',
mb3 varchar(100) comment '密保3'
) comment '用户';
花艺表创建语句如下：
create table t_huayi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '花艺';
花艺投票表创建语句如下：
create table t_huayitp(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
huayiId int comment '花艺',
ipaddress varchar(100) comment 'ip地址',
insertDate datetime comment '日期'
) comment '花艺投票';
表创建语句如下：
create table t_jk(
id int primary key auto_increment comment '主键',
types varchar(100) comment '类型',
v1 varchar(100) comment '',
v2 varchar(100) comment ''
) comment '';
课程表创建语句如下：
create table t_kc(
id int primary key auto_increment comment '主键',
kcName varchar(100) comment '课程名称',
pic varchar(100) comment '图片',
fileUrl varchar(100) comment '视频',
content varchar(100) comment '内容'
) comment '课程';
留言表创建语句如下：
create table t_liuyan(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
content varchar(100) comment '留言内容',
insertDate datetime comment '日期',
back varchar(100) comment '回复内容',
status varchar(100) comment '状态'
) comment '留言';
论坛说明表创建语句如下：
create table t_ltsm(
id int primary key auto_increment comment '主键',
title varchar(100) comment '论坛说明'
) comment '论坛说明';
敏感词表创建语句如下：
create table t_mgc(
id int primary key auto_increment comment '主键',
mgc varchar(100) comment '敏感词'
) comment '敏感词';
表创建语句如下：
create table t_ms(
id int primary key auto_increment comment '主键',
types varchar(100) comment '分类',
msName varchar(100) comment '名称',
content varchar(100) comment '内容',
msPic varchar(100) comment ''
) comment '';
评论表创建语句如下：
create table t_mspl(
id int primary key auto_increment comment '主键',
msId int comment '',
customerId int comment '用户',
content varchar(100) comment '内容',
insertDate datetime 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_sc(
id int primary key auto_increment comment '主键',
types varchar(100) comment '分类',
scName varchar(100) comment '名称',
pic varchar(100) comment '图片',
content1 varchar(100) comment '内容',
content2 varchar(100) comment ''
) comment '';
图鉴表创建语句如下：
create table t_tj(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) 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 '发布日期',
nologin varchar(100) comment '游客是否可见',
bkId int comment '',
ship varchar(100) comment ''
) comment '我的消息';
表创建语句如下：
create table t_zx(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
insertDate datetime comment '日期'
) comment '';
基于BootStrap的晴雅花艺交流论坛的开发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_bk(
id integer,
bkName varchar(100)
);
--论坛版块字段加注释
comment on column t_bk.id is '主键';
comment on column t_bk.bkName is '版块名称';
--论坛版块表加注释
comment on table t_bk 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),
level varchar(100),
isft varchar(100),
ispl varchar(100),
mb1 varchar(100),
mb2 varchar(100),
mb3 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 column t_customer.level is '层级';
comment on column t_customer.isft is '发帖权限';
comment on column t_customer.ispl is '评论权限';
comment on column t_customer.mb1 is '密保1';
comment on column t_customer.mb2 is '密保2';
comment on column t_customer.mb3 is '密保3';
--用户表加注释
comment on table t_customer is '用户';
花艺表创建语句如下：
create table t_huayi(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
insertDate datetime
);
--花艺字段加注释
comment on column t_huayi.id is '主键';
comment on column t_huayi.customerId is '用户';
comment on column t_huayi.title is '标题';
comment on column t_huayi.pic is '图片';
comment on column t_huayi.content is '内容';
comment on column t_huayi.insertDate is '日期';
--花艺表加注释
comment on table t_huayi is '花艺';
花艺投票表创建语句如下：
create table t_huayitp(
id integer,
customerId int,
huayiId int,
ipaddress varchar(100),
insertDate datetime
);
--花艺投票字段加注释
comment on column t_huayitp.id is '主键';
comment on column t_huayitp.customerId is '用户';
comment on column t_huayitp.huayiId is '花艺';
comment on column t_huayitp.ipaddress is 'ip地址';
comment on column t_huayitp.insertDate is '日期';
--花艺投票表加注释
comment on table t_huayitp is '花艺投票';
表创建语句如下：
create table t_jk(
id integer,
types varchar(100),
v1 varchar(100),
v2 varchar(100)
);
--字段加注释
comment on column t_jk.id is '主键';
comment on column t_jk.types is '类型';
comment on column t_jk.v1 is '';
comment on column t_jk.v2 is '';
--表加注释
comment on table t_jk is '';
课程表创建语句如下：
create table t_kc(
id integer,
kcName varchar(100),
pic varchar(100),
fileUrl varchar(100),
content varchar(100)
);
--课程字段加注释
comment on column t_kc.id is '主键';
comment on column t_kc.kcName is '课程名称';
comment on column t_kc.pic is '图片';
comment on column t_kc.fileUrl is '视频';
comment on column t_kc.content is '内容';
--课程表加注释
comment on table t_kc is '课程';
留言表创建语句如下：
create table t_liuyan(
id integer,
customerId int,
content varchar(100),
insertDate datetime,
back varchar(100),
status varchar(100)
);
--留言字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.customerId is '用户';
comment on column t_liuyan.content is '留言内容';
comment on column t_liuyan.insertDate is '日期';
comment on column t_liuyan.back is '回复内容';
comment on column t_liuyan.status is '状态';
--留言表加注释
comment on table t_liuyan is '留言';
论坛说明表创建语句如下：
create table t_ltsm(
id integer,
title varchar(100)
);
--论坛说明字段加注释
comment on column t_ltsm.id is '主键';
comment on column t_ltsm.title is '论坛说明';
--论坛说明表加注释
comment on table t_ltsm is '论坛说明';
敏感词表创建语句如下：
create table t_mgc(
id integer,
mgc varchar(100)
);
--敏感词字段加注释
comment on column t_mgc.id is '主键';
comment on column t_mgc.mgc is '敏感词';
--敏感词表加注释
comment on table t_mgc is '敏感词';
表创建语句如下：
create table t_ms(
id integer,
types varchar(100),
msName varchar(100),
content varchar(100),
msPic varchar(100)
);
--字段加注释
comment on column t_ms.id is '主键';
comment on column t_ms.types is '分类';
comment on column t_ms.msName is '名称';
comment on column t_ms.content is '内容';
comment on column t_ms.msPic is '';
--表加注释
comment on table t_ms is '';
评论表创建语句如下：
create table t_mspl(
id integer,
msId int,
customerId int,
content varchar(100),
insertDate datetime
);
--评论字段加注释
comment on column t_mspl.id is '主键';
comment on column t_mspl.msId is '';
comment on column t_mspl.customerId is '用户';
comment on column t_mspl.content is '内容';
comment on column t_mspl.insertDate is '日期';
--评论表加注释
comment on table t_mspl 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_sc(
id integer,
types varchar(100),
scName varchar(100),
pic varchar(100),
content1 varchar(100),
content2 varchar(100)
);
--字段加注释
comment on column t_sc.id is '主键';
comment on column t_sc.types is '分类';
comment on column t_sc.scName is '名称';
comment on column t_sc.pic is '图片';
comment on column t_sc.content1 is '内容';
comment on column t_sc.content2 is '';
--表加注释
comment on table t_sc is '';
图鉴表创建语句如下：
create table t_tj(
id integer,
title varchar(100),
pic varchar(100)
);
--图鉴字段加注释
comment on column t_tj.id is '主键';
comment on column t_tj.title is '标题';
comment on column t_tj.pic is '图片';
--图鉴表加注释
comment on table t_tj is '图鉴';
我的消息表创建语句如下：
create table t_wdxx(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
zan int,
insertDate datetime,
nologin varchar(100),
bkId int,
ship varchar(100)
);
--我的消息字段加注释
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 column t_wdxx.nologin is '游客是否可见';
comment on column t_wdxx.bkId is '';
comment on column t_wdxx.ship is '';
--我的消息表加注释
comment on table t_wdxx is '我的消息';
表创建语句如下：
create table t_zx(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
insertDate datetime
);
--字段加注释
comment on column t_zx.id is '主键';
comment on column t_zx.title is '标题';
comment on column t_zx.pic is '图片';
comment on column t_zx.content is '内容';
comment on column t_zx.insertDate is '日期';
--表加注释
comment on table t_zx is '';
oracle特有，对应序列如下：
create sequence s_t_bk;
create sequence s_t_customer;
create sequence s_t_huayi;
create sequence s_t_huayitp;
create sequence s_t_jk;
create sequence s_t_kc;
create sequence s_t_liuyan;
create sequence s_t_ltsm;
create sequence s_t_mgc;
create sequence s_t_ms;
create sequence s_t_mspl;
create sequence s_t_pinglun;
create sequence s_t_sc;
create sequence s_t_tj;
create sequence s_t_wdxx;
create sequence s_t_zx;
基于BootStrap的晴雅花艺交流论坛的开发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_bk(
id int identity(1,1) primary key not null,--主键
bkName 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),--头像
level varchar(100),--层级
isft varchar(100),--发帖权限
ispl varchar(100),--评论权限
mb1 varchar(100),--密保1
mb2 varchar(100),--密保2
mb3 varchar(100)--密保3
);
花艺表创建语句如下：
--花艺表注释
create table t_huayi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
insertDate datetime--日期
);
花艺投票表创建语句如下：
--花艺投票表注释
create table t_huayitp(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
huayiId int,--花艺
ipaddress varchar(100),--ip地址
insertDate datetime--日期
);
表创建语句如下：
--表注释
create table t_jk(
id int identity(1,1) primary key not null,--主键
types varchar(100),--类型
v1 varchar(100),--
v2 varchar(100)--
);
课程表创建语句如下：
--课程表注释
create table t_kc(
id int identity(1,1) primary key not null,--主键
kcName varchar(100),--课程名称
pic varchar(100),--图片
fileUrl varchar(100),--视频
content varchar(100)--内容
);
留言表创建语句如下：
--留言表注释
create table t_liuyan(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
content varchar(100),--留言内容
insertDate datetime,--日期
back varchar(100),--回复内容
status varchar(100)--状态
);
论坛说明表创建语句如下：
--论坛说明表注释
create table t_ltsm(
id int identity(1,1) primary key not null,--主键
title varchar(100)--论坛说明
);
敏感词表创建语句如下：
--敏感词表注释
create table t_mgc(
id int identity(1,1) primary key not null,--主键
mgc varchar(100)--敏感词
);
表创建语句如下：
--表注释
create table t_ms(
id int identity(1,1) primary key not null,--主键
types varchar(100),--分类
msName varchar(100),--名称
content varchar(100),--内容
msPic varchar(100)--
);
评论表创建语句如下：
--评论表注释
create table t_mspl(
id int identity(1,1) primary key not null,--主键
msId int,--
customerId int,--用户
content varchar(100),--内容
insertDate datetime--日期
);
评论表创建语句如下：
--评论表注释
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_sc(
id int identity(1,1) primary key not null,--主键
types varchar(100),--分类
scName varchar(100),--名称
pic varchar(100),--图片
content1 varchar(100),--内容
content2 varchar(100)--
);
图鉴表创建语句如下：
--图鉴表注释
create table t_tj(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100)--图片
);
我的消息表创建语句如下：
--我的消息表注释
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,--发布日期
nologin varchar(100),--游客是否可见
bkId int,--
ship varchar(100)--
);
表创建语句如下：
--表注释
create table t_zx(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
insertDate datetime--日期
);
登录后主页.jpg?x-oss-process=style/00001)
基于BootStrap的晴雅花艺交流论坛的开发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_bk")
public class Bk {
//主键
@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 bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}用户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;
//层级
private String level;
//发帖权限
private String isft;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
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;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
}花艺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_huayi")
public class Huayi {
//主键
@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 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 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_huayitp")
public class Huayitp {
//主键
@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 huayiId;
//ip地址
private String ipaddress;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHuayiId() {return huayiId;}
public void setHuayiId(Integer huayiId) {this.huayiId = huayiId;}
public String getIpaddress() {return ipaddress;}
public void setIpaddress(String ipaddress) {this.ipaddress = ipaddress;}
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_jk")
public class Jk {
//主键
@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 types;
//
private String v1;
//
private String v2;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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_kc")
public class Kc {
//主键
@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 kcName;
//图片
private String pic;
//视频
private String fileUrl;
//内容
private String content;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}留言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_liuyan")
public class Liuyan {
//主键
@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 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 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_ltsm")
public class Ltsm {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}敏感词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_mgc")
public class Mgc {
//主键
@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 mgc;
public String getMgc() {return mgc;}
public void setMgc(String mgc) {this.mgc = mgc;}
}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_ms")
public class Ms {
//主键
@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 types;
//名称
private String msName;
//内容
private String content;
//
private String msPic;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getMsName() {return msName;}
public void setMsName(String msName) {this.msName = msName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getMsPic() {return msPic;}
public void setMsPic(String msPic) {this.msPic = msPic;}
}评论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_mspl")
public class Mspl {
//主键
@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 msId;
//用户
private Integer customerId;
//内容
private String content;
//日期
private Date insertDate;
public Integer getMsId() {return msId;}
public void setMsId(Integer msId) {this.msId = msId;}
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_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_sc")
public class Sc {
//主键
@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 types;
//名称
private String scName;
//图片
private String pic;
//内容
private String content1;
//
private String content2;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getScName() {return scName;}
public void setScName(String scName) {this.scName = scName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent1() {return content1;}
public void setContent1(String content1) {this.content1 = content1;}
public String getContent2() {return content2;}
public void setContent2(String content2) {this.content2 = content2;}
}图鉴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_tj")
public class Tj {
//主键
@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;
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;}
}我的消息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;
//游客是否可见
private String nologin;
//
private Integer bkId;
//
private String ship;
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;}
public String getNologin() {return nologin;}
public void setNologin(String nologin) {this.nologin = nologin;}
public Integer getBkId() {return bkId;}
public void setBkId(Integer bkId) {this.bkId = bkId;}
public String getShip() {return ship;}
public void setShip(String ship) {this.ship = ship;}
}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_zx")
public class Zx {
//主键
@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 Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}基于BootStrap的晴雅花艺交流论坛的开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
论坛版块javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//论坛版块
public class Bk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//版块名称
private String bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}用户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;
//层级
private String level;
//发帖权限
private String isft;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
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;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
}花艺javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//花艺
public class Huayi 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 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 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 Huayitp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//花艺
private Integer huayiId;
//ip地址
private String ipaddress;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHuayiId() {return huayiId;}
public void setHuayiId(Integer huayiId) {this.huayiId = huayiId;}
public String getIpaddress() {return ipaddress;}
public void setIpaddress(String ipaddress) {this.ipaddress = ipaddress;}
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 Jk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类型
private String types;
//
private String v1;
//
private String v2;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
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 Kc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程名称
private String kcName;
//图片
private String pic;
//视频
private String fileUrl;
//内容
private String content;
public String getKcName() {return kcName;}
public void setKcName(String kcName) {this.kcName = kcName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}留言javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//留言
public class Liuyan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//留言内容
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 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 Ltsm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//论坛说明
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}敏感词javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//敏感词
public class Mgc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//敏感词
private String mgc;
public String getMgc() {return mgc;}
public void setMgc(String mgc) {this.mgc = mgc;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Ms extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类
private String types;
//名称
private String msName;
//内容
private String content;
//
private String msPic;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getMsName() {return msName;}
public void setMsName(String msName) {this.msName = msName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getMsPic() {return msPic;}
public void setMsPic(String msPic) {this.msPic = msPic;}
}评论javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//评论
public class Mspl extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer msId;
//用户
private Integer customerId;
//内容
private String content;
//日期
private Date insertDate;
public Integer getMsId() {return msId;}
public void setMsId(Integer msId) {this.msId = msId;}
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 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 Sc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//分类
private String types;
//名称
private String scName;
//图片
private String pic;
//内容
private String content1;
//
private String content2;
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getScName() {return scName;}
public void setScName(String scName) {this.scName = scName;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent1() {return content1;}
public void setContent1(String content1) {this.content1 = content1;}
public String getContent2() {return content2;}
public void setContent2(String content2) {this.content2 = content2;}
}图鉴javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//图鉴
public class Tj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
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;}
}我的消息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;
//游客是否可见
private String nologin;
//
private Integer bkId;
//
private String ship;
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;}
public String getNologin() {return nologin;}
public void setNologin(String nologin) {this.nologin = nologin;}
public Integer getBkId() {return bkId;}
public void setBkId(Integer bkId) {this.bkId = bkId;}
public String getShip() {return ship;}
public void setShip(String ship) {this.ship = ship;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Zx 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 Date insertDate;
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 Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}