加密数据查询系统

加密数据查询系统登录注册界面

加密数据查询系统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 '年龄',
	sex varchar(100) comment '性别',
	address varchar(100) comment '地址'
) comment '用户';

错误记录表创建语句如下:


create table t_error(
	id int primary key auto_increment comment '主键',
	ipAddress varchar(100) comment '访问ip',
	insertDate datetime comment '日期'
) comment '错误记录';

显示信息表创建语句如下:


create table t_message(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '内容',
	titlemi varchar(100) comment '内容加密后'
) comment '显示信息';

查询表创建语句如下:


create table t_search(
	id int primary key auto_increment comment '主键',
	customerId int comment '用户',
	title varchar(100) comment '查询内容',
	insertDate datetime comment '日期',
	status 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_customer(
	id integer,
	username varchar(100),
	password varchar(100),
	customerName varchar(100),
	phone varchar(100),
	age varchar(100),
	sex varchar(100),
	address 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 column t_customer.address is '地址';
--用户表加注释
comment on table t_customer is '用户';

错误记录表创建语句如下:


create table t_error(
	id integer,
	ipAddress varchar(100),
	insertDate datetime
);
--错误记录字段加注释
comment on column t_error.id is '主键';
comment on column t_error.ipAddress is '访问ip';
comment on column t_error.insertDate is '日期';
--错误记录表加注释
comment on table t_error is '错误记录';

显示信息表创建语句如下:


create table t_message(
	id integer,
	title varchar(100),
	titlemi varchar(100)
);
--显示信息字段加注释
comment on column t_message.id is '主键';
comment on column t_message.title is '内容';
comment on column t_message.titlemi is '内容加密后';
--显示信息表加注释
comment on table t_message is '显示信息';

查询表创建语句如下:


create table t_search(
	id integer,
	customerId int,
	title varchar(100),
	insertDate datetime,
	status varchar(100)
);
--查询字段加注释
comment on column t_search.id is '主键';
comment on column t_search.customerId is '用户';
comment on column t_search.title is '查询内容';
comment on column t_search.insertDate is '日期';
comment on column t_search.status is '状态';
--查询表加注释
comment on table t_search is '查询';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_error;
create sequence s_t_message;
create sequence s_t_search;

加密数据查询系统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),--年龄
	sex varchar(100),--性别
	address varchar(100)--地址
);

错误记录表创建语句如下:


--错误记录表注释
create table t_error(
	id int identity(1,1) primary key not null,--主键
	ipAddress varchar(100),--访问ip
	insertDate datetime--日期
);

显示信息表创建语句如下:


--显示信息表注释
create table t_message(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--内容
	titlemi varchar(100)--内容加密后
);

查询表创建语句如下:


--查询表注释
create table t_search(
	id int identity(1,1) primary key not null,--主键
	customerId int,--用户
	title varchar(100),--查询内容
	insertDate datetime,--日期
	status varchar(100)--状态
);

加密数据查询系统登录后主页

加密数据查询系统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 sex;
//地址
private String address;
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;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

错误记录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_error")
public class Error {
//主键
@Id
@Column(name = "id")
@GeneratedValue(strategy = GenerationType.IDENTITY)
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//访问ip
private String ipAddress;
//日期
private Date insertDate;
public String getIpAddress() {return ipAddress;}
public void setIpAddress(String ipAddress) {this.ipAddress = ipAddress;}
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_message")
public class Message {
//主键
@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 titlemi;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTitlemi() {return titlemi;}
public void setTitlemi(String titlemi) {this.titlemi = titlemi;}
}

查询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_search")
public class Search {
//主键
@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 Date insertDate;
//状态
private String status;
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 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;}
}

加密数据查询系统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 sex;
//地址
private String address;
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;}
public String getAddress() {return address;}
public void setAddress(String address) {this.address = address;}
}

错误记录javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//错误记录
public class Error  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//访问ip
private String ipAddress;
//日期
private Date insertDate;
public String getIpAddress() {return ipAddress;}
public void setIpAddress(String ipAddress) {this.ipAddress = ipAddress;}
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 Message  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//内容
private String title;
//内容加密后
private String titlemi;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getTitlemi() {return titlemi;}
public void setTitlemi(String titlemi) {this.titlemi = titlemi;}
}

查询javaBean创建语句如下:


package project.model;
import org.springframework.format.annotation.DateTimeFormat;
import java.util.Date;

//查询
public class Search  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 Date insertDate;
//状态
private String status;
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 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;}
}

评论