Lecture 5.1

Question 1

What is JDBC

Answer 1

Java Database Connnectivity: JDBC is a standard API specification developed in order to move data from frontend to the backend.

Question 2

Describe java.sql.connection

Answer 2

Represents a connection from the Java program to the external database system

Question 3

Describe java.sql.statement

Answer 3

Used to issue raw SQL statements to a relational database. Statement interface cannot accept parameters and useful when you are using static SQL statements at runtime.

Question 4

Describe java.sql.PreparedStatement

Answer 4

Used to issue precompiled SQL statements to a relational database. The PreparedStatement interface accepts input parameters at runtime

Question 5

Describe java.sql.ResultSet

Answer 5

Represents the results returned from a relational database after an SQL statement has been processed