- java数字签名系统mysql数据库创建语句
- java数字签名系统oracle数据库创建语句
- java数字签名系统sqlserver数据库创建语句
- java数字签名系统spring+springMVC+hibernate框架对象(javaBean,pojo)设计
- java数字签名系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计
登录注册界面.jpg?x-oss-process=style/00001)
java数字签名系统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_dept(
id int primary key auto_increment comment '主键',
deptName varchar(100) comment '部门'
) comment '部门';
文件表创建语句如下:
create table t_file(
id int primary key auto_increment comment '主键',
ygId int comment '用户',
fileName varchar(100) comment '文件名称',
fileUrl varchar(100) comment '地址',
insertDate datetime comment '上传日期',
qm varchar(100) comment '签名',
gs varchar(100) comment ''
) comment '文件';
用户表创建语句如下:
create table t_yg(
id int primary key auto_increment comment '主键',
username varchar(100) comment '账号',
password varchar(100) comment '密码',
ygName varchar(100) comment '姓名',
age varchar(100) comment '年龄',
sex varchar(100) comment '性别',
phone varchar(100) comment '电话',
gh varchar(100) comment '工号',
deptId int comment '部门'
) comment '用户';
java数字签名系统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_dept(
id integer,
deptName varchar(100)
);
--部门字段加注释
comment on column t_dept.id is '主键';
comment on column t_dept.deptName is '部门';
--部门表加注释
comment on table t_dept is '部门';
文件表创建语句如下:
create table t_file(
id integer,
ygId int,
fileName varchar(100),
fileUrl varchar(100),
insertDate datetime,
qm varchar(100),
gs varchar(100)
);
--文件字段加注释
comment on column t_file.id is '主键';
comment on column t_file.ygId is '用户';
comment on column t_file.fileName is '文件名称';
comment on column t_file.fileUrl is '地址';
comment on column t_file.insertDate is '上传日期';
comment on column t_file.qm is '签名';
comment on column t_file.gs is '';
--文件表加注释
comment on table t_file is '文件';
用户表创建语句如下:
create table t_yg(
id integer,
username varchar(100),
password varchar(100),
ygName varchar(100),
age varchar(100),
sex varchar(100),
phone varchar(100),
gh varchar(100),
deptId int
);
--用户字段加注释
comment on column t_yg.id is '主键';
comment on column t_yg.username is '账号';
comment on column t_yg.password is '密码';
comment on column t_yg.ygName is '姓名';
comment on column t_yg.age is '年龄';
comment on column t_yg.sex is '性别';
comment on column t_yg.phone is '电话';
comment on column t_yg.gh is '工号';
comment on column t_yg.deptId is '部门';
--用户表加注释
comment on table t_yg is '用户';
oracle特有,对应序列如下:
create sequence s_t_dept;
create sequence s_t_file;
create sequence s_t_yg;
java数字签名系统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_dept(
id int identity(1,1) primary key not null,--主键
deptName varchar(100)--部门
);
文件表创建语句如下:
--文件表注释
create table t_file(
id int identity(1,1) primary key not null,--主键
ygId int,--用户
fileName varchar(100),--文件名称
fileUrl varchar(100),--地址
insertDate datetime,--上传日期
qm varchar(100),--签名
gs varchar(100)--
);
用户表创建语句如下:
--用户表注释
create table t_yg(
id int identity(1,1) primary key not null,--主键
username varchar(100),--账号
password varchar(100),--密码
ygName varchar(100),--姓名
age varchar(100),--年龄
sex varchar(100),--性别
phone varchar(100),--电话
gh varchar(100),--工号
deptId int--部门
);
登录后主页.jpg?x-oss-process=style/00001)
java数字签名系统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_dept")
public class Dept {
//主键
@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 deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}
文件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_file")
public class File {
//主键
@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 ygId;
//文件名称
private String fileName;
//地址
private String fileUrl;
//上传日期
private Date insertDate;
//签名
private String qm;
//
private String gs;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public String getFileName() {return fileName;}
public void setFileName(String fileName) {this.fileName = fileName;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getQm() {return qm;}
public void setQm(String qm) {this.qm = qm;}
public String getGs() {return gs;}
public void setGs(String gs) {this.gs = gs;}
}
用户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_yg")
public class Yg {
//主键
@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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//工号
private String gh;
//部门
private Integer deptId;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
}
java数字签名系统spring+springMVC+mybatis框架对象(javaBean,pojo)设计:
部门javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//部门
public class Dept extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//部门
private String deptName;
public String getDeptName() {return deptName;}
public void setDeptName(String deptName) {this.deptName = deptName;}
}
文件javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//文件
public class File extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//用户
private Integer ygId;
//文件名称
private String fileName;
//地址
private String fileUrl;
//上传日期
private Date insertDate;
//签名
private String qm;
//
private String gs;
public Integer getYgId() {return ygId;}
public void setYgId(Integer ygId) {this.ygId = ygId;}
public String getFileName() {return fileName;}
public void setFileName(String fileName) {this.fileName = fileName;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Date getInsertDate() {return insertDate;}
public void setInsertDate(Date insertDate) {this.insertDate = insertDate;}
public String getQm() {return qm;}
public void setQm(String qm) {this.qm = qm;}
public String getGs() {return gs;}
public void setGs(String gs) {this.gs = gs;}
}
用户javaBean创建语句如下:
package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;
//用户
public class Yg 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 ygName;
//年龄
private String age;
//性别
private String sex;
//电话
private String phone;
//工号
private String gh;
//部门
private Integer deptId;
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 getYgName() {return ygName;}
public void setYgName(String ygName) {this.ygName = ygName;}
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 getPhone() {return phone;}
public void setPhone(String phone) {this.phone = phone;}
public String getGh() {return gh;}
public void setGh(String gh) {this.gh = gh;}
public Integer getDeptId() {return deptId;}
public void setDeptId(Integer deptId) {this.deptId = deptId;}
}