Hide Files in MySQL Database

This simple Java application allows you to hide local files in a MySQL database.

Prerequisites

You will need to have the following installed on your computer:

1. Java (I used 21)
2. MySQL Server (I used 8.0.35)
3. Apache Maven
4. Google-generated app password for sending emails (Not your regular google-account password)

My Development OS: Ubuntu 22.04

Maven Dependencies

The following dependencies are required for this project:

1. mysql-connector-java
2. javax.mail

Add these dependencies to your pom.xml file:

<dependencies>
    <!-- https://mvnrepository.com/artifact/mysql/mysql-connector-java -->
    <dependency>
        <groupId>mysql</groupId>
        <artifactId>mysql-connector-java</artifactId>
        <version>8.0.33</version>
    </dependency>

    <!-- https://mvnrepository.com/artifact/com.sun.mail/javax.mail -->
    <dependency>
        <groupId>com.sun.mail</groupId>
        <artifactId>javax.mail</artifactId>
        <version>1.6.2</version>
    </dependency>
</dependencies>

Note: Always check for the proper version of dependencies regarding your project.

Using the Project

1. Create the database using the following SQL command:

CREATE DATABASE fileHider;

Now switch to the database:

USE fileHider;

2. Create the following tables (users, data) in the database:

create table users
(
    id int primary key auto_increment,
    name varchar(100),
    email varchar(100) unique
);

create table data
(
    id int primary key auto_increment,
    name varchar(100),
    path varchar(255),
    email varchar(100),
    bin_data blob
);

3. If everything is done correctly, you should be able to run and use the project.

Running the Project

1. Clone the project to your computer
2. Open the project in your IDE
3. Run the "Main" class inside /src/main/java

About Me

I am Mohd Mohitur Rahaman, a tech geek pursuing a Master's in Computer Applications from KIIT, Bhubaneswar. With a deep passion for coding and a strong love for science & technology, I am dedicated to honing my skills and achieving proficiency as a developer.

Connect with me

• LinkedIn

Note: This project was inspired from Sheriyans Coding School YouTube channel. Video link - here