🗄 Manipulating Data Reading Database 📚

_{· Execution of a query to the database ·}

📚 Fundamentals

The software available in this repository allows the display of a simple table with the information of certain persons and also shows the principal e-mail domains most used in the world, reading the set of e-mail addresses from a file and storing it in a local database specified by an URL.

👨🏻‍💻 Implementation

The development of this practice consists of the creation of a simple table with an id, name and job position for certain famous persons and insert into a table information of existing domains from an e-mail provider, representing it by using a simple table. The software consists of three versions where the Java SQL library are used to read the data from a database.

1️⃣ First version:

The first version of this software introduces the connection with a local database through the file named Kata5.db, that represents the local database. After the connection to this mentioned database, a query of all the data stored in it, is performed.

2️⃣ Second Version:

The second version of this software takes advantage of the implementation of the connection to a local database made in the first version, and adds the possibility of creating a table with a specified name and fields in the specified database using the SQL language.

⚠️ Notice: The table will be created empty, with no contained data.

3️⃣ Third Version:

The third version of this software takes advantage of the implementations developed in the first and second versions and introduces the ability to insert data into the specified table using SQL statements.

💾 Expected Outputs

The results of running each of the implemented versions can be found here.

🚀 Build the project

1. Clone the repository using git with git clone https://github.com/BrianSuarezSantiago/Manipulating-Data-Reading-Database-P1.git command or download from Source Code.

2. Move to the directory where you have the code.

3. Compile using javac -d . *.java command followed by the java database.Main command to run and use the available software.

---

Made with ♥️ in Spain