Concurrent Collections and Maps-OCP Oracle Certified Professional

Month: August 2022

Creating and Executing SQL Statements – Database Connectivity

By - Rachel Morse
Posted on 2022-08-262024-08-19

24.4 Creating and Executing SQL Statements The JDBC API defines three interfaces that represent SQL statements: The result of executing a SELECT statement is a table of rows represented by the following interface: All statements are created using a previously initialized JDBC connection object. A statement is created using one of the methods of the

Creating and Executing SQL Statements 2 – Database Connectivity

By - Rachel Morse
Posted on 2022-08-252024-08-19

When calling the execute() method with a SQL statement as a String parameter, it might not be possible to know a priori what type of SQL statement will be executed. However, this method would return true if the statement happens to be a SELECT query; otherwise, it returns false. As shown in the code below,