Basic data handling with Java, MySQL and MongoDB

Libraries needed:

• MySQL Connector 8.0.21
• MongoDB Java Driver 3.4.2
• MongoDB Java Driver Core 3.4.2

Given a database, this program is able to create a table pet if pet doesn't already exist.

mysql> describe pet;

Other features of the program:

• Show all rows in the table.
• Insert new row.
• Delete a row given parameters (key, value).
  • DELETE FROM pet WHERE key=value

Compared to MySQL, MongoDB is more flexible regarding handling data.

Given a database test, the program is able to:

• See all collections inside test.
• Read all documents inside one collection.
• Create a new collection.
• Insert documents into a collection.
• Remove a document from a collection.
• Drop an entire collection.