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 vote349 views1 answer
Java ordenar numeros ascendente
Java
0 vote450 views1 answer
Spring boot get bean
Java Spring
1 vote399 views1 answer
Java Pair
Java
7 votes358 views2 answers
Check if string contains numbers
Java
0 vote359 views1 answer
Java code to get all leaf nodes of a xml
Java
0 vote378 views1 answer
Javafx polygon
Java
0 vote370 views1 answer
Java set get all not containing
Java
2 votes337 views1 answer
Java 8 list stream delete by name
Java
0 vote447 views1 answer
Spring boot MVC config
Java Spring
0 vote369 views1 answer
Can abstract method be protected, default, private
Java