- 基于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_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 '入库日期',
v1 varchar(100) comment '',
v2 varchar(100) comment '',
v3 varchar(100) comment ''
) comment '用户';
社团负责人表创建语句如下：
create table t_fzr(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
fzrName varchar(100) comment '负责人姓名',
st varchar(100) comment ''
) comment '社团负责人';
计算机社团表创建语句如下：
create table t_jsj(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
jsjDate varchar(100) comment '日期',
status varchar(100) comment '状态'
) comment '计算机社团';
留言表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
toC int comment '对谁留言',
dpContent varchar(100) comment '内容',
sydpDate datetime comment '日期'
) comment '留言';
社团列表表创建语句如下：
create table t_stlb(
id int primary key auto_increment comment '主键',
types varchar(100) comment '类型',
v1 varchar(100) comment '社团名称',
v2 varchar(100) comment '社团负责人',
v3 varchar(100) comment '成立时间',
v4 varchar(100) comment '社团介绍'
) comment '社团列表';
摄影社团表创建语句如下：
create table t_sy(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
syPic varchar(100) comment '图片',
status varchar(100) comment '状态'
) comment '摄影社团';
摄影点评表创建语句如下：
create table t_sydp(
id int primary key auto_increment comment '主键',
syId int comment '摄影',
customerId int comment '用户',
dpContent varchar(100) comment '点评内容',
sydpDate datetime comment '评论日期'
) comment '摄影点评';
文学社团表创建语句如下：
create table t_wx(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
wxName varchar(100) comment '文章',
status varchar(100) comment '状态'
) comment '文学社团';
文学点评表创建语句如下：
create table t_wxdp(
id int primary key auto_increment comment '主键',
wxId int comment '文学',
customerId int comment '用户',
dpContent varchar(100) comment '点评内容',
wxdpDate datetime comment '评论日期'
) comment '文学点评';
社团新闻表创建语句如下：
create table t_xw(
id int primary key auto_increment comment '主键',
xwtitle varchar(100) comment '新闻标题',
xwContent varchar(100) comment '新闻内容',
xwDate varchar(100) 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_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,
v1 varchar(100),
v2 varchar(100),
v3 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.v1 is '';
comment on column t_customer.v2 is '';
comment on column t_customer.v3 is '';
--用户表加注释
comment on table t_customer is '用户';
社团负责人表创建语句如下：
create table t_fzr(
id integer,
username varchar(100),
password varchar(100),
fzrName varchar(100),
st varchar(100)
);
--社团负责人字段加注释
comment on column t_fzr.id is '主键';
comment on column t_fzr.username is '账号';
comment on column t_fzr.password is '密码';
comment on column t_fzr.fzrName is '负责人姓名';
comment on column t_fzr.st is '';
--社团负责人表加注释
comment on table t_fzr is '社团负责人';
计算机社团表创建语句如下：
create table t_jsj(
id integer,
customerId int,
jsjDate varchar(100),
status varchar(100)
);
--计算机社团字段加注释
comment on column t_jsj.id is '主键';
comment on column t_jsj.customerId is '用户';
comment on column t_jsj.jsjDate is '日期';
comment on column t_jsj.status is '状态';
--计算机社团表加注释
comment on table t_jsj is '计算机社团';
留言表创建语句如下：
create table t_ly(
id integer,
customerId int,
toC int,
dpContent varchar(100),
sydpDate datetime
);
--留言字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '用户';
comment on column t_ly.toC is '对谁留言';
comment on column t_ly.dpContent is '内容';
comment on column t_ly.sydpDate is '日期';
--留言表加注释
comment on table t_ly is '留言';
社团列表表创建语句如下：
create table t_stlb(
id integer,
types varchar(100),
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100)
);
--社团列表字段加注释
comment on column t_stlb.id is '主键';
comment on column t_stlb.types is '类型';
comment on column t_stlb.v1 is '社团名称';
comment on column t_stlb.v2 is '社团负责人';
comment on column t_stlb.v3 is '成立时间';
comment on column t_stlb.v4 is '社团介绍';
--社团列表表加注释
comment on table t_stlb is '社团列表';
摄影社团表创建语句如下：
create table t_sy(
id integer,
customerId int,
syPic varchar(100),
status varchar(100)
);
--摄影社团字段加注释
comment on column t_sy.id is '主键';
comment on column t_sy.customerId is '用户';
comment on column t_sy.syPic is '图片';
comment on column t_sy.status is '状态';
--摄影社团表加注释
comment on table t_sy is '摄影社团';
摄影点评表创建语句如下：
create table t_sydp(
id integer,
syId int,
customerId int,
dpContent varchar(100),
sydpDate datetime
);
--摄影点评字段加注释
comment on column t_sydp.id is '主键';
comment on column t_sydp.syId is '摄影';
comment on column t_sydp.customerId is '用户';
comment on column t_sydp.dpContent is '点评内容';
comment on column t_sydp.sydpDate is '评论日期';
--摄影点评表加注释
comment on table t_sydp is '摄影点评';
文学社团表创建语句如下：
create table t_wx(
id integer,
customerId int,
wxName varchar(100),
status varchar(100)
);
--文学社团字段加注释
comment on column t_wx.id is '主键';
comment on column t_wx.customerId is '用户';
comment on column t_wx.wxName is '文章';
comment on column t_wx.status is '状态';
--文学社团表加注释
comment on table t_wx is '文学社团';
文学点评表创建语句如下：
create table t_wxdp(
id integer,
wxId int,
customerId int,
dpContent varchar(100),
wxdpDate datetime
);
--文学点评字段加注释
comment on column t_wxdp.id is '主键';
comment on column t_wxdp.wxId is '文学';
comment on column t_wxdp.customerId is '用户';
comment on column t_wxdp.dpContent is '点评内容';
comment on column t_wxdp.wxdpDate is '评论日期';
--文学点评表加注释
comment on table t_wxdp is '文学点评';
社团新闻表创建语句如下：
create table t_xw(
id integer,
xwtitle varchar(100),
xwContent varchar(100),
xwDate varchar(100)
);
--社团新闻字段加注释
comment on column t_xw.id is '主键';
comment on column t_xw.xwtitle is '新闻标题';
comment on column t_xw.xwContent is '新闻内容';
comment on column t_xw.xwDate is '新闻日期';
--社团新闻表加注释
comment on table t_xw is '社团新闻';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_fzr;
create sequence s_t_jsj;
create sequence s_t_ly;
create sequence s_t_stlb;
create sequence s_t_sy;
create sequence s_t_sydp;
create sequence s_t_wx;
create sequence s_t_wxdp;
create sequence s_t_xw;
基于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_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,--入库日期
v1 varchar(100),--
v2 varchar(100),--
v3 varchar(100)--
);
社团负责人表创建语句如下：
--社团负责人表注释
create table t_fzr(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
fzrName varchar(100),--负责人姓名
st varchar(100)--
);
计算机社团表创建语句如下：
--计算机社团表注释
create table t_jsj(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
jsjDate varchar(100),--日期
status varchar(100)--状态
);
留言表创建语句如下：
--留言表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
toC int,--对谁留言
dpContent varchar(100),--内容
sydpDate datetime--日期
);
社团列表表创建语句如下：
--社团列表表注释
create table t_stlb(
id int identity(1,1) primary key not null,--主键
types varchar(100),--类型
v1 varchar(100),--社团名称
v2 varchar(100),--社团负责人
v3 varchar(100),--成立时间
v4 varchar(100)--社团介绍
);
摄影社团表创建语句如下：
--摄影社团表注释
create table t_sy(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
syPic varchar(100),--图片
status varchar(100)--状态
);
摄影点评表创建语句如下：
--摄影点评表注释
create table t_sydp(
id int identity(1,1) primary key not null,--主键
syId int,--摄影
customerId int,--用户
dpContent varchar(100),--点评内容
sydpDate datetime--评论日期
);
文学社团表创建语句如下：
--文学社团表注释
create table t_wx(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
wxName varchar(100),--文章
status varchar(100)--状态
);
文学点评表创建语句如下：
--文学点评表注释
create table t_wxdp(
id int identity(1,1) primary key not null,--主键
wxId int,--文学
customerId int,--用户
dpContent varchar(100),--点评内容
wxdpDate datetime--评论日期
);
社团新闻表创建语句如下：
--社团新闻表注释
create table t_xw(
id int identity(1,1) primary key not null,--主键
xwtitle varchar(100),--新闻标题
xwContent varchar(100),--新闻内容
xwDate varchar(100)--新闻日期
);
登录后主页.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_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 v1;
//
private String v2;
//
private String v3;
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 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;}
}社团负责人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_fzr")
public class Fzr {
//主键
@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 fzrName;
//
private String st;
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 getFzrName() {return fzrName;}
public void setFzrName(String fzrName) {this.fzrName = fzrName;}
public String getSt() {return st;}
public void setSt(String st) {this.st = st;}
}计算机社团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_jsj")
public class Jsj {
//主键
@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 jsjDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getJsjDate() {return jsjDate;}
public void setJsjDate(String jsjDate) {this.jsjDate = jsjDate;}
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_ly")
public class Ly {
//主键
@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 toC;
//内容
private String dpContent;
//日期
private Date sydpDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToC() {return toC;}
public void setToC(Integer toC) {this.toC = toC;}
public String getDpContent() {return dpContent;}
public void setDpContent(String dpContent) {this.dpContent = dpContent;}
public Date getSydpDate() {return sydpDate;}
public void setSydpDate(Date sydpDate) {this.sydpDate = sydpDate;}
}社团列表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_stlb")
public class Stlb {
//主键
@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;
//成立时间
private String v3;
//社团介绍
private String v4;
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;}
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_sy")
public class Sy {
//主键
@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 syPic;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSyPic() {return syPic;}
public void setSyPic(String syPic) {this.syPic = syPic;}
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_sydp")
public class Sydp {
//主键
@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 syId;
//用户
private Integer customerId;
//点评内容
private String dpContent;
//评论日期
private Date sydpDate;
public Integer getSyId() {return syId;}
public void setSyId(Integer syId) {this.syId = syId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDpContent() {return dpContent;}
public void setDpContent(String dpContent) {this.dpContent = dpContent;}
public Date getSydpDate() {return sydpDate;}
public void setSydpDate(Date sydpDate) {this.sydpDate = sydpDate;}
}文学社团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_wx")
public class Wx {
//主键
@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 wxName;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWxName() {return wxName;}
public void setWxName(String wxName) {this.wxName = wxName;}
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_wxdp")
public class Wxdp {
//主键
@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 wxId;
//用户
private Integer customerId;
//点评内容
private String dpContent;
//评论日期
private Date wxdpDate;
public Integer getWxId() {return wxId;}
public void setWxId(Integer wxId) {this.wxId = wxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDpContent() {return dpContent;}
public void setDpContent(String dpContent) {this.dpContent = dpContent;}
public Date getWxdpDate() {return wxdpDate;}
public void setWxdpDate(Date wxdpDate) {this.wxdpDate = wxdpDate;}
}社团新闻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_xw")
public class Xw {
//主键
@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 xwtitle;
//新闻内容
private String xwContent;
//新闻日期
private String xwDate;
public String getXwtitle() {return xwtitle;}
public void setXwtitle(String xwtitle) {this.xwtitle = xwtitle;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}基于spring的社团管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String name;
//手机
private String phone;
//性别
private String sex;
//年龄
private String age;
//家庭住址
private String address;
//身份证
private String idcard;
//入库日期
private Date insertDate;
//
private String v1;
//
private String v2;
//
private String v3;
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 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;}
}社团负责人javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//社团负责人
public class Fzr 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 fzrName;
//
private String st;
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 getFzrName() {return fzrName;}
public void setFzrName(String fzrName) {this.fzrName = fzrName;}
public String getSt() {return st;}
public void setSt(String st) {this.st = st;}
}计算机社团javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//计算机社团
public class Jsj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//日期
private String jsjDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getJsjDate() {return jsjDate;}
public void setJsjDate(String jsjDate) {this.jsjDate = jsjDate;}
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 Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//对谁留言
private Integer toC;
//内容
private String dpContent;
//日期
private Date sydpDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToC() {return toC;}
public void setToC(Integer toC) {this.toC = toC;}
public String getDpContent() {return dpContent;}
public void setDpContent(String dpContent) {this.dpContent = dpContent;}
public Date getSydpDate() {return sydpDate;}
public void setSydpDate(Date sydpDate) {this.sydpDate = sydpDate;}
}社团列表javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//社团列表
public class Stlb 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;
//成立时间
private String v3;
//社团介绍
private String v4;
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;}
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 Sy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//图片
private String syPic;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getSyPic() {return syPic;}
public void setSyPic(String syPic) {this.syPic = syPic;}
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 Sydp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//摄影
private Integer syId;
//用户
private Integer customerId;
//点评内容
private String dpContent;
//评论日期
private Date sydpDate;
public Integer getSyId() {return syId;}
public void setSyId(Integer syId) {this.syId = syId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDpContent() {return dpContent;}
public void setDpContent(String dpContent) {this.dpContent = dpContent;}
public Date getSydpDate() {return sydpDate;}
public void setSydpDate(Date sydpDate) {this.sydpDate = sydpDate;}
}文学社团javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//文学社团
public class Wx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//文章
private String wxName;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getWxName() {return wxName;}
public void setWxName(String wxName) {this.wxName = wxName;}
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 Wxdp extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文学
private Integer wxId;
//用户
private Integer customerId;
//点评内容
private String dpContent;
//评论日期
private Date wxdpDate;
public Integer getWxId() {return wxId;}
public void setWxId(Integer wxId) {this.wxId = wxId;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDpContent() {return dpContent;}
public void setDpContent(String dpContent) {this.dpContent = dpContent;}
public Date getWxdpDate() {return wxdpDate;}
public void setWxdpDate(Date wxdpDate) {this.wxdpDate = wxdpDate;}
}社团新闻javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//社团新闻
public class Xw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//新闻标题
private String xwtitle;
//新闻内容
private String xwContent;
//新闻日期
private String xwDate;
public String getXwtitle() {return xwtitle;}
public void setXwtitle(String xwtitle) {this.xwtitle = xwtitle;}
public String getXwContent() {return xwContent;}
public void setXwContent(String xwContent) {this.xwContent = xwContent;}
public String getXwDate() {return xwDate;}
public void setXwDate(String xwDate) {this.xwDate = xwDate;}
}