#JDBC

Question count - 0     Last updated    - V4 (19-Dec-2024)

What transaction insulation levels are supported in JDBC

What parts is JDBC from

What is JDBC url

What are the advantages of using JDBC

What is the difference between Statement and PrepareDstate

What is Resultset

What is the difference between Execute, Executequary, Executeupdate

Why do we need Resultset

How to close the connection connection

How to cause a stored procedure

How is the database request and processing the results are carried out

How to register a jdbc driver

How can you install a connection with a database

How Resultset works inside

JDBC JDBC driver T1 JDBC-ODBC Drivers T2 Native API Drivers T3 Network Protocol Drivers T4 Native Protocol Drivers Transaction Management Batch Processing - addBatch(), executeBatch, clearBatch()

Java.sql.DriverManager (Class) Java.sql.Connection (Interface) Java.sql.Statement (Interface) Java.sql.PrepareStatement (Interface) Java.sql.CallableStatement (Interface) Java.sql.ResultSet (Interface) Java.sql.ResultSetMetaData (Interface) Java.sql.DatabaseMetaData (Interface) Java.sql.Date (Class) Java.sql.Time (Class) Java.sql.Blob (Interface) Java.sql.Clob (Interface)

executeQurey() vs executeUpdate() vs execute() Statement: Used to execute static SQL queries PreparedStatement: Used to execute dynamic or parameterized SQL queries CallableStatement: Used to execute stored procedures, cursors, and functions Statement vs PreparedStatement vs CallableStatement