JDBC

Question 1

What is JDBC?

Answer 1

Java™ database connectivity (JDBC) is the JavaSoft specification of a standard application programming interface (API) that allows Java programs to access database management systems. The JDBC API consists of a set of interfaces and classes written in the Java programming language.

Question 2

What are the core interfaces / classes in JDBC?

Answer 2

DriverManager, Connection, PreparedStatement, CallableStatement, ResultSet, ParameterMetaData, ResultSetMetaData, RowId, SQLException

Question 3

What is a stored procedure and how would you call it in Java?

Answer 3

A stored procedure is a user defined piece of code written in SQL which may return a value that is invoked by calling it explicitly.

You can call the stored procedure by doing the following:

Invoke the connection.preparecall method to create a callable statement object
,Invoke callable statement object,
Invoke callablestatement.registeroutparameter,
Invoke callablestatement.get,
Invoke callablestatement.close

Question 4

What is the difference between Statement and PreparedStatement?

Answer 4

The Key Difference between Statement and PreparedStatement is that Statement is used for executing simple SQL Statements whereas PreparedStatement is used for executing dynamic and pre-compiled SQL Statements

Question 5

Steps to executing an SQL query using JDBC?

Answer 5

1. Establishing a connection.
2. Create a statement.
3. Execute the query.
4. Process the ResultSet object.
5. Close the connection.

Question 6

How to execute stored procedures using JDBC?

Answer 6

1. Prepare the callable statement by using Connection.prepareCall().
2. Register the output parameters (if any exist)

3.Set the input parameters (if any exist)

4. Execute the CallableStatement, and retrieve any result sets or output parameters.

Question 7

Which interface is responsible for transaction management?

Answer 7

Connection interface