Скачать или смотреть JDBC, Statement interface. JDBC-Ep:3

Hi,
Hope you are all doing great. Let's learn together.
Join Telegram: 📲 https://t.me/contactajoydebnath

Chapters ❤
0:00 Introduction
03:30 Theory
07:52 Statement Interface Theory
11:00 Code Implementation


Note:
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.

Video Links:
Core Java Playlist:
   • Core Java  

Spring Playlist:
   • Spring Framework  

Video Link:
JDBC established a connection with the database. --    • JDBC, established connection with database...  
JDBC, DatabaseMetaData interface. --    • JDBC, DatabaseMetaData interface. JDBC-Ep:...  

Document Link -
https://docs.google.com/document/d/1i...
https://docs.google.com/document/d/1U...


Like, Comment, Share, and Subscribe.
Thank you again.

Eclipse Download
https://www.eclipse.org/downloads/pac...

JDK Link:
https://www.oracle.com/java/technolog...

MySQL Connector JAR
https://mvnrepository.com/artifact/my...

MySQL Installer
https://dev.mysql.com/downloads/insta...


JDBC
The JDBC API is a Java API that can access any kind of tabular data, especially data stored in a relational database.

Tabular Data: A tabular database, as the name implies is a database that is structured in a tabular form. It arranges data elements in vertical columns and horizontal rows. Each cell is formed by the intersection of a column and a row.

JDBC helps you to write Java applications that manage these three programming activities:

1. Connect to a data source, like a database
2. Send queries and update statements to the database
3. Retrieve and process the results received from the database in answer to your query

Connection Interface:
A Connection is a session between a Java application and a database. The Connection interface is a factory of Statement, PreparedStatement, and DatabaseMetaData i.e. object of Connection can be used to get the object of Statement and DatabaseMetaData. The Connection interface provides many methods for transaction management like commit(), rollback(), etc.

DatabaseMetaData:
DatabaseMetaData interface provides methods to get metadata of a database such as database product name, database product version, driver name, name of total number of tables, name of total number of views etc.

Statement
The JDBC statement is used to execute queries against the database. The statement is an interface that provides the methods to execute queries. We can get a statement object by invoking the createStatement() method of the Connection interface.
1. execute(String SQL): It is used to execute SQL DDL statements.
2.executeUpdate(String SQL): It is used to execute the query like insert, update, delete, etc. It returns the no. of affected rows.
3.executeQuery(String SQL): It is used to execute the select query and returns an object of ResultSet.