,,,
..
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. ,
Copyright (c) 2024 Stud-Baza.ru , , , .