4.2 JDBC APPLICATION FUNDAMENTALS As we discussed in Section 3.1 in Chapter 3, to run a Java database application to perform data actions against the selected database, the JDBC API
Getting Connected – JDBC Applications and Design ConsiderationsGetting Connected – JDBC Applications and Design Considerations
4.2.2 Getting Connected To establish a connection to the desired database, two methods can be used: Before we can take a closer look at these two methods, first let’s have
Using the Driver.connect() Method – JDBC Applications and Design ConsiderationsUsing the Driver.connect() Method – JDBC Applications and Design Considerations
4.2.2.3 Using the Driver.connect() Method The Driver.connect() method enables you to create an actual connection to the desired data-base and returns an associated Connection object. This method accepts the database
Establish a Database Connection – JDBC Applications and Design ConsiderationsEstablish a Database Connection – JDBC Applications and Design Considerations
4.2.2.5 Establish a Database Connection Now we have a clear picture and understanding of the fundamentals in the DriverManager and Driver classes as well as the related database connection methods.
Executing Statements 2 – JDBC Applications and Design ConsiderationsExecuting Statements 2 – JDBC Applications and Design Considerations
CallableStatement is also a subclass of the Statement and the PreparedStatement classes, and it is mainly used to execute stored procedures with both IN and OUT parameters. As we know,
Executing Statements – JDBC Applications and Design ConsiderationsExecuting Statements – JDBC Applications and Design Considerations
4.2.3 Executing Statements To successfully execute an appropriate Statement object to perform Oracle statements, the following operational sequence should be followed: 1) Creating a Statement object based on the requirements
Using the Statement Object – JDBC Applications and Design ConsiderationsUsing the Statement Object – JDBC Applications and Design Considerations
4.2.3.2 Using the Statement Object As we discussed in the last section, three separate statement objects can be created based on three different data actions: Statement, PreparedStatement and CallableStatement. Let’s
Creating the PreparedStatement Object – JDBC Applications and Design ConsiderationsCreating the PreparedStatement Object – JDBC Applications and Design Considerations
4.2.3.3.1 Creating the PreparedStatement Object Refer to Table 4.3. The prepareStatement() method defined in the Connection interface is used to create a PreparedStatement object. Example code to create a PreparedStatement
Executing the PreparedStatement Object – JDBC Applications and Design ConsiderationsExecuting the PreparedStatement Object – JDBC Applications and Design Considerations
4.2.3.3.4 Executing the PreparedStatement Object As we discussed in Section 3.3.2 in Chapter 3, three execution methods can be called to perform the data action against the database. Refer to
Using the CallableStatement Object – JDBC Applications and Design ConsiderationsUsing the CallableStatement Object – JDBC Applications and Design Considerations
4.2.3.4 Using the CallableStatement Object As we discussed in the early part of this chapter, CallableStatement is a subclass of both Statement and PreparedStatement, and this interface is mainly used