JAVA_and_PLSQL ( 33 )汇.pptVIP

copyright 2004 all rights reserved JAVA PL/SQL For Oracle RDBMS (8i 9i) By Joel A. Thompson (joel@) 05/2004 INTRODUCTION Joel A. Thompson 15 years of industry experience Consultant: Architecture, Software Engineering and Project Manager Java and Oracle expert OVERVIEW Basics of PLSQL Optimizing RDBMS Calls from JAVA Return Values Cursors Logic processing on Server, ARRAY inserts And more … Examples WRAP UP / QA Getting Started with Java Must install a JDK IDE JDK (Java Developers Kit) from Sun /j2se/1.4/index.html IDE (Integrated Developers Environment) Oracle’s JDeveloper () IntelliJ: () Textpad: Getting Started with Oracle Server Install Oracle (Steps) Download/Install from Create the database, use Oracles Database Configuration Assistant. Make sure network listeners are started – typically your instance will be available on port 1525 – use Oracles Net Configuration Assistant, to configure a Listener. Client Requirement Copy the $ORACLE_HOME/jdbc/lib/classes12.jar to your client sides CLASSPATH. Connect string example (thin driver) – requires no client side libraries: jdbc:oracle:thin:joel/welcome@localhost:1521:UCDBA Client Server Java/PLSQL Architecture What is PL/SQL? A programming language If/then/else Loops Function calls Transactional Procedural Feature rich Performance Gain Oracle only Some Good Reasons to use PL/SQL Basically youd like to do some logic on the server side in one call to the database Transaction support within the PL/SQL Temporary table queries/inserts to filter data further before returning result set Take advantage of server side resources while processing you PL/SQL – send message out through Oracles Advanced Queuing. Distributed Computing – update another database… You want to abstract your database layer into Oracle, such that you can change the tables or columns around without affecting the client program. Ways to call PL/SQL ADHOC Send the PL/SQL block of code from the client java program to the server for processing. F