Oracle9i JDeveloper R9.0.3 チュートリアル

Size: px

Start display at page:

Download "Oracle9i JDeveloper R9.0.3 チュートリアル"

きょうすけかくはり
4 years ago
Views:

1 Oracle9i JDeveloper JavaServer Pages Creation Date: Jan. 27, 03 Last Update: Feb. 13, 03 Version: 1.0

2 JDeveloper JSP JSP... 5 JSP JDeveloper TLD Oracle9i Application Server Oracle9iAS WAR A: JDeveloper OC4J Web B: JDeveloper Oracle9i JDeveloper R9.0.3 JavaServer Pages 1

3 Oracle9i JDeveloper JDeveloper Java XML Web END-TO-END IDE JDeveloper J2EE 1.3 XML JavaServer Pages JSP Oracle9i Application Server Oracle9iAS JDeveloper JDeveloper OTN-J Oracle9i JDeveloper R9.0.3 Oracle9i Application Server R9.0.3 URL admin.jar java -version < > <JDEV_HOME> JDeveloper Windows UNIX Linux Oracle9i JDeveloper R9.0.3 JavaServer Pages 2

4 JDeveloper JSP JavaServer Pages JSP Servlet Java HTML Servlet JSP HTML XML Java JSP 1.1 Web Java JDeveloper Servlet 2.3 JSP 1.2 Web R9.0.3 T / HTTP JSP JSP JSP HTML T HTML/JSP TWeb UIX Jakarta Struts TJDeveloper Oracle9iAS Containers for J2EE OC4J Servlet T Servlet/JSP T Web web.xml TWAR T OC4J Oracle9i Application Server WebLogic Server Oracle SCOTT EMP JSP JSP JSP JSP JDeveloper OC4J OC4J Oracle9i JDeveloper R9.0.3 JavaServer Pages 3

5 JDBC JDeveloper Java JDBC Oracle JDBC 1/4: 2/4: 3/4: 4/4: JDBC / Oracle JDBC Thin/OCI Oracle SID TNS 1~3 Oracle SQL92 JDBC JDeveloper SCOTT Scott JDBC JDBC OTN-J Oracle9i JDeveloper R9.0.3 DataSource JDBC DataSource JDBC 2.0 Standard Extension API java.sql.drivermanager JDBC / DataSource Java Naming and Directory JNDI JNDI DriverManager DriverManager.registerDriver(new OracleDriver()); Connection conn = DriverManager.getConnection( "jdbc:oracle:thin:@localhost:1521:orcl","soctt","tiger"); Oracle9i JDeveloper R9.0.3 JavaServer Pages 4

6 DataSource + JNDI InitialContext ic = new InitialContext(); DataSource ds = (DataSource) ic.lookup("jdbc/scottds"); Connection conn = ds.getconnection(); JDeveloper JDBC DataSource OC4J JNDI Scott JDBC OC4J jdbc/scottds JNDI DataSource JSP JDeveloper JSP 1. JDeveloper tutorial_jsp.jws jsp.jpr OTN-J Oracle9i JDeveloper R jsp.jpr Web Tier JavaServer Pages JSP JSP 1 Oracle9i JDeveloper R9.0.3 JavaServer Pages 5

7 3. JSP OK JSP JSP emp.jsp 2 JSP 4. JSP emp.jsp Web web.xml JSP JDeveloper JSP JSP JSP JSP contenttype / JSP emp.jsp JSP JSP JSP Oracle9i JDeveloper R9.0.3 JavaServer Pages 6

8 3 JSP JSP taglib : <%@ page contenttype="text/html;charset=shift_jis"%> : <%! int = 0; %> : <%= new java.util.date() %> : <% System.out.println(); %> JSP : <jsp:getproperty name="beanname" property="propertyname"/> JSP : <jsp:include page="url"> </jsp:include> : <prefix:tag attr="value"/> : <prefix:tag attr="value"> </prefix:tag> JDeveloper JSP JavaServer Page Tag Editor OC4J OJSP SQL 3 Oracle9i JDeveloper R9.0.3 JavaServer Pages 7

9 dbopen dbquery dbclose JDBC URL / DataSource JNDI 1. emp.jsp 15 4 doopen 2. OJSP SQL dbopen 5 dbopen 3. JavaServer Page Tag Editor OK Oracle9i JDeveloper R9.0.3 JavaServer Pages 8

connid ID conn datasource DataSource JNDI jdbc/scottds JDBC Scott 6 JavaServer Page Tag Editor emp.jsp tablib dbopen JavaServer Page Tag Editor 4. dbopen dbquery 5.

10 connid ID conn datasource DataSource JNDI jdbc/scottds JDBC Scott 6 JavaServer Page Tag Editor emp.jsp tablib dbopen JavaServer Page Tag Editor 4. dbopen dbquery 5. JavaServer Page Tag Editor OK connid dbopen connid conn output 3 HTML HTML JDBC java.sql.resultset XML XML /XML DOM emp.jsp dbquery HTML 6. dbquery SELECT <database:dbquery connid="conn" output="html"> SELECT * FROM EMP </database:dbquery> 7. dbquery dbclose Oracle9i JDeveloper R9.0.3 JavaServer Pages 9

11 8. JavaServer Page Tag Editor connid conn dbopen connid OK emp.jsp dbclose JDeveloper J2EE / Oracle9iAS Containers for J2EE OC4J JSP emp.jsp emp.jsp OC4J OC4J Web OC4J Web A: JDeveloper 7 Oracle9i JDeveloper R9.0.3 JavaServer Pages 10

12 OC4J JDeveloper OC4J 2 a. OC4J b. Run Manager Run Manager OC4J 8 Run Manager Oracle9i JDeveloper R9.0.3 JavaServer Pages 11

13 JDeveloper javax.servlet.jsp.tagext Java TLD tld XML JDeveloper JSP TLD JSP JSP Tag Attribute Wizard JDeveloper username hello JDeveloper JSP emp.jsp TLD JDeveloper JSP TLD 1. tutorial_jsp.jws taglib.jpr 2. taglib.jpr 3. Web Tier JavaServer Pages JSP JSP Oracle9i JDeveloper R9.0.3 JavaServer Pages 12

14 4. JSP Welcome 9 JSP 5. JSP JSP URI JDeveloper TLD JSP tutorialtaglib tutorialtaglib Oracle9i JDeveloper R9.0.3 JavaServer Pages 13

10 JSP 6. JSP JSP 1.2 GIF JPEG 11 JSP JSP 1.2 7. JSP tutorialtaglib.tld web.xml taglib.

15 10 JSP 6. JSP JSP 1.2 GIF JPEG 11 JSP JSP JSP tutorialtaglib.tld web.xml taglib.deploy 3 taglib.jpr tutorialtaglib.tld <taglib> <tlib-version>1.0</tlib-version> <jsp-version>1.2</jsp-version> <short-name>tutorialtaglib</short-name> <uri>tutorialtaglib</uri> <description> </description> </taglib> Oracle9i JDeveloper R9.0.3 JavaServer Pages 14

16 JSP JSP TLD 1. taglib.jpr 2. tutorial.taglib tutorialtaglib.tld JSP 13 JSP Oracle9i JDeveloper R9.0.3 JavaServer Pages 15

17 4. JSP Welcome 14 JSP Welcome 5. JSP 1/3: hello HelloTag tutorial.taglib 3 Empty 1 JSP 2 tagdependent 3 Empty 1 2 JSP JSP HTML 3 JSP Oracle9i JDeveloper R9.0.3 JavaServer Pages 16

18 15 JSP 1/3: 6. JSP 2/3: Empty a. javax.jsp.tagext.tagsupport b. javax.jsp.tagext.tag TagSupport 16 JSP 2/3: 7. JSP 3/3: Oracle9i JDeveloper R9.0.3 JavaServer Pages 17

19 17 JSP 3/3: 8. JSP HelloTag.java tutorialtaglib.tld TLD 18 HelloTag.java tutorialtaglib.tld <tag> <name>hello</name> <tag-class>tutorial.taglib.hellotag</tag-class> <body-content>empty</body-content> <description> </description> <example> Snippet </example> </tag> TLD setter/getter JDeveloper JSP Tag Attribute Wizard TLD hello username Oracle9i JDeveloper R9.0.3 JavaServer Pages 18

20 1. HelloTag.java 19 JSP Tag Attribute Wizard 2. JSP Tag Attribute Wizard OK username JSP JSP Servlet String Oracle9i JDeveloper R9.0.3 JavaServer Pages 19

21 20 JSP Tag Attribute Wizard 3. JSP Tag Attribute Wizard HelloTag.java getusername() setusername() TLD username tutorialtaglib.tld <attribute> <name>username</name> <required>true</required> <rtexprvalue>false</rtexprvalue> </attribute> hello Empty dostarttag() dostarttag() dostarttag public int dostarttag() throws JspException { try { JspWriter out = pagecontext.getout(); out.println(" " + username + " "); } catch(exception e) { e.printstacktrace(); } return SKIP_BODY; } Oracle9i JDeveloper R9.0.3 JavaServer Pages 20

22 JDeveloper JDeveloper deploy JSP TLD JAR JAR taglib.deploy taglib.deploy JAR 21 JAR JAR taglib.deploy JAR JAR Oracle9i JDeveloper R9.0.3 JavaServer Pages 21

23 22 JAR JSP TLD URI OK TLD URI tutorialtaglib.tld JAR tutorialtaglib TLD tutorial 23 Oracle9i JDeveloper R9.0.3 JavaServer Pages 22

24 Tutorial jsp 24 Tutorial hello Tutorial Add JSP Tag Component(s) tutorial hello OK Oracle9i JDeveloper R9.0.3 JavaServer Pages 23

25 25 Add JSP Tag Component(s) Install tag(s)? hello OK 26 Oracle9i JDeveloper R9.0.3 JavaServer Pages 24

hello emp.jsp 1. emp.jsp 16 dbopen 27 2.

26 hello emp.jsp 1. emp.jsp 16 dbopen Tutorial hello 28 Tutorial hello 3. JavaServer Page Tag Editor username OK 29 JavaServer Page Tag Editor Oracle9i JDeveloper R9.0.3 JavaServer Pages 25

27 Oracle9i Application Server J2EE EJB Web Enterprise Archive EAR.ear JAR Web Web Web Archive WAR.war JAR JSP JDeveloper Oracle9i Application Server R9.0.3 Oracle9iAS Oracle9iAS Web WAR /EAR Web Web Oracle9iAS Oracle9iAS JDeveloper Oracle9iAS Oracle9iAS JDeveloper Oracle9iAS JDeveloper Oracle9iAS Oracle9i JDeveloper R9.0.3 JavaServer Pages 26

28 /2: Local_9iAS Oracle9i Application Server Local DCM 31 1/2: 4. 2/2: Oracle9iAS Oracle 32 2/2: Oracle9i JDeveloper R9.0.3 JavaServer Pages 27

29 5. Oracle9iAS 33 Oracle9iAS Oracle9iAS /4: Remote_9iAS Oracle9i Application Server Remote DCM Oracle9i JDeveloper R9.0.3 JavaServer Pages 28

30 34 1/4: 4. 2/4: Oracle9iAS ias_admin 35 2/4: 5. 3/4: Oracle9iAS Enterprise Manager Web HTTP Oracle9iAS Oracle Enterprise Manager OC4J Enterprise Manager OC4J HTTP 9iAS Oracle OC4J Enterprise Manager Web Enterprise Manager Web HTTP Oracle9iAS Oracle OC4J Oracle9i JDeveloper R9.0.3 JavaServer Pages 29

31 36 3/4: 6. 4/4: Oracle9iAS 37 4/4: 7. Oracle9iAS WAR JDeveloper Web WAR WAR JDeveloper WAR WAR Oracle9i JDeveloper R9.0.3 JavaServer Pages 30

32 a. web.xml jsp.jpr web.xml WAR b. jsp.jpr General Deployment Profiles WAR - J2EE Web -- WAR J2EE Web webapp1.deploy 38 WAR webapp1.deploy WAR Oracle9i JDeveloper R9.0.3 JavaServer Pages 31

33 WAR WAR WEB-INF/classes WEB-INF/lib WAR/EAR J2EE Web WAR JSP HTML WAR MANIFIST WEB-INF/class Java JAR WEB-INF/lib Web EAR EAR/WAR 39 WAR Web tutorial_jsp WAR Oracle9i JDeveloper R9.0.3 JavaServer Pages 32

34 Web J2EE Web tutorial_jsp 40 WAR Web JSP URL >:<HTTP >/tutorial_jsp/emp.jsp Oracle9iAS Local_9iAS Remote_9iAS WAR Oracle9iAS Oracle9iAS WAR <Oracle9iAS > DCM 0 Oracle9iAS dcmctl : 0 Oracle9i JDeveloper R9.0.3 JavaServer Pages 33

35 42 Web JSP Oracle9iAS JSP 1.2 Oracle9iAS Oracle9iAS T OC4J TWebLogic Server 6.x/7.x Jakarta Tomcat WebSphere Application Server WAR EAR WAR WAR WAR EAR EAR OC4J OTN-J Oracle9i JDeveloper R9.0.3 Servlet WebLogic Server OTN-J Oracle9i JDeveloper & BEA WebLogic 6.1 OJSP SQL Oracle9iAS OC4J OJSP SQL Oracle9iAS OC4J OJSP SQL Oracle9i JDeveloper R9.0.3 JavaServer Pages 34

OJSP SQL WAR WAR WAR WEB-INF/lib 43 ojsputil.jar 43 WAR WAR WEB-INF/lib Oracle9iAS R9.0.2.x JDeveloper R9.0.3 Oracle9iAS R9.0.2 R9.0.3 Oracle9iAS R9.0.2 Oracle9iAS OTN-J DCM Oracle9i JDeveloper 9.

36 OJSP SQL WAR WAR WAR WEB-INF/lib 43 ojsputil.jar 43 WAR WAR WEB-INF/lib Oracle9iAS R9.0.2.x JDeveloper R9.0.3 Oracle9iAS R9.0.2 R9.0.3 Oracle9iAS R9.0.2 Oracle9iAS OTN-J DCM Oracle9i JDeveloper Oracle9iAS Oracle9iAS R9.0.2 OC4J R9.0.2 JSP 1.2 JSP Oracle9i JDeveloper R9.0.3 JavaServer Pages 35

37 HelloTag.java package tutorial.taglib; import javax.servlet.jsp.tagext.*; import javax.servlet.jsp.*; import java.io.printwriter; public class HelloTag extends TagSupport { /* tag attribute: username */ private String username = ""; /** * Method called at start of tag. SKIP_BODY */ public int dostarttag() throws JspException { try { JspWriter out = pagecontext.getout(); out.println(" " + username + " "); } catch(exception e) { e.printstacktrace(); } return SKIP_BODY; } /** * Method is invoked after every body evaluation to control whether the body will be reevaluated or not. SKIP_BODY */ public int doafterbody() throws JspException { return SKIP_BODY; } /** * Method called at end of tag. EVAL_PAGE */ public int doendtag() { return EVAL_PAGE; } public void setusername(string value) { username = value; } Oracle9i JDeveloper R9.0.3 JavaServer Pages 36

38 public String getusername() { return username; } } emp.jsp <%@ taglib uri="tutorialtaglib" prefix="tutorial" %> <%@ taglib uri=" prefix="database" %> <%@ page contenttype="text/html;charset=shift_jis"%> <html> <head> <meta http-equiv="content-type" content="text/html; charset=shift_jis"> <title> Hello World </title> </head> <body> <h2> : </h2> <p> <%= new java.util.date() %></p> <tutorial:hello username="jdev Team" /> <database:dbopen connid="conn" datasource="jdbc/scottds"> </database:dbopen> <database:dbquery connid="conn" output="html"> SELECT * FROM EMP </database:dbquery> <database:dbclose connid="conn" /> </body> </html> Oracle9i JDeveloper R9.0.3 JavaServer Pages 37

39 A: JDeveloper JDeveloper JDeveloper Servlet JDeveloper OC4J OC4J Servlet Web OC4J OC4J OC4J OC4J Web IP OC4J OC4J R9.0.3 / OC4J OC4J <JDEV_HOME> j2ee home OC4J R OC4J Web Web / JDeveloper Servlet JSP / Web Oracle9i JDeveloper R9.0.3 JavaServer Pages 38

40 Web Servlet JSP Web 45 Web / Oracle9i JDeveloper R9.0.3 JavaServer Pages 39

B: JDeveloper JDeveloper JDeveloper HTML JSP 1.

41 B: JDeveloper JDeveloper JDeveloper HTML JSP : Oracle9i JDeveloper R9.0.3 JavaServer Pages 40

42 OK Oracle9i JDeveloper R9.0.3 JavaServer Pages 41

43 HTML JSP.html/.htm/.jsp.htm(l?)$.jsp$ JDeveloper : Oracle9i JDeveloper R9.0.3 JavaServer Pages 42

44 51 7. OK 52 JSP 52 Oracle9i JDeveloper R9.0.3 JavaServer Pages 43

45 JDeveloper JSP Oracle9iAS JDeveloper Enterprise Java Beans EJB JavaServer Pages JSP Business Components for Java BC4J JDeveloper OTN-Japan TOracle9i JDeveloper R9.0.3 Oracle9i JDeveloper Servlet JavaServer Pages Enterprise Java Beans Business Components for Java Web Java Oracle9i SCM TBusiness Components for Java J2EE J2EE Business Components for Java J2EE Oracle9i JDeveloper R9.0.3 JavaServer Pages 44

BC4J...4 BC4J Association JSP BC4J JSP OC4J

BC4J...4 BC4J Association JSP BC4J JSP OC4J lê~åäévá=gaéîéäçééê= 9.0.3/9.0.4 BC4J Creation Date: Oct 08, 2003 Last Update: Feb 27, 2004 Version 1.0 ...3... 3 BC4J...4 BC4J...4... 4... 5... 6...7... 8... 9 Association... 13... 15... 20... 22... 25