A Leader of Enterprise e-business Solution FORCS Co., LTD 1
OZ Application Designer Getting Started 2 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 3
OZ Application Designer 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 OZ Application Getting Started OZ Application Designer User's Guide OZ Query Designer User's Guide OZ Enterprise Server Administrator's Guide Description., OZC, OZS, OZF..,,. WAS. FORCS Co., LTD 5
OZ Application Designer 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 Designer 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 Designer 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 Designer Getting Started,,,. 2D/3D Chart,,,, 2D/3D Chart Chart,,,. Table, (Horizontal Navigator, Vertical Navigator),. CrossTab,,. Grid,,,,,.. Export. 12 FORCS Co., LTD
A Leader of Enterprise e-business Solution GroupBox, Panel, TabControl. Invisibles ContextMenu, MainMenu, ImageList, Timer, ToolTip.,,, JScript,,,, JScript.,., XML, EJB Non-DB UDS(User Data Store). DBMS, DBMS.,. OZC(OZComponent) ComboBox, ListBox, Chart FORCS Co., LTD 13
OZ Application Designer Getting Started OZC. OZF(OZFunction) OZF. OZS(OZStyle),, OZS.,, /.,... 14 FORCS Co., LTD
A Leader of Enterprise e-business Solution ODI, ODI. FORCS Co., LTD 15
OZ Application Designer Getting Started / OS Windows NT 4.0, Windows XP, Windows 2000, Windows 2003 JRE 1.3 CPU RAM : Pentium 500MHz : 256MB(512MB ) : XGA(1024 x 768 ) OS Windows 98 MS Windows NT(NT4.0/2000/XP/2003). 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 XP, Windows 2000, Windows 2003 CPU RAM : Pentium 00MHz : 128MB(256MB ) : XGA(1024 x 768 ) FORCS Co., LTD 17
OZ Application Designer Getting Started 18 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 19
OZ Application Designer 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 3 Step 2 Step 3 Step 4 20 FORCS Co., LTD
A Leader of Enterprise e-business Solution..,. FORCS Co., LTD 21
OZ Application Designer 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', [] 22 FORCS Co., LTD
A Leader of Enterprise e-business Solution 'AppSample.mdb'. 4) []. 5) 'AppSample'. (OZ Query Designer). FORCS Co., LTD 23
OZ Application Designer Getting Started 1) [] [ ]. 2) [ ]. 'AppSample' [ ] 'ODBC' [ ] ODBC 'AppSample'. 3). 24 FORCS Co., LTD
A Leader of Enterprise e-business Solution. 1) [AppSample] [ ]. 2) [ ] 'SaleResultParam' []. 3). [ ] [ ]. '' []. FORCS Co., LTD 25
OZ Application Designer Getting Started '' []. [ ]. 4). 'SaleResultParam' [] [ ] []. ' '. 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' []. 'SaleResultParam',. FORCS Co., LTD 27
OZ Application Designer 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 Designer Getting Started 2) [Repository] [ ]. C:\Repository. 30 FORCS Co., LTD
A Leader of Enterprise e-business Solution ODI ODI (AppSample.odi). 1) ODI. [] [ODI ] 'AppSample.odi' [] [Repository] 'AppSample.odi'. 2) [DataInfos] ODI. FORCS Co., LTD 31
OZ Application Designer Getting Started. 1). [Component] [Board1] 'Property' 'BackColor' [ ]. 2). [] [] [] [ ] Drag & Drop. 3),,. 'Label1' 'Property'. 'BackColor' 'LineColor', 'Font' ', 20pt, Bold', 'TextAlign' 'MiddleCenter', 'Text' ' '. 32 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4). [] [ ] [] [ ] Drag & Drop. 'Line1' 'Property' 'LineColor' 'PenThickness'. User Interface,,. 1). FORCS Co., LTD 33
OZ Application Designer Getting Started 2) 2. 3) ODI.. 'ComboBox1' 'Property' 'ODIKey' 'AppSample', 'DataSet' '', 'Field' ''.. 'ComboBox2' 'Property' 'ODIKey' 'AppSample', 'DataSet' '', 'Field' ''. 34 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4). Text ' '. ODI. 1). [] [ ] [] [ ] Drag & Drop. FORCS Co., LTD 35
OZ Application Designer Getting Started 2) ODI. 'Table1' 'Property' 'ODIKey' 'AppSample', 'DataSet' 'SaleResultParam'. 3). [ ]. / [ ][ ] / [ ][ ]. '' '' ' ' '' 'Property' 'ColumnMerge' 'True'. [OK]. 36 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4). 'Table1' 'Property' 'ShowIndicator' 'False'.. 'GridCellHeader', 'GridCellTitle', 'GridCellIndicator'. 'Component' 'Table1' 'GridCellHeader1' [Shift] 'GridCellIndicator1',. 'BackColor' ( '204,226,236'), 'Font' ',12pt', 'TextAlign' 'MiddleCenter'. FORCS Co., LTD 37
OZ Application Designer Getting Started. 'CellLabel',, ( ) 'Font' ',12pt', 'TextAlign' 'MiddleCenter' 'CellLabel', 'Font' ',12pt', 'TextAlign' 'MiddleRight', 'Pattern' [ ] '', 'InternalMargin' '0,0,10,0'.. ODI. 1). [] [ ] [] [ ] Drag & Drop 2) ODI. 'Chart1' 'Property' 'ODIKey' 'AppSample' 'DataSet' 'SaleResultParam'. 38 FORCS Co., LTD
A Leader of Enterprise e-business Solution 3). [ ]. [] X, Y, Drag & Drop. 4),,, X, Y /. [Type] 3. FORCS Co., LTD 39
OZ Application Designer Getting Started []. []. 40 FORCS Co., LTD
A Leader of Enterprise e-business Solution [] ''. [X-] [] X. FORCS Co., LTD 41
OZ Application Designer Getting Started [Y-] [] Y /.. 1). 42 FORCS Co., LTD
A Leader of Enterprise e-business Solution [ ]. 'Document' 'Global Function'. 'searchdata()' 'saveexcel() '. FORCS Co., LTD 43
OZ Application Designer Getting Started 2). 'Board1' 'OnAttached' 'searchdata()'. 3).. 'ComboBox1' 'OnSelectedIndexChanged' 'searchdata()'.. 'ComboBox2' 'OnSelectedIndexChanged' 'searchdata()' 44 FORCS Co., LTD
A Leader of Enterprise e-business Solution. 4) '. 'Button1' 'OnClick' 'saveexcel()'. 5). [Edit] [Preview Script]. FORCS Co., LTD 45
OZ Application Designer Getting Started Step 3 [File] [Preview] [ ].. 46 FORCS Co., LTD
A Leader of Enterprise e-business Solution 'AppSample.oza'. FORCS Co., LTD 47
OZ Application Designer Getting Started Step 1 conf db.properties. AppSample.vender = 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 Repository Server ODI. 1) [Repository] ' ' [ ]. 2) ' ' []. ( 'admin'.) FORCS Co., LTD 49
OZ Application Designer Getting Started 3). 4) ' ' Drag & Drop. 'AppSample.oza' ODI 'AppSample.odi'. 50 FORCS Co., LTD
A Leader of Enterprise e-business Solution 5). Step 3. <OBJECT id=ztransferx style="left: 0px; TOP: 0px" codebase=http://127.0.0.1/ozapplicationviewer/ztransferx.cab#version=2,0,1,2 height=0 width=0 classid="clsid:c7c7225a-9476-47ac-b0b0-ff3b79d55e67" VIEWASTEXT> <PARAM NAME="download.Server" VALUE="http://127.0.0.1/OZApplicationViewer"> <PARAM NAME="download.Port" VALUE="80"> <PARAM NAME="download.Instruction" VALUE="OZAViewer.idf"> <PARAM NAME="install.Base" VALUE="<PROGRAMS>/Forcs"> <PARAM NAME="install.Namespace" VALUE="AppViewer"> <PARAM NAME="useprogress" VALUE="1"> <PARAM NAME="debug" VALUE="-1"> </OBJECT> IIS, FORCS Co., LTD 51
OZ Application Designer Getting Started IIS. ( IIS 'OZApplicationViewer' ). <OBJECT bgcolor="#ffffff" width = "800" height = "600" ID="OZAppViewer" CLASSID="CLSID:907A00F3-7390-4EF2-931B-360546587804" VIEWASTEXT> <param name="repository_agent.type" value="from_ozserver"> <param name="repository_agent.ozserver.server" value="127.0.0.1"> <param name="repository_agent.ozserver.port" value="8003"> <param name="repository_agent.user" value="admin"> <param name="repository_agent.pass" value="admin"> <param name="odi.clientdmtype" value="dm_client_use_memory"> <param name="odi.serverdmtype" value="dm_server_use_memory"> <param name="odi.fetchtype" value="dm_concurrent_fetch"> <param name="ozadoc.path" value="appsample.oza"> </OBJECT> 'ozadoc.path'. 'AppSample.oza'. HTML HTML appsample.html. 52 FORCS Co., LTD
A Leader of Enterprise e-business Solution Step 4. 1) HTML (appsample.html). 2). 'install.base' 'install.namespace'. FORCS Co., LTD 53
OZ Application Designer Getting Started 3). 54 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 55
OZ Application Designer 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