Chapter 10: JDBC

Question 1

Enumerate the four interfaces in JDBC

Answer 1

Connection, Driver, Statement, ResultSet

Question 2

Parts of JDBC URL

Answer 2

: :

jdbc:oracle:thin:@192168.1.18:1521:orcl

Question 3

what is Class.forName() method for?

Answer 3

It loads the class and throws ClassNotFoundException if the class is not available.

Question 4

Two ways to create a statement?

Answer 4

conn. createStatement() and

conn. createStatement(ResultSet type, ResultSet concurrency)

Question 5

ResultSet type, You can go through the data once in the order in which it was retrieved.

Answer 5

ResultSet.TYPE_FORWARD_ONLY

Question 6

ResultSet Type, Allows you to move forward and backward to the resultSet but the result set is static.

Answer 6

ResultSet.TYPE_SCROLL_INSENSITIVE

Question 7

ResultSet Type, Allows you to move backward and forward in the ResultSet but you see the latest data when scrolling

Answer 7

ResultSet.TYPE_SCROLL_SENSITIVE Not many database driver and database support this feature.

Question 8

ResultSet Concurrency Mode, you cannot update the result set.

Answer 8

ResultSet.CONCUR_READ_ONLY

Question 9

ResultSet Concurrency Mode, you can update the result set.

Answer 9

ResultSet.CONCUR_UPDATABLE

Question 10

statement method, you can execute a query or update statement and it will return a boolean if there is a result set.

Answer 10

statement.execute(“Query”);

Question 11

statement method, executes a query and returns a result set

Answer 11

statement.executeQuery(“Query”);

Question 12

statement method, executes an update, delete, and insert. returns how many rows are affected.

Answer 12

statement.executeUPdate(“Query”);

Question 13

9 get methods in ResultSet.

Answer 13

getBoolean
getDate
getDouble
getInt
getLong
getObject
getString
getTime
getTimeStamp