- 小区停车管理系统mysql数据库创建语句
- 小区停车管理系统oracle数据库创建语句
- 小区停车管理系统sqlserver数据库创建语句
- 小区停车管理系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 小区停车管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
小区停车管理系统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_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
headPic varchar(100) comment '头像',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
types varchar(100) comment '用户类型'
) comment '用户';
车位表创建语句如下：
create table t_cw(
id int primary key auto_increment comment '主键',
cwName varchar(100) comment '车位编号',
qw varchar(100) comment '区位',
status varchar(100) comment '状态',
mqcp varchar(100) comment '目前车牌'
) comment '车位';
物业公告表创建语句如下：
create table t_gonggao(
id int primary key auto_increment comment '主键',
title varchar(100) comment '标题',
pic varchar(100) comment '图片',
content varchar(100) comment '内容',
showDate datetime comment '日期'
) comment '物业公告';
ic卡表创建语句如下：
create table t_ick(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
ickName varchar(100) comment 'ic卡号',
cp varchar(100) comment '车牌',
fee varchar(100) comment '余额'
) comment 'ic卡';
进入记录表创建语句如下：
create table t_jilu(
id int primary key auto_increment comment '主键',
cp varchar(100) comment '车牌',
beginDate datetime comment '进入时间',
endDate datetime comment '出去时间'
) comment '进入记录';
通知表创建语句如下：
create table t_tongzhi(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
title varchar(100) comment '标题',
content varchar(100) comment '内容',
insertDate datetime 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_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
headPic varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100),
types varchar(100)
);
--用户字段加注释
comment on column t_customer.id is '主键';
comment on column t_customer.username is '账号';
comment on column t_customer.password is '密码';
comment on column t_customer.customerName is '姓名';
comment on column t_customer.headPic is '头像';
comment on column t_customer.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.types is '用户类型';
--用户表加注释
comment on table t_customer is '用户';
车位表创建语句如下：
create table t_cw(
id integer,
cwName varchar(100),
qw varchar(100),
status varchar(100),
mqcp varchar(100)
);
--车位字段加注释
comment on column t_cw.id is '主键';
comment on column t_cw.cwName is '车位编号';
comment on column t_cw.qw is '区位';
comment on column t_cw.status is '状态';
comment on column t_cw.mqcp is '目前车牌';
--车位表加注释
comment on table t_cw is '车位';
物业公告表创建语句如下：
create table t_gonggao(
id integer,
title varchar(100),
pic varchar(100),
content varchar(100),
showDate datetime
);
--物业公告字段加注释
comment on column t_gonggao.id is '主键';
comment on column t_gonggao.title is '标题';
comment on column t_gonggao.pic is '图片';
comment on column t_gonggao.content is '内容';
comment on column t_gonggao.showDate is '日期';
--物业公告表加注释
comment on table t_gonggao is '物业公告';
ic卡表创建语句如下：
create table t_ick(
id integer,
customerId int,
ickName varchar(100),
cp varchar(100),
fee varchar(100)
);
--ic卡字段加注释
comment on column t_ick.id is '主键';
comment on column t_ick.customerId is '用户';
comment on column t_ick.ickName is 'ic卡号';
comment on column t_ick.cp is '车牌';
comment on column t_ick.fee is '余额';
--ic卡表加注释
comment on table t_ick is 'ic卡';
进入记录表创建语句如下：
create table t_jilu(
id integer,
cp varchar(100),
beginDate datetime,
endDate datetime
);
--进入记录字段加注释
comment on column t_jilu.id is '主键';
comment on column t_jilu.cp is '车牌';
comment on column t_jilu.beginDate is '进入时间';
comment on column t_jilu.endDate is '出去时间';
--进入记录表加注释
comment on table t_jilu is '进入记录';
通知表创建语句如下：
create table t_tongzhi(
id integer,
customerId int,
title varchar(100),
content varchar(100),
insertDate datetime
);
--通知字段加注释
comment on column t_tongzhi.id is '主键';
comment on column t_tongzhi.customerId is '用户';
comment on column t_tongzhi.title is '标题';
comment on column t_tongzhi.content is '内容';
comment on column t_tongzhi.insertDate is '日期';
--通知表加注释
comment on table t_tongzhi is '通知';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_cw;
create sequence s_t_gonggao;
create sequence s_t_ick;
create sequence s_t_jilu;
create sequence s_t_tongzhi;
小区停车管理系统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_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
headPic varchar(100),--头像
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100),--性别
types varchar(100)--用户类型
);
车位表创建语句如下：
--车位表注释
create table t_cw(
id int identity(1,1) primary key not null,--主键
cwName varchar(100),--车位编号
qw varchar(100),--区位
status varchar(100),--状态
mqcp varchar(100)--目前车牌
);
物业公告表创建语句如下：
--物业公告表注释
create table t_gonggao(
id int identity(1,1) primary key not null,--主键
title varchar(100),--标题
pic varchar(100),--图片
content varchar(100),--内容
showDate datetime--日期
);
ic卡表创建语句如下：
--ic卡表注释
create table t_ick(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
ickName varchar(100),--ic卡号
cp varchar(100),--车牌
fee varchar(100)--余额
);
进入记录表创建语句如下：
--进入记录表注释
create table t_jilu(
id int identity(1,1) primary key not null,--主键
cp varchar(100),--车牌
beginDate datetime,--进入时间
endDate datetime--出去时间
);
通知表创建语句如下：
--通知表注释
create table t_tongzhi(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
title varchar(100),--标题
content varchar(100),--内容
insertDate datetime--日期
);
登录后主页.jpg?x-oss-process=style/00001)
小区停车管理系统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_customer")
public class Customer {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//用户类型
private String types;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}车位javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//车位
@Table(name = "t_cw")
public class Cw {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车位编号
private String cwName;
//区位
private String qw;
//状态
private String status;
//目前车牌
private String mqcp;
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getQw() {return qw;}
public void setQw(String qw) {this.qw = qw;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getMqcp() {return mqcp;}
public void setMqcp(String mqcp) {this.mqcp = mqcp;}
}物业公告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_gonggao")
public class Gonggao {
//主键
@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 Date 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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}ic卡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
//ic卡
@Table(name = "t_ick")
public class Ick {
//主键
@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;
//ic卡号
private String ickName;
//车牌
private String cp;
//余额
private String fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getIckName() {return ickName;}
public void setIckName(String ickName) {this.ickName = ickName;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
}进入记录javaBean创建语句如下：
package project.model;
import javax.persistence.Column;
import javax.persistence.Entity;
import javax.persistence.GeneratedValue;
import javax.persistence.GenerationType;
import javax.persistence.Id;
import javax.persistence.Table;
import java.util.Date;
@Entity
//进入记录
@Table(name = "t_jilu")
public class Jilu {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车牌
private String cp;
//进入时间
private Date beginDate;
//出去时间
private Date endDate;
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}通知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_tongzhi")
public class Tongzhi {
//主键
@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 content;
//日期
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}小区停车管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
用户javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Customer extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//账号
private String username;
//密码
private String password;
//姓名
private String customerName;
//头像
private String headPic;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
//用户类型
private String types;
public String getUsername() {return username;}
public void setUsername(String username) {this.username = username;}
public String getPassword() {return password;}
public void setPassword(String password) {this.password = password;}
public String getCustomerName() {return customerName;}
public void setCustomerName(String customerName) {this.customerName = customerName;}
public String getHeadPic() {return headPic;}
public void setHeadPic(String headPic) {this.headPic = headPic;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAge() {return age;}
public void setAge(String age) {this.age = age;}
public String getSex() {return sex;}
public void setSex(String sex) {this.sex = sex;}
public String getTypes() {return types;}
public void setTypes(String types) {this.types = types;}
}车位javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车位
public class Cw extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车位编号
private String cwName;
//区位
private String qw;
//状态
private String status;
//目前车牌
private String mqcp;
public String getCwName() {return cwName;}
public void setCwName(String cwName) {this.cwName = cwName;}
public String getQw() {return qw;}
public void setQw(String qw) {this.qw = qw;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getMqcp() {return mqcp;}
public void setMqcp(String mqcp) {this.mqcp = mqcp;}
}物业公告javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//物业公告
public class Gonggao 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 Date 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 Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}ic卡javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//ic卡
public class Ick extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//ic卡号
private String ickName;
//车牌
private String cp;
//余额
private String fee;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getIckName() {return ickName;}
public void setIckName(String ickName) {this.ickName = ickName;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public String getFee() {return fee;}
public void setFee(String fee) {this.fee = fee;}
}进入记录javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//进入记录
public class Jilu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车牌
private String cp;
//进入时间
private Date beginDate;
//出去时间
private Date endDate;
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public Date getBeginDate() {return beginDate;}
public void setBeginDate(Date beginDate) {this.beginDate = beginDate;}
public Date getEndDate() {return endDate;}
public void setEndDate(Date endDate) {this.endDate = endDate;}
}通知javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//通知
public class Tongzhi 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 content;
//日期
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 getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
}