Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Book Image

JDBC 4.0 and Oracle JDeveloper for J2EE Development

Overview of this book

Table of Contents (20 chapters)
JDBC 4.0 and Oracle JDeveloper for J2EE Development
Credits
About the Author
About the Reviewer
Preface

Setting the Environment


The org.apache.poi.hssf.usermodel package classes are required to generate an Excel spreadsheet. Download the Apache POI library's poi-bin-3.0.2-FINAL-20080204.zip file from http://www.apache.org/dyn/closer.cgi/poi/ and extract the ZIP file to an installation directory. Install JDeveloper 10g (10.1.3). Install the Oracle database 10g including sample schemas. Create a database instance. Create an example database table from which an Excel spreadsheet will be generated. The SQL script to create example table Catalog is listed as follows:

CREATE TABLE OE.Catalog(CatalogId VARCHAR(25), Journal VARCHAR(25),
Publisher Varchar(25),Edition VARCHAR(25), Title Varchar(255),
Author Varchar(25));
INSERT INTO OE.Catalog VALUES('catalog1', 'Oracle Magazine',
'Oracle Publishing', 'March-April 2005', 'Starting with Oracle ADF
', 'Steve Muench');
INSERT INTO OE.Catalog VALUES('catalog2', 'Oracle Magazine',
'Oracle Publishing','Jan-Feb 2005', 'Understanding Optimization',
'Kimberly...