小区物业管理app _部分源代码分享

• 小区物业管理appmysql数据库创建语句
• 小区物业管理apporacle数据库创建语句
• 小区物业管理appsqlserver数据库创建语句
• 小区物业管理appspring+springMVC+hibernate框架对象(javaBean,pojo)设计
• 小区物业管理appspring+springMVC+mybatis框架对象(javaBean,pojo)设计

小区物业管理appmysql数据库版本源码：

超级管理员表创建语句如下：

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_bx(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	bxlc varchar(100) comment '报修楼层',
	bxdw varchar(100) comment '报修单位',
	bxyy varchar(100) comment '报修原因',
	pic varchar(100) comment '图片',
	lxdh varchar(100) comment '联系电话',
	status varchar(100) comment '状态'
) comment '报修';

建议表创建语句如下：

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 '姓名',
	sex varchar(100) comment '性别',
	address varchar(100) comment '小区住址',
	mobile varchar(100) comment '手机'
) comment '客户';

公告表创建语句如下：

create table t_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate varchar(100) comment '日期'
) comment '公告';

信息交流表创建语句如下：

create table t_message(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	messageContent varchar(100) comment '内容',
	types int comment '',
	insertDate datetime comment '时间'
) comment '信息交流';

水电费表创建语句如下：

create table t_sdf(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	types varchar(100) comment '类型',
	fee int comment '费用',
	yf varchar(100) comment '月份',
	status varchar(100) comment '状态'
) comment '水电费';

投诉表创建语句如下：

create table t_ts(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	tsName varchar(100) comment '投诉说明',
	content varchar(100) comment '详细说明',
	status varchar(100) comment '状态'
) comment '投诉';

小区物业管理apporacle数据库版本源码：

超级管理员表创建语句如下：

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_bx(
	id integer,
	customerId int,
	bxlc varchar(100),
	bxdw varchar(100),
	bxyy varchar(100),
	pic varchar(100),
	lxdh varchar(100),
	status varchar(100)
);
--报修字段加注释
comment on column t_bx.id is '主键';
comment on column t_bx.customerId is '用户';
comment on column t_bx.bxlc is '报修楼层';
comment on column t_bx.bxdw is '报修单位';
comment on column t_bx.bxyy is '报修原因';
comment on column t_bx.pic is '图片';
comment on column t_bx.lxdh is '联系电话';
comment on column t_bx.status is '状态';
--报修表加注释
comment on table t_bx 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),
	sex varchar(100),
	address varchar(100),
	mobile 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.sex is '性别';
comment on column t_customer.address is '小区住址';
comment on column t_customer.mobile is '手机';
--客户表加注释
comment on table t_customer is '客户';

公告表创建语句如下：

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

信息交流表创建语句如下：

create table t_message(
	id integer,
	customerId int,
	messageContent varchar(100),
	types int,
	insertDate datetime
);
--信息交流字段加注释
comment on column t_message.id is '主键';
comment on column t_message.customerId is '用户';
comment on column t_message.messageContent is '内容';
comment on column t_message.types is '';
comment on column t_message.insertDate is '时间';
--信息交流表加注释
comment on table t_message is '信息交流';

水电费表创建语句如下：

create table t_sdf(
	id integer,
	customerId int,
	types varchar(100),
	fee int,
	yf varchar(100),
	status varchar(100)
);
--水电费字段加注释
comment on column t_sdf.id is '主键';
comment on column t_sdf.customerId is '用户';
comment on column t_sdf.types is '类型';
comment on column t_sdf.fee is '费用';
comment on column t_sdf.yf is '月份';
comment on column t_sdf.status is '状态';
--水电费表加注释
comment on table t_sdf is '水电费';

投诉表创建语句如下：

create table t_ts(
	id integer,
	customerId int,
	tsName varchar(100),
	content varchar(100),
	status varchar(100)
);
--投诉字段加注释
comment on column t_ts.id is '主键';
comment on column t_ts.customerId is '用户';
comment on column t_ts.tsName is '投诉说明';
comment on column t_ts.content is '详细说明';
comment on column t_ts.status is '状态';
--投诉表加注释
comment on table t_ts is '投诉';

oracle特有，对应序列如下：

create sequence s_t_bx;
create sequence s_t_contact;
create sequence s_t_customer;
create sequence s_t_gg;
create sequence s_t_message;
create sequence s_t_sdf;
create sequence s_t_ts;

小区物业管理appsqlserver数据库版本源码：

超级管理员表创建语句如下：

--超级管理员
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_bx(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	bxlc varchar(100),--报修楼层
	bxdw varchar(100),--报修单位
	bxyy varchar(100),--报修原因
	pic varchar(100),--图片
	lxdh varchar(100),--联系电话
	status varchar(100)--状态
);

建议表创建语句如下：

--建议表注释
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),--姓名
	sex varchar(100),--性别
	address varchar(100),--小区住址
	mobile varchar(100)--手机
);

公告表创建语句如下：

--公告表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate varchar(100)--日期
);

信息交流表创建语句如下：

--信息交流表注释
create table t_message(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	messageContent varchar(100),--内容
	types int,--
	insertDate datetime--时间
);

水电费表创建语句如下：

--水电费表注释
create table t_sdf(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	types varchar(100),--类型
	fee int,--费用
	yf varchar(100),--月份
	status varchar(100)--状态
);

投诉表创建语句如下：

--投诉表注释
create table t_ts(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	tsName varchar(100),--投诉说明
	content varchar(100),--详细说明
	status varchar(100)--状态
);

小区物业管理appspring+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_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 bxlc;
//报修单位
private String bxdw;
//报修原因
private String bxyy;
//图片
private String pic;
//联系电话
private String lxdh;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getBxlc() {return bxlc;}
public void setBxlc(String bxlc) {this.bxlc = bxlc;}
public String getBxdw() {return bxdw;}
public void setBxdw(String bxdw) {this.bxdw = bxdw;}
public String getBxyy() {return bxyy;}
public void setBxyy(String bxyy) {this.bxyy = bxyy;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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_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 sex;
//小区住址
private String address;
//手机
private String mobile;
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 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 getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}

公告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_gg")
public class Gg {
//主键
@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 pic;
//内容
private String content;
//日期
private String showDate;
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 String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

信息交流javaBean创建语句如下：

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

//信息交流
@Table(name = "t_message")
public class Message {
//主键
@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 messageContent;
//
private Integer types;
//时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMessageContent() {return messageContent;}
public void setMessageContent(String messageContent) {this.messageContent = messageContent;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
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_sdf")
public class Sdf {
//主键
@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 types;
//费用
private Integer fee;
//月份
private String yf;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
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_ts")
public class Ts {
//主键
@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 tsName;
//详细说明
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTsName() {return tsName;}
public void setTsName(String tsName) {this.tsName = tsName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}

小区物业管理appspring+springMVC+mybatis框架对象(javaBean,pojo)设计：

报修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 bxlc;
//报修单位
private String bxdw;
//报修原因
private String bxyy;
//图片
private String pic;
//联系电话
private String lxdh;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getBxlc() {return bxlc;}
public void setBxlc(String bxlc) {this.bxlc = bxlc;}
public String getBxdw() {return bxdw;}
public void setBxdw(String bxdw) {this.bxdw = bxdw;}
public String getBxyy() {return bxyy;}
public void setBxyy(String bxyy) {this.bxyy = bxyy;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
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 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 sex;
//小区住址
private String address;
//手机
private String mobile;
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 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 getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}

公告javaBean创建语句如下：

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

//公告
public class Gg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private String showDate;
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 String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
}

信息交流javaBean创建语句如下：

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

//信息交流
public class Message  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//内容
private String messageContent;
//
private Integer types;
//时间
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getMessageContent() {return messageContent;}
public void setMessageContent(String messageContent) {this.messageContent = messageContent;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
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 Sdf  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//类型
private String types;
//费用
private Integer fee;
//月份
private String yf;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
public String getYf() {return yf;}
public void setYf(String yf) {this.yf = yf;}
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 Ts  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//投诉说明
private String tsName;
//详细说明
private String content;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getTsName() {return tsName;}
public void setTsName(String tsName) {this.tsName = tsName;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
}