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

16 votes307 views2 answers
Java shorthand if
Java
0 vote272 views1 answer
Build cmake gradle
Java
0 vote260 views1 answer
If else bedingungen java
Java
0 vote318 views1 answer
Spring boot maven run with profile
Java Spring
0 vote270 views1 answer
Return type of executebatch in java
Java
0 vote294 views1 answer
Programmatically click button javafx
Java
0 vote273 views1 answer
Error: Could not find or load main class mcp.client.Start Caused by: java.lang.ClassNotFoundException: mcp.client.Start
Java
0 vote268 views1 answer
Zweidimensionales array erstellen java
Java
0 vote266 views1 answer
Java array sortieren
Java
0 vote289 views1 answer
How to getobject from id in controlp5
Java