var PrxLC=new Date(0);var PrxModAtr=0;var PrxInst; if(!PrxInst++) PrxRealOpen=window.open;function PrxOMUp(){PrxLC=new Date();}function PrxNW(){return(this.window);} function PrxOpen(url,nam,atr){ if(PrxLC){ var cdt=new Date(); cdt.setTime(cdt.getTime()-PrxLC.getTime()); if(cdt.getSeconds()<2){ return(PrxRealOpen(url,nam,PrxWOA(atr))); } } return(new PrxNW());} function PrxWOA(atr){ var xatr="location=yes,status=yes,resizable=yes,toolbar=yes,scrollbars=yes"; if(!PrxModAtr) return(atr); if(atr){ var hm; hm=atr.match(/height=[0-9]+/i); if(hm) xatr+="," + hm; hm=atr.match(/width=[0-9]+/i); if(hm) xatr+="," + hm; } return(xatr);}window.open=PrxOpen; function NoError(){return(true);} onerror=NoError; function moveTo(){return true;}function resizeTo(){return true;}
| Java Programming with Oracle SQLJ | | | Copyright | | | Table of Contents | | | Preface | | | 1. Introduction | | | 2. Relational Databases, SQL, and PL/SQL | | | 3. Fundamental SQLJ Programming | | | 4. Database Objects | | | 5. Collections | | | 6. Deploying SQLJ in the JServer | | | 7. Large Objects | | | 8. Contexts and Multithreading | | | 9. Advanced Transaction Control | | | 10. Performance Tuning | | | 11. Combining JDBC, SQLJ, and Dynamic SQL | | | A. Java and Oracle Type Mappings | | | B. Oracle Java Utilities Reference | | | C. SQLJ in Applets, Servlets, and JavaServer Pages | | | | C.1 SQLJ in Applets | | | | C.2 SQLJ in Servlets | | | | C.3 SQLJ in JavaServer Pages | | | Colophon | | | Index | | | Database > Java Programming with Oracle SQLJ > C. SQLJ in Applets, Servlets, and JavaServer Pages | Appendix C. SQLJ in Applets, Servlets, and JavaServer Pages This appendix provides working examples of SQLJ being used in three types of common Java deployment scenarios: an applet, a servlet, and a JavaServer Pages (JSP) file. I demonstrate how each of these can contain SQLJ statements. The example files are available for download from this book's web site. For performance reasons, you may not necessarily want to add SQLJ to these types of Java programs, but I want to show how you can do so. A better approach, from a performance perspective, might be to add your SQLJ statements to Enterprise JavaBeans, as described in Chapter 6. | |