- 智能快递柜的设计与实现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 '姓名',
phone varchar(100) comment '电话',
age varchar(100) comment '年龄',
js varchar(100) comment '角色'
) comment '用户';
寄件表创建语句如下：
create table t_jj(
id int primary key auto_increment comment '主键',
xm varchar(100) comment '姓名',
phone varchar(100) comment '电话',
address varchar(100) comment '地址',
kdgName varchar(100) comment '快递柜编号',
toPhone varchar(100) comment '快递员手机号(必须，因为如果多个快递员不知道发给谁，默认手机分配)',
insertDate datetime comment '日期',
status varchar(100) comment '状态',
qjDate datetime comment '取件日期',
types int comment '1是用户发起 2是快递员发起'
) comment '寄件';
快递柜表创建语句如下：
create table t_kdg(
id int primary key auto_increment comment '主键',
kdgName varchar(100) comment '快递柜编号',
status varchar(100) comment '状态',
mm varchar(100) comment '密码'
) comment '快递柜';
取件表创建语句如下：
create table t_qj(
id int primary key auto_increment comment '主键',
xm varchar(100) comment '姓名',
phone varchar(100) comment '电话',
address varchar(100) comment '地址',
kdgName varchar(100) comment '快递柜编号',
toPhone varchar(100) comment '快递员手机号(谁送的货)',
insertDate datetime comment '日期',
status varchar(100) comment '状态',
qjDate datetime comment '取件日期'
) comment '取件';
消息表创建语句如下：
create table t_xiaoxi(
id int primary key auto_increment comment '主键',
phone 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),
phone varchar(100),
age varchar(100),
js 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.js is '角色';
--用户表加注释
comment on table t_customer is '用户';
寄件表创建语句如下：
create table t_jj(
id integer,
xm varchar(100),
phone varchar(100),
address varchar(100),
kdgName varchar(100),
toPhone varchar(100),
insertDate datetime,
status varchar(100),
qjDate datetime,
types int
);
--寄件字段加注释
comment on column t_jj.id is '主键';
comment on column t_jj.xm is '姓名';
comment on column t_jj.phone is '电话';
comment on column t_jj.address is '地址';
comment on column t_jj.kdgName is '快递柜编号';
comment on column t_jj.toPhone is '快递员手机号(必须，因为如果多个快递员不知道发给谁，默认手机分配)';
comment on column t_jj.insertDate is '日期';
comment on column t_jj.status is '状态';
comment on column t_jj.qjDate is '取件日期';
comment on column t_jj.types is '1是用户发起 2是快递员发起';
--寄件表加注释
comment on table t_jj is '寄件';
快递柜表创建语句如下：
create table t_kdg(
id integer,
kdgName varchar(100),
status varchar(100),
mm varchar(100)
);
--快递柜字段加注释
comment on column t_kdg.id is '主键';
comment on column t_kdg.kdgName is '快递柜编号';
comment on column t_kdg.status is '状态';
comment on column t_kdg.mm is '密码';
--快递柜表加注释
comment on table t_kdg is '快递柜';
取件表创建语句如下：
create table t_qj(
id integer,
xm varchar(100),
phone varchar(100),
address varchar(100),
kdgName varchar(100),
toPhone varchar(100),
insertDate datetime,
status varchar(100),
qjDate datetime
);
--取件字段加注释
comment on column t_qj.id is '主键';
comment on column t_qj.xm is '姓名';
comment on column t_qj.phone is '电话';
comment on column t_qj.address is '地址';
comment on column t_qj.kdgName is '快递柜编号';
comment on column t_qj.toPhone is '快递员手机号(谁送的货)';
comment on column t_qj.insertDate is '日期';
comment on column t_qj.status is '状态';
comment on column t_qj.qjDate is '取件日期';
--取件表加注释
comment on table t_qj is '取件';
消息表创建语句如下：
create table t_xiaoxi(
id integer,
phone varchar(100),
content varchar(100),
insertDate datetime
);
--消息字段加注释
comment on column t_xiaoxi.id is '主键';
comment on column t_xiaoxi.phone is '电话';
comment on column t_xiaoxi.content is '内容';
comment on column t_xiaoxi.insertDate is '日期';
--消息表加注释
comment on table t_xiaoxi is '消息';
oracle特有，对应序列如下：
create sequence s_t_customer;
create sequence s_t_jj;
create sequence s_t_kdg;
create sequence s_t_qj;
create sequence s_t_xiaoxi;
智能快递柜的设计与实现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),--姓名
phone varchar(100),--电话
age varchar(100),--年龄
js varchar(100)--角色
);
寄件表创建语句如下：
--寄件表注释
create table t_jj(
id int identity(1,1) primary key not null,--主键
xm varchar(100),--姓名
phone varchar(100),--电话
address varchar(100),--地址
kdgName varchar(100),--快递柜编号
toPhone varchar(100),--快递员手机号(必须，因为如果多个快递员不知道发给谁，默认手机分配)
insertDate datetime,--日期
status varchar(100),--状态
qjDate datetime,--取件日期
types int--1是用户发起 2是快递员发起
);
快递柜表创建语句如下：
--快递柜表注释
create table t_kdg(
id int identity(1,1) primary key not null,--主键
kdgName varchar(100),--快递柜编号
status varchar(100),--状态
mm varchar(100)--密码
);
取件表创建语句如下：
--取件表注释
create table t_qj(
id int identity(1,1) primary key not null,--主键
xm varchar(100),--姓名
phone varchar(100),--电话
address varchar(100),--地址
kdgName varchar(100),--快递柜编号
toPhone varchar(100),--快递员手机号(谁送的货)
insertDate datetime,--日期
status varchar(100),--状态
qjDate datetime--取件日期
);
消息表创建语句如下：
--消息表注释
create table t_xiaoxi(
id int identity(1,1) primary key not null,--主键
phone 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 phone;
//年龄
private String age;
//角色
private String js;
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 getJs() {return js;}
public void setJs(String js) {this.js = js;}
}寄件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_jj")
public class Jj {
//主键
@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 xm;
//电话
private String phone;
//地址
private String address;
//快递柜编号
private String kdgName;
//快递员手机号(必须，因为如果多个快递员不知道发给谁，默认手机分配)
private String toPhone;
//日期
private Date insertDate;
//状态
private String status;
//取件日期
private Date qjDate;
//1是用户发起 2是快递员发起
private Integer types;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getKdgName() {return kdgName;}
public void setKdgName(String kdgName) {this.kdgName = kdgName;}
public String getToPhone() {return toPhone;}
public void setToPhone(String toPhone) {this.toPhone = toPhone;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getQjDate() {return qjDate;}
public void setQjDate(Date qjDate) {this.qjDate = qjDate;}
public Integer getTypes() {return types;}
public void setTypes(Integer 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_kdg")
public class Kdg {
//主键
@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 kdgName;
//状态
private String status;
//密码
private String mm;
public String getKdgName() {return kdgName;}
public void setKdgName(String kdgName) {this.kdgName = kdgName;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getMm() {return mm;}
public void setMm(String mm) {this.mm = mm;}
}取件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_qj")
public class Qj {
//主键
@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 xm;
//电话
private String phone;
//地址
private String address;
//快递柜编号
private String kdgName;
//快递员手机号(谁送的货)
private String toPhone;
//日期
private Date insertDate;
//状态
private String status;
//取件日期
private Date qjDate;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getKdgName() {return kdgName;}
public void setKdgName(String kdgName) {this.kdgName = kdgName;}
public String getToPhone() {return toPhone;}
public void setToPhone(String toPhone) {this.toPhone = toPhone;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getQjDate() {return qjDate;}
public void setQjDate(Date qjDate) {this.qjDate = qjDate;}
}消息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_xiaoxi")
public class Xiaoxi {
//主键
@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 phone;
//内容
private String content;
//日期
private Date insertDate;
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;}
}智能快递柜的设计与实现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 phone;
//年龄
private String age;
//角色
private String js;
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 getJs() {return js;}
public void setJs(String js) {this.js = js;}
}寄件javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//寄件
public class Jj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String xm;
//电话
private String phone;
//地址
private String address;
//快递柜编号
private String kdgName;
//快递员手机号(必须，因为如果多个快递员不知道发给谁，默认手机分配)
private String toPhone;
//日期
private Date insertDate;
//状态
private String status;
//取件日期
private Date qjDate;
//1是用户发起 2是快递员发起
private Integer types;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getKdgName() {return kdgName;}
public void setKdgName(String kdgName) {this.kdgName = kdgName;}
public String getToPhone() {return toPhone;}
public void setToPhone(String toPhone) {this.toPhone = toPhone;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getQjDate() {return qjDate;}
public void setQjDate(Date qjDate) {this.qjDate = qjDate;}
public Integer getTypes() {return types;}
public void setTypes(Integer types) {this.types = types;}
}快递柜javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//快递柜
public class Kdg extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//快递柜编号
private String kdgName;
//状态
private String status;
//密码
private String mm;
public String getKdgName() {return kdgName;}
public void setKdgName(String kdgName) {this.kdgName = kdgName;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public String getMm() {return mm;}
public void setMm(String mm) {this.mm = mm;}
}取件javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//取件
public class Qj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//姓名
private String xm;
//电话
private String phone;
//地址
private String address;
//快递柜编号
private String kdgName;
//快递员手机号(谁送的货)
private String toPhone;
//日期
private Date insertDate;
//状态
private String status;
//取件日期
private Date qjDate;
public String getXm() {return xm;}
public void setXm(String xm) {this.xm = xm;}
public String getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
public String getKdgName() {return kdgName;}
public void setKdgName(String kdgName) {this.kdgName = kdgName;}
public String getToPhone() {return toPhone;}
public void setToPhone(String toPhone) {this.toPhone = toPhone;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getStatus() {return status;}
public void setStatus(String status) {this.status = status;}
public Date getQjDate() {return qjDate;}
public void setQjDate(Date qjDate) {this.qjDate = qjDate;}
}消息javaBean创建语句如下：
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//消息
public class Xiaoxi extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//电话
private String phone;
//内容
private String content;
//日期
private Date insertDate;
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;}
}