- 住宅小区车辆管理系统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_cheliangjc(
id int primary key auto_increment comment '主键',
cheweiName varchar(100) comment '车位编号',
cp varchar(100) comment '车牌',
lx varchar(100) comment '用户类型',
beginDate datetime comment '进入时间',
endDate datetime comment '出去时间',
status varchar(100) comment '状态',
xiaoshi int comment '总小时',
fy int comment '费用'
) comment '车辆进出';
车位表创建语句如下：
create table t_chewei(
id int primary key auto_increment comment '主键',
cheweiName varchar(100) comment '车位编号',
cheweiwz varchar(100) comment '车位位置',
status varchar(100) comment '状态'
) comment '车位';
用户表创建语句如下：
create table t_customer(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
customerName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别'
) comment '用户';
车位预定表创建语句如下：
create table t_cwyd(
id int primary key auto_increment comment '主键',
customerId int comment '用户',
cheweiName varchar(100) comment '车位编号',
ydDate datetime comment '预定日期',
status varchar(100) comment '状态'
) comment '车位预定';
网站设定表创建语句如下：
create table t_miaoshu(
id int primary key auto_increment comment '主键',
fee int comment '价格设定/小时',
content varchar(100) comment '网站说明'
) comment '网站设定';
出入管理员表创建语句如下：
create table t_ptadmin(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ptadminName varchar(100) comment '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
sex varchar(100) 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_cheliangjc(
id integer,
cheweiName varchar(100),
cp varchar(100),
lx varchar(100),
beginDate datetime,
endDate datetime,
status varchar(100),
xiaoshi int,
fy int
);
--车辆进出字段加注释
comment on column t_cheliangjc.id is '主键';
comment on column t_cheliangjc.cheweiName is '车位编号';
comment on column t_cheliangjc.cp is '车牌';
comment on column t_cheliangjc.lx is '用户类型';
comment on column t_cheliangjc.beginDate is '进入时间';
comment on column t_cheliangjc.endDate is '出去时间';
comment on column t_cheliangjc.status is '状态';
comment on column t_cheliangjc.xiaoshi is '总小时';
comment on column t_cheliangjc.fy is '费用';
--车辆进出表加注释
comment on table t_cheliangjc is '车辆进出';
车位表创建语句如下：
create table t_chewei(
id integer,
cheweiName varchar(100),
cheweiwz varchar(100),
status varchar(100)
);
--车位字段加注释
comment on column t_chewei.id is '主键';
comment on column t_chewei.cheweiName is '车位编号';
comment on column t_chewei.cheweiwz is '车位位置';
comment on column t_chewei.status is '状态';
--车位表加注释
comment on table t_chewei is '车位';
用户表创建语句如下：
create table t_customer(
id integer,
username varchar(100),
password varchar(100),
customerName varchar(100),
phone varchar(100),
age varchar(100),
sex 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.phone is '电话';
comment on column t_customer.age is '年龄';
comment on column t_customer.sex is '性别';
--用户表加注释
comment on table t_customer is '用户';
车位预定表创建语句如下：
create table t_cwyd(
id integer,
customerId int,
cheweiName varchar(100),
ydDate datetime,
status varchar(100)
);
--车位预定字段加注释
comment on column t_cwyd.id is '主键';
comment on column t_cwyd.customerId is '用户';
comment on column t_cwyd.cheweiName is '车位编号';
comment on column t_cwyd.ydDate is '预定日期';
comment on column t_cwyd.status is '状态';
--车位预定表加注释
comment on table t_cwyd is '车位预定';
网站设定表创建语句如下：
create table t_miaoshu(
id integer,
fee int,
content varchar(100)
);
--网站设定字段加注释
comment on column t_miaoshu.id is '主键';
comment on column t_miaoshu.fee is '价格设定/小时';
comment on column t_miaoshu.content is '网站说明';
--网站设定表加注释
comment on table t_miaoshu is '网站设定';
出入管理员表创建语句如下：
create table t_ptadmin(
id integer,
username varchar(100),
password varchar(100),
ptadminName varchar(100),
phone varchar(100),
age varchar(100),
sex varchar(100)
);
--出入管理员字段加注释
comment on column t_ptadmin.id is '主键';
comment on column t_ptadmin.username is '账号';
comment on column t_ptadmin.password is '密码';
comment on column t_ptadmin.ptadminName is '姓名';
comment on column t_ptadmin.phone is '电话';
comment on column t_ptadmin.age is '年龄';
comment on column t_ptadmin.sex is '性别';
--出入管理员表加注释
comment on table t_ptadmin is '出入管理员';
oracle特有，对应序列如下：
create sequence s_t_cheliangjc;
create sequence s_t_chewei;
create sequence s_t_customer;
create sequence s_t_cwyd;
create sequence s_t_miaoshu;
create sequence s_t_ptadmin;
住宅小区车辆管理系统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_cheliangjc(
id int identity(1,1) primary key not null,--主键
cheweiName varchar(100),--车位编号
cp varchar(100),--车牌
lx varchar(100),--用户类型
beginDate datetime,--进入时间
endDate datetime,--出去时间
status varchar(100),--状态
xiaoshi int,--总小时
fy int--费用
);
车位表创建语句如下：
--车位表注释
create table t_chewei(
id int identity(1,1) primary key not null,--主键
cheweiName varchar(100),--车位编号
cheweiwz varchar(100),--车位位置
status varchar(100)--状态
);
用户表创建语句如下：
--用户表注释
create table t_customer(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
customerName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
车位预定表创建语句如下：
--车位预定表注释
create table t_cwyd(
id int identity(1,1) primary key not null,--主键
customerId int,--用户
cheweiName varchar(100),--车位编号
ydDate datetime,--预定日期
status varchar(100)--状态
);
网站设定表创建语句如下：
--网站设定表注释
create table t_miaoshu(
id int identity(1,1) primary key not null,--主键
fee int,--价格设定/小时
content varchar(100)--网站说明
);
出入管理员表创建语句如下：
--出入管理员表注释
create table t_ptadmin(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ptadminName varchar(100),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
sex varchar(100)--性别
);
登录后主页.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_cheliangjc")
public class Cheliangjc {
//主键
@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 cheweiName;
//车牌
private String cp;
//用户类型
private String lx;
//进入时间
private Date beginDate;
//出去时间
private Date endDate;
//状态
private String status;
//总小时
private Integer xiaoshi;
//费用
private Integer fy;
public String getCheweiName() {return cheweiName;}
public void setCheweiName(String cheweiName) {this.cheweiName = cheweiName;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
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;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getXiaoshi() {return xiaoshi;}
public void setXiaoshi(Integer xiaoshi) {this.xiaoshi = xiaoshi;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
}车位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_chewei")
public class Chewei {
//主键
@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 cheweiName;
//车位位置
private String cheweiwz;
//状态
private String status;
public String getCheweiName() {return cheweiName;}
public void setCheweiName(String cheweiName) {this.cheweiName = cheweiName;}
public String getCheweiwz() {return cheweiwz;}
public void setCheweiwz(String cheweiwz) {this.cheweiwz = cheweiwz;}
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_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 phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}车位预定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_cwyd")
public class Cwyd {
//主键
@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 cheweiName;
//预定日期
private Date ydDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCheweiName() {return cheweiName;}
public void setCheweiName(String cheweiName) {this.cheweiName = cheweiName;}
public Date getYdDate() {return ydDate;}
public void setYdDate(Date ydDate) {this.ydDate = ydDate;}
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_miaoshu")
public class Miaoshu {
//主键
@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 fee;
//网站说明
private String content;
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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_ptadmin")
public class Ptadmin {
//主键
@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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}住宅小区车辆管理系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计：
车辆进出javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车辆进出
public class Cheliangjc extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车位编号
private String cheweiName;
//车牌
private String cp;
//用户类型
private String lx;
//进入时间
private Date beginDate;
//出去时间
private Date endDate;
//状态
private String status;
//总小时
private Integer xiaoshi;
//费用
private Integer fy;
public String getCheweiName() {return cheweiName;}
public void setCheweiName(String cheweiName) {this.cheweiName = cheweiName;}
public String getCp() {return cp;}
public void setCp(String cp) {this.cp = cp;}
public String getLx() {return lx;}
public void setLx(String lx) {this.lx = lx;}
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;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Integer getXiaoshi() {return xiaoshi;}
public void setXiaoshi(Integer xiaoshi) {this.xiaoshi = xiaoshi;}
public Integer getFy() {return fy;}
public void setFy(Integer fy) {this.fy = fy;}
}车位javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车位
public class Chewei extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//车位编号
private String cheweiName;
//车位位置
private String cheweiwz;
//状态
private String status;
public String getCheweiName() {return cheweiName;}
public void setCheweiName(String cheweiName) {this.cheweiName = cheweiName;}
public String getCheweiwz() {return cheweiwz;}
public void setCheweiwz(String cheweiwz) {this.cheweiwz = cheweiwz;}
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 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 phone;
//年龄
private String age;
//性别
private String sex;
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 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;}
}车位预定javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//车位预定
public class Cwyd extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer customerId;
//车位编号
private String cheweiName;
//预定日期
private Date ydDate;
//状态
private String status;
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public String getCheweiName() {return cheweiName;}
public void setCheweiName(String cheweiName) {this.cheweiName = cheweiName;}
public Date getYdDate() {return ydDate;}
public void setYdDate(Date ydDate) {this.ydDate = ydDate;}
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 Miaoshu extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//价格设定/小时
private Integer fee;
//网站说明
private String content;
public Integer getFee() {return fee;}
public void setFee(Integer fee) {this.fee = fee;}
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 Ptadmin 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 ptadminName;
//电话
private String phone;
//年龄
private String age;
//性别
private String sex;
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 getPtadminName() {return ptadminName;}
public void setPtadminName(String ptadminName) {this.ptadminName = ptadminName;}
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;}
}