- 基于WEB的校讯通系统的设计与实现mysql数据库创建语句
- 基于WEB的校讯通系统的设计与实现oracle数据库创建语句
- 基于WEB的校讯通系统的设计与实现sqlserver数据库创建语句
- 基于WEB的校讯通系统的设计与实现spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于WEB的校讯通系统的设计与实现spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于WEB的校讯通系统的设计与实现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 '入库日期',
level varchar(100) comment ''
) comment '家长';
电子课程表创建语句如下：
create table t_dzkc(
id int primary key auto_increment comment '主键',
dzkcName varchar(100) comment '课程标题',
v2 varchar(100) comment '图片',
v3 varchar(100) comment '分类',
v4 varchar(100) comment '供应商',
v5 int comment '库存数量'
) comment '电子课程';
购买表创建语句如下：
create table t_gm(
id int primary key auto_increment comment '主键',
dzkcId int comment '电子课程',
num int comment '数量',
customerId int comment '家长',
insertDate datetime comment '日期',
status varchar(100) comment '状态',
pingfen varchar(100) comment '评分'
) comment '购买';
学校活动表创建语句如下：
create table t_hd(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
pic varchar(100) comment '图片',
showDate varchar(100) comment '日期'
) comment '学校活动';
日志表创建语句如下：
create table t_log(
id int primary key auto_increment comment '主键',
v1 varchar(100) comment '用户',
v2 varchar(100) comment '操作类型',
insertDate datetime comment '操作日期'
) comment '日志';
校园资讯表创建语句如下：
create table t_xyzx(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
pic varchar(100) comment '图片',
showDate varchar(100) comment '日期'
) comment '校园资讯';
员工表创建语句如下：
create table t_yg(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ygName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
sex varchar(100) comment '性别',
age varchar(100) comment '年龄',
qx varchar(100) comment '权限'
) comment '员工';
咨询表创建语句如下：
create table t_zx(
id int primary key auto_increment comment '主键',
customerId int comment '家长',
content varchar(100) comment '问题',
answer varchar(100) comment '答案'
) comment '咨询';
基于WEB的校讯通系统的设计与实现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,
level 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.level is '';
--家长表加注释
comment on table t_customer is '家长';
电子课程表创建语句如下：
create table t_dzkc(
id integer,
dzkcName varchar(100),
v2 varchar(100),
v3 varchar(100),
v4 varchar(100),
v5 int
);
--电子课程字段加注释
comment on column t_dzkc.id is '主键';
comment on column t_dzkc.dzkcName is '课程标题';
comment on column t_dzkc.v2 is '图片';
comment on column t_dzkc.v3 is '分类';
comment on column t_dzkc.v4 is '供应商';
comment on column t_dzkc.v5 is '库存数量';
--电子课程表加注释
comment on table t_dzkc is '电子课程';
购买表创建语句如下：
create table t_gm(
id integer,
dzkcId int,
num int,
customerId int,
insertDate datetime,
status varchar(100),
pingfen varchar(100)
);
--购买字段加注释
comment on column t_gm.id is '主键';
comment on column t_gm.dzkcId is '电子课程';
comment on column t_gm.num is '数量';
comment on column t_gm.customerId is '家长';
comment on column t_gm.insertDate is '日期';
comment on column t_gm.status is '状态';
comment on column t_gm.pingfen is '评分';
--购买表加注释
comment on table t_gm is '购买';
学校活动表创建语句如下：
create table t_hd(
id integer,
title varchar(100),
content varchar(100),
pic varchar(100),
showDate varchar(100)
);
--学校活动字段加注释
comment on column t_hd.id is '主键';
comment on column t_hd.title is '标题';
comment on column t_hd.content is '内容';
comment on column t_hd.pic is '图片';
comment on column t_hd.showDate is '日期';
--学校活动表加注释
comment on table t_hd is '学校活动';
日志表创建语句如下：
create table t_log(
id integer,
v1 varchar(100),
v2 varchar(100),
insertDate datetime
);
--日志字段加注释
comment on column t_log.id is '主键';
comment on column t_log.v1 is '用户';
comment on column t_log.v2 is '操作类型';
comment on column t_log.insertDate is '操作日期';
--日志表加注释
comment on table t_log is '日志';
校园资讯表创建语句如下：
create table t_xyzx(
id integer,
title varchar(100),
content varchar(100),
pic varchar(100),
showDate varchar(100)
);
--校园资讯字段加注释
comment on column t_xyzx.id is '主键';
comment on column t_xyzx.title is '标题';
comment on column t_xyzx.content is '内容';
comment on column t_xyzx.pic is '图片';
comment on column t_xyzx.showDate is '日期';
--校园资讯表加注释
comment on table t_xyzx is '校园资讯';
员工表创建语句如下：
create table t_yg(
id integer,
username varchar(100),
password varchar(100),
ygName varchar(100),
phone varchar(100),
sex varchar(100),
age varchar(100),
qx varchar(100)
);
--员工字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.phone is '电话';
comment on column t_yg.sex is '性别';
comment on column t_yg.age is '年龄';
comment on column t_yg.qx is '权限';
--员工表加注释
comment on table t_yg is '员工';
咨询表创建语句如下：
create table t_zx(
id integer,
customerId int,
content varchar(100),
answer varchar(100)
);
--咨询字段加注释
comment on column t_zx.id is '主键';
comment on column t_zx.customerId is '家长';
comment on column t_zx.content is '问题';
comment on column t_zx.answer is '答案';
--咨询表加注释
comment on table t_zx is '咨询';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_dzkc;
create sequence s_t_gm;
create sequence s_t_hd;
create sequence s_t_log;
create sequence s_t_xyzx;
create sequence s_t_yg;
create sequence s_t_zx;
基于WEB的校讯通系统的设计与实现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,--入库日期
level varchar(100)--
);
电子课程表创建语句如下：
--电子课程表注释
create table t_dzkc(
id int identity(1,1) primary key not null,--主键
dzkcName varchar(100),--课程标题
v2 varchar(100),--图片
v3 varchar(100),--分类
v4 varchar(100),--供应商
v5 int--库存数量
);
购买表创建语句如下：
--购买表注释
create table t_gm(
id int identity(1,1) primary key not null,--主键
dzkcId int,--电子课程
num int,--数量
customerId int,--家长
insertDate datetime,--日期
status varchar(100),--状态
pingfen varchar(100)--评分
);
学校活动表创建语句如下：
--学校活动表注释
create table t_hd(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content varchar(100),--内容
pic varchar(100),--图片
showDate varchar(100)--日期
);
日志表创建语句如下：
--日志表注释
create table t_log(
id int identity(1,1) primary key not null,--主键
v1 varchar(100),--用户
v2 varchar(100),--操作类型
insertDate datetime--操作日期
);
校园资讯表创建语句如下：
--校园资讯表注释
create table t_xyzx(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
content varchar(100),--内容
pic varchar(100),--图片
showDate varchar(100)--日期
);
员工表创建语句如下：
--员工表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ygName varchar(100),--姓名
phone varchar(100),--电话
sex varchar(100),--性别
age varchar(100),--年龄
qx varchar(100)--权限
);
咨询表创建语句如下：
--咨询表注释
create table t_zx(
id int identity(1,1) primary key not null,--主键
customerId int,--家长
content varchar(100),--问题
answer varchar(100)--答案
);
登录后主页.jpg?x-oss-process=style/00001)
基于WEB的校讯通系统的设计与实现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 level;
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 getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
}电子课程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_dzkc")
public class Dzkc {
//主键
@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 dzkcName;
//图片
private String v2;
//分类
private String v3;
//供应商
private String v4;
//库存数量
private Integer v5;
public String getDzkcName() {return dzkcName;}
public void setDzkcName(String dzkcName) {this.dzkcName = dzkcName;}
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 Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
}购买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_gm")
public class Gm {
//主键
@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 dzkcId;
//数量
private Integer num;
//家长
private Integer customerId;
//日期
private Date insertDate;
//状态
private String status;
//评分
private String pingfen;
public Integer getDzkcId() {return dzkcId;}
public void setDzkcId(Integer dzkcId) {this.dzkcId = dzkcId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPingfen() {return pingfen;}
public void setPingfen(String pingfen) {this.pingfen = pingfen;}
}学校活动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_hd")
public class Hd {
//主键
@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 String pic;
//日期
private String showDate;
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}日志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_log")
public class Log {
//主键
@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 Date 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 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_xyzx")
public class Xyzx {
//主键
@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 String pic;
//日期
private String showDate;
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}员工javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//员工
@Table(name = "t_yg")
public class Yg {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String ygName;
//电话
private String phone;
//性别
private String sex;
//年龄
private String age;
//权限
private String qx;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}咨询javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//咨询
@Table(name = "t_zx")
public class Zx {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//家长
private Integer customerId;
//问题
private String content;
//答案
private String answer;
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 getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
}基于WEB的校讯通系统的设计与实现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 level;
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 getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
}电子课程javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//电子课程
public class Dzkc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//课程标题
private String dzkcName;
//图片
private String v2;
//分类
private String v3;
//供应商
private String v4;
//库存数量
private Integer v5;
public String getDzkcName() {return dzkcName;}
public void setDzkcName(String dzkcName) {this.dzkcName = dzkcName;}
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 Integer getV5() {return v5;}
public void setV5(Integer v5) {this.v5 = v5;}
}购买javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//购买
public class Gm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//电子课程
private Integer dzkcId;
//数量
private Integer num;
//家长
private Integer customerId;
//日期
private Date insertDate;
//状态
private String status;
//评分
private String pingfen;
public Integer getDzkcId() {return dzkcId;}
public void setDzkcId(Integer dzkcId) {this.dzkcId = dzkcId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getPingfen() {return pingfen;}
public void setPingfen(String pingfen) {this.pingfen = pingfen;}
}学校活动javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//学校活动
public class Hd 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 String pic;
//日期
private String showDate;
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}日志javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//日志
public class Log 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 Date 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 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 Xyzx 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 String pic;
//日期
private String showDate;
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 String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}员工javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//员工
public class Yg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String ygName;
//电话
private String phone;
//性别
private String sex;
//年龄
private String age;
//权限
private String qx;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getQx() {return qx;}
public void setQx(String qx) {this.qx = qx;}
}咨询javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//咨询
public class Zx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//家长
private Integer customerId;
//问题
private String content;
//答案
private String answer;
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 getAnswer() {return answer;}
public void setAnswer(String answer) {this.answer = answer;}
}