更多成品,定做java毕业设计,请咨询管理员qq:2812491287

基于MySQL网盘管理系统的设计与实现

基于MySQL网盘管理系统的设计与实现登录注册界面

基于MySQL网盘管理系统的设计与实现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 '姓名',
	age varchar(100) comment '年龄',
	sex varchar(100) comment '性别',
	phone varchar(100) comment '电话',
	kjdx int comment '空间大小',
	isGly varchar(100) comment '是否管理员'
) comment '用户';

文件表创建语句如下:


create table t_fileup(
	id int primary key auto_increment comment '主键',
	fileName varchar(100) comment '文件名称',
	wjwz varchar(100) comment '文件位置',
	fileUrl varchar(100) comment '文件地址',
	fileSzie int comment '文件大小',
	filelx varchar(100) comment '文件格式',
	insertDate datetime comment '上传日期',
	status varchar(100) comment '是否有效',
	fx varchar(100) comment '是否分享',
	customerId int comment '用户',
	typesId int comment '文件类型'
) comment '文件';

公告表创建语句如下:


create table t_gg(
	id int primary key auto_increment comment '主键',
	title varchar(100) comment '标题',
	pic varchar(100) comment '图片',
	content varchar(100) comment '内容',
	showDate datetime comment '日期'
) comment '公告';

文件类型表创建语句如下:


create table t_types(
	id int primary key auto_increment comment '主键',
	typesName varchar(100) comment '文件类型'
) comment '文件类型';

基于MySQL网盘管理系统的设计与实现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),
	age varchar(100),
	sex varchar(100),
	phone varchar(100),
	kjdx int,
	isGly 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.age is '年龄';
comment on column t_customer.sex is '性别';
comment on column t_customer.phone is '电话';
comment on column t_customer.kjdx is '空间大小';
comment on column t_customer.isGly is '是否管理员';
--用户表加注释
comment on table t_customer is '用户';

文件表创建语句如下:


create table t_fileup(
	id integer,
	fileName varchar(100),
	wjwz varchar(100),
	fileUrl varchar(100),
	fileSzie int,
	filelx varchar(100),
	insertDate datetime,
	status varchar(100),
	fx varchar(100),
	customerId int,
	typesId int
);
--文件字段加注释
comment on column t_fileup.id is '主键';
comment on column t_fileup.fileName is '文件名称';
comment on column t_fileup.wjwz is '文件位置';
comment on column t_fileup.fileUrl is '文件地址';
comment on column t_fileup.fileSzie is '文件大小';
comment on column t_fileup.filelx is '文件格式';
comment on column t_fileup.insertDate is '上传日期';
comment on column t_fileup.status is '是否有效';
comment on column t_fileup.fx is '是否分享';
comment on column t_fileup.customerId is '用户';
comment on column t_fileup.typesId is '文件类型';
--文件表加注释
comment on table t_fileup is '文件';

公告表创建语句如下:


create table t_gg(
	id integer,
	title varchar(100),
	pic varchar(100),
	content varchar(100),
	showDate datetime
);
--公告字段加注释
comment on column t_gg.id is '主键';
comment on column t_gg.title is '标题';
comment on column t_gg.pic is '图片';
comment on column t_gg.content is '内容';
comment on column t_gg.showDate is '日期';
--公告表加注释
comment on table t_gg is '公告';

文件类型表创建语句如下:


create table t_types(
	id integer,
	typesName varchar(100)
);
--文件类型字段加注释
comment on column t_types.id is '主键';
comment on column t_types.typesName is '文件类型';
--文件类型表加注释
comment on table t_types is '文件类型';

oracle特有,对应序列如下:


create sequence s_t_customer;
create sequence s_t_fileup;
create sequence s_t_gg;
create sequence s_t_types;

基于MySQL网盘管理系统的设计与实现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),--姓名
	age varchar(100),--年龄
	sex varchar(100),--性别
	phone varchar(100),--电话
	kjdx int,--空间大小
	isGly varchar(100)--是否管理员
);

文件表创建语句如下:


--文件表注释
create table t_fileup(
	id int identity(1,1) primary key not null,--主键
	fileName varchar(100),--文件名称
	wjwz varchar(100),--文件位置
	fileUrl varchar(100),--文件地址
	fileSzie int,--文件大小
	filelx varchar(100),--文件格式
	insertDate datetime,--上传日期
	status varchar(100),--是否有效
	fx varchar(100),--是否分享
	customerId int,--用户
	typesId int--文件类型
);

公告表创建语句如下:


--公告表注释
create table t_gg(
	id int identity(1,1) primary key not null,--主键
	title varchar(100),--标题
	pic varchar(100),--图片
	content varchar(100),--内容
	showDate datetime--日期
);

文件类型表创建语句如下:


--文件类型表注释
create table t_types(
	id int identity(1,1) primary key not null,--主键
	typesName varchar(100)--文件类型
);

基于MySQL网盘管理系统的设计与实现登录后主页

基于MySQL网盘管理系统的设计与实现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 age;
//性别
private String sex;
//电话
private String phone;
//空间大小
private Integer kjdx;
//是否管理员
private String isGly;
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 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 Integer getKjdx() {return kjdx;}
public void setKjdx(Integer kjdx) {this.kjdx = kjdx;}
public String getIsGly() {return isGly;}
public void setIsGly(String isGly) {this.isGly = isGly;}
}

文件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_fileup")
public class Fileup {
//主键
@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 fileName;
//文件位置
private String wjwz;
//文件地址
private String fileUrl;
//文件大小
private Integer fileSzie;
//文件格式
private String filelx;
//上传日期
private Date insertDate;
//是否有效
private String status;
//是否分享
private String fx;
//用户
private Integer customerId;
//文件类型
private Integer typesId;
public String getFileName() {return fileName;}
public void setFileName(String fileName) {this.fileName = fileName;}
public String getWjwz() {return wjwz;}
public void setWjwz(String wjwz) {this.wjwz = wjwz;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Integer getFileSzie() {return fileSzie;}
public void setFileSzie(Integer fileSzie) {this.fileSzie = fileSzie;}
public String getFilelx() {return filelx;}
public void setFilelx(String filelx) {this.filelx = filelx;}
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 String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
}

公告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_gg")
public class Gg {
//主键
@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 pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

文件类型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_types")
public class Types {
//主键
@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 typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

基于MySQL网盘管理系统的设计与实现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 age;
//性别
private String sex;
//电话
private String phone;
//空间大小
private Integer kjdx;
//是否管理员
private String isGly;
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 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 Integer getKjdx() {return kjdx;}
public void setKjdx(Integer kjdx) {this.kjdx = kjdx;}
public String getIsGly() {return isGly;}
public void setIsGly(String isGly) {this.isGly = isGly;}
}

文件javaBean创建语句如下:


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

//文件
public class Fileup  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文件名称
private String fileName;
//文件位置
private String wjwz;
//文件地址
private String fileUrl;
//文件大小
private Integer fileSzie;
//文件格式
private String filelx;
//上传日期
private Date insertDate;
//是否有效
private String status;
//是否分享
private String fx;
//用户
private Integer customerId;
//文件类型
private Integer typesId;
public String getFileName() {return fileName;}
public void setFileName(String fileName) {this.fileName = fileName;}
public String getWjwz() {return wjwz;}
public void setWjwz(String wjwz) {this.wjwz = wjwz;}
public String getFileUrl() {return fileUrl;}
public void setFileUrl(String fileUrl) {this.fileUrl = fileUrl;}
public Integer getFileSzie() {return fileSzie;}
public void setFileSzie(Integer fileSzie) {this.fileSzie = fileSzie;}
public String getFilelx() {return filelx;}
public void setFilelx(String filelx) {this.filelx = filelx;}
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 String getFx() {return fx;}
public void setFx(String fx) {this.fx = fx;}
public Integer getCustomerId() {return customerId;}
public void setCustomerId(Integer customerId) {this.customerId = customerId;}
public Integer getTypesId() {return typesId;}
public void setTypesId(Integer typesId) {this.typesId = typesId;}
}

公告javaBean创建语句如下:


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

//公告
public class Gg  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//标题
private String title;
//图片
private String pic;
//内容
private String content;
//日期
private Date showDate;
public String getTitle() {return title;}
public void setTitle(String title) {this.title = title;}
public String getPic() {return pic;}
public void setPic(String pic) {this.pic = pic;}
public String getContent() {return content;}
public void setContent(String content) {this.content = content;}
public Date getShowDate() {return showDate;}
public void setShowDate(Date showDate) {this.showDate = showDate;}
}

文件类型javaBean创建语句如下:


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

//文件类型
public class Types  extends BaseBean{
//主键
private Integer id;
public Integer getId() {return id;}
public void setId(Integer id) {this.id = id;}
//文件类型
private String typesName;
public String getTypesName() {return typesName;}
public void setTypesName(String typesName) {this.typesName = typesName;}
}

评论