This is the main page of the application. Otherwise, it redisplays the login.jsp page including a message. If authentication is successful, the page forwards the user to employees.jsp. This is a nonviewable page that handles the authentication of the user-supplied login details from login.jsp. The user name, password, and host information are validated and used to create the connection descriptor to log in to the database. This page allows users to log in to the application. It automatically forwards the user to the login page of the application, login.jsp. This is the starting page of the application. Getting meta information about the database and result setsĭefining integer constants used to identify SQL typesįigure 1-2 Web Pages in the Sample Applicationĭescription of "Figure 1-2 Web Pages in the Sample Application"Ī brief description of the Web pages in the sample application follows: Setting Oracle performance extensions for any statementīinding oracle.sql.* types into prepared and callable statements The key classes and interfaces of this package provide methods that support standard JDBC features and perform tasks such as: They also provide access to other Oracle-specific features, including Oracle performance enhancements. These extensions provide access to Oracle SQL-format data. The interfaces of the oracle.jdbc package define the Oracle extensions to the interfaces in the java.sql package. In addition to data type classes, the oracle.sql package supports classes and interfaces for use with objects and collections. Some of the classes are for JDBC 2.0-compliant data types. The characters are converted to Java chars and, then, to bytes in the UCS-2 character set.Each of the oracle.sql.* data type classes extends, a superclass that includes functions and features common to all the data types. Essentially, the classes act as Java wrappers for SQL data. This package consists primarily of classes that provide Java mappings to SQL data types and their support classes. The oracle.sql package supports direct access to data in SQL format. These packages support all Java Development Kit (JDK) releases from 1.5 through 1.6. Oracle support for the JDBC API is provided through the oracle.jdbc and oracle.sql packages. You can access the Oracle-specific JDBC features and the standard features by using the oracle.jdbc package. The Thin driver will work on any machine that has a suitable Java virtual machine (JVM). The driver supports the TCP/IP protocol and requires a Transparent Network Substrate ( TNS) listener on the TCP/IP sockets on the database server. The JDBC Thin Driver allows a direct connection to the database by providing a pure Java implementation of Oracle network protocols ( Two-Task Common, also known as the TTC protocol, and SQL*Net). The JDBC Thin Driver communicates with the server using SQL*Net to access Oracle Database. It is platform-independent and does not require any additional Oracle software for client-side application development. It supports the Java TM 2 Platform Standard Edition 5.0, also known as Java Development Kit (JDK) 5. The JDBC Thin Driver is a pure Java, Type IV driver. JDBC-OCI is only needed for OCI-specific features. Oracle recommends using the JDBC Thin Driver for most requirements.
0 Comments
Leave a Reply. |