Question

Write a program using JDBC to display all the records from supplier table(supno, supname, city). (java)​

Answer 1

Answer:

It can be of two types namely structural and non-structural database. The structural database is the one which can be stored in row and columns. A nonstructural database can not be stored in form of rows and columns for which new concepts are introduced which would not be discussing here. Most of the real-world data is non-structural like photos, videos, social media. As they are not having pre-defined data-types, so they are not present in the database. Hence, the structural database is stored in data warehouses and unstructured in data lakes. Java Database Connectivity is basically a standard API(application interface) between the java programming language and various databases like Oracle, SQL, PostgreSQL, MongoDB, etc. It connects the front end(for interacting with the users) with the backend for storing data

JDBC consists of 7 elements that are known as connection steps. They are listed below:

Attention reader! Don’t stop learning now. Get hold of all the important Java Foundation and Collections concepts with the Fundamentals of Java and Java Collections Course at a student-friendly price and become industry ready. To complete your preparation from learning a language to DS Algo and many more,  please refer Complete Interview Preparation Course.

JDBC connection steps   Sep/Connection Number

1 Import the package 

2 Load and Register the drivers 

3 Establish the connection 

4 Create the statement 

5 Execute the statement 

6 Process Result

7 Close/terminate

The syntax for importing package to deal with JDBC operations:

Explanation:

Hope it will help you