内容文本说明exday

1、练习列表注： 理解级别 掌握级别 应用级别练习 ：重定向 JJ+SV9KXRKZ PGG1VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG OU 6XOTZ=XOZKX! OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *XOKX3GTGMKX!OSVUXZ PGG YWR 6XKVGXKJ9ZGZKSKTZ!OSVUXZ PGG YWR 972+IKVZOUT!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ P

2、GG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK! VHROI IRGYY JJ+SV9KXRKZ KZKTJY .ZZV9KXRKZaVHROI UOJ YKXOIK .ZZV9KXRKZ8KWKYZ XKWKYZ .ZZV9KXRKZ8KYVUTYK XKYVUTYK 名称描述级别 重定向掌握重定向的语句，理解重定向的流程 雇员的增删改查综合练9KXRKZ 中进行数据库操作，掌握 S_YWR 数据库的使用方法 *5 及工厂模式理解 *5 的含义，在今后的编程过程中融入 *5 的操作，理解工厂模

3、式并尽量达到熟练应用 2ZNXUY 9KXRKZ+IKVZOUT /5+IKVZOUTa 这行代码要放在MKZ6GXGSKZKX 执行之前。 XKWKYZ YKZ)NGXGIZKX+TIUJOTM ZL !9ZXOTM TGSK # XKWKYZ MKZ6GXGSKZKX TGSK ! JUHRK YGRGX_ # *UHRK VGXYK*UHRK XKWKYZ MKZ6GXGSKZKX YGRGX_ !OTZ GMK # /TZKMKX VGXYK/TZ XKWKYZ MKZ6GXGSKZKX GMK !9_YZKS UZ VXOTZRT TGSK TGSK !9_YZKS UZ VXOTZ

4、RT YGRGX_ YGRGX_ !9_YZKS UZ VXOTZRT GMK GMK !数据库)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX ! IUTT # *XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ !6XKVGXKJ9ZGZKSKTZ VXKV # IUTT VXKVGXK9ZGZKSKTZ OTYKXZ OTZU ZEKSV TGSK YGRGX_ GMK GRKY % % % !VXKV YKZ9ZXOTM TGSK ! V

5、XKV YKZ*UHRK YGRGX_ !VXKV YKZ/TZ GMK ! VXKV KKIZK;VJGZK ! XKYVUTYK YKZ)UTZKTZ:_VK ZKZ NZSR!INGXYKZ#ZL !6XOTZ=XOZKX UZ # XKYVUTYK MKZ=XOZKX !UZ VXOTZRT 添加雇员成功 ! UZ VXOTZRT G NXKL# ROYZ $ 查看雇员 G$ ! 2OYZ+SV9KXRKZ PGG3VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG OU 6XOTZ=XOZKX! OSVUXZ PGG YWR )UTTKIZ

6、OUT! OSVUXZ PGG YWR *XOKX3GTGMKX! OSVUXZ PGG YWR 8KYRZ9KZ!OSVUXZ PGG YWR 972+IKVZOUT! OSVUXZ PGG YWR 9ZGZKSKTZ!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ!UZ IRUYK ! 重定向XKYVUTYK YKTJ8KJOXKIZ ROYZ !c IGZIN +IKVZOUT K a YZKV 先日志K VXOTZ9ZG

7、IQ:XGIK ! YZKV 抛出ZNXU TK 9KXRKZ+IKVZOUT K !cLOTGRR_aOL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN 972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc4OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK!VHROI IRGYY 2OYZ+SV9KXRKZ KZKTJY .ZZV9KXRKZa VHROI UOJ YKXOIK .ZZV9KXRKZ8KWKYZ XKWKYZ .ZZV9KXRKZ8KYVUTYK XKYVUTYK ZNXUY 9KXRKZ

8、+IKVZOUT /5+IKVZOUTa数据库)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX !IUTT #*XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ ! 9ZGZKSKTZ YZGZ #IUTT IXKGZK9ZGZKSKTZ !8KYRZ9KZ XYZ # YZGZ KKIZK7KX_ YKRKIZ LXUS ZEKSV ! 使用查询得到的结果，生成一个表格 XKYVUTYK YKZ)UTZKTZ:_VK ZKZ NZSR!INGX

9、YKZ#ZL !6XOTZ=XOZKX UZ # XKYVUTYK MKZ=XOZKX !UZ VXOTZRT ZGHRK HUXJKX# OJZN# IKRRVGJJOTM# IKRRYVGIOTM# $ !UZ VXOTZRT ZX$ ZJ$OJ ZJ$ ZJ$ ZJ$ ZJ$薪水 ZJ$ ZJ$ ZJ$ ZX$ !NORK XYZ TKZ aRUTM OJ #XYZ MKZ2UTM OJ ! GJJ+SV NZSR5NZSR$ NKGJ$SKZG NZZV KWO# )UTZKTZ :_VK 9ZXOTM TGSK #XYZ MKZ9ZXOTM TGSK !JUHRK YGRGX_ #X

10、YZ MKZ*UHRK YGRGX_ !OTZ GMK #XYZ MKZ/TZ GMK ! UZ VXOTZRT ZX$ZJ$ OJ ZJ$ZJ$ TGSK ZJ$ZJ$ YGRGX_ ZJ$ZJ$ GMK ZJ$ ZX$ !cUZ VXOTZRT ZGHRK$ ! UZ VXOTZRT G NXKL# GJJ+SV NZSR $ 增加新雇员 G$ !UZ IRUYK !c IGZIN +IKVZOUT K aK VXOTZ9ZGIQ:XGIK !ZNXU TK 9KXRKZ+IKVZOUT K !cLOTGRR_aOL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN

11、972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc KXX NZSR KH SR6%SR KXYOUT# KTIUJOTM# ;:, %$ KH GVV KXYOUT# SRTY# NZZV PGG YT IUS SR TY P KK SRTY YO# NZZV UXM 329INKSG OTYZGTIK YO YINKSG2UIGZOUT#NZSR$ NKGJ$SKZG NZZV KWO# )UTZKTZ :_VK IUTZKTZ# ZKZ NZSR! INGXYKZ#;:, $ZOZRK$/TYKXZ ZOZRK NKXK ZOZRK$ NKGJ$HUJ_ Y

12、Z_RK# LUTZ YOK V!IURUX XKJ! $发生了系统错误，请稍后G NXKL# GJJ+SV NZSR $重试 G$ HUJ_$ NZSR$IUTZKTZ# ZKZ NZSR! INGXYKZ#ZL $ZOZRK$GJJ+SV ZOZRK$ NKGJ$HUJ_ YZ_RK# LUTZ YOK V! $LUXS GIZOUT# GJJ SKZNUJ# VUYZ $ LOKRJYKZ$RKMKTJ$添加雇员 RKMKTJ$ OTVZ TGSK# TGSK $HX $薪水 OTVZ TGSK# YGRGX_ $HX $ OTVZ TGSK# GMK $HX $OTVZ Z_VK# Y

13、HSOZ GRK# 确认 $ LOKRJYKZ$ LUXS$ HUJ_$ NZSR$执行结果 开启 :)6 /6 3UTOZUX，“NZZV RUIGRNUYZ KH GJJ+SV NZSR”7 NZZV PGG YT IUS SR TY P KKNZZV PGG YT IUS SR TY P KK KH GVVE E YJ $ YKXRKZ$YKXRKZ TGSK$GJJ+SV9KXRKZ YKXRKZ TGSK$ YKXRKZ IRGYY$KH JJ+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$YKXRKZ$YKXRKZ TGSK$ROYZ+SV9KXRKZ YKXRKZ

14、TGSK$ YKXRKZ IRGYY$KH 2OYZ+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$YKXRKZ SGVVOTM$YKXRKZ TGSK$GJJ+SV9KXRKZ YKXRKZ TGSK$ XR VGZZKXT$ GJJ XR VGZZKXT$ YKXRKZ SGVVOTM$ YKXRKZ SGVVOTM$ YKXRKZ TGSK$ROYZ+SV9KXRKZ YKXRKZ TGSK$ XR VGZZKXT$ ROYZ XR VGZZKXT$ YKXRKZ SGVVOTM$KXXUX VGMK$ 方式 KXXUX IUJK$ KXXUX IUJK$ $ 方式 $KI

15、KVZOUT Z_VK$PGG YKXRKZ 9KXRKZ+IKVZOUT KIKVZOUT Z_VK$RUIGZOUT$ KXXUX NZSR RUIGZOUT$ KXXUX VGMK$ KH GVV$点击“确定”提交数据 页面直接跳转到“NZZV RUIGRNUYZ KH ROYZ” :)6 /6 3UTOZUX 显示8练习 ：雇员的增删改查 2OYZ+SV9KXRKZ PGG9VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG OU 6XOTZ=XOZKX! OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *

16、XOKX3GTGMKX! OSVUXZ PGG YWR 8KYRZ9KZ!OSVUXZ PGG YWR 972+IKVZOUT! OSVUXZ PGG YWR 9ZGZKSKTZ!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK!VHROI IRGYY 2OYZ+SV9KXRKZ KZKTJY .ZZV9KXRKZa10VHROI UOJ YKX

17、OIK .ZZV9KXRKZ8KWKYZ XKWKYZ .ZZV9KXRKZ8KYVUTYK XKYVUTYK ZNXUY 9KXRKZ+IKVZOUT /5+IKVZOUTa数据库)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX !IUTT #*XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ ! 9ZGZKSKTZ YZGZ #IUTT IXKGZK9ZGZKSKTZ !8KYRZ9KZ XYZ # YZGZ KKIZK7KX_ YKRKIZ

18、 LXUS ZEKSV ! 使用查询得到的结果，生成一个表格 XKYVUTYK YKZ)UTZKTZ:_VK ZKZ NZSR!INGXYKZ#ZL !6XOTZ=XOZKX UZ # XKYVUTYK MKZ=XOZKX !UZ VXOTZRT ZGHRK HUXJKX# OJZN# IKRRVGJJOTM# IKRRYVGIOTM# $ !UZ VXOTZRT ZX$ ZJ$OJ ZJ$ ZJ$ ZJ$ ZJ$薪水 ZJ$ ZJ$ ZJ$ ZJ$操作 ZJ$ ZX$ !NORK XYZ TKZ aRUTM OJ #XYZ MKZ2UTM OJ !9ZXOTM TGSK #XYZ MKZ9Z

19、XOTM TGSK ! *KR+SV9KXRKZ PGG11JUHRK YGRGX_ #XYZ MKZ*UHRK YGRGX_ !OTZ GMK #XYZ MKZ/TZ GMK ! UZ VXOTZRT ZX$ZJ$ OJ ZJ$ZJ$ TGSK ZJ$ZJ$ YGRGX_ ZJ$ZJ$ GMK ZJ$ZJ$ G NXKL# JKR%OJ# OJ $ 删除 G$ THYV! G NXKL# RUGJ%OJ# OJ $ 修改 G$ ZJ$ ZX$ !cUZ VXOTZRT ZGHRK$ ! UZ VXOTZRT G NXKL# GJJ+SV NZSR $ 增加新雇员 G$ !UZ IRUYK !

20、c IGZIN +IKVZOUT K aK VXOTZ9ZGIQ:XGIK !ZNXU TK 9KXRKZ+IKVZOUT K !cLOTGRR_aOL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN 972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc12VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *XOKX3GTGMKX!OSVUXZ PGG YWR 6XKVGXKJ9ZGZKSKTZ! OSVUXZ PGG YWR 972+

21、IKVZOUT!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK!VHROI IRGYY *KR+SV9KXRKZKZKTJY .ZZV9KXRKZaVHROI UOJ YKXOIK .ZZV9KXRKZ8KWKYZ XKWKYZ .ZZV9KXRKZ8KYVUTYK XKYVUTYK ZNXUY 9KXRKZ+IKVZOUT /5+IKVZOU

22、TaRUTM OJ #2UTM VGXYK2UTM XKWKYZ MKZ6GXGSKZKX OJ !数据库)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX ! IUTT # *XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ !6XKVGXKJ9ZGZKSKTZ VXKV # IUTT VXKVGXK9ZGZKSKTZ JKRKZK LXUS ZEKSV NKXK OJ # % !VXKV YKZ2UTM OJ ! VXKV KKIZK;VJGZ

23、K ! 重定向XKYVUTYK YKTJ8KJOXKIZ ROYZ ! 2UGJ+SV9KXRKZ PGG13VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG OU 6XOTZ=XOZKX! OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *XOKX3GTGMKX!OSVUXZ PGG YWR 6XKVGXKJ9ZGZKSKTZ!OSVUXZ PGG YWR 8KYRZ9KZ! OSVUXZ PGG YWR 972+IKVZOUT! OSVUXZ PGG YWR 9ZGZKSKTZ!OSVUXZ PGG YKXR

24、KZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK!VHROI IRGYY 2UGJ+SV9KXRKZ KZKTJY .ZZV9KXRKZa VHROI UOJ YKXOIK .ZZV9KXRKZ8KWKYZ XKWKYZ c IGZIN +IKVZOUT K a YZKV 先日志K VXOTZ9ZGIQ:XGIK ! YZKV 抛出ZNXU TK 9KXRKZ+IKVZOUT

25、 K !cLOTGRR_aOL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN 972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc14.ZZV9KXRKZ8KYVUTYK XKYVUTYK ZNXUY 9KXRKZ+IKVZOUT /5+IKVZOUTa RUTM OJ # 2UTM VGXYK2UTM XKWKYZ MKZ6GXGSKZKX OJ !数据库)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX !IUTT #*XOKX3GTGMKX MKZ)UTTKIZO

26、UT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ !6XKVGXKJ9ZGZKSKTZ VXKV # IUTT VXKVGXK9ZGZKSKTZ YKRKIZ LXUS ZEKSV NKXK OJ # % !VXKV YKZ2UTM OJ !8KYRZ9KZ XYZ # VXKV KKIZK7KX_ ! XKYVUTYK YKZ)UTZKTZ:_VK ZKZ NZSR!INGXYKZ#ZL !6XOTZ=XOZKX UZ # XKYVUTYK MKZ=XOZKX !OL XYZ TKZ a9ZXOTM TGSK #XYZ MKZ9ZXOTM TGSK !JUHRK

27、 YGRGX_ #XYZ MKZ*UHRK YGRGX_ !OTZ GMK #XYZ MKZ/TZ GMK !UZ VXOTZRT LUXS GIZOUT# SUJOL_%OJ# OJ SKZNUJ# VUYZ $ !UZ VXOTZRT OJ OJ HX $ !UZ VXOTZRT OTVZ TGSK# TGSK GRK# TGSK $HX $ !UZ VXOTZRT 薪水 OTVZ TGSK# YGRGX_ GRK# 3UJOL_+SV9KXRKZ PGG15VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG YWR )UTTKIZOUT! OS

28、VUXZ PGG YWR *XOKX3GTGMKX!OSVUXZ PGG YWR 6XKVGXKJ9ZGZKSKTZ! OSVUXZ PGG YWR 972+IKVZOUT!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!YGRGX_ $HX $ !UZ VXOTZRT OTVZ TGSK# GMK GRK# GMK $HX $ !UZ VXOTZRT OTVZ Z_VK# YHSOZ GRK# 确认 $ !UZ VXOTZRT LUXS$ !UZ IRUYK !ccIGZIN +IKVZOUT K aK

29、VXOTZ9ZGIQ:XGIK !ZNXU TK 9KXRKZ+IKVZOUT K !cLOTGRR_aOL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN 972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc16OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK!VHROI IRGYY 3UJOL_+SV9KXRKZ KZKTJY .ZZV9KXRKZa VHROI UOJ YKXOIK .ZZV9KXRKZ8KWKYZ XKWK

30、YZ .ZZV9KXRKZ8KYVUTYK XKYVUTYK ZNXUY 9KXRKZ+IKVZOUT /5+IKVZOUTaXKWKYZ YKZ)NGXGIZKX+TIUJOTM ZL ! RUTM OJ #2UTM VGXYK2UTM XKWKYZ MKZ6GXGSKZKX OJ !9ZXOTM TGSK #XKWKYZ MKZ6GXGSKZKX TGSK !JUHRK YGRGX_ #*UHRK VGXYK*UHRK XKWKYZ MKZ6GXGSKZKX YGRGX_ !OTZ GMK # /TZKMKX VGXYK/TZ XKWKYZ MKZ6GXGSKZKX GMK !数据库)UT

31、TKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX !IUTT #*XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ !6XKVGXKJ9ZGZKSKTZ VXKV # IUTT VXKVGXK9ZGZKSKTZ VJGZK ZEKSV YKZ TGSK#% YGRGX_#% GMK#% NKXK OJ#% !VXKV YKZ9ZXOTM TGSK ! VXKV YKZ*UHRK YGRGX_ ! VXKV YKZ2UTM GMK !VXKV YKZ2U

32、TM OJ ! JJ+SV9KXRKZ PGG17VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG OU 6XOTZ=XOZKX! OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *XOKX3GTGMKX!OSVUXZ PGG YWR 6XKVGXKJ9ZGZKSKTZ!OSVUXZ PGG YWR 972+IKVZOUT!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9

33、KXRKZ8KWKYZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK! VHROI IRGYY JJ+SV9KXRKZ KZKTJY .ZZV9KXRKZaVHROI UOJ YKXOIK .ZZV9KXRKZ8KWKYZ XKWKYZ .ZZV9KXRKZ8KYVUTYK XKYVUTYK VXKV KKIZK;VJGZK !XKYVUTYK YKTJ8KJOXKIZ ROYZ ! cIGZIN +IKVZOUT K aK VXOTZ9ZGIQ:XGIK !ZNXU TK 9KXRKZ+IKVZOUT K !cLOTGRR_aOL IUTT #TRR a

34、ZX_ aIUTT IRUYK !c IGZIN 972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc18ZNXUY 9KXRKZ+IKVZOUT /5+IKVZOUTa 这行代码要放在MKZ6GXGSKZKX 执行之前。 XKWKYZ YKZ)NGXGIZKX+TIUJOTM ZL !9ZXOTM TGSK # XKWKYZ MKZ6GXGSKZKX TGSK ! JUHRK YGRGX_ # *UHRK VGXYK*UHRK XKWKYZ MKZ6GXGSKZKX YGRGX_ !OTZ GMK # /TZKMKX VGXYK/TZ XKWKYZ MKZ6GXG

35、SKZKX GMK !9_YZKS UZ VXOTZRT TGSK TGSK !9_YZKS UZ VXOTZRT YGRGX_ YGRGX_ !9_YZKS UZ VXOTZRT GMK GMK !数据库)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX ! IUTT # *XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ !6XKVGXKJ9ZGZKSKTZ VXKV # IUTT VXKVGXK9ZGZKSKTZ OTYKXZ OTZU ZE

36、KSV TGSK YGRGX_ GMK GRKY % % % !VXKV YKZ9ZXOTM TGSK ! VXKV YKZ*UHRK YGRGX_ !VXKV YKZ/TZ GMK ! VXKV KKIZK;VJGZK ! XKYVUTYK YKZ)UTZKTZ:_VK ZKZ NZSR!INGXYKZ#ZL !6XOTZ=XOZKX UZ # XKYVUTYK MKZ=XOZKX !UZ VXOTZRT 添加雇员成功 ! UZ VXOTZRT G NXKL# ROYZ $ GJJ+SV NZSR19NZSR$NKGJ$SKZG NZZV KWO# )UTZKTZ :_VK IUTZKTZ#

37、 ZKZ NZSR! INGXYKZ#ZL $ ZOZRK$GJJ+SV ZOZRK$ NKGJ$HUJ_ YZ_RK# LUTZ YOK V! $LUXS GIZOUT# GJJ SKZNUJ# VUYZ $ LOKRJYKZ$RKMKTJ$添加雇员 RKMKTJ$ OTVZ TGSK# TGSK $HX $薪水 OTVZ TGSK# YGRGX_ $HX $ 查看雇员 G$ ! UZ IRUYK ! 重定向XKYVUTYK YKTJ8KJOXKIZ ROYZ !c IGZIN +IKVZOUT K a YZKV 先日志K VXOTZ9ZGIQ:XGIK ! YZKV 抛出ZNXU TK 9

38、KXRKZ+IKVZOUT K !cLOTGRR_aOL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN 972+IKVZOUT K a K VXOTZ9ZGIQ:XGIK !ccccc KXXUX NZSR KH SR20%SR KXYOUT# KTIUJOTM# ;:, %$KH GVV KXYOUT# SRTY# NZZV PGG YT IUS SR TY P KK SRTY YO# NZZV UXM 329INKSG OTYZGTIK YO YINKSG2UIGZOUT# NZZV PGG YT IUS SR TY P KKNZZV PGG YT IUS SR

39、TY P KK KH GVVE E YJ $ YKXRKZ$YKXRKZ TGSK$GJJ+SV9KXRKZ YKXRKZ TGSK$ YKXRKZ IRGYY$KH JJ+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$ YKXRKZ$YKXRKZ TGSK$ROYZ+SV9KXRKZ YKXRKZ TGSK$ YKXRKZ IRGYY$KH 2OYZ+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$ YKXRKZ$YKXRKZ TGSK$JKR+SV9KXRKZ YKXRKZ TGSK$NZSR$ NKGJ$SKZG NZZV KWO# )UTZKTZ :_VK I

40、UTZKTZ# ZKZ NZSR! INGXYKZ#;:, $ ZOZRK$/TYKXZ ZOZRK NKXK ZOZRK$ NKGJ$HUJ_ YZ_RK# LUTZ YOK V!IURUX XKJ! $发生了系统错误，请稍后G NXKL# GJJ+SV NZSR $重试 G$ HUJ_$ NZSR$ OTVZ TGSK# GMK $HX $OTVZ Z_VK# YHSOZ GRK# 确认 $ LOKRJYKZ$ LUXS$ HUJ_$ NZSR$21YKXRKZ IRGYY$KH *KR+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$YKXRKZ$YKXRKZ TGSK$RU

41、GJ+SV9KXRKZ YKXRKZ TGSK$ YKXRKZ IRGYY$KH 2UGJ+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$ YKXRKZ$YKXRKZ TGSK$SUJOL_+SV9KXRKZ YKXRKZ TGSK$ YKXRKZ IRGYY$KH 3UJOL_+SV9KXRKZ YKXRKZ IRGYY$ YKXRKZ$YKXRKZ SGVVOTM$YKXRKZ TGSK$GJJ+SV9KXRKZ YKXRKZ TGSK$ XR VGZZKXT$ GJJ XR VGZZKXT$ YKXRKZ SGVVOTM$ YKXRKZ SGVVOTM$YKXRKZ TGS

42、K$ROYZ+SV9KXRKZ YKXRKZ TGSK$ XR VGZZKXT$ ROYZ XR VGZZKXT$ YKXRKZ SGVVOTM$ YKXRKZ SGVVOTM$YKXRKZ TGSK$JKR+SV9KXRKZ YKXRKZ TGSK$XR VGZZKXT$ JKR XR VGZZKXT$ YKXRKZ SGVVOTM$YKXRKZ SGVVOTM$YKXRKZ TGSK$RUGJ+SV9KXRKZ YKXRKZ TGSK$ XR VGZZKXT$ RUGJ XR VGZZKXT$ YKXRKZ SGVVOTM$ YKXRKZ SGVVOTM$YKXRKZ TGSK$SUJOL

43、_+SV9KXRKZ YKXRKZ TGSK$ XR VGZZKXT$ SUJOL_ XR VGZZKXT$ YKXRKZ SGVVOTM$KXXUX VGMK$KXXUX IUJK$ KXXUX IUJK$ RUIGZOUT$ KXXUX NZSR RUIGZOUT$ KXXUX VGMK$ KH GVV$练习 ：*5 及工厂模式项目结构 参考代码 +SVRU_KK PGG22VGIQGMK KTZOZ_! 实体类&GZNUX ZKGINKX +SVRU_KK*5 PGG23VGIQGMK JGU!OSVUXZ PGG ZOR 2OYZ! OSVUXZ KTZOZ_ +SVRU_KK! *

44、*5 接口&GZNUX ZKGINKX VHROI OTZKXLGIK +SVRU_KK*5 a VHROI UOJ YGK +SVRU_KK K ZNXUY 972+IKVZOUT!这种方式不好 因为出现了 PJHI 的异常类，这就要求实现该方法叧能使用PJHI VHROI 2OYZ+SVRU_KK$ LOTJRR ZNXUY +IKVZOUT!VHROI UOJ JKRKZK RUTM OJ ZNXUY +IKVZOUT! VHROI IRGYY +SVRU_KK aVXOGZK RUTM OJ! VXOGZK 9ZXOTM TGSK! VXOGZK JUHRK YGRGX_! VXOGZ

45、K OTZ GMK!VHROI OTZ MKZMK aXKZXT GMK!cVHROI UOJ YKZMK OTZ GMK aZNOY GMK # GMK!cVHROI RUTM MKZ/J aXKZXT OJ!cVHROI UOJ YKZ/J RUTM OJ aZNOY OJ # OJ!c VHROI 9ZXOTM MKZ4GSK aXKZXT TGSK!c VHROI UOJ YKZ4GSK 9ZXOTM TGSK aZNOY TGSK # TGSK!cVHROI JUHRK MKZ9GRGX_ aXKZXT YGRGX_!cVHROI UOJ YKZ9GRGX_ JUHRK YGRGX_

46、 aZNOY YGRGX_ # YGRGX_!cc +SVRU_KK*50JHI/SVR PGG24VGIQGMK JGU OSVR!OSVUXZ PGG YWR )UTTKIZOUT!OSVUXZ PGG YWR 6XKVGXKJ9ZGZKSKTZ! OSVUXZ PGG YWR 8KYRZ9KZ!OSVUXZ PGG YWR 9ZGZKSKTZ! OSVUXZ PGG ZOR XXG_2OYZ! OSVUXZ PGG ZOR 2OYZ!OSVUXZ ZOR *(;ZOR!OSVUXZ JGU +SVRU_KK*5! OSVUXZ KTZOZ_ +SVRU_KK!VHROI IRGYY +S

47、VRU_KK*50JHI/SVROSVRKSKTZY +SVRU_KK*5aVHROI 2OYZ+SVRU_KK$ LOTJRR ZNXUY +IKVZOUT a)UTTKIZOUT IUTT # *(;ZOR MKZ)UTTKIZOUT ! 9ZGZKSKTZ YZGZ #IUTT IXKGZK9ZGZKSKTZ !8KYRZ9KZ XYZ # YZGZ KKIZK7KX_ YKRKIZ LXUS ZEKSV ! 2OYZ+SVRU_KK$ KSVRU_KKY #TK XXG_2OYZ+SVRU_KK$ !NORK XYZ TKZ a+SVRU_KK K # TK +SVRU_KK !K Y

48、KZ/J XYZ MKZ2UTM OJ !VHROI UOJ YGK +SVRU_KK K ZNXUY +IKVZOUT!VHROI +SVRU_KK LOTJ(_/J RUTM OJ ZNXUY +IKVZOUT!VHROI UOJ VJGZK +SVRU_KK K ZNXUY +IKVZOUT!c25K YKZ4GSK XYZ MKZ9ZXOTM TGSK !K YKZ9GRGX_ XYZ MKZ*UHRK YGRGX_ !K YKZMK XYZ MKZ/TZ GMK ! KSVRU_KKY GJJ K !c*(;ZOR IRUYK IUTT ! XKZXT KSVRU_KKY!cVHRO

49、I UOJ JKRKZK RUTM OJ ZNXUY +IKVZOUT a)UTTKIZOUT IUTT # *(;ZOR MKZ)UTTKIZOUT ! 6XKVGXKJ9ZGZKSKTZ VXKV #IUTT VXKVGXK9ZGZKSKTZ JKRKZK LXUS ZEKSV NKXK OJ#% !VXKV YKZ2UTM OJ ! VXKV KKIZK;VJGZK !*(;ZOR IRUYK IUTT !cVHROI UOJ YGK +SVRU_KK K ZNXUY +IKVZOUT a)UTTKIZOUT IUTT # *(;ZOR MKZ)UTTKIZOUT ! 6XKVGXKJ9

50、ZGZKSKTZ VXKV #IUTT VXKVGXK9ZGZKSKTZ OTYKXZ OTZU ZEKSV TGSK YGRGX_ GMK GRKY % % % !VXKV YKZ9ZXOTM K MKZ4GSK !VXKV YKZ*UHRK K MKZ9GRGX_ ! VXKV YKZ/TZ K MKZMK !VXKV KKIZK;VJGZK !*(;ZOR IRUYK IUTT !cVHROI +SVRU_KK LOTJ(_/J RUTM OJ ZNXUY +IKVZOUT a)UTTKIZOUT IUTT # *(;ZOR MKZ)UTTKIZOUT ! +SVRU_KK*5.OHKX

51、TGZK/SVR PGG26VGIQGMK JGU OSVR!6XKVGXKJ9ZGZKSKTZ VXKV #IUTT VXKVGXK9ZGZKSKTZ YKRKIZ LXUS ZEKSV NKXK OJ#% !VXKV YKZ2UTM OJ !8KYRZ9KZ XYZ # VXKV KKIZK7KX_ !+SVRU_KK K # TRR!OL XYZ TKZ aK # TK +SVRU_KK !K YKZ/J OJ !K YKZ4GSK XYZ MKZ9ZXOTM TGSK ! K YKZ9GRGX_ XYZ MKZ*UHRK YGRGX_ !K YKZMK XYZ MKZ/TZ GMK !

52、c*(;ZOR IRUYK IUTT ! XKZXT K!cVHROI UOJ VJGZK +SVRU_KK K ZNXUY +IKVZOUT a)UTTKIZOUT IUTT # *(;ZOR MKZ)UTTKIZOUT ! 6XKVGXKJ9ZGZKSKTZ VXKV #IUTT VXKVGXK9ZGZKSKTZ VJGZK ZEKSV YKZ TGSK#% YGRGX_#% GMK#% NKXK OJ#% ! VXKV YKZ9ZXOTM K MKZ4GSK !VXKV YKZ*UHRK K MKZ9GRGX_ ! VXKV YKZ/TZ K MKZMK !VXKV YKZ2UTM K

53、MKZ/J !VXKV KKIZK;VJGZK !*(;ZOR IRUYK IUTT !ccOSVUXZ PGG ZOR 2OYZ!OSVUXZ JGU +SVRU_KK*5! OSVUXZ KTZOZ_ +SVRU_KK! JGU 的另外一个实现&GZNUX ZKGINKX VHROI IRGYY +SVRU_KK*5.OHKXTGZK/SVR OSVRKSKTZY +SVRU_KK*5aVHROI UOJ JKRKZK RUTM OJ ZNXUY +IKVZOUT acVHROI 2OYZ+SVRU_KK$ LOTJRR ZNXUY +IKVZOUT a 9_YZKS UZ VXOTZRT

54、 NOHKXTGZK 实现 LOTJRR !XKZXT TRR!cVHROI +SVRU_KK LOTJ(_/J RUTM OJ ZNXUY +IKVZOUT a XKZXT TRR!cVHROI UOJ YGK +SVRU_KK K ZNXUY +IKVZOUT acVHROI UOJ VJGZK +SVRU_KK K ZNXUY +IKVZOUT acc :KYZ*5 PGG27 *5,GIZUX_ PGG28VGIQGMK ZOR!OSVUXZ JGU OSVR +SVRU_KK*5.OHKXTGZK/SVR!VGIQGMK ZKYZ!OSVUXZ PGG ZOR 2OYZ!OSVUXZ

55、 JGU +SVRU_KK*5!OSVUXZ JGU OSVR +SVRU_KK*50JHI/SVR! OSVUXZ KTZOZ_ +SVRU_KK!VHROI IRGYY :KYZ*5 aVHROI YZGZOI UOJ SGOT 9ZXOTMAC GXMY ZNXUY +IKVZOUT a+SVRU_KK*5 JGU # TK +SVRU_KK*50JHI/SVR ! 查找全部 2OYZ+SVRU_KK$ KSVRU_KKY # JGU LOTJRR !9_YZKS UZ VXOTZRT KSVRU_KKY YOK ! 删除 JGU JKRKZK !数据 +SVRU_KK K # TK +

56、SVRU_KK ! K YKZ4GSK GHI ! K YKZ9GRGX_ ! K YKZMK ! JGU YGK K ! 按 OJ 查找 +SVRU_KK K # JGU LOTJ(_/J ! 9_YZKS UZ VXOTZRT K MKZ4GSK !cc *(;ZOR PGG29VGIQGMK ZOR!OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *XOKX3GTGMKX! OSVUXZ PGG YWR 972+IKVZOUT! PJHI 工具类，提供获得连接、关闭连接的方法&GZNUX ZKGINKX VHROI IRGYY *(;ZOR aVHRO

57、I YZGZOI )UTTKIZOUT MKZ)UTTKIZOUT ZNXUY +IKVZOUTa)UTTKIZOUT IUTT # TRR!ZX_ a)RGYY LUX4GSK IUS S_YWR PJHI *XOKX ! IUTT # *XOKX3GTGMKX MKZ)UTTKIZOUT PJHI S_YWR RUIGRNUYZ PJ JH XUUZ XUUZ !OSVUXZ JGU OSVR +SVRU_KK*50JHI/SVR! JGU 工厂，为调用者提供 JGU 实现类的实例&GZNUX ZKGINKX VHROI IRGYY *5,GIZUX_ aVHROI YZGZOI 5HPK

58、IZ MKZ/TYZGTIK 9ZXOTM Z_VK a 5HPKIZ UHP # TRR!OL Z_VK KWGRY +SVRU_KK*5 a UHP # TK +SVRU_KK*50JHI/SVR ! UHP # TK +SVRU_KK*5.OHKXTGZK/SVR !cXKZXT UHP!cc JJ+SV9KXRKZ PGG30VGIQGMK KH!OSVUXZ PGG OU /5+IKVZOUT! OSVUXZ PGG OU 6XOTZ=XOZKX! OSVUXZ PGG YWR )UTTKIZOUT! OSVUXZ PGG YWR *XOKX3GTGMKX!OSVUXZ PGG YW

59、R 6XKVGXKJ9ZGZKSKTZ! OSVUXZ PGG YWR 972+IKVZOUT!OSVUXZ PGG YKXRKZ 9KXRKZ+IKVZOUT! OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ!OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KWKYZ!c IGZIN +IKVZOUT K aK VXOTZ9ZGIQ:XGIK !ZNXU K!cXKZXT IUTT!cVHROI YZGZOI UOJ IRUYK )UTTKIZOUT IUTT a OL IUTT #TRR aZX_ aIUTT IRUYK !c IGZIN 972+I

60、KVZOUT K a K VXOTZ9ZGIQ:XGIK !ccc 用于测试*(;ZORVHROI YZGZOI UOJ SGOT 9ZXOTMAC GXMY ZNXUY +IKVZOUT a9_YZKS UZ VXOTZRT MKZ)UTTKIZOUT !cc31OSVUXZ PGG YKXRKZ NZZV .ZZV9KXRKZ8KYVUTYK!OSVUXZ JGU +SVRU_KK*5!OSVUXZ JGU OSVR +SVRU_KK*50JHI/SVR! OSVUXZ KTZOZ_ +SVRU_KK!VHROI IRGYY JJ+SV9KXRKZ KZKTJY .ZZV9KXRKZa V