- 学生分流系统开发mysql数据库创建语句
- 学生分流系统开发oracle数据库创建语句
- 学生分流系统开发sqlserver数据库创建语句
- 学生分流系统开发spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 学生分流系统开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
学生分流系统开发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_dalei(
id int primary key auto_increment comment '主键',
typesName varchar(100) comment '大类名称'
) comment '大类';
表创建语句如下：
create table t_daoru(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '',
v2 varchar(100) comment '',
v3 varchar(100) comment '',
v4 varchar(100) comment '',
v5 varchar(100) comment '',
v6 varchar(100) comment '',
v7 varchar(100) comment '',
v8 varchar(100) comment '',
v9 varchar(100) comment '',
v10 varchar(100) comment '',
a1 int comment '',
a2 int comment '',
a3 int comment '',
a4 int comment '',
a5 int comment '',
a6 int comment '',
a7 int comment ''
) comment '';
学生表创建语句如下：
create table t_student(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
sex varchar(100) comment '性别',
address varchar(100) comment '地址',
phone varchar(100) comment '手机',
account int comment '',
jf int comment '',
email varchar(100) comment '邮箱',
headPic varchar(100) comment '头像',
typesId int comment '',
productId int comment '',
isdj int comment '是否得奖',
jd int comment ''
) comment '学生';
小类表创建语句如下：
create table t_xiaolei(
id int primary key auto_increment comment '主键',
productName varchar(100) comment '产品名称',
price int comment '价格',
typesId int comment '分类',
jf int comment '积分'
) comment '小类';
志愿表创建语句如下：
create table t_zhiyuan(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
v1 int comment '',
v2 int comment '',
v3 int comment '',
v4 int comment ''
) comment '志愿';
评分表创建语句如下：
create table t_zuoye(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
content varchar(100) comment '说明',
fileUrl varchar(100) comment '附件',
insertDate datetime comment '日期',
back varchar(100) comment '回复',
pf int comment '评分',
status 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_dalei(
id integer,
typesName varchar(100)
);
--大类字段加注释
comment on column t_dalei.id is '主键';
comment on column t_dalei.typesName is '大类名称';
--大类表加注释
comment on table t_dalei is '大类';
表创建语句如下：
create table t_daoru(
id integer,
v1 varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 varchar(100),
v6 varchar(100),
v7 varchar(100),
v8 varchar(100),
v9 varchar(100),
v10 varchar(100),
a1 int,
a2 int,
a3 int,
a4 int,
a5 int,
a6 int,
a7 int
);
--字段加注释
comment on column t_daoru.id is '主键';
comment on column t_daoru.v1 is '';
comment on column t_daoru.v2 is '';
comment on column t_daoru.v3 is '';
comment on column t_daoru.v4 is '';
comment on column t_daoru.v5 is '';
comment on column t_daoru.v6 is '';
comment on column t_daoru.v7 is '';
comment on column t_daoru.v8 is '';
comment on column t_daoru.v9 is '';
comment on column t_daoru.v10 is '';
comment on column t_daoru.a1 is '';
comment on column t_daoru.a2 is '';
comment on column t_daoru.a3 is '';
comment on column t_daoru.a4 is '';
comment on column t_daoru.a5 is '';
comment on column t_daoru.a6 is '';
comment on column t_daoru.a7 is '';
--表加注释
comment on table t_daoru is '';
学生表创建语句如下：
create table t_student(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
sex varchar(100),
address varchar(100),
phone varchar(100),
account int,
jf int,
email varchar(100),
headPic varchar(100),
typesId int,
productId int,
isdj int,
jd int
);
--学生字段加注释
comment on column t_student.id is '主键';
comment on column t_student.username is '账号';
comment on column t_student.password is '密码';
comment on column t_student.customerName is '姓名';
comment on column t_student.sex is '性别';
comment on column t_student.address is '地址';
comment on column t_student.phone is '手机';
comment on column t_student.account is '';
comment on column t_student.jf is '';
comment on column t_student.email is '邮箱';
comment on column t_student.headPic is '头像';
comment on column t_student.typesId is '';
comment on column t_student.productId is '';
comment on column t_student.isdj is '是否得奖';
comment on column t_student.jd is '';
--学生表加注释
comment on table t_student is '学生';
小类表创建语句如下：
create table t_xiaolei(
id integer,
productName varchar(100),
price int,
typesId int,
jf int
);
--小类字段加注释
comment on column t_xiaolei.id is '主键';
comment on column t_xiaolei.productName is '产品名称';
comment on column t_xiaolei.price is '价格';
comment on column t_xiaolei.typesId is '分类';
comment on column t_xiaolei.jf is '积分';
--小类表加注释
comment on table t_xiaolei is '小类';
志愿表创建语句如下：
create table t_zhiyuan(
id integer,
customerId int,
v1 int,
v2 int,
v3 int,
v4 int
);
--志愿字段加注释
comment on column t_zhiyuan.id is '主键';
comment on column t_zhiyuan.customerId is '用户';
comment on column t_zhiyuan.v1 is '';
comment on column t_zhiyuan.v2 is '';
comment on column t_zhiyuan.v3 is '';
comment on column t_zhiyuan.v4 is '';
--志愿表加注释
comment on table t_zhiyuan is '志愿';
评分表创建语句如下：
create table t_zuoye(
id integer,
customerId int,
content varchar(100),
fileUrl varchar(100),
insertDate datetime,
back varchar(100),
pf int,
status varchar(100)
);
--评分字段加注释
comment on column t_zuoye.id is '主键';
comment on column t_zuoye.customerId is '用户';
comment on column t_zuoye.content is '说明';
comment on column t_zuoye.fileUrl is '附件';
comment on column t_zuoye.insertDate is '日期';
comment on column t_zuoye.back is '回复';
comment on column t_zuoye.pf is '评分';
comment on column t_zuoye.status is '状态';
--评分表加注释
comment on table t_zuoye is '评分';
oracle特有，对应序列如下：
create sequence s_t_dalei;
create sequence s_t_daoru;
create sequence s_t_student;
create sequence s_t_xiaolei;
create sequence s_t_zhiyuan;
create sequence s_t_zuoye;
学生分流系统开发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_dalei(
id int identity(1,1) primary key not null,--主键
typesName varchar(100)--大类名称
);
表创建语句如下：
--表注释
create table t_daoru(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--
v2 varchar(100),--
v3 varchar(100),--
v4 varchar(100),--
v5 varchar(100),--
v6 varchar(100),--
v7 varchar(100),--
v8 varchar(100),--
v9 varchar(100),--
v10 varchar(100),--
a1 int,--
a2 int,--
a3 int,--
a4 int,--
a5 int,--
a6 int,--
a7 int--
);
学生表创建语句如下：
--学生表注释
create table t_student(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
sex varchar(100),--性别
address varchar(100),--地址
phone varchar(100),--手机
account int,--
jf int,--
email varchar(100),--邮箱
headPic varchar(100),--头像
typesId int,--
productId int,--
isdj int,--是否得奖
jd int--
);
小类表创建语句如下：
--小类表注释
create table t_xiaolei(
id int identity(1,1) primary key not null,--主键
productName varchar(100),--产品名称
price int,--价格
typesId int,--分类
jf int--积分
);
志愿表创建语句如下：
--志愿表注释
create table t_zhiyuan(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
v1 int,--
v2 int,--
v3 int,--
v4 int--
);
评分表创建语句如下：
--评分表注释
create table t_zuoye(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
content varchar(100),--说明
fileUrl varchar(100),--附件
insertDate datetime,--日期
back varchar(100),--回复
pf int,--评分
status varchar(100)--状态
);
登录后主页.jpg?x-oss-process=style/00001)
学生分流系统开发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_dalei")
public class Dalei {
//主键
@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_daoru")
public class Daoru {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String v1;
//
private String v2;
//
private String v3;
//
private String v4;
//
private String v5;
//
private String v6;
//
private String v7;
//
private String v8;
//
private String v9;
//
private String v10;
//
private Integer a1;
//
private Integer a2;
//
private Integer a3;
//
private Integer a4;
//
private Integer a5;
//
private Integer a6;
//
private Integer a7;
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;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
public Integer getA1() {return a1;}
public void setA1(Integer a1) {this.a1 = a1;}
public Integer getA2() {return a2;}
public void setA2(Integer a2) {this.a2 = a2;}
public Integer getA3() {return a3;}
public void setA3(Integer a3) {this.a3 = a3;}
public Integer getA4() {return a4;}
public void setA4(Integer a4) {this.a4 = a4;}
public Integer getA5() {return a5;}
public void setA5(Integer a5) {this.a5 = a5;}
public Integer getA6() {return a6;}
public void setA6(Integer a6) {this.a6 = a6;}
public Integer getA7() {return a7;}
public void setA7(Integer a7) {this.a7 = a7;}
}学生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_student")
public class Student {
//主键
@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 customerName;
//性别
private String sex;
//地址
private String address;
//手机
private String phone;
//
private Integer account;
//
private Integer jf;
//邮箱
private String email;
//头像
private String headPic;
//
private Integer typesId;
//
private Integer productId;
//是否得奖
private Integer isdj;
//
private Integer jd;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getAccount() {return account;}
public void setAccount(Integer account) {this.account = account;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public Integer getIsdj() {return isdj;}
public void setIsdj(Integer isdj) {this.isdj = isdj;}
public Integer getJd() {return jd;}
public void setJd(Integer jd) {this.jd = jd;}
}小类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_xiaolei")
public class Xiaolei {
//主键
@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;
//价格
private Integer price;
//分类
private Integer typesId;
//积分
private Integer jf;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public Integer getPrice() {return price;}
public void setPrice(Integer price) {this.price = price;}
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;}
}志愿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_zhiyuan")
public class Zhiyuan {
//主键
@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 v1;
//
private Integer v2;
//
private Integer v3;
//
private Integer v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer 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_zuoye")
public class Zuoye {
//主键
@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 String fileUrl;
//日期
private Date insertDate;
//回复
private String back;
//评分
private Integer pf;
//状态
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}学生分流系统开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
大类javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//大类
public class Dalei 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 Daoru extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String v1;
//
private String v2;
//
private String v3;
//
private String v4;
//
private String v5;
//
private String v6;
//
private String v7;
//
private String v8;
//
private String v9;
//
private String v10;
//
private Integer a1;
//
private Integer a2;
//
private Integer a3;
//
private Integer a4;
//
private Integer a5;
//
private Integer a6;
//
private Integer a7;
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;}
public String getV5() {return v5;}
public void setV5(String v5) {this.v5 = v5;}
public String getV6() {return v6;}
public void setV6(String v6) {this.v6 = v6;}
public String getV7() {return v7;}
public void setV7(String v7) {this.v7 = v7;}
public String getV8() {return v8;}
public void setV8(String v8) {this.v8 = v8;}
public String getV9() {return v9;}
public void setV9(String v9) {this.v9 = v9;}
public String getV10() {return v10;}
public void setV10(String v10) {this.v10 = v10;}
public Integer getA1() {return a1;}
public void setA1(Integer a1) {this.a1 = a1;}
public Integer getA2() {return a2;}
public void setA2(Integer a2) {this.a2 = a2;}
public Integer getA3() {return a3;}
public void setA3(Integer a3) {this.a3 = a3;}
public Integer getA4() {return a4;}
public void setA4(Integer a4) {this.a4 = a4;}
public Integer getA5() {return a5;}
public void setA5(Integer a5) {this.a5 = a5;}
public Integer getA6() {return a6;}
public void setA6(Integer a6) {this.a6 = a6;}
public Integer getA7() {return a7;}
public void setA7(Integer a7) {this.a7 = a7;}
}学生javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学生
public class Student 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 customerName;
//性别
private String sex;
//地址
private String address;
//手机
private String phone;
//
private Integer account;
//
private Integer jf;
//邮箱
private String email;
//头像
private String headPic;
//
private Integer typesId;
//
private Integer productId;
//是否得奖
private Integer isdj;
//
private Integer jd;
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 getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getAccount() {return account;}
public void setAccount(Integer account) {this.account = account;}
public Integer getJf() {return jf;}
public void setJf(Integer jf) {this.jf = jf;}
public String getEmail() {return email;}
public void setEmail(String email) {this.email = email;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public Integer getIsdj() {return isdj;}
public void setIsdj(Integer isdj) {this.isdj = isdj;}
public Integer getJd() {return jd;}
public void setJd(Integer jd) {this.jd = jd;}
}小类javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//小类
public class Xiaolei extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String productName;
//价格
private Integer price;
//分类
private Integer typesId;
//积分
private Integer jf;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public Integer getPrice() {return price;}
public void setPrice(Integer price) {this.price = price;}
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;}
}志愿javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//志愿
public class Zhiyuan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//
private Integer v1;
//
private Integer v2;
//
private Integer v3;
//
private Integer v4;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getV1() {return v1;}
public void setV1(Integer v1) {this.v1 = v1;}
public Integer getV2() {return v2;}
public void setV2(Integer v2) {this.v2 = v2;}
public Integer getV3() {return v3;}
public void setV3(Integer v3) {this.v3 = v3;}
public Integer getV4() {return v4;}
public void setV4(Integer v4) {this.v4 = v4;}
}评分javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//评分
public class Zuoye 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 String fileUrl;
//日期
private Date insertDate;
//回复
private String back;
//评分
private Integer pf;
//状态
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 String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
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 Integer getPf() {return pf;}
public void setPf(Integer pf) {this.pf = pf;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}