- 基于jsp的养老院管理系统的设计与开发mysql数据库创建语句
- 基于jsp的养老院管理系统的设计与开发oracle数据库创建语句
- 基于jsp的养老院管理系统的设计与开发sqlserver数据库创建语句
- 基于jsp的养老院管理系统的设计与开发spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于jsp的养老院管理系统的设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于jsp的养老院管理系统的设计与开发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_bk(
id int primary key auto_increment comment '主键',
bkName varchar(100) comment '版块名称'
) comment '论坛版块';
报修表创建语句如下：
create table t_bx(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
bxName varchar(100) comment '报修标题',
content varchar(100) comment '内容',
pic varchar(100) comment '图片',
status varchar(100) comment '状态',
back varchar(100) comment '反馈'
) comment '报修';
用户表创建语句如下：
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 '入库日期',
headPic varchar(100) comment '头像',
level varchar(100) comment '层级',
isft varchar(100) comment '发帖权限',
ispl varchar(100) comment '评论权限',
mb1 varchar(100) comment '密保1',
mb2 varchar(100) comment '密保2',
mb3 varchar(100) comment '密保3'
) comment '用户';
宿舍打分表创建语句如下：
create table t_df(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
dfName varchar(100) comment '宿舍',
insertDate datetime comment '打分日期',
content varchar(100) comment '说明'
) comment '宿舍打分';
普通管理员表创建语句如下：
create table t_gly(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
glyName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话'
) comment '普通管理员';
缴费表创建语句如下：
create table t_jf(
id int primary key auto_increment comment '主键',
jsId int comment '家属',
jfName varchar(100) comment '缴费名称',
fee varchar(100) comment '缴费金额',
jfDate varchar(100) comment '缴费日期'
) comment '缴费';
家属表创建语句如下：
create table t_js(
id int primary key auto_increment comment '主键',
jsName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
ssId int comment '宿舍'
) comment '家属';
论坛说明表创建语句如下：
create table t_ltsm(
id int primary key auto_increment comment '主键',
title 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_ss(
id int primary key auto_increment comment '主键',
ssName varchar(100) comment '',
sscw 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 '我的消息';
基于jsp的养老院管理系统的设计与开发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_bk(
id integer,
bkName varchar(100)
);
--论坛版块字段加注释
comment on column t_bk.id is '主键';
comment on column t_bk.bkName is '版块名称';
--论坛版块表加注释
comment on table t_bk is '论坛版块';
报修表创建语句如下：
create table t_bx(
id integer,
customerId int,
bxName varchar(100),
content varchar(100),
pic varchar(100),
status varchar(100),
back varchar(100)
);
--报修字段加注释
comment on column t_bx.id is '主键';
comment on column t_bx.customerId is '用户';
comment on column t_bx.bxName is '报修标题';
comment on column t_bx.content is '内容';
comment on column t_bx.pic is '图片';
comment on column t_bx.status is '状态';
comment on column t_bx.back is '反馈';
--报修表加注释
comment on table t_bx 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,
headPic varchar(100),
level varchar(100),
isft varchar(100),
ispl varchar(100),
mb1 varchar(100),
mb2 varchar(100),
mb3 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.headPic is '头像';
comment on column t_customer.level is '层级';
comment on column t_customer.isft is '发帖权限';
comment on column t_customer.ispl is '评论权限';
comment on column t_customer.mb1 is '密保1';
comment on column t_customer.mb2 is '密保2';
comment on column t_customer.mb3 is '密保3';
--用户表加注释
comment on table t_customer is '用户';
宿舍打分表创建语句如下：
create table t_df(
id integer,
customerId int,
dfName varchar(100),
insertDate datetime,
content varchar(100)
);
--宿舍打分字段加注释
comment on column t_df.id is '主键';
comment on column t_df.customerId is '用户';
comment on column t_df.dfName is '宿舍';
comment on column t_df.insertDate is '打分日期';
comment on column t_df.content is '说明';
--宿舍打分表加注释
comment on table t_df is '宿舍打分';
普通管理员表创建语句如下：
create table t_gly(
id integer,
username varchar(100),
password varchar(100),
glyName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100)
);
--普通管理员字段加注释
comment on column t_gly.id is '主键';
comment on column t_gly.username is '账号';
comment on column t_gly.password is '密码';
comment on column t_gly.glyName is '姓名';
comment on column t_gly.age is '年龄';
comment on column t_gly.sex is '性别';
comment on column t_gly.phone is '电话';
--普通管理员表加注释
comment on table t_gly is '普通管理员';
缴费表创建语句如下：
create table t_jf(
id integer,
jsId int,
jfName varchar(100),
fee varchar(100),
jfDate varchar(100)
);
--缴费字段加注释
comment on column t_jf.id is '主键';
comment on column t_jf.jsId is '家属';
comment on column t_jf.jfName is '缴费名称';
comment on column t_jf.fee is '缴费金额';
comment on column t_jf.jfDate is '缴费日期';
--缴费表加注释
comment on table t_jf is '缴费';
家属表创建语句如下：
create table t_js(
id integer,
jsName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
ssId int
);
--家属字段加注释
comment on column t_js.id is '主键';
comment on column t_js.jsName is '姓名';
comment on column t_js.age is '年龄';
comment on column t_js.sex is '性别';
comment on column t_js.phone is '电话';
comment on column t_js.ssId is '宿舍';
--家属表加注释
comment on table t_js is '家属';
论坛说明表创建语句如下：
create table t_ltsm(
id integer,
title varchar(100)
);
--论坛说明字段加注释
comment on column t_ltsm.id is '主键';
comment on column t_ltsm.title is '论坛说明';
--论坛说明表加注释
comment on table t_ltsm 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_ss(
id integer,
ssName varchar(100),
sscw varchar(100)
);
--宿舍字段加注释
comment on column t_ss.id is '主键';
comment on column t_ss.ssName is '';
comment on column t_ss.sscw is '';
--宿舍表加注释
comment on table t_ss 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 '我的消息';
oracle特有，对应序列如下：
create sequence s_t_bk;
create sequence s_t_bx;
create sequence s_t_customer;
create sequence s_t_df;
create sequence s_t_gly;
create sequence s_t_jf;
create sequence s_t_js;
create sequence s_t_ltsm;
create sequence s_t_pinglun;
create sequence s_t_ss;
create sequence s_t_wdxx;
基于jsp的养老院管理系统的设计与开发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_bk(
id int identity(1,1) primary key not null,--主键
bkName varchar(100)--版块名称
);
报修表创建语句如下：
--报修表注释
create table t_bx(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
bxName varchar(100),--报修标题
content varchar(100),--内容
pic varchar(100),--图片
status varchar(100),--状态
back varchar(100)--反馈
);
用户表创建语句如下：
--用户表注释
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,--入库日期
headPic varchar(100),--头像
level varchar(100),--层级
isft varchar(100),--发帖权限
ispl varchar(100),--评论权限
mb1 varchar(100),--密保1
mb2 varchar(100),--密保2
mb3 varchar(100)--密保3
);
宿舍打分表创建语句如下：
--宿舍打分表注释
create table t_df(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
dfName varchar(100),--宿舍
insertDate datetime,--打分日期
content varchar(100)--说明
);
普通管理员表创建语句如下：
--普通管理员表注释
create table t_gly(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
glyName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100)--电话
);
缴费表创建语句如下：
--缴费表注释
create table t_jf(
id int identity(1,1) primary key not null,--主键
jsId int,--家属
jfName varchar(100),--缴费名称
fee varchar(100),--缴费金额
jfDate varchar(100)--缴费日期
);
家属表创建语句如下：
--家属表注释
create table t_js(
id int identity(1,1) primary key not null,--主键
jsName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
ssId int--宿舍
);
论坛说明表创建语句如下：
--论坛说明表注释
create table t_ltsm(
id int identity(1,1) primary key not null,--主键
title 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_ss(
id int identity(1,1) primary key not null,--主键
ssName varchar(100),--
sscw 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--
);
登录后主页.jpg?x-oss-process=style/00001)
基于jsp的养老院管理系统的设计与开发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_bk")
public class Bk {
//主键
@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 bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}报修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_bx")
public class Bx {
//主键
@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 bxName;
//内容
private String content;
//图片
private String pic;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getBxName() {return bxName;}
public void setBxName(String bxName) {this.bxName = bxName;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}用户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 headPic;
//层级
private String level;
//发帖权限
private String isft;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
}宿舍打分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_df")
public class Df {
//主键
@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 dfName;
//打分日期
private Date insertDate;
//说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDfName() {return dfName;}
public void setDfName(String dfName) {this.dfName = dfName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}普通管理员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_gly")
public class Gly {
//主键
@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 glyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getGlyName() {return glyName;}
public void setGlyName(String glyName) {this.glyName = glyName;}
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;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}缴费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_jf")
public class Jf {
//主键
@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 jsId;
//缴费名称
private String jfName;
//缴费金额
private String fee;
//缴费日期
private String jfDate;
public Integer getJsId() {return jsId;}
public void setJsId(Integer jsId) {this.jsId = jsId;}
public String getJfName() {return jfName;}
public void setJfName(String jfName) {this.jfName = jfName;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getJfDate() {return jfDate;}
public void setJfDate(String jfDate) {this.jfDate = jfDate;}
}家属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_js")
public class Js {
//主键
@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 jsName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//宿舍
private Integer ssId;
public String getJsName() {return jsName;}
public void setJsName(String jsName) {this.jsName = jsName;}
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;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
}论坛说明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_ltsm")
public class Ltsm {
//主键
@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;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}评论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_ss")
public class Ss {
//主键
@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 ssName;
//
private String sscw;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getSscw() {return sscw;}
public void setSscw(String sscw) {this.sscw = sscw;}
}我的消息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;}
}基于jsp的养老院管理系统的设计与开发spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
论坛版块javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//论坛版块
public class Bk extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//版块名称
private String bkName;
public String getBkName() {return bkName;}
public void setBkName(String bkName) {this.bkName = bkName;}
}报修javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//报修
public class Bx extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//报修标题
private String bxName;
//内容
private String content;
//图片
private String pic;
//状态
private String status;
//反馈
private String back;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getBxName() {return bxName;}
public void setBxName(String bxName) {this.bxName = bxName;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getBack() {return back;}
public void setBack(String back) {this.back = back;}
}用户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 headPic;
//层级
private String level;
//发帖权限
private String isft;
//评论权限
private String ispl;
//密保1
private String mb1;
//密保2
private String mb2;
//密保3
private String mb3;
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 getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getLevel() {return level;}
public void setLevel(String level) {this.level = level;}
public String getIsft() {return isft;}
public void setIsft(String isft) {this.isft = isft;}
public String getIspl() {return ispl;}
public void setIspl(String ispl) {this.ispl = ispl;}
public String getMb1() {return mb1;}
public void setMb1(String mb1) {this.mb1 = mb1;}
public String getMb2() {return mb2;}
public void setMb2(String mb2) {this.mb2 = mb2;}
public String getMb3() {return mb3;}
public void setMb3(String mb3) {this.mb3 = mb3;}
}宿舍打分javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//宿舍打分
public class Df extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//宿舍
private String dfName;
//打分日期
private Date insertDate;
//说明
private String content;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDfName() {return dfName;}
public void setDfName(String dfName) {this.dfName = dfName;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
}普通管理员javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//普通管理员
public class Gly 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 glyName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
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 getGlyName() {return glyName;}
public void setGlyName(String glyName) {this.glyName = glyName;}
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;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
}缴费javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//缴费
public class Jf extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//家属
private Integer jsId;
//缴费名称
private String jfName;
//缴费金额
private String fee;
//缴费日期
private String jfDate;
public Integer getJsId() {return jsId;}
public void setJsId(Integer jsId) {this.jsId = jsId;}
public String getJfName() {return jfName;}
public void setJfName(String jfName) {this.jfName = jfName;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
public String getJfDate() {return jfDate;}
public void setJfDate(String jfDate) {this.jfDate = jfDate;}
}家属javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//家属
public class Js extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String jsName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//宿舍
private Integer ssId;
public String getJsName() {return jsName;}
public void setJsName(String jsName) {this.jsName = jsName;}
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;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public Integer getSsId() {return ssId;}
public void setSsId(Integer ssId) {this.ssId = ssId;}
}论坛说明javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//论坛说明
public class Ltsm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//论坛说明
private String title;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
}评论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 Ss extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private String ssName;
//
private String sscw;
public String getSsName() {return ssName;}
public void setSsName(String ssName) {this.ssName = ssName;}
public String getSscw() {return sscw;}
public void setSscw(String sscw) {this.sscw = sscw;}
}我的消息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;}
}