20th Day @ Apex: JDBC

-
Hi Readers,
I have created my project a bit. I created my whole GUI now I have To Connnect This GUI with database to store information which is given by user.

This will be done by JDBC
JDBC stands for Java Database Connectivity. JDBC is a Java API to connect and execute the query with the database. It is a part of JavaSE (Java Standard Edition). JDBC API uses JDBC drivers to connect with the database. There are four types of JDBC drivers:

JDBC-ODBC Bridge Driver,
Native Driver,
Network Protocol Driver, and
Thin Driver
We have discussed the above four drivers in the next chapter.

We can use JDBC API to access tabular data stored in any relational database. By the help of JDBC API, we can save, update, delete and fetch data from the database. It is like Open Database Connectivity (ODBC) provided by Microsoft.

JDBC (Java Database Connectivity)

Why Should We Use JDBC
Before JDBC, ODBC API was the database API to connect and execute the query with the database. But, ODBC API uses ODBC driver which is written in C language (i.e. platform dependent and unsecured). That is why Java has defined its own API (JDBC API) that uses JDBC drivers (written in Java language).

We can use JDBC API to handle database using Java program and can perform the following activities:

Connect to the database
Execute queries and update statements to the database
Retrieve the result received from the database.

Comments

Post a Comment

Thank you!

Popular posts from this blog

How to add Internet download manager extension in the Chrome browser

-
Image
Internet download manager  is an important tool to download youtube videos and also it improves the downloading speed. It is helpful to download any file over the internet with huge speed. Now I am going to show you how we can add an extension of the IDM in chrome. Actually, It is very simple to do. What we have to do is just copy a file and paste to the chrome. steps: 1. open the folder 2. On the other hand, open the Chrome browser and click on  three dots  on the right. 3. Look for the  more tools  and click on the  extension 4. Drag  IDMGCExt.crx  from the folder and drop to the extension of chrome. Now you are able to download youtube videos. Enjoy the downloading! If you liked it then please subscribe and share this article.
Read more

A Day in Noida: Learning Begins

-
Image
Today was my first day in Apex Pvt Ltd and I have learnt the basic elements of Java. These elements are given below: 1. What are the uses of println() and printf? Ans: println( )  prints a new blank line and then your message.  printf() provides string formatting similar to the printf function in C .  printf() is primarily needed when you need to print big strings to avoid string concatenation in println() which can be confusing at times (Although both can be used in almost all cases). Eg. int a = 10;int b = 20;  println("a: " + a + " b: " + b);      //Tedious String Concatenation printf("a: %d b: %d\n", a, b);     // Output using string formatting.  While printf() enables you to print fractional outputs up to any decimal place in a single line, the same task using println() can get very complex. 2. What is the use of Java? Ans: Java is a programming language that developers use to create applications on your computer. Chance
Read more

Python Deciding factor

-
Image
Decision making is anticipation of conditions occurring while execution of the program and specifying actions taken according to the conditions. Decision structures evaluate multiple expressions which produce TRUE or FALSE as outcome. You need to determine which action to take and which statements to execute if outcome is TRUE or FALSE otherwise. Following is the general form of a typical decision making structure found in most of the programming languages − Python programming language assumes any  non-zero  and  non-null  values as TRUE, and if it is either  zero  or  null , then it is assumed as FALSE value.
Read more