基于Android的弱电机房管理系统

 课题名称:基于Android的弱电机房管理系统 

具体专业:  通信工程(和毕设关系不大)
普通用户

1.普通用户注册登录(姓名,身份证号,单位,密码);

2.普通用户查询设备信息(输入设备号码查找)

3.普通用户申请门禁卡界面(姓名/单位/出入时间/进入原因),通过网络发送给管理人员

管理人员

1、首先通过用户级别的认证,管理员登录到管理界面。

2.管理员对新增设备具体信息的录入、删除(型号/厂家/放置位置)

3.管理员进行故障维修报备(故障设备号码,故障时间)、查询维修人员信息;

4.管理员对普通用户账号进行管理(增加,删除);

5.对普通用户的申请进行审核,分配门禁卡(接到申请后,分配一张门禁卡(数字区分))

基于Android的弱电机房管理系统登录注册界面

基于Android的弱电机房管理系统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 '姓名',
	sex varchar(100) comment '性别',
	address varchar(100) comment '地址',
	mobile varchar(100) comment '手机',
	sfz varchar(100) comment '身份证'
) comment '客户';

故障维修表创建语句如下:


create table t_gzwx(
	id int primary key auto_increment comment '主键',
	sbbh varchar(100) comment '设备编号',
	gzDate varchar(100) comment '故障时间',
	wxyName varchar(100) comment '维修员姓名',
	wxyphone varchar(100) comment '维修员联系电话',
	remark 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_mjk(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	dw varchar(100) comment '单位',
	showDate varchar(100) comment '出入时间',
	lxdh varchar(100) comment '最新联系电话',
	remark varchar(100) comment '进入原因',
	status varchar(100) comment '状态',
	km varchar(100) comment '门禁卡密'
) comment '门禁卡';

订单表创建语句如下:


create table t_order(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	productDetail varchar(100) comment '订单详细',
	allPrice varchar(100) comment '订单总价格',
	status varchar(100) comment '状态',
	orderNum varchar(100) comment '',
	pl varchar(100) comment '',
	insertDate datetime comment ''
) comment '订单';

产品表创建语句如下:


create table t_product(
	id int primary key auto_increment comment '主键',
	productName varchar(100) comment '产品名称',
	productPic varchar(100) comment '图片',
	price varchar(100) comment '价格',
	content varchar(100) comment '内容'
) comment '产品';

设备表创建语句如下:


create table t_sb(
	id int primary key auto_increment comment '主键',
	sbbh varchar(100) comment '设备编号',
	xh varchar(100) comment '型号',
	cj varchar(100) comment '厂家',
	wz varchar(100) comment '放置位置',
	pic varchar(100) comment '图片',
	remark varchar(100) comment '备注'
) comment '设备';

购物车表创建语句如下:


create table t_shopcar(
	id int primary key auto_increment comment '主键',
	productId int comment '产品',
	num int comment '数量',
	customerId int comment ''
) comment '购物车';

普通员工表创建语句如下:


create table t_user(
	id int primary key auto_increment comment '主键',
	username varchar(100) comment '账号',
	password varchar(100) comment '密码',
	name varchar(100) comment '姓名',
	gh varchar(100) comment '工号',
	mobile varchar(100) comment '手机'
) comment '普通员工';

基于Android的弱电机房管理系统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),
	sex varchar(100),
	address varchar(100),
	mobile varchar(100),
	sfz 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 column t_customer.sfz is '身份证';
--客户表加注释
comment on table t_customer is '客户';

故障维修表创建语句如下:


create table t_gzwx(
	id integer,
	sbbh varchar(100),
	gzDate varchar(100),
	wxyName varchar(100),
	wxyphone varchar(100),
	remark varchar(100)
);
--故障维修字段加注释
comment on column t_gzwx.id is '主键';
comment on column t_gzwx.sbbh is '设备编号';
comment on column t_gzwx.gzDate is '故障时间';
comment on column t_gzwx.wxyName is '维修员姓名';
comment on column t_gzwx.wxyphone is '维修员联系电话';
comment on column t_gzwx.remark is '具体维修内容';
--故障维修表加注释
comment on table t_gzwx 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_mjk(
	id integer,
	customerId int,
	dw varchar(100),
	showDate varchar(100),
	lxdh varchar(100),
	remark varchar(100),
	status varchar(100),
	km varchar(100)
);
--门禁卡字段加注释
comment on column t_mjk.id is '主键';
comment on column t_mjk.customerId is '用户';
comment on column t_mjk.dw is '单位';
comment on column t_mjk.showDate is '出入时间';
comment on column t_mjk.lxdh is '最新联系电话';
comment on column t_mjk.remark is '进入原因';
comment on column t_mjk.status is '状态';
comment on column t_mjk.km is '门禁卡密';
--门禁卡表加注释
comment on table t_mjk is '门禁卡';

订单表创建语句如下:


create table t_order(
	id integer,
	customerId int,
	productDetail varchar(100),
	allPrice varchar(100),
	status varchar(100),
	orderNum varchar(100),
	pl varchar(100),
	insertDate datetime
);
--订单字段加注释
comment on column t_order.id is '主键';
comment on column t_order.customerId is '用户';
comment on column t_order.productDetail is '订单详细';
comment on column t_order.allPrice is '订单总价格';
comment on column t_order.status is '状态';
comment on column t_order.orderNum is '';
comment on column t_order.pl is '';
comment on column t_order.insertDate is '';
--订单表加注释
comment on table t_order is '订单';

产品表创建语句如下:


create table t_product(
	id integer,
	productName varchar(100),
	productPic varchar(100),
	price varchar(100),
	content varchar(100)
);
--产品字段加注释
comment on column t_product.id is '主键';
comment on column t_product.productName is '产品名称';
comment on column t_product.productPic is '图片';
comment on column t_product.price is '价格';
comment on column t_product.content is '内容';
--产品表加注释
comment on table t_product is '产品';

设备表创建语句如下:


create table t_sb(
	id integer,
	sbbh varchar(100),
	xh varchar(100),
	cj varchar(100),
	wz varchar(100),
	pic varchar(100),
	remark varchar(100)
);
--设备字段加注释
comment on column t_sb.id is '主键';
comment on column t_sb.sbbh is '设备编号';
comment on column t_sb.xh is '型号';
comment on column t_sb.cj is '厂家';
comment on column t_sb.wz is '放置位置';
comment on column t_sb.pic is '图片';
comment on column t_sb.remark is '备注';
--设备表加注释
comment on table t_sb is '设备';

购物车表创建语句如下:


create table t_shopcar(
	id integer,
	productId int,
	num int,
	customerId int
);
--购物车字段加注释
comment on column t_shopcar.id is '主键';
comment on column t_shopcar.productId is '产品';
comment on column t_shopcar.num is '数量';
comment on column t_shopcar.customerId is '';
--购物车表加注释
comment on table t_shopcar is '购物车';

普通员工表创建语句如下:


create table t_user(
	id integer,
	username varchar(100),
	password varchar(100),
	name varchar(100),
	gh varchar(100),
	mobile varchar(100)
);
--普通员工字段加注释
comment on column t_user.id is '主键';
comment on column t_user.username is '账号';
comment on column t_user.password is '密码';
comment on column t_user.name is '姓名';
comment on column t_user.gh is '工号';
comment on column t_user.mobile is '手机';
--普通员工表加注释
comment on table t_user is '普通员工';

oracle特有,对应序列如下:


create sequence s_t_contact;
create sequence s_t_customer;
create sequence s_t_gzwx;
create sequence s_t_message;
create sequence s_t_mjk;
create sequence s_t_order;
create sequence s_t_product;
create sequence s_t_sb;
create sequence s_t_shopcar;
create sequence s_t_user;

基于Android的弱电机房管理系统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),--姓名
	sex varchar(100),--性别
	address varchar(100),--地址
	mobile varchar(100),--手机
	sfz varchar(100)--身份证
);

故障维修表创建语句如下:


--故障维修表注释
create table t_gzwx(
	id int identity(1,1) primary key not null,--主键
	sbbh varchar(100),--设备编号
	gzDate varchar(100),--故障时间
	wxyName varchar(100),--维修员姓名
	wxyphone varchar(100),--维修员联系电话
	remark 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_mjk(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	dw varchar(100),--单位
	showDate varchar(100),--出入时间
	lxdh varchar(100),--最新联系电话
	remark varchar(100),--进入原因
	status varchar(100),--状态
	km varchar(100)--门禁卡密
);

订单表创建语句如下:


--订单表注释
create table t_order(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	productDetail varchar(100),--订单详细
	allPrice varchar(100),--订单总价格
	status varchar(100),--状态
	orderNum varchar(100),--
	pl varchar(100),--
	insertDate datetime--
);

产品表创建语句如下:


--产品表注释
create table t_product(
	id int identity(1,1) primary key not null,--主键
	productName varchar(100),--产品名称
	productPic varchar(100),--图片
	price varchar(100),--价格
	content varchar(100)--内容
);

设备表创建语句如下:


--设备表注释
create table t_sb(
	id int identity(1,1) primary key not null,--主键
	sbbh varchar(100),--设备编号
	xh varchar(100),--型号
	cj varchar(100),--厂家
	wz varchar(100),--放置位置
	pic varchar(100),--图片
	remark varchar(100)--备注
);

购物车表创建语句如下:


--购物车表注释
create table t_shopcar(
	id int identity(1,1) primary key not null,--主键
	productId int,--产品
	num int,--数量
	customerId int--
);

普通员工表创建语句如下:


--普通员工表注释
create table t_user(
	id int identity(1,1) primary key not null,--主键
	username varchar(100),--账号
	password varchar(100),--密码
	name varchar(100),--姓名
	gh varchar(100),--工号
	mobile varchar(100)--手机
);

基于Android的弱电机房管理系统登录后主页

基于Android的弱电机房管理系统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 sex;
//地址
private String address;
//手机
private String mobile;
//身份证
private String sfz;
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;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}

故障维修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_gzwx")
public class Gzwx {
//主键
@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 sbbh;
//故障时间
private String gzDate;
//维修员姓名
private String wxyName;
//维修员联系电话
private String wxyphone;
//具体维修内容
private String remark;
public String getSbbh() {return sbbh;}
public void setSbbh(String sbbh) {this.sbbh = sbbh;}
public String getGzDate() {return gzDate;}
public void setGzDate(String gzDate) {this.gzDate = gzDate;}
public String getWxyName() {return wxyName;}
public void setWxyName(String wxyName) {this.wxyName = wxyName;}
public String getWxyphone() {return wxyphone;}
public void setWxyphone(String wxyphone) {this.wxyphone = wxyphone;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

信息交流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_mjk")
public class Mjk {
//主键
@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 dw;
//出入时间
private String showDate;
//最新联系电话
private String lxdh;
//进入原因
private String remark;
//状态
private String status;
//门禁卡密
private String km;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
}

订单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_order")
public class Order {
//主键
@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 productDetail;
//订单总价格
private String allPrice;
//状态
private String status;
//
private String orderNum;
//
private String pl;
//
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getProductDetail() {return productDetail;}
public void setProductDetail(String productDetail) {this.productDetail = productDetail;}
public String getAllPrice() {return allPrice;}
public void setAllPrice(String allPrice) {this.allPrice = allPrice;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public String getPl() {return pl;}
public void setPl(String pl) {this.pl = pl;}
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_product")
public class Product {
//主键
@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 productName;
//图片
private String productPic;
//价格
private String price;
//内容
private String content;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic() {return productPic;}
public void setProductPic(String productPic) {this.productPic = productPic;}
public String getPrice() {return price;}
public void setPrice(String price) {this.price = price;}
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_sb")
public class Sb {
//主键
@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 sbbh;
//型号
private String xh;
//厂家
private String cj;
//放置位置
private String wz;
//图片
private String pic;
//备注
private String remark;
public String getSbbh() {return sbbh;}
public void setSbbh(String sbbh) {this.sbbh = sbbh;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

购物车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_shopcar")
public class Shopcar {
//主键
@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 productId;
//数量
private Integer num;
//
private Integer customerId;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

普通员工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_user")
public class User {
//主键
@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 gh;
//手机
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}

基于Android的弱电机房管理系统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 sex;
//地址
private String address;
//手机
private String mobile;
//身份证
private String sfz;
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;}
public String getSfz() {return sfz;}
public void setSfz(String sfz) {this.sfz = sfz;}
}

故障维修javaBean创建语句如下:


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

//故障维修
public class Gzwx  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备编号
private String sbbh;
//故障时间
private String gzDate;
//维修员姓名
private String wxyName;
//维修员联系电话
private String wxyphone;
//具体维修内容
private String remark;
public String getSbbh() {return sbbh;}
public void setSbbh(String sbbh) {this.sbbh = sbbh;}
public String getGzDate() {return gzDate;}
public void setGzDate(String gzDate) {this.gzDate = gzDate;}
public String getWxyName() {return wxyName;}
public void setWxyName(String wxyName) {this.wxyName = wxyName;}
public String getWxyphone() {return wxyphone;}
public void setWxyphone(String wxyphone) {this.wxyphone = wxyphone;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

信息交流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 Mjk  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//单位
private String dw;
//出入时间
private String showDate;
//最新联系电话
private String lxdh;
//进入原因
private String remark;
//状态
private String status;
//门禁卡密
private String km;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getDw() {return dw;}
public void setDw(String dw) {this.dw = dw;}
public String getShowDate() {return showDate;}
public void setShowDate(String showDate) {this.showDate = showDate;}
public String getLxdh() {return lxdh;}
public void setLxdh(String lxdh) {this.lxdh = lxdh;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getKm() {return km;}
public void setKm(String km) {this.km = km;}
}

订单javaBean创建语句如下:


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

//订单
public class Order  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//订单详细
private String productDetail;
//订单总价格
private String allPrice;
//状态
private String status;
//
private String orderNum;
//
private String pl;
//
private Date insertDate;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getProductDetail() {return productDetail;}
public void setProductDetail(String productDetail) {this.productDetail = productDetail;}
public String getAllPrice() {return allPrice;}
public void setAllPrice(String allPrice) {this.allPrice = allPrice;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getOrderNum() {return orderNum;}
public void setOrderNum(String orderNum) {this.orderNum = orderNum;}
public String getPl() {return pl;}
public void setPl(String pl) {this.pl = pl;}
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 Product  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品名称
private String productName;
//图片
private String productPic;
//价格
private String price;
//内容
private String content;
public String getProductName() {return productName;}
public void setProductName(String productName) {this.productName = productName;}
public String getProductPic() {return productPic;}
public void setProductPic(String productPic) {this.productPic = productPic;}
public String getPrice() {return price;}
public void setPrice(String price) {this.price = price;}
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 Sb  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//设备编号
private String sbbh;
//型号
private String xh;
//厂家
private String cj;
//放置位置
private String wz;
//图片
private String pic;
//备注
private String remark;
public String getSbbh() {return sbbh;}
public void setSbbh(String sbbh) {this.sbbh = sbbh;}
public String getXh() {return xh;}
public void setXh(String xh) {this.xh = xh;}
public String getCj() {return cj;}
public void setCj(String cj) {this.cj = cj;}
public String getWz() {return wz;}
public void setWz(String wz) {this.wz = wz;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getRemark() {return remark;}
public void setRemark(String remark) {this.remark = remark;}
}

购物车javaBean创建语句如下:


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

//购物车
public class Shopcar  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//产品
private Integer productId;
//数量
private Integer num;
//
private Integer customerId;
public Integer getProductId() {return productId;}
public void setProductId(Integer productId) {this.productId = productId;}
public Integer getNum() {return num;}
public void setNum(Integer num) {this.num = num;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
}

普通员工javaBean创建语句如下:


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

//普通员工
public class User  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 gh;
//手机
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 getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public String getMobile() {return mobile;}
public void setMobile(String mobile) {this.mobile = mobile;}
}

源代码下载点这里

评论