Java畢業設計_基於MySQL網盤管理系統的設計與實現

bishe_teacher發表於2020-12-05
JavaMySql

基於MySQL網盤管理系統的設計與實現 _部分原始碼分享

基於MySQL網盤管理系統的設計與實現mysql資料庫建立語句
基於MySQL網盤管理系統的設計與實現oracle資料庫建立語句
基於MySQL網盤管理系統的設計與實現sqlserver資料庫建立語句
基於MySQL網盤管理系統的設計與實現spring+springMVC+hibernate框架物件(javaBean,pojo)設計
基於MySQL網盤管理系統的設計與實現spring+springMVC+mybatis框架物件(javaBean,pojo)設計
高質量程式設計視訊：shangyepingtai.xin
基於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’);
SQLCopy
使用者表建立語句如下：

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 ‘使用者’;
SQLCopy
檔案表建立語句如下：

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 ‘檔案’;
SQLCopy
公告表建立語句如下：

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 ‘公告’;
SQLCopy
檔案型別表建立語句如下：

create table t_types(
id int primary key auto_increment comment ‘主鍵’,
typesName varchar(100) comment ‘檔案型別’
) comment ‘檔案型別’;
SQLCopy
基於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 ‘超級管理員’;
SQLCopy
使用者表建立語句如下：

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 ‘使用者’;
SQLCopy
檔案表建立語句如下：

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 ‘檔案’;
SQLCopy
公告表建立語句如下：

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 ‘公告’;
SQLCopy
檔案型別表建立語句如下：

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 ‘檔案型別’;
SQLCopy
oracle特有，對應序列如下：

create sequence s_t_customer;
create sequence s_t_fileup;
create sequence s_t_gg;
create sequence s_t_types;
SQLCopy
基於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’);
SQLCopy
使用者表建立語句如下：

–使用者表註釋
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)–是否管理員
);
SQLCopy
檔案表建立語句如下：

–檔案表註釋
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–檔案型別
);
SQLCopy
公告表建立語句如下：

–公告表註釋
create table t_gg(
id int identity(1,1) primary key not null,–主鍵
title varchar(100),–標題
pic varchar(100),–圖片
content varchar(100),–內容
showDate datetime–日期
);
SQLCopy
檔案型別表建立語句如下：

–檔案型別表註釋
create table t_types(
id int identity(1,1) primary key not null,–主鍵
typesName varchar(100)–檔案型別
);
SQLCopy
基於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;}
}
JavaCopy
檔案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;}
}
JavaCopy
公告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;}
}
JavaCopy
檔案型別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;}
}
JavaCopy
基於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;}
}
JavaCopy
檔案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;}
}
JavaCopy
公告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;}
}
JavaCopy
檔案型別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;}
}
JavaCopy

相關文章