Posts

Showing posts with the label Java

Java Data Base Connectivity (JDBC) with MongoDB

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...

PROJECT-2 Picture Modifier

Image
Picture Modifier Picture Modifier is a desktop application created using java. It is an image editor with various features to edit an image. This application has been made using inbuilt libraries of java and its user interface has been made using java swing and Java AWT. Before we move further here is the video which shows how this application works. Features of this Application: It can modify RGB (Red, blue, green) components of an image by sliding the bar of the intensity of each component. It can modify the contrast and brightness of the image. Using this we can zoom in and zoom out to resize the image and we can rotate an image by 360 degrees. There are various filters available for the image like Grayscale, negative image, pencil art, dot portrait, etc. How to install this application: Go to this GitHub repository:  Picture Editor - gitHub   Download the zip file of this and extract it to your desired folder. In the classes folder, there is a file named opencv_java420.ra...

PROJECT 1 DerbyDB Creator -SQL scripting tool for Apache Derby

Image
'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...

Java Database Connectivity (JDBC) with MySQL

Image
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...