Learn Programming

Lets first start with some basics of MongoDB. What is MongoDB? MongoDB is document-oriented NoSQL database. This is a collection of documents where data is stored in the form documents, unlike old SQL systems where data is stored in the form of tables. Here each document consists of the key-value pairs which are the building block of the NoSQL database. The data is stored in documents in the key-value pairs.  example: { "first_name":"Ambarish", "last_name" :"Dashora" } So basically the data is stored in the JSON format called documents in MongoDB. Now we are here to connect, create, access, and modify collections and documents of MongoDB using java. So let's get started. First of all, we will learn how to set up a MongoDB client driver for java. I am assuming that you have installed MongoDB on your system. If not then download and install it from this link:   MongoDB . Get M...

'DerbyDB Creator' is a SQL scripting tool with Graphical User Interface for Apache derby databases.  Apache derby is an RDBMS (Relational Database Management System)  developed by the  Apache Software Foundation  that can be embedded in  Java  programs.   The core of the technology, Derby's database engine, is a full-functioned relationally embedded database-engine, supporting JDBC  and SQL  as programming APIs. Before we move further Have a look at this video which shows the functioning of DerbyDB Creator 1) What is DerbyDB Creator? DerbyDB Creator as a Graphical User Interface to access databases of apache derby and modify the databases by providing various SQL commands for the apache derby database. It is a replacement for 'ij' command-line tool of Apache org. This application has been created using JDBC(Java Database Connectivity) and the interface is cr...

JDBC -Java Database Connectivity  As the name suggests  It is an  API  that enables us to connect to our databases using java. Using this we can connect, add, update, delete, select -tables,columns,rows,databases i.e. In short we can do everything, we want to do with our databases using java. Now, I won't much talk about the theory, I will help you to understand - how you can apply it. But don't worry I assure you that everything I  have shown here will give you complete understanding about JDBC and after reading this blog you will be able to implement it in any of your projects. So let's begin this. Get the driver for MySQL : To start with MySQL  you will first need a jdbc driver for MySQL, it is called as 'MySQL connector ' . You can find it on this link:   MySQL JDBC Connector Choose the connector of your MySQL version. And choose OS  'platform-indepen...