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 Description., OZC, OZS, OZF. OZ Query Designer User's Guide. OZ Repository Manager User's Guide OZ Enterprise Server Administrator's Guide.,,. Web Application Server Installation. 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 OZC FORCS Co., LTD 13
OZ Application Designer Getting Started. 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', [] 'AppSample.mdb'. 22 FORCS Co., LTD
A Leader of Enterprise e-business Solution 4) []. 5) 'AppSample'. (OZ Query Designer). 1) [] FORCS Co., LTD 23
OZ Application Designer Getting Started [ ]. 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'.. 38 FORCS Co., LTD
A Leader of Enterprise e-business Solution ODI. 1). [] [ ] [] [ ] Drag & Drop 2) ODI. 'Chart1' 'Property' 'ODIKey' 'AppSample' 'DataSet' 'SaleResultParam'. 3). [ ]. [ ] ' '. FORCS Co., LTD 39
OZ Application Designer Getting Started 4) [] X, Y, Drag & Drop. 5),, X, Y /. [X] [] X. 40 FORCS Co., LTD
A Leader of Enterprise e-business Solution [Y] [] Y /. [] ''. FORCS Co., LTD 41
OZ Application Designer Getting Started []. []. 42 FORCS Co., LTD
A Leader of Enterprise e-business Solution. 1). [ ]. 'Document' FORCS Co., LTD 43
OZ Application Designer Getting Started 'Global Function'. 'searchdata()' 'saveexcel() '. 2). 'Board1' 'OnAttached' 'searchdata()'. 44 FORCS Co., LTD
A Leader of Enterprise e-business Solution 3).. 'ComboBox1' 'OnSelectedIndexChanged' 'searchdata()'.. 'ComboBox2' 'OnSelectedIndexChanged' 'searchdata()'. FORCS Co., LTD 45
OZ Application Designer Getting Started 4) '. 'Button1' 'OnClick' 'saveexcel()'. 5). [Edit] [Preview Script]. 46 FORCS Co., LTD
A Leader of Enterprise e-business Solution Step 3 [File] [Preview] [ ].. FORCS Co., LTD 47
OZ Application Designer Getting Started 'AppSample.oza'. 48 FORCS Co., LTD
A Leader of Enterprise e-business Solution 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. FORCS Co., LTD 49
OZ Application Designer Getting Started Step 2 Repository Server ODI. 1) [Repository] ' ' [ ]. 2) ' ' [ ] [ ]. ( 'admin'.) 50 FORCS Co., LTD
A Leader of Enterprise e-business Solution ' ' " ". 3). 4) ' ' Drag & Drop. 'AppSample.oza' ODI 'AppSample.odi'. FORCS Co., LTD 51
OZ Application Designer Getting Started 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"> 52 FORCS Co., LTD
A Leader of Enterprise e-business Solution <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"> </OBJECT> IIS, 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="ozadoc.path" value="appsample.oza"> </OBJECT> 'ozadoc.path'. 'AppSample.oza'. HTML HTML appsample.html. FORCS Co., LTD 53
OZ Application Designer Getting Started Step 4. 1) HTML (appsample.html). 2). 'install.base' 'install.namespace'. 54 FORCS Co., LTD
A Leader of Enterprise e-business Solution 3). FORCS Co., LTD 55
OZ Application Designer Getting Started 56 FORCS Co., LTD
A Leader of Enterprise e-business Solution FORCS Co., LTD 57
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 58 FORCS Co., LTD