A Leader of Enterprise e-business Solution FORCS Co., LTD 1
OZ Application Getting Started 2 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 3
OZ Application Getting Started 'OZ Application'. Features Overview Quick Tour,. Features Overview,,. Quick Tour. 4 FORCS Co., LTD
A Leader of Enterprise e-business Solution OZ Application OZ. Manual Getting Started WAS Description.., OZC, OZS, OZF...,.. FORCS Co., LTD 5
OZ Application Getting Started. DB (JDBC/ODBC, SQL ) WAS(Web Application Server) (HTML, JavaScript ),... (Intranet) (B2B) B2C, / (G2B, G2C) ASP/MSP 6 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 7
OZ Application Getting Started,,,,,. (OZ Application Designer) C/S. Built-in.. 8 FORCS Co., LTD
A Leader of Enterprise e-business Solution (OZ Query Designer) (ODI:OZ Data Info). DB,. Drag & Drop. (OZ Enterprise Manager). Non-Stop. (OZ Repository Manager)., ODI,. (OZ Application Viewer). User Interface,,. Full ActiveX,. FORCS Co., LTD 9
OZ Application Getting Started (OZ Enterprise Server) (Result Set). /.. WAS. 10 FORCS Co., LTD
A Leader of Enterprise e-business Solution. Drag & Drop,.,,,. (TextBox, RichTextBox, MaskTextBox, ComboBox), (NumericUpDown), (RadioButton, CheckBox, CheckListBox), (DateTimePicker, MonthCalendar), (// ) (Button). (Label), (ListBox, CheckListBox, TreeView), (PictureBox), (ProgressBar), (HTMLView). ActiveXControl, CustomControl.,,,. FORCS Co., LTD 11
OZ Application Getting Started 2D/3D Chart,,,, 2D/3D Chart, Chart,,,. Table, (Horizontal Navigator, Vertical Navigator),. CrossTab,,. Grid,,,,,.. Export. GroupBox, Panel, TabControl. Invisibles ContextMenu, 12 FORCS Co., LTD
A Leader of Enterprise e-business Solution MainMenu, ImageList, Timer, ToolTip.,,, JScript,,,, JScript.,., XML, EJB Non-DB UDS(User Data Store). DBMS, DBMS.,. OZC(OZComponent) ComboBox, ListBox, Chart OZC. OZF(OZFunction) OZF. FORCS Co., LTD 13
OZ Application Getting Started OZS(OZStyle),, OZS.,, /.,... 14 FORCS Co., LTD
A Leader of Enterprise e-business Solution. ODI, ODI.. FORCS Co., LTD 15
OZ Application Getting Started / OS Windows NT 4.0, Windows 2000, Windows XP, Windows 2003 JRE 1.3 CPU RAM : Pentium 500MHz : 256MB(512MB ) : XGA(1024 x 768 ) OS Windows 98 Windows NT4.0/2000/XP/2003/Vista. CPU RAM : Pentium 300MHz : 64MB(128MB ) : SVGA(800 x 600 ) OS JRE(Java Runtime Environment) 1.1.X (JRE 1.3.X ) (Windows NT/2000/XP/2003, Linux, HP-UX, Solaris, AIX, Unixware ) JRE 1.4. 16 FORCS Co., LTD
A Leader of Enterprise e-business Solution Internet Information Server(IIS), Netscape Enterprise Server, Apache, NCSE, CERN HTTP WebLogic, WebSphere, Jeus, Tomcat, JRun, iplanet, SilverStream, NetAction, EAServer, ias, AppServer, NEC WebOTX, Fujitsu Interstage Oracle, MS SQL Server, DB2(UDB), Informix, Sybase, IngresII JDBC ODBC DBMS / OS Windows NT 4.0, Windows 2000, Windows XP, Windows 2003 CPU RAM : Pentium 00MHz : 128MB(256MB ) : XGA(1024 x 768 ) FORCS Co., LTD 17
OZ Application Getting Started 18 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 19
OZ Application Getting Started (MS Windows NT 4.0 ) (IIS). ( ),. MS Access DB MS Access ODBC Driver. IIS,. Step 1 ODI Step 1 ODBC Step 2 ODI UI / Step 2 Step 3 HTML Step 3 Step 4 20 FORCS Co., LTD
A Leader of Enterprise e-business Solution..,.. FORCS Co., LTD 21
OZ Application Getting Started Step 1 ODI ODBC DB ODBC ODBC. Microsoft Access DB AppSample.mdb, DB. AppSample.mdb ODBC (DSN) 'AppSample'. 1) [] [ ] [ (ODBC)] ODBC. 2) [ DSN] [] Microsoft Access Driver(*.mdb) []. 3) 'AppSample', [] 'AppSample.mdb'. 22 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4) []. 5) 'AppSample'. (OZ Query Designer). FORCS Co., LTD 23
OZ Application Getting Started 1) [] [ ]. 2) [ ]. 'AppSample' [ ] 'ODBC' [ ] ODBC 'AppSample'. 3). 24 FORCS Co., LTD
A Leader of Enterprise e-business Solution. 1) [AppSample] [ ]. 2) [ ] 'SaleResult' []. 3). [ ] [ ]. '', '' []. FORCS Co., LTD 25
OZ Application Getting Started [ ]. 4). 'SaleResult' [] [ ] []. " ". 26 FORCS Co., LTD
A Leader of Enterprise e-business Solution 5).. SELECT * FROM SaleResult WHERE = '#OZParam.#' AND = '#OZParam.#' 6) ( ) <F5> 'OZParam.' '2002' 'OZParam.' '1' []. 'SaleResult',. FORCS Co., LTD 27
OZ Application Getting Started 7). ''. 'AppSample' [ ]. ' ' '' ( 4), 5) ) ( ).. SELECT Distinct SaleResult. FROM SaleResult 28 FORCS Co., LTD
A Leader of Enterprise e-business Solution ''. 'AppSample' [ ]. ' ' '' ( ).. SELECT Distinct SaleResult. FROM SaleResult 8) ODI. [] [] 'AppSample.odi'. 'C:\Repository'. Step 2. 1) [] [ ] ( ). FORCS Co., LTD 29
OZ Application Getting Started 2) [] [ ]. C:\Repository. 30 FORCS Co., LTD
A Leader of Enterprise e-business Solution ODI ODI (AppSample.odi). 1) ODI. [] [ODI ] 'AppSample.odi' [] [] 'AppSample.odi'. 2) [ ] ODI. FORCS Co., LTD 31
OZ Application Getting Started. 1). [] [Board1] '' 'BackColor' [ ]. 2). [] [] [] ( ) Drag & Drop. 3),,. 'Label1' ''. 32 FORCS Co., LTD
A Leader of Enterprise e-business Solution 'BackColor' 'LineColor', 'Font' ', 20pt, Bold', 'TextAlign' 'MiddleCenter', 'Text' ' '. 4). [] [ ] [] ( ) Drag & Drop. 'Line1' '' 'LineColor' 'PenThickness'. User Interface,, FORCS Co., LTD 33
OZ Application Getting Started. 1). 2) 2. 3) ODI.. 'ComboBox1' ' ' 'ODIKey' 'AppSample', 'DataSet' '', 'Field' ''.. 'ComboBox2' '' 'ODIKey' 'AppSample', 34 FORCS Co., LTD
A Leader of Enterprise e-business Solution 'DataSet' '', 'Field' ''. 4). Text '' ' '. ODI. 1). FORCS Co., LTD 35
OZ Application Getting Started [] [ ] [] ( ) Drag & Drop 2) ODI. 'Chart1' '' 'ODIKey' 'AppSample' 'DataSet' 'SaleResult'. 3). [ ]. [ ] ' '. 36 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4) [] X, Y, Drag & Drop. 5),, X, Y /. [X] [] X. [Y] [] Y /. FORCS Co., LTD 37
OZ Application Getting Started [] ''. []. 38 FORCS Co., LTD
A Leader of Enterprise e-business Solution []. ODI. 1). [] [ ] [] FORCS Co., LTD 39
OZ Application Getting Started ( ) Drag & Drop. 2) ODI. 'Table1' '' 'ODIKey' 'AppSample', 'DataSet' 'SaleResult'. 3). []. / [ ][ ] / [ ][ ]. '' '' ' ' '' '' 'ColumnMerge' 'True'. []. 40 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4). 'Table1' '' 'ShowIndicator' 'False'.. 'GridCellHeader', 'GridCellTitle', 'GridCellIndicator'. '' 'Table1' 'GridCellHeader1' <Shift> 'GridCellIndicator1',. 'BackColor' ( '204,226,236'), 'CellFrameColor' '192,192,192', 'Font' ', FORCS Co., LTD 41
OZ Application Getting Started 12pt', 'TextAlign' 'MiddleCenter'.. 'CellLabel',, ( ) 'Font' ', 12pt', 'TextAlign' 'MiddleCenter'. 'CellLabel', 'Font' ', 12pt', 'TextAlign' 'MiddleRight', 'Pattern' [ '0,0,10,0'. ] '', 'InternalMargin'. 42 FORCS Co., LTD
A Leader of Enterprise e-business Solution. 1). [ ]. 'Document' 'GlobalFunction'. 'searchdata()' 'saveexcel()'. FORCS Co., LTD 43
OZ Application Getting Started 2). 'Board1' 'OnAttached' 'searchdata()'. 3) []. 'Button1' 'OnClick' 'searchdata()'. 44 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4) [ ]. 'Button2' 'OnClick' 'saveexcel()'. 5). [] [ ]. FORCS Co., LTD 45
OZ Application Getting Started 46 FORCS Co., LTD
A Leader of Enterprise e-business Solution Step 3 [] [] ( ).. 'AppSample.oza'. FORCS Co., LTD 47
OZ Application Getting Started Step 1 conf db.properties. AppSample.vendor = odbc AppSample.dsn = AppSample AppSample.user = AppSample.password = AppSample.maxconns = 5 AppSample.initconns = 2 AppSample.timeout = 5 ODBC. Oracle " ". bin ozstart.bat. 48 FORCS Co., LTD
A Leader of Enterprise e-business Solution Step 2 ODI. 1) [] ' ' [ ]. 2) '' [ ] [ ]. ( 'admin'.) '' " ". FORCS Co., LTD 49
OZ Application Getting Started 3). 4) '' Drag & Drop [ ]. 'AppSample.oza' ODI 'AppSample.odi'. 5). 50 FORCS Co., LTD
A Leader of Enterprise e-business Solution Step 3. - ztransferx.js var ZTransferXObjectElement = document.createelement('<object width = "0" height = "0" ID="ZTransferX" CLASSID="CLSID:C7C7225A-9476-47AC-B0B0- FF3B79D55E67" codebase="http://127.0.0.1/ozapplicationviewer/ztransferx.cab#version=2,1, 0,2"></OBJECT>'); var ZTransferXParamElement1 = document.createelement('<param NAME="download.Server" VALUE="http://127.0.0.1/OZApplicationViewer/">'); var ZTransferXParamElement2 = document.createelement('<param NAME="download.Port" VALUE="80">'); var ZTransferXParamElement3 = document.createelement('<param NAME="download.Instruction" VALUE="ozaviewer.idf">'); var ZTransferXParamElement4 = document.createelement('<param NAME="install.Base" VALUE="<PROGRAMS>/Forcs">'); var ZTransferXParamElement5 = document.createelement('<param NAME="install.Namespace" VALUE="CustomNameSpace">'); ZTransferXObjectElement.appendChild(ZTransferXParamElement1); ZTransferXObjectElement.appendChild(ZTransferXParamElement2); ZTransferXObjectElement.appendChild(ZTransferXParamElement3); ZTransferXObjectElement.appendChild(ZTransferXParamElement4); ZTransferXObjectElement.appendChild(ZTransferXParamElement5); OZEmbedControlLocation.appendChild(ZTransferXObjectElement); IIS, IIS. ( IIS 'OZApplicationViewer' FORCS Co., LTD 51
OZ Application Getting Started ). <div id="ozembedcontrollocation"> <script id="ztransferx" src="ztransferx.js"></script> <script LANGUAGE="Javascript"> var tag = '<OBJECT id = "OZApplicationViewer" CLASSID="CLSID:907A00F3-7390-4EF2-931B-360546587804" width="800" height="600"></object>'; var paramtag = new Array(); paramtag[paramtag.length] = '<param name="repository_agent.type" value="from_ozserver">'; paramtag[paramtag.length] = '<param name="repository_agent.ozserver.server" value="127.0.0.1">'; paramtag[paramtag.length] = '<param name="repository_agent.ozserver.port" value="8003">'; paramtag[paramtag.length] = '<param name="ozadoc.path" value="appsample.oza">'; paramtag[paramtag.length] = '<param name="viewer.namespace" value="customnamespace\bin">'; oz_activex_build(ozembedcontrollocation, tag, paramtag); </script> </div> 'ozadoc.path'. 'AppSample.oza'. HTML HTML appsample.html. 52 FORCS Co., LTD
A Leader of Enterprise e-business Solution 'ztransferx.js' 'oz_activex.js' HTML. Step 4. 1) HTML (appsample.html). 2) Ztransfer Control FORCS Co., LTD 53
OZ Application Getting Started 3) Ztransfer. 'install.base' 'install.namespace'. 4). 54 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 55
OZ Application Getting Started,. Overview, Quick Tour. Getting Started. http://www.forcs.com 49-6 12 (156-754) : 82-2-828-1400 e-mail : oz@forcs.com 56 FORCS Co., LTD