Oracle9i Application Server for Windows NT 1.0.2.0.0 2001.2.1 1
1 PL/SQL...3 1.1...3 1.2 PL/SQL Web Toolkit...5 1.3 Database Access Descriptor...6 1.4 PL/SQL...8 1.5 PL/SQL...10 1.6 PL/SQL...12 2 SERVLET...13 2.1 Servlet...14 2.2 Servlet...16 2.3 Servlet...17 2.4 Servlet...18 3 ORACLE JSP...19 3.1 Oracle JSP...20 3.2 Oracle JSP...22 3.3 Oracle JSP...23 4...25 2
1 PL/SQL Oracle9i Application Server Oracle HTTP HTTP mod_plsql Oracle PL/SQL HTML Oracle9i Application Server PL/SQL HTML create or replace procedure helloplsql is begin htp.htmlopen(); htp.headopen(); htp.title( SAMPLE ); htp.headclose(); htp.bodyopen(); htp.print( Hello World ); htp.bodyclose(); htp.htmlopen(); end; Oracle9i Application Server PL/SQL Web Toolkit htp HTML htp.htmlopen <HTML> htp.title <TITLE> </TITLE> HTML PL/SQL Toolkit htp.htmlopen() htp.p( <HTML> ) HTML htp.p HTML 1.1 PL/SQL Web Oracle PL/SQL Oracle Oracle 3
Oracle9i Application Server Oracle Net8 Net8 Oracle8 Oracle9i Application Server Net8 Oracle8i WindowsNT Oracle9i Application Server Net8 Net8 Net8 Configuration Assistant Net8 Assistant Oracle9i Application Server 4
1.2 PL/SQL Web Toolkit PL/SQL HTML PL/SQL Web Toolkit PL/SQL Web Toolkit htp [ ] Oracle9i Application Server Oracle Apache modplsql owa ( Oracle D: Oracle isuites D: Oracle isuites Apache modplsql owa ) > CD %ORACLE_HOME% Apache modplsql owa > CD Oracle isuites Apache modplsql owa SQL owaload.sql sqlplus PL/SQL Web Toolkit sys > sqlplus sys/( )@( ) > sqlplus sys/change_on_install@orcl SQL owaload.sql SQL> @owaload.sql <logfile> SQL>@owaload.sql owaload.log <logfile> owaload.sql 5
1.3 Database Access Descriptor PL/SQL Web Toolkit DAD (Database Access Descriptor) DAD Oracle9i Application Server Oracle9i Application Server Database Access Descriptor URL http://<hostname>( <Port>)/<Virtual path>/ admin_/dadentries.htm <Virtual path> pls : http://www.myhost.com/pls/admin_/dadentries.htm DAD 6
DAD Database Access Descriptor ( ) Oracle ( ) Oracle ( ) Oracle ( ) 7
DAD [ ] [ ] DAD 1.4 PL/SQL Oracle PL/SQL PL/SQL Web Toolkit PL/SQL KeyWeb Creator WebDB SQL*Plus 8
create or replace procedure helloplsql is begin htp.htmlopen(); htp.prn('<meta HTTP-EQUIV="Content-Type"'); htp.p(' CONTENT="text/html;charset=Shift_JIS">'); htp.headopen(); htp.title('sample'); htp.headclose(); htp.bodyopen(); htp.print('hello World<BR>'); htp.print(' <BR>'); htp.bodyclose(); htp.htmlclose(); end helloplsql; / Oracle9i Application Server Oracle9i Application Server PL/SQL sqlplus scott/tiger@orcl SQL>@helloplsql.sql SQL>exit 9
1.5 PL/SQL Oracle9i Application Server PL/SQL PL/SQL 1. Oracle9i Application Server Net8 Oracle 2. Oracle PL/SQL Web Toolkit 3. Net8 Oracle9i Application Server DAD 4. PL/SQL URL PL/SQL http://<hostname>(:<port>)/<virtual path> /<DAD>/<Procedure> <Virtual path> pls http://www.myhost.com/pls/orcl/helloplsql 10
helloplsql PL/SQL sample.main <Package>.<Procedure> 11
1.6 PL/SQL PL/SQL Oracle Oracle9i Application Server HTTP PL/SQL PL/SQL HTML 1 Oracle9i Application Server Oracle / DAD PL/SQL 12
2 Servlet Servlet API Oracle9i Application Server Oracle9i Application Server Servlet CGI import javax.servlet.*; import javax.servlet.http.*; Servlet Servlet API JDeveloper Suite import java.io.*; import java.util.*; public class HelloServlet extends HttpServlet { } // HTTP Get public void doget(httpservletrequest request, HttpServletResponse response) } throws ServletException, IOException { response.setcontenttype("text/html"); PrintWriter out = new PrintWriter(response.getOutputStream()); out.println("<html>"); out.print("<meta HTTP-EQUIV= "Content-Type ""); out.println(" CONTENT= "text/html;charset=shift_jis ">"); out.println("<head><title> Servlet</TITLE></HEAD>"); out.println("<body> Servlet</BODY>"); out.println("</html>"); out.close(); 13
Servlet HttpServletRequest HttpServletRequest Web HTTP URL HttpServletResponse HttpServletResponse Web HTTP getwriter HTML PrintWriter println HTML 2.1 Servlet Servlet JDeveloper Suite class Oracle9i Application Server Oracle JDeveloper Suite Servlet Oracle Jdeveloper Suite Java Servlet > <Drive> > CD <Directory> > C: > CD src servlet PATH Oracle9i Application Server Java 14
> set PATH=%ORACLE_HOME% Apache jdk bin;%path% > set PATH=D: Oracle isuites Apache jdk bin;%path% CLASSPATH Oracle9i Application Server JSDK(Java Servlet Development Kit) jar > set CLASSPATH=%ORACLE_HOME% Apache Jsdk lib jsdk.jar > set CLASSPATH=D: Oracle isuites Apache Jsdk lib jsdk.jar Java Java > javac <file>.java > javac HelloServlet.java HelloServlet.class 15
2.2 Servlet Oracle9i Application Server Servlet Oracle9i Application Server Java %ORACLE_HOME% Apache Jserv servlets D: Oracle isuites Apache Jserv servlets Servlet Java URL 16
http://<hostname>(:<port>)/<virtual path>/<class> <Virtual path> servlets http://www.myhost.com/servlets/helloservlet 2.3 Servlet Servlet Oracle9i Application Server [ ] [ ] [Oracle-<Oracle >] [Oracle HTTP Server] [Start HTTP Server powered by Apache] Servlet Java http://www.myhost.com/servlets/helloservlet HelloServlet Servlet 17
2.4 Servlet Servlet HTTP HTML 1 Oracle JDBC Web Servlet Oracle JDBC Thin Driver 8.1.6 JDBC2.0 Connection Pooling Servlet Oracle Connection Pooling 2 JServ Servlet JServ JServ JServ 3 EJB Enterprise JavaBeans EJB 18
3 Oracle JSP Oracle JavaServer Pages(Oracle JSP) Servlet API HTML Java Servlet HTML Oracle JSP Web JavaBeans JSP JavaBeans Oracle JSP <%@ page contenttype="text/html;charset=shift_jis" %> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=Shift_JIS"> <TITLE>,JSP </TITLE> </HEAD> <BODY> <H1>,JSP </H1> <%! String saying = ",JSP";%> <%! int counter = 0;%> <TABLE> <% for (counter=0;counter<3;counter++) { %> <TR> <TD><%= counter %></TD> <TD><%= saying %></TD> </TR> <% } %> </TABLE> </BODY> </HTML> 19
Oracle JSP Java HTML Oracle JSP HTML Java <% %> Oracle JSP.jsp Oracle JSP 1. Oracle9i Application Server JSP 2. JSP Oracle JSP Java Servlet 3. Java Servlet 4. 5. Oracle JSP Servlet 3.1 Oracle JSP.jsp ( JSPsample.jsp) <%@ page contenttype="text/html;charset=shift_jis" %> <HTML> <HEAD> <META HTTP-EQUIV="Content-Type" CONTENT="text/html;charset=Shift_JIS"> <TITLE>,JSP </TITLE> </HEAD> <BODY> <H1>,JSP </H1> <%! String saying = ",JSP";%> <%! int counter = 0;%> <TABLE> <% 20
for (counter=0;counter<3;counter++) { %> <TR> <TD><%= counter %></TD> <TD><%= saying %></TD> </TR> <% } %> </TABLE> </BODY> </HTML> JSP JSP %ORACLE_HOME% Apache jsp conf ojsp.conf D: Oracle isuites Apache jsp conf ojsp.conf JSP 1 Alias /<Virtual Path>/ <Directory>/ Alias /jsp/ D: Home jsp/ <Virtual Path>,<Directory> / JSP Alias URL JSP http://<hostname>(:<port>)/ <Virtual Path>/<File>.jsp http://www.myhost.com/jsp/jspsample.jsp JSPsample.jsp JSP 21
Oracle JSP 3.2 Oracle JSP Oracle JSP Oracle9i Application Server [ ] [ ] [Oracle-<Oracle >] [Oracle HTTP Server] [Start HTTP Server powered by Apache] URL http://<hostname>(:<port>)/ <Virtual Path>/<File>.jsp http://www.myhost.com/jsp/jspsample.jsp JSPsample.jsp JSP 22
3.3 Oracle JSP Oracle JSP 1 Oracle JSP Bean Oracle JSP ( ) Java int java.lang.integer, java.lang.string Java <% %> Java Oracle JSP Java 4 Bean Oracle.jsp.jml.JmlBooean: boolean Bean Oracle.jsp.jml.JmlInteger: Bean Oracle.jsp.jml.JmlDouble: Bean Oracle.jsp.jml.JmlString: Bean Oracle JSP Bean <jsp:usebean> Oracle JSP 0 count 23
<jsp:userbean id= count class= oracle.jsp.jml.number scope= application /> 2 JSP Oracle Bean Web 3 /EJB Bean JSP Bean EJB 24
4 Oracle9i Application Server Oracle Portal Oracle Portal Portal Developer's Kit API Java XML Oracle9i Application Server Oracle JDeveloper Oracle JDeveloper Oracle Java Java Business Components for Java GUI Key Web Creator Key Web Creator PL/SQL Web Web 25
Oracle Oracle8 Oracle8i Oracle9i Net8 26