**流浪猫狗救助系统**
有一点是 登陆的时候要分普通用户 和 救助站 救助站注册要通过平台认证 然后发布的信息救助站要有标记显示
流浪猫狗救助系统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_contact(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
phone varchar(100) comment '联系方式',
content varchar(100) comment '内容',
insertDate datetime 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 ''
) comment '用户';
救助站表创建语句如下：
create table t_jzz(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
jzzName varchar(100) comment '救助站名称',
address varchar(100) comment '地址',
jwd varchar(100) comment '经纬度',
fzr varchar(100) comment '负责人',
lxdh varchar(100) comment '联系电话',
pic varchar(100) comment '图片'
) comment '救助站';
表创建语句如下：
create table t_liuyan(
id int primary key auto_increment comment '主键',
customerId int comment '',
toId int comment '',
content varchar(100) comment '',
insertDate datetime comment '',
status varchar(100) comment '',
flag varchar(100) comment ''
) comment '';
领养表创建语句如下：
create table t_ly(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
mgId int comment '宠物',
insertDate datetime comment '领养日期',
status varchar(100) comment '状态'
) comment '领养';
猫狗表创建语句如下：
create table t_mg(
id int primary key auto_increment comment '主键',
jzzId int comment '救助站',
types varchar(100) comment '类型',
pz varchar(100) comment '品种',
nickName varchar(100) comment '昵称',
sex varchar(100) comment '性别',
xxsm varchar(100) comment '详细描述',
jzzd varchar(100) comment '救助地点',
jzsj varchar(100) comment '救助时间',
pic varchar(100) comment '图片',
status varchar(100) comment '状态'
) comment '猫狗';
评论表创建语句如下：
create table t_pinglun(
id int primary key auto_increment comment '主键',
wdxxId int comment '评论信息',
customerId int comment '评论人',
content varchar(100) comment '评论内容',
insertDate datetime comment '评论日期'
) comment '评论';
我的好友表创建语句如下：
create table t_wdhy(
id int primary key auto_increment comment '主键',
customerId int comment '我',
hhId int comment '好友',
insertDate datetime 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 '发布日期'
) comment '我的消息';
云养表创建语句如下：
create table t_yy(
id int primary key auto_increment comment '主键',
mgId int comment '猫狗',
customerId int comment '用户',
insertDate datetime comment '日期',
jg int 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_contact(
id integer,
customerId int,
phone varchar(100),
content varchar(100),
insertDate datetime
);
--建议字段加注释
comment on column t_contact.id is '主键';
comment on column t_contact.customerId is '用户';
comment on column t_contact.phone is '联系方式';
comment on column t_contact.content is '内容';
comment on column t_contact.insertDate is '日期';
--建议表加注释
comment on table t_contact 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)
);
--用户字段加注释
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 table t_customer is '用户';
救助站表创建语句如下：
create table t_jzz(
id integer,
username varchar(100),
password varchar(100),
jzzName varchar(100),
address varchar(100),
jwd varchar(100),
fzr varchar(100),
lxdh varchar(100),
pic varchar(100)
);
--救助站字段加注释
comment on column t_jzz.id is '主键';
comment on column t_jzz.username is '账号';
comment on column t_jzz.password is '密码';
comment on column t_jzz.jzzName is '救助站名称';
comment on column t_jzz.address is '地址';
comment on column t_jzz.jwd is '经纬度';
comment on column t_jzz.fzr is '负责人';
comment on column t_jzz.lxdh is '联系电话';
comment on column t_jzz.pic is '图片';
--救助站表加注释
comment on table t_jzz is '救助站';
表创建语句如下：
create table t_liuyan(
id integer,
customerId int,
toId int,
content varchar(100),
insertDate datetime,
status varchar(100),
flag varchar(100)
);
--字段加注释
comment on column t_liuyan.id is '主键';
comment on column t_liuyan.customerId is '';
comment on column t_liuyan.toId is '';
comment on column t_liuyan.content is '';
comment on column t_liuyan.insertDate is '';
comment on column t_liuyan.status is '';
comment on column t_liuyan.flag is '';
--表加注释
comment on table t_liuyan is '';
领养表创建语句如下：
create table t_ly(
id integer,
customerId int,
mgId int,
insertDate datetime,
status varchar(100)
);
--领养字段加注释
comment on column t_ly.id is '主键';
comment on column t_ly.customerId is '用户';
comment on column t_ly.mgId is '宠物';
comment on column t_ly.insertDate is '领养日期';
comment on column t_ly.status is '状态';
--领养表加注释
comment on table t_ly is '领养';
猫狗表创建语句如下：
create table t_mg(
id integer,
jzzId int,
types varchar(100),
pz varchar(100),
nickName varchar(100),
sex varchar(100),
xxsm varchar(100),
jzzd varchar(100),
jzsj varchar(100),
pic varchar(100),
status varchar(100)
);
--猫狗字段加注释
comment on column t_mg.id is '主键';
comment on column t_mg.jzzId is '救助站';
comment on column t_mg.types is '类型';
comment on column t_mg.pz is '品种';
comment on column t_mg.nickName is '昵称';
comment on column t_mg.sex is '性别';
comment on column t_mg.xxsm is '详细描述';
comment on column t_mg.jzzd is '救助地点';
comment on column t_mg.jzsj is '救助时间';
comment on column t_mg.pic is '图片';
comment on column t_mg.status is '状态';
--猫狗表加注释
comment on table t_mg 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_wdhy(
id integer,
customerId int,
hhId int,
insertDate datetime
);
--我的好友字段加注释
comment on column t_wdhy.id is '主键';
comment on column t_wdhy.customerId is '我';
comment on column t_wdhy.hhId is '好友';
comment on column t_wdhy.insertDate is '关注日期';
--我的好友表加注释
comment on table t_wdhy is '我的好友';
我的消息表创建语句如下：
create table t_wdxx(
id integer,
customerId int,
title varchar(100),
pic varchar(100),
content varchar(100),
zan int,
insertDate datetime
);
--我的消息字段加注释
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 table t_wdxx is '我的消息';
云养表创建语句如下：
create table t_yy(
id integer,
mgId int,
customerId int,
insertDate datetime,
jg int
);
--云养字段加注释
comment on column t_yy.id is '主键';
comment on column t_yy.mgId is '猫狗';
comment on column t_yy.customerId is '用户';
comment on column t_yy.insertDate is '日期';
comment on column t_yy.jg is '价格';
--云养表加注释
comment on table t_yy is '云养';
oracle特有，对应序列如下：
create sequence s_t_contact;
create sequence s_t_customer;
create sequence s_t_jzz;
create sequence s_t_liuyan;
create sequence s_t_ly;
create sequence s_t_mg;
create sequence s_t_pinglun;
create sequence s_t_wdhy;
create sequence s_t_wdxx;
create sequence s_t_yy;
流浪猫狗救助系统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_contact(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
phone varchar(100),--联系方式
content varchar(100),--内容
insertDate datetime--日期
);
用户表创建语句如下：
--用户表注释
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)--
);
救助站表创建语句如下：
--救助站表注释
create table t_jzz(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
jzzName varchar(100),--救助站名称
address varchar(100),--地址
jwd varchar(100),--经纬度
fzr varchar(100),--负责人
lxdh varchar(100),--联系电话
pic varchar(100)--图片
);
表创建语句如下：
--表注释
create table t_liuyan(
id int identity(1,1) primary key not null,--主键
customerId int,--
toId int,--
content varchar(100),--
insertDate datetime,--
status varchar(100),--
flag varchar(100)--
);
领养表创建语句如下：
--领养表注释
create table t_ly(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
mgId int,--宠物
insertDate datetime,--领养日期
status varchar(100)--状态
);
猫狗表创建语句如下：
--猫狗表注释
create table t_mg(
id int identity(1,1) primary key not null,--主键
jzzId int,--救助站
types varchar(100),--类型
pz varchar(100),--品种
nickName varchar(100),--昵称
sex varchar(100),--性别
xxsm varchar(100),--详细描述
jzzd varchar(100),--救助地点
jzsj varchar(100),--救助时间
pic varchar(100),--图片
status varchar(100)--状态
);
评论表创建语句如下：
--评论表注释
create table t_pinglun(
id int identity(1,1) primary key not null,--主键
wdxxId int,--评论信息
customerId int,--评论人
content varchar(100),--评论内容
insertDate datetime--评论日期
);
我的好友表创建语句如下：
--我的好友表注释
create table t_wdhy(
id int identity(1,1) primary key not null,--主键
customerId int,--我
hhId int,--好友
insertDate datetime--关注日期
);
我的消息表创建语句如下：
--我的消息表注释
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--发布日期
);
云养表创建语句如下：
--云养表注释
create table t_yy(
id int identity(1,1) primary key not null,--主键
mgId int,--猫狗
customerId int,--用户
insertDate datetime,--日期
jg int--价格
);
流浪猫狗救助系统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_contact")
public class Contact {
//主键
@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 phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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_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;
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;}
}救助站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_jzz")
public class Jzz {
//主键
@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 jzzName;
//地址
private String address;
//经纬度
private String jwd;
//负责人
private String fzr;
//联系电话
private String lxdh;
//图片
private String pic;
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 getJzzName() {return jzzName;}
public void setJzzName(String jzzName) {this.jzzName = jzzName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJwd() {return jwd;}
public void setJwd(String jwd) {this.jwd = jwd;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//
@Table(name = "t_liuyan")
public class Liuyan {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer customerId;
//
private Integer toId;
//
private String content;
//
private Date insertDate;
//
private String status;
//
private String flag;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getFlag() {return flag;}
public void setFlag(String flag) {this.flag = flag;}
}领养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_ly")
public class Ly {
//主键
@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 mgId;
//领养日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getMgId() {return mgId;}
public void setMgId(Integer mgId) {this.mgId = mgId;}
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;}
}猫狗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_mg")
public class Mg {
//主键
@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 jzzId;
//类型
private String types;
//品种
private String pz;
//昵称
private String nickName;
//性别
private String sex;
//详细描述
private String xxsm;
//救助地点
private String jzzd;
//救助时间
private String jzsj;
//图片
private String pic;
//状态
private String status;
public Integer getJzzId() {return jzzId;}
public void setJzzId(Integer jzzId) {this.jzzId = jzzId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public String getNickName() {return nickName;}
public void setNickName(String nickName) {this.nickName = nickName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXxsm() {return xxsm;}
public void setXxsm(String xxsm) {this.xxsm = xxsm;}
public String getJzzd() {return jzzd;}
public void setJzzd(String jzzd) {this.jzzd = jzzd;}
public String getJzsj() {return jzsj;}
public void setJzsj(String jzsj) {this.jzsj = jzsj;}
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;}
}评论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_wdhy")
public class Wdhy {
//主键
@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 hhId;
//关注日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHhId() {return hhId;}
public void setHhId(Integer hhId) {this.hhId = hhId;}
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_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;
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;}
}云养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_yy")
public class Yy {
//主键
@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 mgId;
//用户
private Integer customerId;
//日期
private Date insertDate;
//价格
private Integer jg;
public Integer getMgId() {return mgId;}
public void setMgId(Integer mgId) {this.mgId = mgId;}
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 Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
}
流浪猫狗救助系统spring springMVC mybatis框架对象(javaBean,pojo)设计：
建议javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//建议
public class Contact extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//联系方式
private String phone;
//内容
private String content;
//日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
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 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;
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;}
}救助站javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//救助站
public class Jzz 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 jzzName;
//地址
private String address;
//经纬度
private String jwd;
//负责人
private String fzr;
//联系电话
private String lxdh;
//图片
private String pic;
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 getJzzName() {return jzzName;}
public void setJzzName(String jzzName) {this.jzzName = jzzName;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getJwd() {return jwd;}
public void setJwd(String jwd) {this.jwd = jwd;}
public String getFzr() {return fzr;}
public void setFzr(String fzr) {this.fzr = fzr;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
}javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//
public class Liuyan extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//
private Integer customerId;
//
private Integer toId;
//
private String content;
//
private Date insertDate;
//
private String status;
//
private String flag;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getToId() {return toId;}
public void setToId(Integer toId) {this.toId = toId;}
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 getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getFlag() {return flag;}
public void setFlag(String flag) {this.flag = flag;}
}领养javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//领养
public class Ly extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//宠物
private Integer mgId;
//领养日期
private Date insertDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getMgId() {return mgId;}
public void setMgId(Integer mgId) {this.mgId = mgId;}
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;}
}猫狗javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//猫狗
public class Mg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//救助站
private Integer jzzId;
//类型
private String types;
//品种
private String pz;
//昵称
private String nickName;
//性别
private String sex;
//详细描述
private String xxsm;
//救助地点
private String jzzd;
//救助时间
private String jzsj;
//图片
private String pic;
//状态
private String status;
public Integer getJzzId() {return jzzId;}
public void setJzzId(Integer jzzId) {this.jzzId = jzzId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public String getPz() {return pz;}
public void setPz(String pz) {this.pz = pz;}
public String getNickName() {return nickName;}
public void setNickName(String nickName) {this.nickName = nickName;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getXxsm() {return xxsm;}
public void setXxsm(String xxsm) {this.xxsm = xxsm;}
public String getJzzd() {return jzzd;}
public void setJzzd(String jzzd) {this.jzzd = jzzd;}
public String getJzsj() {return jzsj;}
public void setJzsj(String jzsj) {this.jzsj = jzsj;}
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;}
}评论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 Wdhy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//我
private Integer customerId;
//好友
private Integer hhId;
//关注日期
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getHhId() {return hhId;}
public void setHhId(Integer hhId) {this.hhId = hhId;}
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 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;
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;}
}云养javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//云养
public class Yy extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//猫狗
private Integer mgId;
//用户
private Integer customerId;
//日期
private Date insertDate;
//价格
private Integer jg;
public Integer getMgId() {return mgId;}
public void setMgId(Integer mgId) {this.mgId = mgId;}
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 Integer getJg() {return jg;}
public void setJg(Integer jg) {this.jg = jg;}
} 
转播
