9iAS_DEV.PDF

Size: px

Start display at page:

Download "9iAS_DEV.PDF"

せとかうづき
4 years ago
Views:

1 Oracle9i Application Server for Windows NT

2 1 PL/SQL PL/SQL Web Toolkit Database Access Descriptor PL/SQL PL/SQL PL/SQL SERVLET Servlet Servlet Servlet Servlet ORACLE JSP Oracle JSP Oracle JSP Oracle JSP

3 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

4 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

5 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 <logfile> SQL>@owaload.sql owaload.log <logfile> owaload.sql 5

6 1.3 Database Access Descriptor PL/SQL Web Toolkit DAD (Database Access Descriptor) DAD Oracle9i Application Server Oracle9i Application Server Database Access Descriptor URL <Port>)/<Virtual path>/ admin_/dadentries.htm <Virtual path> pls : DAD 6

7 DAD Database Access Descriptor ( ) Oracle ( ) Oracle ( ) Oracle ( ) 7

8 DAD [ ] [ ] DAD 1.4 PL/SQL Oracle PL/SQL PL/SQL Web Toolkit PL/SQL KeyWeb Creator WebDB SQL*Plus 8

9 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

10 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 path> /<DAD>/<Procedure> <Virtual path> pls 10

11 helloplsql PL/SQL sample.main <Package>.<Procedure> 11

12 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

13 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

14 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

15 > 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

16 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

17 path>/<class> <Virtual path> servlets Servlet Servlet Oracle9i Application Server [ ] [ ] [Oracle-<Oracle >] [Oracle HTTP Server] [Start HTTP Server powered by Apache] Servlet Java HelloServlet Servlet 17

18 2.4 Servlet Servlet HTTP HTML 1 Oracle JDBC Web Servlet Oracle JDBC Thin Driver JDBC2.0 Connection Pooling Servlet Oracle Connection Pooling 2 JServ Servlet JServ JServ JServ 3 EJB Enterprise JavaBeans EJB 18

19 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

20 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 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

21 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 <Virtual Path>/<File>.jsp JSPsample.jsp JSP 21

22 Oracle JSP 3.2 Oracle JSP Oracle JSP Oracle9i Application Server [ ] [ ] [Oracle-<Oracle >] [Oracle HTTP Server] [Start HTTP Server powered by Apache] URL <Virtual Path>/<File>.jsp JSPsample.jsp JSP 22

23 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

24 <jsp:userbean id= count class= oracle.jsp.jml.number scope= application /> 2 JSP Oracle Bean Web 3 /EJB Bean JSP Bean EJB 24

25 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

26 Oracle Oracle8 Oracle8i Oracle9i Net8 26

橡9iAS_DEV.PDF

橡9iAS_DEV.PDF 1.0.2.1.0 2001.6.1 Oracle9i Application Server for Windows NT 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...9 1.5 PL/SQL...11 1.6 PL/SQL...12 1.7 PL/SQL...18