- 基于WEB的安保系统mysql数据库创建语句
- 基于WEB的安保系统oracle数据库创建语句
- 基于WEB的安保系统sqlserver数据库创建语句
- 基于WEB的安保系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- 基于WEB的安保系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
基于WEB的安保系统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_address(
id int primary key auto_increment comment '主键',
lat double comment '经度',
lon double comment '纬度',
insertDate datetime comment '日期'
) comment '地理位置';
报警客户端表创建语句如下:
create table t_bj(
id int primary key auto_increment comment '主键',
name varchar(100) comment '经度'
) comment '报警客户端';
伪码报警表创建语句如下:
create table t_wm(
id int primary key auto_increment comment '主键',
wmnr varchar(100) comment '伪码内容',
insertDate datetime comment '日期',
status varchar(100) comment ''
) comment '伪码报警';
基于WEB的安保系统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_address(
id integer,
lat double,
lon double,
insertDate datetime
);
--地理位置字段加注释
comment on column t_address.id is '主键';
comment on column t_address.lat is '经度';
comment on column t_address.lon is '纬度';
comment on column t_address.insertDate is '日期';
--地理位置表加注释
comment on table t_address is '地理位置';
报警客户端表创建语句如下:
create table t_bj(
id integer,
name varchar(100)
);
--报警客户端字段加注释
comment on column t_bj.id is '主键';
comment on column t_bj.name is '经度';
--报警客户端表加注释
comment on table t_bj is '报警客户端';
伪码报警表创建语句如下:
create table t_wm(
id integer,
wmnr varchar(100),
insertDate datetime,
status varchar(100)
);
--伪码报警字段加注释
comment on column t_wm.id is '主键';
comment on column t_wm.wmnr is '伪码内容';
comment on column t_wm.insertDate is '日期';
comment on column t_wm.status is '';
--伪码报警表加注释
comment on table t_wm is '伪码报警';
oracle特有,对应序列如下:
create sequence s_t_address;
create sequence s_t_bj;
create sequence s_t_wm;
基于WEB的安保系统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_address(
id int identity(1,1) primary key not null,--主键
lat double,--经度
lon double,--纬度
insertDate datetime--日期
);
报警客户端表创建语句如下:
--报警客户端表注释
create table t_bj(
id int identity(1,1) primary key not null,--主键
name varchar(100)--经度
);
伪码报警表创建语句如下:
--伪码报警表注释
create table t_wm(
id int identity(1,1) primary key not null,--主键
wmnr varchar(100),--伪码内容
insertDate datetime,--日期
status varchar(100)--
);
登录后主页.jpg?x-oss-process=style/00001)
基于WEB的安保系统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_address")
public class Address {
//主键
@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 Double lat;
//纬度
private Double lon;
//日期
private Date insertDate;
public Double getLat() {return lat;}
public void setLat(Double lat) {this.lat = lat;}
public Double getLon() {return lon;}
public void setLon(Double lon) {this.lon = lon;}
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_bj")
public class Bj {
//主键
@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 name;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
}
伪码报警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_wm")
public class Wm {
//主键
@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 wmnr;
//日期
private Date insertDate;
//
private String status;
public String getWmnr() {return wmnr;}
public void setWmnr(String wmnr) {this.wmnr = wmnr;}
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;}
}
基于WEB的安保系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
地理位置javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//地理位置
public class Address extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//经度
private Double lat;
//纬度
private Double lon;
//日期
private Date insertDate;
public Double getLat() {return lat;}
public void setLat(Double lat) {this.lat = lat;}
public Double getLon() {return lon;}
public void setLon(Double lon) {this.lon = lon;}
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 Bj extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//经度
private String name;
public String getName() {return name;}
public void setName(String name) {this.name = name;}
}
伪码报警javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//伪码报警
public class Wm extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//伪码内容
private String wmnr;
//日期
private Date insertDate;
//
private String status;
public String getWmnr() {return wmnr;}
public void setWmnr(String wmnr) {this.wmnr = wmnr;}
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;}
}