PowerBuilder????

1
PowerBuilder????

• ??? ??
• ??? ??? ??
• ???????

2
?1? PowerBuilder????

• PowerBuilder?????????????????Sybase
  Inc.????PowerSoft? 1991?6????????????? .
• PowerBuilder?????????????????/???(Client/Server)??
  ????????,????????????????,???????Internet??????
• PowerBuilder?????????????,????????????,??????Power
  Builder,??????????????????????????????????????
• ?PowerBuilder?????????????,?????????????????,?????
  ?????PowerBuilder??????,???????????????
• PowerBuilder??????????/??????????????World Wide
  Web???????????,??????????,???????OLE,OCX,??????,?P
  owerBuilder???????????????

3
?1? PowerBuilder????

• 1.1 PowerBuilder???
• 1.2 ??????IDE??
• 1.3 ??Code Examples
• 1.4 ????????
• 1.5 ????????

4
1.1 PowerBuilder???

• 1. ?????/???????
• ??/???????????????????????????????????????
  ,?????????????????PowerBuilder????????????????????
  ????,????/????????
• 2. ???????
• ??????????????(?????),??????????,?????????
  ???????PowerBuilder?????
• 3. ?????????????
• ?????????????????????,PowerBuilder??????
  ???????(RDBMS),????????,?????????????????,????????
  ??ODBC???????? PowerBuilder????????????????????Ada
  ptive Server Anywhere8.0,????????????????????
• 4. ???????????
• PB??????????,???????????????????????????????
  ???????????,???????????,?????????????

5
1.1 PowerBuilder???

• 5. ????????????????
• PB???????????????????????????????????????????
  ?,???????????????????????,???????????????,????????
  ?????????????HTML???
• 6. ?????????
• ????????????????????,????????????????????????
  ???,?????????????????,???????????????????????,????
  ?????????????????????
• 7. ???????????
• ??????,??????????????????????????????????????
  ??????????????????????DBMS??????DBMS?
• 8. ??????????????
• PowerBuilder??????????????????????,??????????
  ?,????,?????????????????,?????????????

6
1.1 PowerBuilder???

• 9. ??????
• PB?????PowerScript???????????,?????????????
  ????????DDE,OLE???????????????????,????????
• 10.?Web?????
• Internet???????
• (1) Web.PB DLL (2) Web.PB?? (3)
  Web.PB??
• (4) PowerBuilder Window Plug-in DLL?(5)
  Window ActiveX
• (6) PowerBuilder DataWindow Plug-in DLL?
• (7) OReilly WebSite Web???? (8) Context??
• (9) HTML?? (10) JavaBean??
• 11.??????????
• ????????????
• (1)???? (2) ???? (3) ???????????????????
  ? (4) ??????(Push)

7
1.2 ??????IDE??

• 1. ???
• ??????????????????????????????????
• File???
• Run???
• Tools???
• 2. ??
• ????????????????????
• 3. ???
• ?????,??????????.

8
1.2 ??????IDE??

• ????????
• Application painter???? ?????????????????
• Database painter??????????,??????????,??????????
  
• DataWindow painter??????????????
• Data pipeline painter??????????????,?????????????
  ????
• Function painter??????????
• Library painter??????????PowerBuilder????
• Menu painter??????????
• Project painter???????????????????????
• Query painter???????????SQL Select??,????Query??,
  ????????????

9
1.2 ??????IDE??

• Select painterSelect????????????????SQL
  Select??
• Structure painter??????????
• User Object painter????????????
• Window painter??????????
• 4. ????
• ??????,??????????????????????????

10
1.3 ??Code Examples

• 1.Code Examples???
• (1)???????????????,??????Code Examples??,?????????
  ???
• (2)?????????????,??????????????
• (3)???????????,????????????
• (4)???????????Description?????Techniques????????,?
  ?????????????????????????
• (5)????Code Examples?????????????????????????
• ? PowerBuilder??

11
1.3 ??Code Examples

• 2.Code Examples???????
• (1) ??Code Examples??

• File???New?New??????????Workspace?,??

12
1.3 ??Code Examples

• ?????????,??????????ex.pbw?

13
1.3 ??Code Examples

• ??????,????????ex???????????Add Target?

14
1.3 ??Code Examples

• ??Add Target To Workspace??????PowerBuilder????
  ?pbexamfe.pbl???

15
1.3 ??Code Examples

• (2) ??Code Examples??
• ??Run????,??????1-11???
• 3.???????
• ?????????,???????????????????,??????????????
  ?????????????????????Related Objects?,???????????
  ??,????????????,??????????
• 4.????
• ?????????????,????????Run!????, ?????????

16
1.4 ????????

• 1. ?????????
• ?????????,??????????,?????????????,???????
  ?,?????????,??????????????????????????
• 2. ?????????
• ??????????????????????????????????????
  ???????????????????????????????????,????????????
  ????,????????,????????????????????????????????????
  ??
• 3. ?????????
• ??????????????,????????,??????,??????,????
  ??????????
• 4. ??????????
• ????????Workspace?????1-12,?????? New
  ?? ????New??? ?????Workspace?, ??OK
  ,???????,??????????????? ?,?????

17
1.4 ????????
18
1.4 ????????

• ??????Application?????1-13,??????New??????New?
  ?? ?????Target? ???Application?????Template
  Application,??OK?

19
1.5 ????????

• ?????????,????????????????????
• ?1-15 ?????
• ????

20
1.5 ????????

• ???????????????????D\myPBEx ?
• ??
• 1.????
• (1) ???????????New???? ???Workspace?,??OK,??
  ???????,????????D\myPBEx,??????Ex1?
• (2) ?????????New?????Target????Application,??
  OK????????,????????D\myPBEx,??????CalArea,??1
  -16,?????Finish,???????????????????.pbl?.pbt
  ????CalArea.pbl???????CalArea.pbt?

21
1.5 ????????

• ?1-16
• ??CalArea??

22
1.5 ????????

• 2.???????????
• (1)????,?????????New?????PB Object?,??Window??
  ,????????????????,?????????layout????????(Properti
  es)??General??,?Title?????????????,???????
• (2)????????,???????

23
1.5 ????????

• ????,???????w_calarea?????
• ?1-17 w_calarea????

24
1.5 ????????

• 3.????
• (1)????????Clicked???????cb_1??,??????
• decimal r
• rdec(sle_1.text)
• sle_2.textstring(3.14159rr)
• (2)??????,????CalArea,??????? ???
  ???????????Open?????
• Open(w_calarea)

25
1.5 ????????

• ??????????
• ?1-18
• Open ??
• ???
• 4. ??????
• ??Run????,???????????????

26
??????Application???
27
Run????
28
(No Transcript)
29
(No Transcript)
30
File???

• New ??
• Inherit ??
• Open ??
• Run/Preview ???????
• Open Workspace ????????
• Printer Setup ?????
• Recent Objectsgt ????????
• Recent Workspacegt ??????????

• Recent Connectionsgt ?????????
• Exit ??PowerBuilder??
• Incremental Build Workspace
• ????????????
• Full Build Workspace ???????????
• Deploy Workspace ??????

31
Run???

• Debug ???????
• Select and Debug ????
• Run ???????
• Select and Run ????
• Skip Operation ????
• Stop Operation ????
• Next Error/Message ?????/??
•  Previous Error/Message ?????/??

32
Tools???

• Toolbars ??????????
• Keyboard Shortcuts ??????
• System Options ??????
• To Do List ???????????,????????????????
• Browser ??????????????????,????????????
• Library Painter ?????????

• Database Profile ???????
• EA Server Profile ??????????????
• Database Painter ?????????
• File Editor ?????????????
• Tile Vertical ??????
• Tile Horizontal ??????
• Layer ????
• Cascade ????

33
Tools???

• Arrange Icons ??????
• Close All ??????
• System Tree ?????
• Output ????
• Clip ?????
• Contents????
• Welcome to PowerBuilder8.0 PowerBuilder8.0??

• Sybase Web Site ??Sybase????
• Electronic Case Management ??????
• Sybase Online Books Site ??Sybase????????
• AboutPowerBuilder PowerBuilder????