![public class AbstDTO implements DTO {
private Field[] fields; // 覲 覦一
private Method[] methods; // 覃 覦一
protected String[] keyNames; // 貉殊 覦一
protected String tableName; // 企 企
// 危 螻旧 覃
}
SQL 結豺 豢DTO
// Attribute 襦 覦 覲れ DTO襦 蠍磯 覈
for(String name : dto.getNames()){ // 覲れ 企 語
Object value = Request.getAttribute(name); // 覲 企 企麹 Attribute 語
dto.set(name, value); // 覲 企 企麹 螳 set
}
SQL 結豺 豢DTO 覃
12](https://image.slidesharecdn.com/4pt20170816-170925070529/85/Central-Culture-System-12-320.jpg)
More Related Content
Featured (20)
Central Culture System
- 2. Cobra - Coding brothers 覦譯狩 伎 豌瑚鍵 螻旧/ 襴 豢蟲蟯 2
- 3. 伎 3
- 4. 讌ル化 螳 覲伎 伎
- 5. 螳覦 殊 蟯 5
- 6. 螳覦 殊 6
- 7. 襦蠏碁 7
- 8. 0. 覃 ろ 螻旧 覈更
- 9. SQL 伎 螻旧 覈更 SELECT, INSERT, UPDATE, DELETE 襯 豌襴 螻旧 覈更. 企 : 覈 企 WHERE 譟郁唄 : LIKES / EQUAL ( = 觜蟲 ) WHERE 譟郁唄 螳 : 覃 ろ 轟 9
- 10. 0 2 4 6 8 10 12 14 16 18 20 dao.askdelete dao.blacklist dao.blacklistdel dao.checkPenalty dao.clubadd dao.delPenalty dao.fileUpdate dao.getBookCount dao.getRend_key dao.getRendList dao.insertbook dao.matchingcom dao.myCheck dao.myInsert dao.myUpdate dao.playeradd dao.playerselect dao.rematching dao.reservation dao.setPenalty dao.teamasklist dao.teaminsert dao.teamserch QUERY覓語 觜 蠏 豐螻 : QUERY 覓語 譬襯 : 70 譬 / 語 : 170 觜 螻旧 68螳 覈 : 82 / 覈 蠏 1.3 螻旧 7螳 覈 : 88 / 覈 蠏 12 10
- 11. // SQL FOR覓, IF 覓語 伎螻, table企螻 resultMap 伎 蟆郁骸螳 るゴ蟆 襴 <select id=鐚mySearch鐚 parameterType=鐚DTO" resultMap="myDTO"> WITH comTable AS ( SELECT * FROM (${tableName}) ) SELECT comTable.*, '${tableName}' as rtype FROM comTable <where> <foreach collection="names" item="name" separator="AND" > <bind name="value" value="_parameter.getValueSQL(name)" /> <if test="value!=''" > ${name} LIKE ('%'||${value}||'%') </if> </foreach> </where> </select> SQL 伎 螻旧 覈更伎 蟲譟 11
- 12. public class AbstDTO implements DTO { private Field[] fields; // 覲 覦一 private Method[] methods; // 覃 覦一 protected String[] keyNames; // 貉殊 覦一 protected String tableName; // 企 企 // 危 螻旧 覃 } SQL 結豺 豢DTO // Attribute 襦 覦 覲れ DTO襦 蠍磯 覈 for(String name : dto.getNames()){ // 覲れ 企 語 Object value = Request.getAttribute(name); // 覲 企 企麹 Attribute 語 dto.set(name, value); // 覲 企 企麹 螳 set } SQL 結豺 豢DTO 覃 12
- 13. 襴, / 語 66螳 伎 覿覿 7螳 螻旧 SQL覓語 譟壱朱 給. 襷豺 螻 觚襦 煙 襷 蟆螻 螳給. SQL 伎 Sequence 磯 蟲覿 覿襯 覿襯 伎 DTO SERVICE DaoGroup DAO1 DAO2 DAO3 DAO4 1 ART 覈 襦 show_reservation_title ShowDTO service_art.showFind artDAO dao.showFind 2 ART 殊 襦 show_reservation_date ShowDTO service.play commonDAO dao.myCheck 3 ART 覲 襦 show_reservation_detail ShowDTO service.play commonDAO dao.myCheck 4 ART 譬 襦 show_reservation_seat ShowResDTO service_art.showSeatView commonDAO dao.myCheck dao.myInsert dao.myCheck 5 ART 蟯襴 譬 覈 show_reservation_seat_editmode ShowDTO service_art.showSeatView commonDAO dao.myCheck dao.myInsert dao.myCheck 6 ART 蟯襴 譬 覈 螳煙 show_reservation_seat_editmode_pro ShowDTO service.play commonDAO dao.myUpdate 7 ART 譬 れ螳 螳煙 show_reservation_seat_watchdog ShowResDTO service.play commonDAO dao.myCheck 8 ART 覲願鍵 show_member_info ShowMemberResExDTO service.play commonDAO dao.myCheck 9 ART 螳煙 show_reservation_pro ShowResDTO service_art.showResPro commonDAO dao.myCheck dao.myCheck dao.myInsert dao.myUpdate 10 ART 豬 show_reservation_back ShowMemberResDTO service_art.showResBack commonDAO dao.myCheck dao.myUpdate dao.myDelete 11 ART 覃 覃 觚 伎 襦 main_sub_show ShowDTO service.main_sub commonDAO dao.myCount dao.mySearchAndPaging 12 ART 蟯襴 蟯襴 admin_show_form *DTO service.SearchAndPaging commonDAO dao.myCount dao.mySearchAndPaging 13 ART 蟯襴 蟯襴 admin_show_res_form *DTO service.SearchAndPaging commonDAO dao.myCount dao.mySearchAndPaging 14 ART 蟯襴 蟯襴 admin_show_member_res_form *DTO service.SearchAndPaging commonDAO dao.myCount dao.mySearchAndPaging 15 ART 蟯襴 蟯襴伎 覈 豢螳 admin_what_addPro *DTO service.play commonDAO dao.myInsert 16 ART 蟯襴 蟯襴伎 覈 admin_what_deletePro *DTO service.play commonDAO dao.myDelete 17 ART 蟯襴 蟯襴伎 覈 螳煙 admin_what_updatePro *DTO service.play commonDAO dao.myUpdate 18 COMMON 覃 覃 menu_top MemberDTO service.login commonDAO dao.myCheck 19 COMMON 覲 覲 guest_info_form MemberDTO service.play commonDAO dao.myCheck 20 COMMON 覲 覲 讌 襦 guest_info_pro FileDTO service.upload commonDAO dao.myCount dao.fileUpload dao.fileUpdate 21 COMMON 覲 螳 譴覲 guest_member_addFormCheckPro MemberDTO service.play commonDAO dao.myCheck 22 COMMON 覲 螳 豌襴 guest_member_addPro MemberDTO service.play commonDAO dao.myInsert 23 COMMON 蟯襴 蟯襴 admin_member_form *DTO service.SearchAndPaging commonDAO dao.myCount dao.mySearchAndPaging 24 COMMON 蟯襴 蟯襴伎 覈 豢螳 admin_what_addPro *DTO service.play commonDAO dao.myInsert 25 COMMON 蟯襴 蟯襴伎 覈 admin_what_deletePro *DTO service.play commonDAO dao.myDelete 26 COMMON 蟯襴 蟯襴伎 覈 螳煙 admin_what_updatePro *DTO service.play commonDAO dao.myUpdate 27 COMMON 襦 *.img FileDTO service.download commonDAO dao.fileDownload 28 CIRCLE 襴 襴 豌 蟆 main CirboardDTO Board commonDAO dao.myCount 29 CIRCLE 襴 襴 豌 蟆 main CirqboardDTO Qboard commonDAO dao.myCount dao.mySearchAndPaging 30 CIRCLE 襴 襴 豌 蟆 board CirboardDTO Board commonDAO dao.myCount dao.mySearchAndPaging 31 CIRCLE 襴 襴 豌 蟆 viewContents CirboardDTO ViewContents commonDAO dao.myUpdate 32 CIRCLE 襴 襴 豌 蟆 boardModi CirboardDTO BoardModi commonDAO dao.myCheck 33 CIRCLE 襴 襴 豌 蟆 boardModiPro CirboardDTO BoardModiPro commonDAO dao.myUpdate 34 CIRCLE 襴 襴 豌 蟆 boardDel CirboardDTO BoardDel commonDAO dao.myCheck dao.myDelete 35 CIRCLE 襴 襴 豌 蟆 writePro CirboardDTO writePro commonDAO dao.myInsert 36 CIRCLE 襴 蟆 searchResult CircleInfoDTO searchResult commonDAO dao.mySelect 37 CIRCLE 襴 蟆 viewCircle CircleInfoDTO viewCircle commonDAO dao.mySelect 38 CIRCLE 襴 讌覓 蟆 qboard CirqboardDTO Qboard commonDAO dao.myCount dao.mySearchAndPaging 39 CIRCLE 襴 讌覓 蟆 qviewContents CirqboardDTO QViewContents commonDAO dao.myUpdate 40 CIRCLE 襴 讌覓 蟆 qboardModi CirqboardDTO QBoardModi commonDAO dao.myCheck 41 CIRCLE 襴 讌覓 蟆 qboardModiPro CirqboardDTO QBoardModiPro commonDAO dao.myUpdate 42 CIRCLE 襴 讌覓 蟆 qboardDel CirqboardDTO QBoardDel commonDAO dao.myCheck dao.myDelete 43 CIRCLE 襴 讌覓 蟆 qwritePro CirqboardDTO QwritePro commonDAO dao.myInsert 44 CIRCLE 襴 蟆 蠍磯 searchrounge CirroungeDTO searchResult commonDAO dao.mySelect 45 CIRCLE 襴 蟆 蠍磯 viewCircleInfo CircleInfoDTO viewCircleInfo commonDAO dao.mySelect 46 CIRCLE 襴 襴 豌 request CirRequestDTO request commonDAO dao.myInsert 47 CIRCLE 蟯襴 襴 蟯襴 admin_circle_form CircleInfoDTO admin_circle_form commonDAO dao.myCount dao.mySearchAndPaging 48 CIRCLE 蟯襴 襴 蟯襴 admin_circle_addPro CircleInfoDTO admin_circle_addPro commonDAO dao.myInsert 49 CIRCLE 蟯襴 襴 蟯襴 admin_circle_deletePro CircleInfoDTO admin_circle_deletePro commonDAO dao.myDelete 50 CIRCLE 蟯襴 襴 蟯襴 admin_circle_updatePro CircleInfoDTO admin_circle_updatePro commonDAO dao.myUpdate 51 CIRCLE 蟯襴 蟯襴 admin_member_form CircleDTO admin_member_form commonDAO dao.myCount dao.mySearchAndPaging 52 CIRCLE 蟯襴 蟯襴 admin_member_addPro CircleDTO admin_member_addPro commonDAO dao.myInsert 53 CIRCLE 蟯襴 蟯襴 admin_member_deletePro CircleDTO admin_member_deletePro commonDAO dao.myDelete 54 CIRCLE 蟯襴 蟯襴 admin_member_updatePro CircleDTO admin_member_updatePro commonDAO dao.myUpdate 55 CIRCLE 蟯襴 襴 豌 蟆蟯襴 admin_board_form CirboardDTO admin_board_form commonDAO dao.myCount dao.mySearchAndPaging 56 CIRCLE 蟯襴 襴 豌 蟆蟯襴 admin_board_addPro CirboardDTO admin_board_addPro commonDAO dao.myInsert 57 CIRCLE 蟯襴 襴 豌 蟆蟯襴 admin_board_deletePro CirboardDTO admin_board_deletePro commonDAO dao.myDelete 58 CIRCLE 蟯襴 襴 豌 蟆蟯襴 admin_board_updatePro CirboardDTO admin_board_updatePro commonDAO dao.myUpdate 59 CIRCLE 蟯襴 讌覓 蟆蟯襴 admin_qboard_form CirqboardDTO admin_qboard_form commonDAO dao.myCount dao.mySearchAndPaging 60 CIRCLE 蟯襴 讌覓 蟆蟯襴 admin_qboard_addPro CirqboardDTO admin_qboard_addPro commonDAO dao.myInsert 61 CIRCLE 蟯襴 讌覓 蟆蟯襴 admin_qboard_deletePro CirqboardDTO admin_qboard_deletePro commonDAO dao.myDelete 62 CIRCLE 蟯襴 讌覓 蟆蟯襴 admin_qboard_updatePro CirqboardDTO admin_qboard_updatePro commonDAO dao.myUpdate 63 CIRCLE 蟯襴 襴 螳豌蟯襴 admin_request_form CirRequestDTO admin_request_form commonDAO dao.myCount dao.mySearchAndPaging 64 CIRCLE 蟯襴 襴 螳豌蟯襴 admin_request_addPro CirRequestDTO admin_request_addPro commonDAO dao.myInsert 65 CIRCLE 蟯襴 襴 螳豌蟯襴 admin_request_deletePro CirRequestDTO admin_request_deletePro commonDAO dao.myDelete 66 CIRCLE 蟯襴 襴 螳豌蟯襴 admin_request_updatePro CirRequestDTO admin_request_updatePro commonDAO dao.myUpdate dao.myCount dao.myCheck dao.mySelect dao.myInsert dao.myUpdate dao.myDelete dao.mySearchAndPaging 13
- 14. 1. 襴 襴 蟆 譟壱 蟆 企轟 : :: 蠍磯 ::
- 15. ERD 襴 15
- 16. 覃 覃 襴 16
- 17. 蟆 襴 17
- 18. 襴 蟆 襴 18
- 19. 襴 語覲 襴 19
- 20. 覈レ 螳 襴 20
- 21. 覈レ 螳 伎 襴 21
- 22. 蟯襴 伎 襴 22
- 23. 2. ろ豸/ 襷れ広 蟲 襷れ広 譟壱, 蟯襴 企轟 : 覦譯狩 :: 蠍磯 ::
- 24. ERD 豢蟲 24
- 25. 譯殊 貊 貂襴磯 貊 <%= i%> 讌 P 蠏 id: 覲企ゼ ロ 譬. Time : 螳螻 讌 蟆郁骸 DB ReservationDTO ReservationchkDTO TeamDTO 豢蟲 25
- 26. 譯殊 貊 貊 Longtime : 一危磯ゼ 覦 一危磯ゼ 覲 p 蠏 id 螳螻 覈 曙. 蟆郁骸 DB ReservationDTO ReservationchkDTO TeamDTO 豢蟲 貂襴磯 26
- 27. 豢蟲 覲企殊 / 覿螳 27
- 28. 覃 覃 豢蟲 28
- 29. 覲願鍵 伎 豢蟲 29
- 30. 渚 伎 豢蟲 30
- 31. 觚 襴ろ 覲願鍵 伎 豢蟲 31
- 32. 襴ろ 豢蟲 32
- 33. 覲 豢蟲 33
- 34. 蟯襴 豢蟲 34
- 35. 3. 蟯 譟壱 企轟 : 伎 :: 蠍磯 ::
- 36. ERD 蟯 36
- 37. 覃 覃 蟯 37
- 38. 覲願鍵 蟯 38
- 39. 覈襦 覲願鍵 蟯 39
- 40. 覲願鍵 蟯 40
- 41. 覲願鍵 蟯 41
- 42. 4. , 殊 蠍壱 企轟 : 豌瑚鍵 :: 蠍磯 ::
- 43. ERD 覩語蟯 43
- 44. 譬 ろ 蠍磯 : れ螳 譬 譟壱, 覦 豬 蟯襴 : 譬 蟲 覲蟆 譯殊 誤 ろ襴渚 : れ螳 螳煙 DB : 螻旧 覈更 + 轟 覈更 1譬 覩語蟯 44
- 45. 覩語蟯0 1 1 0 , 1 1 3 3 譬 ろ 譬 蟲譟 1. 覿 = 0螻 1 覦一伎 襦 2. 譬 = 0覿 6 覦一伎 Div襦 3. 蟆郁骸. 45
- 46. 覩語蟯 0 , 1 , 2 , 3 , 4 , 5 , 6 觜螻糾 螻旧 曙 覦磯れ 蠏觜 觜蟲 譬 ろ 譬 蟲譟 600111011111110111006, 001111011111110111100, 011111011111110111110, 111111033111330111111, 111111011111110111111, 111111011222210111111, 111133044444440331111, 000000000000000000000, 111111055555550111111, 111111033111110111111, 011111011111110111110 46
- 47. 螻襴讀) れ螳 螳煙 1. DB襦覿 覿 覲襦 企. 2. 伎 曙 覲襦 企. 3. 覲襯 觜蟲. 4. 谿企ゼ . 5. 願 螻 覦覲牛. 覩語蟯DB : 1111 覃 : 1111 DB : 1113 覃 : 1111 覃 : 1111觜蟲 覃 : 1113觜蟲 蟲郁 DB = 1113 47
- 48. 貊 : 蠍 // 渚蠍 // 襦蠏碁ゼ 蠍企. // 覲襯 覦. // 覦蟆 showResDTO // 豐蠍壱 // れ伎る 覲 覈襦 // 蟇一 memberResDTO 蟇 //id //show_num //res_date //seat //seat_code // 譬 觜蟲. // 覯語 讌襯 覿 企. // 1001 : 伎 覿 る 襴. // 1002 : 譬 蠍語願 るゴる 襴. // 1003 : 譬 螳 るゴる 襴 // 0譬X , 1觜 , 2, 3 // 曙 豌 襭 觜蟲. = 螳 2 螻褐 碁煙り 覈 1伎伎 . // 蠍一ヾ 譬 一危 り 朱 螻 //覲蟆暑 譬 願 // 一危 // => 一危碁 覓語 襷 襷讌襷 一危 . // 蠍磯 ｌ伎. // DTO 一危磯ゼ ｋ. // 蠍磯 谿城. // 1004 : 蠍磯 譴覲 譟伎 蟆曙 襴 - 企 曙 給. 企 殊 曙 豬 伎伎殊語. // 一危碁ゼ 蠏碁 る 觜殊 . // 一危 伎 豢螳 蠍磯 豢螳. // 1005 : 覃る 曙覲願 豢螳讌 朱 襴 // 一危 // 1006 : 一危 讌 る 襴 // 襴危. 覩語蟯 48
- 49. 覩語蟯 覃 伎 49
- 50. 覩語蟯 伎 50
- 51. 覩語蟯 蠍壱 伎 51
- 52. 覩語蟯 螻旧 伎 52
- 53. 覩語蟯 蟯襴 伎 53
- 54. 覩語蟯 譬 伎 54
- 55. 螳矧.
- 56. 螳矧.
- 57. 際際滷sCarnival icons are editable shapes. This means that you can: Resize them without losing quality. Change line color, width and style. Isnt that nice? :) Examples:
- 58. 襴襯 谿城 襷 螳 讌 .螳 襴 覲 覦 螻旧 覲企ゼ 螻 覲 れ 蟯襴 覦 螻 伎 58
- 60. 覲旧 覿 企伎 蟆. 襦 れ 谿場 襷語.覲 譴 蠎給. 覈 蟆 螳 譴蟆 蟷伎 覯. 蟆渚 語 譴 蟆. 蟆渚 60
- 61. 貊 蟯
- 62. 貊 蟯
- 63. 貊 蟯 伎焔 蟯
- 64. 貊 蠍 STEP. 1 蟯
- 65. 貊 蠍 STEP.2 蟯
Editor's Notes
- #3: : 豬覩語襦 覲伎錆蟲′ 覦螻 給. 覦譯狩 : 豢蟲 伎給. (貊覲企 豢蟲襯 譬 ) 伎 : 襷豈/覃伎 譬. 豌瑚鍵 : 覩語 襴 給.
- #4: 譟磯 覈 蟇願 豬覩語 螳螻 給. 蠏碁, 覲伎錆 ,豈 ,豢蟲 企 豬覩語 蟇願 譬 レ 襷 覩語工.
- #28: 螳 覲企殊朱 覦覃 覿螳ロ 讌.
- #60: 一語 蠏豪概: 一語 襯 伎螳 れ 覿覿 蟆螻 給. 企 一語 豬覩語 牛 れ 襷覃 苦 レ 谿城 一 蠏豪概 レ 螻. ろ碁 伎: 覓 訖襷 螳語朱 襷 れ ろ碁るゼ 覦螻 給. 企 ろ碁るゼ 伎 螳 譬 覦覯 譬 豬覩語 蟆 企手 螳. 覈, 煙隈螳: 譬 豬覩語 覈襯 ♀ 蠏瑚 覃 煙隈螳 朱 蟆 螳 濠骸 煙隈螳 牛 視 伎 牛 覓企ルレ レ 螳語 給.