Jdbc

Jdbc interface

-Connection = Helps our java project
connect to database

-Statement = Helps to write and execute SQL query

-ResultSet = A DataStructure where
the data from query result stored

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.

Jdbc dependency

<dependency>
<groupId>oracle</groupId>
<artifactId>ojdbc6</artifactId>
<version>11.2.0.3</version>
</dependency>

Jdbc

JDBC is an SQL-based API created by Sun Microsystems to enable 
Java applications to use SQL for database access.

Register the Driver class
Create connection
Create statement
Execute queries
Close connection

Similar codes

0 vote275 views1 answer
Os compatible java path separator
Java
1 vote282 views1 answer
How to create a variable java
Java
0 vote295 views1 answer
Java string get ith char
Java
0 vote288 views1 answer
Explain java coding standards for classes
Java
1 vote289 views1 answer
Java.io.IOException: Can't read fonts
Java
0 vote308 views1 answer
Document inserted succesfully but not present in the collection java
Java
-1 vote317 views3 answers
From file to array java
Java
0 vote287 views1 answer
AmazonS3ClientBuilder
Java
0 vote281 views1 answer
How to install java on ubuntu 18.0.4
Java
1 vote268 views1 answer
Data java
Java