4.2.3.4.2 Creating the CallableStatement Object To create a CallableStatement object, you need to use one of methods defined in the Connection class (refer to Table 4.3), prepareCall(). When SQL92 syntax
Executing the CallableStatement Object 2 – JDBC Applications and Design ConsiderationsExecuting the CallableStatement Object 2 – JDBC Applications and Design Considerations
Generally, the execute methods can be divided into two categories: 1) execute methods that need to perform a data query, such as executeQuery(), which returns an instance of ResultSet that
Executing the CallableStatement Object – JDBC Applications and Design ConsiderationsExecuting the CallableStatement Object – JDBC Applications and Design Considerations
4.2.3.4.5 Executing the CallableStatement Object To run a CallableStatement object, three execution methods can be used: executeQuery(), executeUpdate() and execute(). As we discussed in Section 4.2.3.1, the executeQuery() method can
Creating and Executing Oracle Statements – JDBC Applications and Design ConsiderationsCreating and Executing Oracle Statements – JDBC Applications and Design Considerations
4.2.3.6 Creating and Executing Oracle Statements Executing any execution method we discussed in the previous sections is exactly the same as exe-cuting a string representing an Oracle statement. In fact,
JDBC Escape Syntax – JDBC Applications and Design ConsiderationsJDBC Escape Syntax – JDBC Applications and Design Considerations
4.2.3.6.3 JDBC Escape Syntax When JDBC performs an Oracle statement, it does not check the Oracle grammar, and you can send any Oracle statement to your database. This gives you
Retrieving Results – JDBC Applications and Design ConsiderationsRetrieving Results – JDBC Applications and Design Considerations
4.2.4 Retrieving Results Based on the different Oracle statements, three execution methods can be used to run an associated Oracle statement. As we discussed in Section 4.2.3.1, each execution method
The ResultSet Interface – JDBC Applications and Design ConsiderationsThe ResultSet Interface – JDBC Applications and Design Considerations
4.2.4.1 The ResultSet Interface Data is stored in a ResultSet just as it is returned by the database: it is stored in tabular format. Each field of the database can
Getting and Processing the ResultSet Object 2 – JDBC Applications and Design ConsiderationsGetting and Processing the ResultSet Object 2 – JDBC Applications and Design Considerations
Figure 4.15a shows an initial cursor position of a ResultSet object in which an execution method has just completed and a ResultSet object is created. The cursor now points to
Getting and Processing the ResultSet Object – JDBC Applications and Design ConsiderationsGetting and Processing the ResultSet Object – JDBC Applications and Design Considerations
4.2.4.2 Getting and Processing the ResultSet Object When an Oracle data query is executed, the returned result is stored in a ResultSet object, and this ResultSet object can be created
Using JDBC MetaData Interfaces – JDBC Applications and Design ConsiderationsUsing JDBC MetaData Interfaces – JDBC Applications and Design Considerations
4.2.5 Using JDBC MetaData Interfaces In addition to general and popular data information provided by three statement interfaces and execution methods, JDBC also provides useful and critical information and descriptions