. , , ,

,,,

Internet/intranet — ,

..

1.

, . , Internet, intranet, , . , ( "" ), ( ), (, ). , , , . , . WWW [4].

⌠ ■ - - Internet (Netscape Communicator, Microsoft Internet Explorer, ..) -;

( , , );

: , , Internet;

( , Internet - ). .

Web- , ⌠ ■, Microsoft Access [2].

. Web- - WWW-, Oracle [7].

:

;

WWW- ;

MS Access Oracle.

2. Web

/ [1] , , . , ⌠■ , , .

Oracle : [7] (. 1).

, , . , , , . . , , , .

, Oracle, , . SQL PL/SQL , [13]. , , √ [8].

SQL*Net √ Oracle [9]. SQL*Net Oracle, , , , .

Web- : , .

2.1

Java [10]. Java - - , , , "" ++. , Java , . . Java " " (- , ).

HTML- Java-, HTML-. Java- (Java-applets). , , Web- . .

Java-, , , . , Java , . , , , , HTML, - .

Java- JDBC, , , Java- ODBC, ODBC.

, Web- / . Java- √ , Internet/intranet .

2.2

. / Oracle Web [6]:

/ (. 1). : . ( ) . , , , , [6].

Web (. 2). : (), , . , . , .

2.2.1 Oracle Web deployment

(Forms Runtime Engine) , . , .

(Application Server) , . WWW-. WWW - , , . WWW √ Internet.

(Forms Client) Java-, Web- . Web-, , . . ( ), / , Web .

:

. Java- , Web.

. , , .

. , / . Java-, Web / .

. Java-, . , , .

(Forms Server) :

(Listener). .

() (Forms Runtime Engine). / , . , ; , .

, .

( ⌠ ■ ⌠ ■). √ ( / ), . , ⌠ Canva1■, ( ).

, :

( );

( checkbox ), , , .

Oracle Web, , Java- Web-, URL (Uniform Resource Locator) . :

URL HTML- (Hypertext Markup Language), .

HTML , .

( , ).

( , ). HTML ( , , SID , ..) , .

. . ⌠■ , . ( Web- ).

/ , SQL*Net ( Oracle).

, , RSA RC4 40- ( ) SQL*Net SNS/ANO ( ) [13].

2.2.2 CGI

Web- CGI (Common Gateway Interface √ ). , :

Web- ( ) √ - , , ;

;

Web- .

CGI Web- . , HTML- , ( ). , CGI- CGI-, Web- , Web- HTML-, .

CGI , CGI- , , HTML-, (. 4).

, [4]:

, , ;

; ;

;

, , CGI;

, , , ( SQL);

, CGI- HTML- ;

Web- HTML- .

CGI- Oracle SQL* Net [7] √ Oracle. CGI- , . CGI- HTML- Web-. Web-, , HTML- , . HTML-.

3. Web-

2, WWW- (. 5), :

;

;

.

.

3.1 Oracle Web-delpoyment

, :

. , , , [1]. ( .), ( ) ( ⌠■ .) [1].

; :

FMX- ;

;

;

.

FMX-

() FMB- FMX-. , Oracle ( FMX), Forms Runtime √ , . FMX- , .

FMX- √ , HTML . ( ), ( ):

ORACLE_HOME\BIN\;

FORMS50_PATH ( ),

ORACLE_HOME FORMS50_PATH √ .

2.

Start->Run Windows NT ( Windows NT 4.0).

<ORACLE_HOME>\bin\f50srv32 port=_ Enter.

. , , 9000. , HTML (. .3 ).

Processes NT. , F50SRV32.EXE, F50WEB32.EXE ( ).

End Process NT.

3.

3.1. Web-

. 3 . √ HTML . , ( , / Web-, , HTML ).

:

Applet codebase ( , .. HTML, ). URL - , (Java-).

ORACLE_HOME\forms50\java (, c:\orant\forms50\java).

/ORACLE/.

HTML . , Web- HTML .

JAR-. , JAR- (Java Archives) Oracle.

:

Applet codebase c:\orant\forms50\java\ /web_code/
HTML c:\web_forms\html\ /web_html/
JAR- c:\orant\forms50\java\ /web_jars/

3.2. HTML ( )

Web Oracle ( URL ), HTML . , , Web. HTML :

. HTML . Oracle Web Server . √ .

. HTML , . Web-. Oracle Developer/2000 R2.0 √ static.htm. , , (.FMX) . , , , HTML (. . 3.1).

3.3. Web URL

HTML FMX-, . URL HTML . URL Java- Web- . HTML-, URL- HTML . URL:

http://gemini.math.cgu.chel.su/web_html/bibliogr.htm

URL: : http

: gemini.csu.ac.ru

HTML : /web_html

HTML : bibliogr.htm

4.

Web Oracle, ( Java-). , Java-. , . :

(Increment). Java-, .

(Bundled). , Java-. , . JAR- HTML .

. , ⌠ ■ - Java- Web-. , JDK (Java Development Kit √ Java) 1.1.x .

3.2 CGI

CGI-, . CGI-, Web- . HTML-, . Web-, HTTP. , .

"-" , HTTP WWW . , - , . HTTP , , (URI - Uniform Resource Identifier), HTTP-. CGI, POST GET. POST , , , , . GET , HTTP .

, CGI 4 :

;

;

;

.

, CGI:

CONTENT_LENGTH - ;

QUERY_STRING - "?" URL . .

2.

CGI - . , cgi-, , . cgi- . , cgi- HTTP .

cgi- CR (0x10). , . , CGI :

Content-type

MIME . :

Content-type: text/html <CR><CR>

, - HTML;

Location

, , . URL, . , , .

Status

HTTP/1.0 -, : nnn xxxxx

: nnn - 3-

-

: HTTP/1.0 200 OK

Server: NCSA/1.0a6

Content-type: text/plain

< 3.

POST HTTP . cgi- :

name=value&name1=value1&...&nameN=valueN

name - ,

value - ,

N -

CONTENT_LENGTH . cgi- CONTENT_TYPE ( ). CONTENT_LENGTH , cgi- . CONTENT_LENGTH CONTENT_TYPE , cgi-. , FORM - METHOD="POST" firm=&price=100023, CONTENT_LENGTH 21 CONTENT_TYPE

application/x-www-form-urlencoded, .

GET, URL.

http://host/cgi-bin/script?name1=value1&name2=value2

QUERY_STRING

name1=value1&name2=value2

4.

GI- :

URL cgi- ( , cgi-);

, .

, ( HTTP-URL ) Bourne shell [12] , cgi- ( Unix-).

GET POST, cgi- .

I. GET

QUERY_STRING;

(, "+" 128 "%" .);

" - " cgi-.

II. POST

CONTENT_LENGTH ;

(, "+" 128 "%" .);

"-" cgi-.

"-" , , , cgi-. cgi- HTML- ( ). , .

cgi- , :

Content-type: text/html ( CR).

HTML.

, CGI- Web- , . CGI- Perl [11] (Practical Extraction and Report Language)- , , . Oracle perl.

- Perl- ( http://www.perl.com/CPAN/) : DBI DBD-Oracle. DBI SQL- - DBD-xxxx, SQL-.

DBI:

$dbh = DBI->connect('dbi:Oracle:'.'db_alias', 'db_user', 'db_pwd', {RaiseError => 1});

$dbh->{RaiseError} = 1; # do this, or check every call for errors

- Oracle

$cursor = $dbh->prepare("SELECT Fie1d, Field2 FROM Table1 ORDER BY Field2");

$cursor->execute;

while (@row = $cursor->fetchrow_array) {

print "$row[0], $row[1] \n";

}

- ( Field1, Filed2 @row)

my($Field1, $Field2, $Field3);

$cursor = $dbh->prepare("SELECT Field1, Field2, Field3 FROM Table1");

$cursor->bind_columns(undef, \($Field1, $Field2, $Field3));

$cursor->execute;

while $cursor->fetch) {

print "$Field1, $Field2, $Field3 \n";

}

- ( Field1, Field2, Field3 $Field1, $Field2, $Field3)

$rc = $cursor->finish;

$rc = $dbh->disconnect;

- .

, Web- Apache Unix-. Web- CGI-, perl, perl- ⌠■. , , ScriptAlias ( cgi-bin) Web- srm.conf, ,

AddHandler cgi-script .cgi

srm.conf (, .cgi). Web-,

$ Apache_HOME/sbin/apachectl restart

Apache_HOME √ , Web-.

perl- ,

#!/usr/local/bin/perl

perl .

4. Web

4.1 - ⌠ ■ Oracle Web deployment

. Oracle Windows NT. Oracle , . , Oracle , Web deployment, Oracle Web.

Web, 3, ( , ):

SQL- (SQL - Structure Query Language √ Oracle [7]), (. ). MS Access Import, SQL- MS Access. , , SQL . , , SQL *Plus ( SQL Worksheet), SQL- Oracle.

MS-DOS ( CGI- √ Unix), SQL *Plus .

; Forms Builder 5.0, Oracle Developer/2000 R2.0. ( FMX-), Developer/2000 Forms Runtime (. ).

( ); Microsoft Internet Information Server.

;

( , ). Oracle ( Bibl), .

, Web-:

Microsoft Internet Explorer 4.0,

Netscape Communicator 4.04 ( , , JDK 1.1.x).

Java- Microsoft Internet Explorer 4.0 rus, . , Java , . , CGI, .

4.2 - ⌠ ■ CGI

Web- Linux Web- Apache. Oracle ( 30 ). Oracle Windows NT.

CGI-, perl. .

search.cgi √ , ( card.cgi)

:

search.cgi?search_string=search_string&search_type=search_type&portion=portion

search_string √ ( ),

search_type √ (1 √ , 2 √ , 3 √ , 4 - , 5 √ ),

portion √ ,

card.cgi √ ,

:

card.cgi?code

code √ ,

reference.cgi √ , ( search.cgi)

:

subject.cgi √ , 3- ( search.cgi)

:

subject.cgi √ ,

subject.cgi?code1 √ ,

subject.cgi?code1&code2 √ ,

subject.cgi?code1&code2&code3 √ , ,

code1, code2, code3 √

common.cgi, module.cgi √ ,

, HTML-, author.html, index.shtml, keyword.html, title.html. CGI- , . , Java-Script, .

, .

4.3 - CGI

- . - ⌠ ■. () , ⌠ ■. Oracle 7.3.2 SCO Unix Open Server Enterprise v.5.0.4. SQL*Oracle Forms 3.0, SQL*Oracle Menu 5.0 SQL*Oracle Reports Writer 1.1.

⌠ ■, ().

⌠ ■, , perl Internet. : ⌠ ■ ⌠ , , ■. ⌠ ■, . , .

SCO Unix Open Server Enterprise v.5.0.4. CGI-, .. Web- . URL (Uniform Resource Locator) , Web- . , , SQL*Net Oracle ( ) . CGI- HTML- Web-. Web- - HTML- Internet- , . 4- (1 3 , ■ 2- ).

:

Oracle Oracle Developer/2000 R2.0;

Oracle WWW- OracleWeb deployment;

Web deployment, Oracle Developer/2000 R2.0 ⌠- ■;

Web- CGI;

CGI- Internet ⌠ ■;

MS-Access Oracle;

Internet : http://reindeer.math.cgu.chel.su/oracle/bibl ( );

CGI- - : http://www.suse.ru:8001/ ( );

: .., .. Internet // '99: . . . . -. 1999.

.. . - .: ⌠ ■. 1992. - 256 .

Microsoft Access 7.0 Windows 95. - Microsoft Corp. Publ. - 1996. 898 .

., ., . Web Oracle // 1996. √ N 5-6

.. WWW // 1996.- N 5-6

Oracle Developer/2000. Forms 4.5 Reference Manual. - Oracle Corp. - 1995. Vol 1-2

Developer/2000 Guidelines for Building Applications Release 2.0 √ - Oracle Corp. - 1997.

Oracle Server V2, 3, ..., 7.0, 7.1 ... and Counting. // EOUG Oracle User Forum 94 17-20 April 1994, Maastriht, The Netherlands.

The Committee for Advanced DBMS Function. Third Generation Database Manifesto. // SIGMOD Record, 1990. - Vol. 19, N 3, pp. 31-44

. ORACLE √ , // 1995.- N1, C.55

. , Java, Jet Infosystems - electronic version

Wall L., Christiansen T., Schwartz R. Programming Perl. 2nd ed. O'Reilly & Associates, 1996.

. UNIX. - .: . 1985. √ 318 .

Oracle Product Documentation Library. √ Oracle Corp. - 1995.

1. ⌠ ■

- (MS Access) (Oracle).

Microsoft Access Oracle
Alphabetical_Catalogue
Systematic_Catalogue
-2 () SC-2
-3 () SC-3

- SQL, :

DROP TABLE Alphabetical_Catalogue;

DROP TABLE SC2;

DROP TABLE SC3;

DROP TABLE Systematic_Catalogue;

CREATE TABLE Alphabetical_Catalogue

(Code NUMBER(6) NOT NULL,

Reference VARCHAR2(25) NULL,

Authors VARCHAR2(120) NULL,

Title VARCHAR2(250) NULL,

Is_Article NUMBER(1) NULL,

Magazine_Or_Publisher VARCHAR2(200) NULL,

Year VARCHAR2(20) NULL,

Volume NUMBER(2) NULL,

Issue VARCHAR2(20) NULL,

From_Page NUMBER(4) NULL,

Till_Page NUMBER(4) NULL,

Is_Russian NUMBER(1) NULL,

Abstract LONG NULL,

Paper VARCHAR2(50) NULL,

Code1 NUMBER(6) NULL,

Code2 NUMBER(6) NULL,

Code3 NUMBER(3) NULL,

Keyword1 VARCHAR2(50) NULL,

Keyword2 VARCHAR2(50) NULL,

Keyword3 VARCHAR2(50) NULL,

Keyword4 VARCHAR2(50) NULL,

Keyword5 VARCHAR2(50) NULL,

Keyword6 VARCHAR2(50) NULL,

Keyword7 VARCHAR2(50) NULL,

Keyword8 VARCHAR2(50) NULL,

Priority NUMBER(2) NULL,

Home_Library NUMBER(1) NULL,

CSU_Library NUMBER(1) NULL) ;

CREATE TABLE SC2

(Code2 NUMBER(6) NOT NULL,

Title2 VARCHAR2(40) NULL,

Code1 NUMBER(6) NULL) ;

CREATE TABLE SC3

(CODE3 NUMBER(6) NOT NULL,

TITLE3 VARCHAR2(35) NULL,

CODE2 NUMBER(6) NULL) ;

CREATE TABLE Systematic_Catalogue

(Title1 VARCHAR2(30) NULL,

Code1 NUMBER(6) NOT NULL) ;

CREATE OR REPLACE VIEW A_C AS

SELECT

Code,

Reference,

Authors,

Title,

Is_Article,

Magazine_Or_Publisher,

Year,

Volume,

Issue,

From_Page,

Till_Page,

Is_Russian,

Abstract,

Paper,

Keyword1,

Keyword2,

Keyword3,

Keyword4,

Keyword5,

Keyword6,

Keyword7,

Keyword8,

Priority,

Home_Library,

CSU_Library,

Title1,

Title2,

Title3

FROM Alphabetical_Catalogue, Systematic_Catalogue, SC2, SC3

WHERE Alphabetical_Catalogue.Code1=Systematic_Catalogue.Code1 AND

Alphabetical_Catalogue.Code2=SC2.Code2 AND

Alphabetical_Catalogue.Code3=SC3.Code3

WITH READ ONLY;

CREATE INDEX iA_C1 ON Alphabetical_Catalogue

(Code);

CREATE INDEX iA_C2 ON Alphabetical_Catalogue

(Reference);

CREATE INDEX iA_C3 ON Alphabetical_Catalogue

(Keyword1);

CREATE INDEX iA_C4 ON Alphabetical_Catalogue

(Keyword2);

CREATE INDEX iA_C5 ON Alphabetical_Catalogue

(Keyword3);

CREATE INDEX iA_C6 ON Alphabetical_Catalogue

(Keyword4);

CREATE INDEX iA_C7 ON Alphabetical_Catalogue

(Keyword5);

CREATE INDEX iA_C8 ON Alphabetical_Catalogue

(Keyword6);

CREATE INDEX iA_C9 ON Alphabetical_Catalogue

(Keyword7);

CREATE INDEX iA_C10 ON Alphabetical_Catalogue

(Keyword8);

CREATE INDEX iA_C11 ON Alphabetical_Catalogue

(Authors);

CREATE INDEX iSystematic_Catalogue_1 ON Systematic_Catalogue

(Code1);

CREATE INDEX iSystematic_Catalogue_2 ON Systematic_Catalogue

(Title1);

CREATE INDEX iSC2_1 ON SC2

(Code2);

CREATE INDEX iSC2_2 ON SC2

(Title2);

CREATE INDEX iSC3_1 ON SC3

(CODE3);

CREATE INDEX iSC3_2 ON SC3

(Title3);

CREATE OR REPLACE PACKAGE bibl

IS

FUNCTION GetYear (S VARCHAR2)

RETURN NUMBER;

PRAGMA RESTRICT_REFERENCES (GetYear, WNDS, WNPS);

END bibl;

/

CREATE OR REPLACE PACKAGE BODY bibl

IS

FUNCTION GetYear (S VARCHAR2)

RETURN NUMBER

IS

i NUMBER;

done BOOLEAN;

BEGIN

done := FALSE;

i := LENGTH (S);

WHILE NOT done AND (i>1) LOOP

IF SUBSTR (S, i, 1) NOT IN ('0','1','2','3','4','5','6','7','8','9') THEN

done := TRUE;

ELSE

i := i-1;

END IF;

END LOOP;

IF done THEN

RETURN TO_NUMBER (SUBSTR (S, i+1));

ELSE

RETURN TO_NUMBER (SUBSTR (S, i));

END IF;

END;

END bibl;

/

2. MS Access Oracle

4 :

MS Access SQL- import.sql ( c:\), export.mdb;

gzip;

FTP Unix-;

Oracle ( loaddata.sh).

MS Access MEMO- - . 2000 ( MEMO- 2000 ).

loaddata.sh Unix-, , SQL- import.sql.gz. , , , () , user_name/user_password@connect_string. .log . , Unix- Oracle.

www.csu.ac.ru

.. 1. ,

 

 

 

! , , , .
. , :