小型停车场管理系统(xfa47)_mysql_oracle代码分享

• 小型停车场管理系统mysql数据库创建语句
• 小型停车场管理系统oracle数据库创建语句
• 小型停车场管理系统sqlserver数据库创建语句
• 小型停车场管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 小型停车场管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计

小型停车场管理系统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_card(
	id int primary key auto_increment comment '主键',
	cardName varchar(100) comment '账号',
	customerId int comment '所属用户',
	cp varchar(100) comment '所属车牌',
	beginDate datetime comment '开始日期',
	endDate datetime comment '结束日期',
	status varchar(100) comment '状态'
) comment '停车卡';

客户表创建语句如下：

create table t_customer(
	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 '头像'
) comment '客户';

车位表创建语句如下：

create table t_cw(
	id int primary key auto_increment comment '主键',
	cwbh varchar(100) comment '车位编号',
	weizhi varchar(100) comment '位置',
	cp varchar(100) comment '当前车牌',
	status varchar(100) comment '状态'
) comment '车位';

进出记录表创建语句如下：

create table t_jilu(
	id int primary key auto_increment comment '主键',
	pic varchar(100) comment '照片',
	cp varchar(100) comment '车牌',
	insertDate datetime comment '发生日期',
	flag2 varchar(100) comment '进去还是出去',
	fee int comment '金额',
	paytype varchar(100) comment '支付方式',
	lx varchar(100) comment '类型 属于临时，还是包月',
	endDate datetime comment ''
) comment '进出记录';

留言表创建语句如下：

create table t_liuyan(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	content text comment '内容',
	insertDate datetime comment '日期',
	back text comment '回复',
	status varchar(100) comment '状态'
) comment '留言';

普通用户表创建语句如下：

create table t_ptadmin(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	ptadminName varchar(100) comment '姓名',
	phone varchar(100) comment '电话',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别'
) comment '普通用户';

资讯表创建语句如下：

create table t_zx(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	content varchar(100) comment '内容',
	pic varchar(100) comment '图片',
	showDate 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_card(
	id integer,
	cardName varchar(100),
	customerId int,
	cp varchar(100),
	beginDate datetime,
	endDate datetime,
	status varchar(100)
);
--停车卡字段加注释
comment on column t_card.id is '主键';
comment on column t_card.cardName is '账号';
comment on column t_card.customerId is '所属用户';
comment on column t_card.cp is '所属车牌';
comment on column t_card.beginDate is '开始日期';
comment on column t_card.endDate is '结束日期';
comment on column t_card.status is '状态';
--停车卡表加注释
comment on table t_card is '停车卡';

客户表创建语句如下：

create table t_customer(
	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)
);
--客户字段加注释
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.customerName is '姓名';
comment on column t_customer.sex is '性别';
comment on column t_customer.address is '地址';
comment on column t_customer.phone is '手机';
comment on column t_customer.account is '账户';
comment on column t_customer.jf is '积分';
comment on column t_customer.email is '邮箱';
comment on column t_customer.headPic is '头像';
--客户表加注释
comment on table t_customer is '客户';

车位表创建语句如下：

create table t_cw(
	id integer,
	cwbh varchar(100),
	weizhi varchar(100),
	cp varchar(100),
	status varchar(100)
);
--车位字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.cwbh is '车位编号';
comment on column t_cw.weizhi is '位置';
comment on column t_cw.cp is '当前车牌';
comment on column t_cw.status is '状态';
--车位表加注释
comment on table t_cw is '车位';

进出记录表创建语句如下：

create table t_jilu(
	id integer,
	pic varchar(100),
	cp varchar(100),
	insertDate datetime,
	flag2 varchar(100),
	fee int,
	paytype varchar(100),
	lx varchar(100),
	endDate datetime
);
--进出记录字段加注释
comment on column t_jilu.id is '主键';
comment on column t_jilu.pic is '照片';
comment on column t_jilu.cp is '车牌';
comment on column t_jilu.insertDate is '发生日期';
comment on column t_jilu.flag2 is '进去还是出去';
comment on column t_jilu.fee is '金额';
comment on column t_jilu.paytype is '支付方式';
comment on column t_jilu.lx is '类型 属于临时，还是包月';
comment on column t_jilu.endDate is '';
--进出记录表加注释
comment on table t_jilu is '进出记录';

留言表创建语句如下：

create table t_liuyan(
	id integer,
	customerId int,
	content text,
	insertDate datetime,
	back text,
	status varchar(100)
);
--留言字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.customerId is '用户';
comment on column t_liuyan.content is '内容';
comment on column t_liuyan.insertDate is '日期';
comment on column t_liuyan.back is '回复';
comment on column t_liuyan.status is '状态';
--留言表加注释
comment on table t_liuyan is '留言';

普通用户表创建语句如下：

create table t_ptadmin(
	id integer,
	username varchar(100),
	password varchar(100),
	ptadminName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100)
);
--普通用户字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
--普通用户表加注释
comment on table t_ptadmin is '普通用户';

资讯表创建语句如下：

create table t_zx(
	id integer,
	title varchar(100),
	content varchar(100),
	pic varchar(100),
	showDate varchar(100)
);
--资讯字段加注释
comment on column t_zx.id is '主键';
comment on column t_zx.title is '标题';
comment on column t_zx.content is '内容';
comment on column t_zx.pic is '图片';
comment on column t_zx.showDate is '';
--资讯表加注释
comment on table t_zx is '资讯';

oracle特有，对应序列如下：

create sequence s_t_card;
create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_jilu;
create sequence s_t_liuyan;
create sequence s_t_ptadmin;
create sequence s_t_zx;

小型停车场管理系统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_card(
	id int identity(1,1) primary key not null,--主键
	cardName varchar(100),--账号
	customerId int,--所属用户
	cp varchar(100),--所属车牌
	beginDate datetime,--开始日期
	endDate datetime,--结束日期
	status varchar(100)--状态
);

客户表创建语句如下：

--客户表注释
create table t_customer(
	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)--头像
);

车位表创建语句如下：

--车位表注释
create table t_cw(
	id int identity(1,1) primary key not null,--主键
	cwbh varchar(100),--车位编号
	weizhi varchar(100),--位置
	cp varchar(100),--当前车牌
	status varchar(100)--状态
);

进出记录表创建语句如下：

--进出记录表注释
create table t_jilu(
	id int identity(1,1) primary key not null,--主键
	pic varchar(100),--照片
	cp varchar(100),--车牌
	insertDate datetime,--发生日期
	flag2 varchar(100),--进去还是出去
	fee int,--金额
	paytype varchar(100),--支付方式
	lx varchar(100),--类型 属于临时，还是包月
	endDate datetime--
);

留言表创建语句如下：

--留言表注释
create table t_liuyan(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	content text,--内容
	insertDate datetime,--日期
	back text,--回复
	status varchar(100)--状态
);

普通用户表创建语句如下：

--普通用户表注释
create table t_ptadmin(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	ptadminName varchar(100),--姓名
	phone varchar(100),--电话
	age varchar(100),--年龄
	sex varchar(100)--性别
);

资讯表创建语句如下：

--资讯表注释
create table t_zx(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	content varchar(100),--内容
	pic varchar(100),--图片
	showDate 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_card")
public class Card {
//主键
@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 cardName;
//所属用户
private Integer customerId;
//所属车牌
private String cp;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//状态
private String status;
public String getCardName() {return cardName;}
public void setCardName(String cardName) {this.cardName = cardName;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
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_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 customerName;
//性别
private String sex;
//地址
private String address;
//手机
private String phone;
//账户
private Integer account;
//积分
private Integer jf;
//邮箱
private String email;
//头像
private String headPic;
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;}
}

车位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_cw")
public class Cw {
//主键
@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 cwbh;
//位置
private String weizhi;
//当前车牌
private String cp;
//状态
private String status;
public String getCwbh() {return cwbh;}
public void setCwbh(String cwbh) {this.cwbh = cwbh;}
public String getWeizhi() {return weizhi;}
public void setWeizhi(String weizhi) {this.weizhi = weizhi;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
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_jilu")
public class Jilu {
//主键
@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;
//车牌
private String cp;
//发生日期
private Date insertDate;
//进去还是出去
private String flag2;
//金额
private Integer fee;
//支付方式
private String paytype;
//类型 属于临时，还是包月
private String lx;
//
private Date endDate;
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getFlag2() {return flag2;}
public void setFlag2(String flag2) {this.flag2 = flag2;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getPaytype() {return paytype;}
public void setPaytype(String paytype) {this.paytype = paytype;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}

留言javaBean创建语句如下：

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

//留言
@Table(name = "t_liuyan")
public class Liuyan {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//内容
private String content;
//日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

普通用户javaBean创建语句如下：

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

//普通用户
@Table(name = "t_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}

资讯javaBean创建语句如下：

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

//资讯
@Table(name = "t_zx")
public class Zx {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String 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;}
}

小型停车场管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：

停车卡javaBean创建语句如下：

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

//停车卡
public class Card  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String cardName;
//所属用户
private Integer customerId;
//所属车牌
private String cp;
//开始日期
private Date beginDate;
//结束日期
private Date endDate;
//状态
private String status;
public String getCardName() {return cardName;}
public void setCardName(String cardName) {this.cardName = cardName;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
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 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 customerName;
//性别
private String sex;
//地址
private String address;
//手机
private String phone;
//账户
private Integer account;
//积分
private Integer jf;
//邮箱
private String email;
//头像
private String headPic;
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;}
}

车位javaBean创建语句如下：

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

//车位
public class Cw  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车位编号
private String cwbh;
//位置
private String weizhi;
//当前车牌
private String cp;
//状态
private String status;
public String getCwbh() {return cwbh;}
public void setCwbh(String cwbh) {this.cwbh = cwbh;}
public String getWeizhi() {return weizhi;}
public void setWeizhi(String weizhi) {this.weizhi = weizhi;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
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 Jilu  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//照片
private String pic;
//车牌
private String cp;
//发生日期
private Date insertDate;
//进去还是出去
private String flag2;
//金额
private Integer fee;
//支付方式
private String paytype;
//类型 属于临时，还是包月
private String lx;
//
private Date endDate;
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getFlag2() {return flag2;}
public void setFlag2(String flag2) {this.flag2 = flag2;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getPaytype() {return paytype;}
public void setPaytype(String paytype) {this.paytype = paytype;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}

留言javaBean创建语句如下：

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

//留言
public class Liuyan  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//内容
private String content;
//日期
private Date insertDate;
//回复
private String back;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

普通用户javaBean创建语句如下：

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

//普通用户
public class Ptadmin  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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
}

资讯javaBean创建语句如下：

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

//资讯
public class Zx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//内容
private String 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;}
}