家教信息交流平台

家教信息交流平台登录注册界面

家教信息交流平台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_adminlb(
	id int primary key auto_increment comment '主键',
	typename varchar(100) comment '类别'
) comment '管理员类别';

学员表创建语句如下:


create table t_customer(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '用户名',
	password varchar(100) comment '密码',
	question varchar(100) comment '提示问题',
	answer varchar(100) comment '答案',
	adminlbId int comment '类别ID',
	realname varchar(100) comment '真实姓名',
	sexuality varchar(100) comment '性别',
	date_of_birth varchar(100) comment '出生年月',
	areas varchar(100) comment '地区',
	tellphone varchar(100) comment '电话号码',
	QQemail varchar(100) comment 'QQ邮箱',
	course varchar(100) comment '求教课程',
	method varchar(100) comment '需要的家教方式',
	sex_need varchar(100) comment '性别要求',
	pay varchar(100) comment '工资待遇',
	typename varchar(100) comment '类别名称',
	head_portrait varchar(100) comment '头像',
	elses varchar(100) comment '其他'
) comment '学员';

教员表创建语句如下:


create table t_jiaoyuan(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '用户名',
	password varchar(100) comment '密码',
	question varchar(100) comment '提示问题',
	answer varchar(100) comment '答案',
	Instruction varchar(100) comment '学历',
	major varchar(100) comment '专业',
	adminlbId int comment '类别ID',
	Workplace varchar(100) comment '工作地方',
	realname varchar(100) comment '真实姓名',
	sexuality varchar(100) comment '性别',
	date_of_birth varchar(100) comment '出生年月',
	areas varchar(100) comment '地区',
	tellphone varchar(100) comment '电话号码',
	QQemail varchar(100) comment 'QQ邮箱',
	course varchar(100) comment '可教科目',
	method varchar(100) comment '提供的家教方式',
	sex_need varchar(100) comment '性别要求',
	treatment varchar(100) comment '期望工资',
	typename varchar(100) comment '类别名称',
	head_portrait varchar(100) comment '头像'
) comment '教员';

轮播图表创建语句如下:


create table t_lbt(
	id int primary key auto_increment comment '主键',
	pic varchar(100) comment '图片'
) comment '轮播图';

留言表创建语句如下:


create table t_liuyan(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	insertDate datetime comment '日期',
	back varchar(100) comment '回复',
	status 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_pinglun_product(
	id int primary key auto_increment comment '主键',
	productId int comment '评论信息',
	customerId int comment '评论人',
	content varchar(100) comment '评论内容',
	insertDate datetime comment '评论日期'
) comment '';

产品表创建语句如下:


create table t_product(
	id int primary key auto_increment comment '主键',
	productName varchar(100) comment '产品名称',
	productPic1 varchar(100) comment '图片1',
	productPic2 varchar(100) comment '图片2',
	productPic3 varchar(100) comment '图片3',
	productPic4 varchar(100) comment '图片4',
	price int comment '价格',
	oldPrice int comment '原价',
	content varchar(100) comment '内容',
	nums int comment '数量',
	tjxj varchar(100) comment '推荐星级',
	status varchar(100) comment '状态',
	typesId int comment '分类',
	jf int comment '积分',
	userId int comment '商家',
	bqId int comment '标签',
	djl int comment '点击量'
) comment '产品';

投诉表创建语句如下:


create table t_tousu(
	id int primary key auto_increment comment '主键',
	contact varchar(100) comment '联系人',
	tellphone varchar(100) comment '电话号码',
	city varchar(100) comment '城市',
	content varchar(100) comment '内容',
	qqemail varchar(100) comment 'qq邮箱'
) comment '投诉';

分类表创建语句如下:


create table t_types(
	id int primary key auto_increment comment '主键',
	typesName 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 ''
) comment '我的消息';

新闻表创建语句如下:


create table t_xinwen(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '新闻标题',
	content varchar(100) comment '新闻内容',
	showDate datetime comment '添加时间',
	author varchar(100) comment '作者',
	xinwenlbId int comment '新闻类别'
) comment '新闻';

新闻类别表创建语句如下:


create table t_xinwenlb(
	id int primary key auto_increment comment '主键',
	typename varchar(100) comment '类别'
) comment '新闻类别';

家教信息交流平台oracle数据库版本源码:

超级管理员表创建语句如下:


create table t_admin(
	id integer,
	username varchar(100),
	password varchar(100)
);
insert into t_admin(id,username,password) values(1,'admin','123456');
--超级管理员字段加注释
comment on column t_admin.id is '主键';
comment on column t_admin.username is '超级管理员账号';
comment on column t_admin.password is '超级管理员密码';
--超级管理员表加注释
comment on table t_admin is '超级管理员';

管理员类别表创建语句如下:


create table t_adminlb(
	id integer,
	typename varchar(100)
);
--管理员类别字段加注释
comment on column t_adminlb.id is '主键';
comment on column t_adminlb.typename is '类别';
--管理员类别表加注释
comment on table t_adminlb is '管理员类别';

学员表创建语句如下:


create table t_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	question varchar(100),
	answer varchar(100),
	adminlbId int,
	realname varchar(100),
	sexuality varchar(100),
	date_of_birth varchar(100),
	areas varchar(100),
	tellphone varchar(100),
	QQemail varchar(100),
	course varchar(100),
	method varchar(100),
	sex_need varchar(100),
	pay varchar(100),
	typename varchar(100),
	head_portrait varchar(100),
	elses 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.question is '提示问题';
comment on column t_customer.answer is '答案';
comment on column t_customer.adminlbId is '类别ID';
comment on column t_customer.realname is '真实姓名';
comment on column t_customer.sexuality is '性别';
comment on column t_customer.date_of_birth is '出生年月';
comment on column t_customer.areas is '地区';
comment on column t_customer.tellphone is '电话号码';
comment on column t_customer.QQemail is 'QQ邮箱';
comment on column t_customer.course is '求教课程';
comment on column t_customer.method is '需要的家教方式';
comment on column t_customer.sex_need is '性别要求';
comment on column t_customer.pay is '工资待遇';
comment on column t_customer.typename is '类别名称';
comment on column t_customer.head_portrait is '头像';
comment on column t_customer.elses is '其他';
--学员表加注释
comment on table t_customer is '学员';

教员表创建语句如下:


create table t_jiaoyuan(
	id integer,
	username varchar(100),
	password varchar(100),
	question varchar(100),
	answer varchar(100),
	Instruction varchar(100),
	major varchar(100),
	adminlbId int,
	Workplace varchar(100),
	realname varchar(100),
	sexuality varchar(100),
	date_of_birth varchar(100),
	areas varchar(100),
	tellphone varchar(100),
	QQemail varchar(100),
	course varchar(100),
	method varchar(100),
	sex_need varchar(100),
	treatment varchar(100),
	typename varchar(100),
	head_portrait varchar(100)
);
--教员字段加注释
comment on column t_jiaoyuan.id is '主键';
comment on column t_jiaoyuan.username is '用户名';
comment on column t_jiaoyuan.password is '密码';
comment on column t_jiaoyuan.question is '提示问题';
comment on column t_jiaoyuan.answer is '答案';
comment on column t_jiaoyuan.Instruction is '学历';
comment on column t_jiaoyuan.major is '专业';
comment on column t_jiaoyuan.adminlbId is '类别ID';
comment on column t_jiaoyuan.Workplace is '工作地方';
comment on column t_jiaoyuan.realname is '真实姓名';
comment on column t_jiaoyuan.sexuality is '性别';
comment on column t_jiaoyuan.date_of_birth is '出生年月';
comment on column t_jiaoyuan.areas is '地区';
comment on column t_jiaoyuan.tellphone is '电话号码';
comment on column t_jiaoyuan.QQemail is 'QQ邮箱';
comment on column t_jiaoyuan.course is '可教科目';
comment on column t_jiaoyuan.method is '提供的家教方式';
comment on column t_jiaoyuan.sex_need is '性别要求';
comment on column t_jiaoyuan.treatment is '期望工资';
comment on column t_jiaoyuan.typename is '类别名称';
comment on column t_jiaoyuan.head_portrait is '头像';
--教员表加注释
comment on table t_jiaoyuan is '教员';

轮播图表创建语句如下:


create table t_lbt(
	id integer,
	pic varchar(100)
);
--轮播图字段加注释
comment on column t_lbt.id is '主键';
comment on column t_lbt.pic is '图片';
--轮播图表加注释
comment on table t_lbt is '轮播图';

留言表创建语句如下:


create table t_liuyan(
	id integer,
	customerId int,
	title varchar(100),
	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.title 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_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_pinglun_product(
	id integer,
	productId int,
	customerId int,
	content varchar(100),
	insertDate datetime
);
--字段加注释
comment on column t_pinglun_product.id is '主键';
comment on column t_pinglun_product.productId is '评论信息';
comment on column t_pinglun_product.customerId is '评论人';
comment on column t_pinglun_product.content is '评论内容';
comment on column t_pinglun_product.insertDate is '评论日期';
--表加注释
comment on table t_pinglun_product is '';

产品表创建语句如下:


create table t_product(
	id integer,
	productName varchar(100),
	productPic1 varchar(100),
	productPic2 varchar(100),
	productPic3 varchar(100),
	productPic4 varchar(100),
	price int,
	oldPrice int,
	content varchar(100),
	nums int,
	tjxj varchar(100),
	status varchar(100),
	typesId int,
	jf int,
	userId int,
	bqId int,
	djl int
);
--产品字段加注释
comment on column t_product.id is '主键';
comment on column t_product.productName is '产品名称';
comment on column t_product.productPic1 is '图片1';
comment on column t_product.productPic2 is '图片2';
comment on column t_product.productPic3 is '图片3';
comment on column t_product.productPic4 is '图片4';
comment on column t_product.price is '价格';
comment on column t_product.oldPrice is '原价';
comment on column t_product.content is '内容';
comment on column t_product.nums is '数量';
comment on column t_product.tjxj is '推荐星级';
comment on column t_product.status is '状态';
comment on column t_product.typesId is '分类';
comment on column t_product.jf is '积分';
comment on column t_product.userId is '商家';
comment on column t_product.bqId is '标签';
comment on column t_product.djl is '点击量';
--产品表加注释
comment on table t_product is '产品';

投诉表创建语句如下:


create table t_tousu(
	id integer,
	contact varchar(100),
	tellphone varchar(100),
	city varchar(100),
	content varchar(100),
	qqemail varchar(100)
);
--投诉字段加注释
comment on column t_tousu.id is '主键';
comment on column t_tousu.contact is '联系人';
comment on column t_tousu.tellphone is '电话号码';
comment on column t_tousu.city is '城市';
comment on column t_tousu.content is '内容';
comment on column t_tousu.qqemail is 'qq邮箱';
--投诉表加注释
comment on table t_tousu 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_wdxx(
	id integer,
	customerId int,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	zan int,
	insertDate datetime,
	nologin varchar(100),
	bkId int
);
--我的消息字段加注释
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 table t_wdxx is '我的消息';

新闻表创建语句如下:


create table t_xinwen(
	id integer,
	title varchar(100),
	content varchar(100),
	showDate datetime,
	author varchar(100),
	xinwenlbId int
);
--新闻字段加注释
comment on column t_xinwen.id is '主键';
comment on column t_xinwen.title is '新闻标题';
comment on column t_xinwen.content is '新闻内容';
comment on column t_xinwen.showDate is '添加时间';
comment on column t_xinwen.author is '作者';
comment on column t_xinwen.xinwenlbId is '新闻类别';
--新闻表加注释
comment on table t_xinwen is '新闻';

新闻类别表创建语句如下:


create table t_xinwenlb(
	id integer,
	typename varchar(100)
);
--新闻类别字段加注释
comment on column t_xinwenlb.id is '主键';
comment on column t_xinwenlb.typename is '类别';
--新闻类别表加注释
comment on table t_xinwenlb is '新闻类别';

oracle特有,对应序列如下:


create sequence s_t_adminlb;
create sequence s_t_customer;
create sequence s_t_jiaoyuan;
create sequence s_t_lbt;
create sequence s_t_liuyan;
create sequence s_t_pinglun;
create sequence s_t_pinglun_product;
create sequence s_t_product;
create sequence s_t_tousu;
create sequence s_t_types;
create sequence s_t_wdxx;
create sequence s_t_xinwen;
create sequence s_t_xinwenlb;

家教信息交流平台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_adminlb(
	id int identity(1,1) primary key not null,--主键
	typename varchar(100)--类别
);

学员表创建语句如下:


--学员表注释
create table t_customer(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--用户名
	password varchar(100),--密码
	question varchar(100),--提示问题
	answer varchar(100),--答案
	adminlbId int,--类别ID
	realname varchar(100),--真实姓名
	sexuality varchar(100),--性别
	date_of_birth varchar(100),--出生年月
	areas varchar(100),--地区
	tellphone varchar(100),--电话号码
	QQemail varchar(100),--QQ邮箱
	course varchar(100),--求教课程
	method varchar(100),--需要的家教方式
	sex_need varchar(100),--性别要求
	pay varchar(100),--工资待遇
	typename varchar(100),--类别名称
	head_portrait varchar(100),--头像
	elses varchar(100)--其他
);

教员表创建语句如下:


--教员表注释
create table t_jiaoyuan(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--用户名
	password varchar(100),--密码
	question varchar(100),--提示问题
	answer varchar(100),--答案
	Instruction varchar(100),--学历
	major varchar(100),--专业
	adminlbId int,--类别ID
	Workplace varchar(100),--工作地方
	realname varchar(100),--真实姓名
	sexuality varchar(100),--性别
	date_of_birth varchar(100),--出生年月
	areas varchar(100),--地区
	tellphone varchar(100),--电话号码
	QQemail varchar(100),--QQ邮箱
	course varchar(100),--可教科目
	method varchar(100),--提供的家教方式
	sex_need varchar(100),--性别要求
	treatment varchar(100),--期望工资
	typename varchar(100),--类别名称
	head_portrait varchar(100)--头像
);

轮播图表创建语句如下:


--轮播图表注释
create table t_lbt(
	id int identity(1,1) primary key not null,--主键
	pic varchar(100)--图片
);

留言表创建语句如下:


--留言表注释
create table t_liuyan(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	title varchar(100),--标题
	content varchar(100),--内容
	insertDate datetime,--日期
	back varchar(100),--回复
	status 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_pinglun_product(
	id int identity(1,1) primary key not null,--主键
	productId int,--评论信息
	customerId int,--评论人
	content varchar(100),--评论内容
	insertDate datetime--评论日期
);

产品表创建语句如下:


--产品表注释
create table t_product(
	id int identity(1,1) primary key not null,--主键
	productName varchar(100),--产品名称
	productPic1 varchar(100),--图片1
	productPic2 varchar(100),--图片2
	productPic3 varchar(100),--图片3
	productPic4 varchar(100),--图片4
	price int,--价格
	oldPrice int,--原价
	content varchar(100),--内容
	nums int,--数量
	tjxj varchar(100),--推荐星级
	status varchar(100),--状态
	typesId int,--分类
	jf int,--积分
	userId int,--商家
	bqId int,--标签
	djl int--点击量
);

投诉表创建语句如下:


--投诉表注释
create table t_tousu(
	id int identity(1,1) primary key not null,--主键
	contact varchar(100),--联系人
	tellphone varchar(100),--电话号码
	city varchar(100),--城市
	content varchar(100),--内容
	qqemail varchar(100)--qq邮箱
);

分类表创建语句如下:


--分类表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName 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--
);

新闻表创建语句如下:


--新闻表注释
create table t_xinwen(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--新闻标题
	content varchar(100),--新闻内容
	showDate datetime,--添加时间
	author varchar(100),--作者
	xinwenlbId int--新闻类别
);

新闻类别表创建语句如下:


--新闻类别表注释
create table t_xinwenlb(
	id int identity(1,1) primary key not null,--主键
	typename varchar(100)--类别
);

家教信息交流平台登录后主页

家教信息交流平台spring+springMVC+hibernate框架对象(javaBean,pojo)设计:

管理员类别javaBean创建语句如下:


package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity

//管理员类别
@Table(name = "t_adminlb")
public class Adminlb {
//主键
@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 typename;
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
}

学员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 question;
//答案
private String answer;
//类别ID
private Integer adminlbId;
//真实姓名
private String realname;
//性别
private String sexuality;
//出生年月
private String date_of_birth;
//地区
private String areas;
//电话号码
private String tellphone;
//QQ邮箱
private String QQemail;
//求教课程
private String course;
//需要的家教方式
private String method;
//性别要求
private String sex_need;
//工资待遇
private String pay;
//类别名称
private String typename;
//头像
private String head_portrait;
//其他
private String elses;
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 getQuestion() {return question;}
public void setQuestion(String question) {this.question = question;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public Integer getAdminlbId() {return adminlbId;}
public void setAdminlbId(Integer adminlbId) {this.adminlbId = adminlbId;}
public String getRealname() {return realname;}
public void setRealname(String realname) {this.realname = realname;}
public String getSexuality() {return sexuality;}
public void setSexuality(String sexuality) {this.sexuality = sexuality;}
public String getDate_of_birth() {return date_of_birth;}
public void setDate_of_birth(String date_of_birth) {this.date_of_birth = date_of_birth;}
public String getAreas() {return areas;}
public void setAreas(String areas) {this.areas = areas;}
public String getTellphone() {return tellphone;}
public void setTellphone(String tellphone) {this.tellphone = tellphone;}
public String getQQemail() {return QQemail;}
public void setQQemail(String QQemail) {this.QQemail = QQemail;}
public String getCourse() {return course;}
public void setCourse(String course) {this.course = course;}
public String getMethod() {return method;}
public void setMethod(String method) {this.method = method;}
public String getSex_need() {return sex_need;}
public void setSex_need(String sex_need) {this.sex_need = sex_need;}
public String getPay() {return pay;}
public void setPay(String pay) {this.pay = pay;}
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
public String getHead_portrait() {return head_portrait;}
public void setHead_portrait(String head_portrait) {this.head_portrait = head_portrait;}
public String getElses() {return elses;}
public void setElses(String elses) {this.elses = elses;}
}

教员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_jiaoyuan")
public class Jiaoyuan {
//主键
@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 question;
//答案
private String answer;
//学历
private String Instruction;
//专业
private String major;
//类别ID
private Integer adminlbId;
//工作地方
private String Workplace;
//真实姓名
private String realname;
//性别
private String sexuality;
//出生年月
private String date_of_birth;
//地区
private String areas;
//电话号码
private String tellphone;
//QQ邮箱
private String QQemail;
//可教科目
private String course;
//提供的家教方式
private String method;
//性别要求
private String sex_need;
//期望工资
private String treatment;
//类别名称
private String typename;
//头像
private String head_portrait;
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 getQuestion() {return question;}
public void setQuestion(String question) {this.question = question;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public String getInstruction() {return Instruction;}
public void setInstruction(String Instruction) {this.Instruction = Instruction;}
public String getMajor() {return major;}
public void setMajor(String major) {this.major = major;}
public Integer getAdminlbId() {return adminlbId;}
public void setAdminlbId(Integer adminlbId) {this.adminlbId = adminlbId;}
public String getWorkplace() {return Workplace;}
public void setWorkplace(String Workplace) {this.Workplace = Workplace;}
public String getRealname() {return realname;}
public void setRealname(String realname) {this.realname = realname;}
public String getSexuality() {return sexuality;}
public void setSexuality(String sexuality) {this.sexuality = sexuality;}
public String getDate_of_birth() {return date_of_birth;}
public void setDate_of_birth(String date_of_birth) {this.date_of_birth = date_of_birth;}
public String getAreas() {return areas;}
public void setAreas(String areas) {this.areas = areas;}
public String getTellphone() {return tellphone;}
public void setTellphone(String tellphone) {this.tellphone = tellphone;}
public String getQQemail() {return QQemail;}
public void setQQemail(String QQemail) {this.QQemail = QQemail;}
public String getCourse() {return course;}
public void setCourse(String course) {this.course = course;}
public String getMethod() {return method;}
public void setMethod(String method) {this.method = method;}
public String getSex_need() {return sex_need;}
public void setSex_need(String sex_need) {this.sex_need = sex_need;}
public String getTreatment() {return treatment;}
public void setTreatment(String treatment) {this.treatment = treatment;}
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
public String getHead_portrait() {return head_portrait;}
public void setHead_portrait(String head_portrait) {this.head_portrait = head_portrait;}
}

轮播图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_lbt")
public class Lbt {
//主键
@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 pic;
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_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 title;
//内容
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 getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public 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_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_pinglun_product")
public class Pinglun_product {
//主键
@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 productId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
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_product")
public class Product {
//主键
@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 productName;
//图片1
private String productPic1;
//图片2
private String productPic2;
//图片3
private String productPic3;
//图片4
private String productPic4;
//价格
private Integer price;
//原价
private Integer oldPrice;
//内容
private String content;
//数量
private Integer nums;
//推荐星级
private String tjxj;
//状态
private String status;
//分类
private Integer typesId;
//积分
private Integer jf;
//商家
private Integer userId;
//标签
private Integer bqId;
//点击量
private Integer djl;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic1() {return productPic1;}
public void setProductPic1(String productPic1) {this.productPic1 = productPic1;}
public String getProductPic2() {return productPic2;}
public void setProductPic2(String productPic2) {this.productPic2 = productPic2;}
public String getProductPic3() {return productPic3;}
public void setProductPic3(String productPic3) {this.productPic3 = productPic3;}
public String getProductPic4() {return productPic4;}
public void setProductPic4(String productPic4) {this.productPic4 = productPic4;}
public Integer getPrice() {return price;}
public void setPrice(Integer price) {this.price = price;}
public Integer getOldPrice() {return oldPrice;}
public void setOldPrice(Integer oldPrice) {this.oldPrice = oldPrice;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getTjxj() {return tjxj;}
public void setTjxj(String tjxj) {this.tjxj = tjxj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getBqId() {return bqId;}
public void setBqId(Integer bqId) {this.bqId = bqId;}
public Integer getDjl() {return djl;}
public void setDjl(Integer djl) {this.djl = djl;}
}

投诉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_tousu")
public class Tousu {
//主键
@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 contact;
//电话号码
private String tellphone;
//城市
private String city;
//内容
private String content;
//qq邮箱
private String qqemail;
public String getContact() {return contact;}
public void setContact(String contact) {this.contact = contact;}
public String getTellphone() {return tellphone;}
public void setTellphone(String tellphone) {this.tellphone = tellphone;}
public String getCity() {return city;}
public void setCity(String city) {this.city = city;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getQqemail() {return qqemail;}
public void setQqemail(String qqemail) {this.qqemail = qqemail;}
}

分类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_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;
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;}
}

新闻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_xinwen")
public class Xinwen {
//主键
@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 content;
//添加时间
private Date showDate;
//作者
private String author;
//新闻类别
private Integer xinwenlbId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getAuthor() {return author;}
public void setAuthor(String author) {this.author = author;}
public Integer getXinwenlbId() {return xinwenlbId;}
public void setXinwenlbId(Integer xinwenlbId) {this.xinwenlbId = xinwenlbId;}
}

新闻类别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_xinwenlb")
public class Xinwenlb {
//主键
@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 typename;
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
}

家教信息交流平台spring+springMVC+mybatis框架对象(javaBean,pojo)设计:

管理员类别javaBean创建语句如下:


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

//管理员类别
public class Adminlb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类别
private String typename;
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
}

学员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 question;
//答案
private String answer;
//类别ID
private Integer adminlbId;
//真实姓名
private String realname;
//性别
private String sexuality;
//出生年月
private String date_of_birth;
//地区
private String areas;
//电话号码
private String tellphone;
//QQ邮箱
private String QQemail;
//求教课程
private String course;
//需要的家教方式
private String method;
//性别要求
private String sex_need;
//工资待遇
private String pay;
//类别名称
private String typename;
//头像
private String head_portrait;
//其他
private String elses;
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 getQuestion() {return question;}
public void setQuestion(String question) {this.question = question;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public Integer getAdminlbId() {return adminlbId;}
public void setAdminlbId(Integer adminlbId) {this.adminlbId = adminlbId;}
public String getRealname() {return realname;}
public void setRealname(String realname) {this.realname = realname;}
public String getSexuality() {return sexuality;}
public void setSexuality(String sexuality) {this.sexuality = sexuality;}
public String getDate_of_birth() {return date_of_birth;}
public void setDate_of_birth(String date_of_birth) {this.date_of_birth = date_of_birth;}
public String getAreas() {return areas;}
public void setAreas(String areas) {this.areas = areas;}
public String getTellphone() {return tellphone;}
public void setTellphone(String tellphone) {this.tellphone = tellphone;}
public String getQQemail() {return QQemail;}
public void setQQemail(String QQemail) {this.QQemail = QQemail;}
public String getCourse() {return course;}
public void setCourse(String course) {this.course = course;}
public String getMethod() {return method;}
public void setMethod(String method) {this.method = method;}
public String getSex_need() {return sex_need;}
public void setSex_need(String sex_need) {this.sex_need = sex_need;}
public String getPay() {return pay;}
public void setPay(String pay) {this.pay = pay;}
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
public String getHead_portrait() {return head_portrait;}
public void setHead_portrait(String head_portrait) {this.head_portrait = head_portrait;}
public String getElses() {return elses;}
public void setElses(String elses) {this.elses = elses;}
}

教员javaBean创建语句如下:


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

//教员
public class Jiaoyuan  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 question;
//答案
private String answer;
//学历
private String Instruction;
//专业
private String major;
//类别ID
private Integer adminlbId;
//工作地方
private String Workplace;
//真实姓名
private String realname;
//性别
private String sexuality;
//出生年月
private String date_of_birth;
//地区
private String areas;
//电话号码
private String tellphone;
//QQ邮箱
private String QQemail;
//可教科目
private String course;
//提供的家教方式
private String method;
//性别要求
private String sex_need;
//期望工资
private String treatment;
//类别名称
private String typename;
//头像
private String head_portrait;
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 getQuestion() {return question;}
public void setQuestion(String question) {this.question = question;}
public String getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
public String getInstruction() {return Instruction;}
public void setInstruction(String Instruction) {this.Instruction = Instruction;}
public String getMajor() {return major;}
public void setMajor(String major) {this.major = major;}
public Integer getAdminlbId() {return adminlbId;}
public void setAdminlbId(Integer adminlbId) {this.adminlbId = adminlbId;}
public String getWorkplace() {return Workplace;}
public void setWorkplace(String Workplace) {this.Workplace = Workplace;}
public String getRealname() {return realname;}
public void setRealname(String realname) {this.realname = realname;}
public String getSexuality() {return sexuality;}
public void setSexuality(String sexuality) {this.sexuality = sexuality;}
public String getDate_of_birth() {return date_of_birth;}
public void setDate_of_birth(String date_of_birth) {this.date_of_birth = date_of_birth;}
public String getAreas() {return areas;}
public void setAreas(String areas) {this.areas = areas;}
public String getTellphone() {return tellphone;}
public void setTellphone(String tellphone) {this.tellphone = tellphone;}
public String getQQemail() {return QQemail;}
public void setQQemail(String QQemail) {this.QQemail = QQemail;}
public String getCourse() {return course;}
public void setCourse(String course) {this.course = course;}
public String getMethod() {return method;}
public void setMethod(String method) {this.method = method;}
public String getSex_need() {return sex_need;}
public void setSex_need(String sex_need) {this.sex_need = sex_need;}
public String getTreatment() {return treatment;}
public void setTreatment(String treatment) {this.treatment = treatment;}
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
public String getHead_portrait() {return head_portrait;}
public void setHead_portrait(String head_portrait) {this.head_portrait = head_portrait;}
}

轮播图javaBean创建语句如下:


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

//轮播图
public class Lbt  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//图片
private String pic;
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 Liuyan  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 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 getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public 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 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 Pinglun_product  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//评论信息
private Integer productId;
//评论人
private Integer customerId;
//评论内容
private String content;
//评论日期
private Date insertDate;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
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 Product  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String productName;
//图片1
private String productPic1;
//图片2
private String productPic2;
//图片3
private String productPic3;
//图片4
private String productPic4;
//价格
private Integer price;
//原价
private Integer oldPrice;
//内容
private String content;
//数量
private Integer nums;
//推荐星级
private String tjxj;
//状态
private String status;
//分类
private Integer typesId;
//积分
private Integer jf;
//商家
private Integer userId;
//标签
private Integer bqId;
//点击量
private Integer djl;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic1() {return productPic1;}
public void setProductPic1(String productPic1) {this.productPic1 = productPic1;}
public String getProductPic2() {return productPic2;}
public void setProductPic2(String productPic2) {this.productPic2 = productPic2;}
public String getProductPic3() {return productPic3;}
public void setProductPic3(String productPic3) {this.productPic3 = productPic3;}
public String getProductPic4() {return productPic4;}
public void setProductPic4(String productPic4) {this.productPic4 = productPic4;}
public Integer getPrice() {return price;}
public void setPrice(Integer price) {this.price = price;}
public Integer getOldPrice() {return oldPrice;}
public void setOldPrice(Integer oldPrice) {this.oldPrice = oldPrice;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Integer getNums() {return nums;}
public void setNums(Integer nums) {this.nums = nums;}
public String getTjxj() {return tjxj;}
public void setTjxj(String tjxj) {this.tjxj = tjxj;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public Integer getUserId() {return userId;}
public void setUserId(Integer userId) {this.userId = userId;}
public Integer getBqId() {return bqId;}
public void setBqId(Integer bqId) {this.bqId = bqId;}
public Integer getDjl() {return djl;}
public void setDjl(Integer djl) {this.djl = djl;}
}

投诉javaBean创建语句如下:


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

//投诉
public class Tousu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//联系人
private String contact;
//电话号码
private String tellphone;
//城市
private String city;
//内容
private String content;
//qq邮箱
private String qqemail;
public String getContact() {return contact;}
public void setContact(String contact) {this.contact = contact;}
public String getTellphone() {return tellphone;}
public void setTellphone(String tellphone) {this.tellphone = tellphone;}
public String getCity() {return city;}
public void setCity(String city) {this.city = city;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getQqemail() {return qqemail;}
public void setQqemail(String qqemail) {this.qqemail = qqemail;}
}

分类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 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;
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;}
}

新闻javaBean创建语句如下:


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

//新闻
public class Xinwen  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//新闻标题
private String title;
//新闻内容
private String content;
//添加时间
private Date showDate;
//作者
private String author;
//新闻类别
private Integer xinwenlbId;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
public String getAuthor() {return author;}
public void setAuthor(String author) {this.author = author;}
public Integer getXinwenlbId() {return xinwenlbId;}
public void setXinwenlbId(Integer xinwenlbId) {this.xinwenlbId = xinwenlbId;}
}

新闻类别javaBean创建语句如下:


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

//新闻类别
public class Xinwenlb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//类别
private String typename;
public String getTypename() {return typename;}
public void setTypename(String typename) {this.typename = typename;}
}

相关毕业设计源码

基于web的师生交流平台的设计与实现

基于web的师生交流平台的设计与实现,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

家教信息交流平台

家教信息交流平台,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

基于SSM师生交流平台作业管理系统

基于SSM师生交流平台作业管理系统,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

高中大学生交流平台的设计与实现

高中大学生交流平台的设计与实现,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

花卉欣赏交流平台

花卉欣赏交流平台,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

基于安卓的家校交流平台开发

基于安卓的家校交流平台开发,提供三种数据库:mysql,oracle,sqlserver,对应三种框架源码:springMVC/spring+springMVC+hibernate/spring+springMVC+mybatis,开发工具是myeclipse,提供基本增删改查,后台分页,图片上传,附件上传,富文本编辑器,时间选择器等功能。

评论