SQL鐖?妯℃嫙鏁版嵁鐢熸垚鍣紙鍚庣锛塖QL鐖堕」鐩細蹇€熺敓鎴怱QL鍜屾ā鎷熸暟鎹紝澶уぇ鎻愰珮寮€鍙戝拰娴嬭瘯鏁堢巼锛侀」鐩儗鏅箣鎵€浠ュ垱寤鸿椤圭洰锛屾槸鍥犱负Yupi瑙ｅ喅浜嗗紑鍙戦」鐩椂閲嶅缂栧啓SQL寤鸿〃鍒涘缓鏁版嵁鐨勯夯鐑︺€俆ableSQL锛屼笉鐢ㄥ垱寤烘暟鎹紝鐩存帴寰楀埌涓€涓湁鍋囨暟鎹殑琛紝璇ュ濂藉晩锛佹湁鍚屽闂负浠€涔堥」鐩笉鍙玈QLMother锛熼偅鎴戦棶浣犱负浠€涔堢户鎵垮彨鐖剁被锛熷簲鐢ㄥ満鏅棤璁轰綘鏄墠绔€佸悗绔€佹祴璇曘€佹暟鎹紑鍙戙€佹暟鎹瀛︺€佺爺绌剁敓锛岀浉淇¤繖娆惧伐鍏烽兘浼氬浣犳湁鎵€甯姪锛佷富瑕佸簲鐢ㄥ満鏅涓嬶細1锛夐€氳繃濉啓鍙鍖栬〃鏍煎揩閫熺敓鎴愬缓琛ㄦ姤琛ㄣ€佹ā鎷熸暟鎹拰浠ｇ爜锛屽憡鍒噸澶嶆€у伐浣滐紒2)鏀寔澶氱蹇嵎瀵煎叆鏂瑰紡銆傛瘮濡備綘宸茬粡鏈夌幇鎴愮殑鏁版嵁琛紝鐩存帴瀵煎叆寤鸿〃璇彞锛屼竴閿敓鎴愭ā鎷熸暟鎹紱涔熷彲浠ョ洿鎺ュ鍏xcel琛ㄦ牸锛屽揩閫熷畬鎴愬缓琛紱鐢氳嚦杩樻敮鎸佹櫤鑳藉鍏ワ紝杈撳叆鍑犱釜瀛楀氨鑷姩鐢熸垚琛ㄦ牸鍜屾暟鎹紒鍊煎緱鍊熼壌鐨勬槸锛岄」鐩湰韬姛鑳介綈鍏紙鍒嗕负鐢ㄦ埛鍓嶇鍜岀鐞嗗悗鍙帮級锛岀鍚堢嚎涓婃爣鍑嗭紝鏋舵瀯璁捐娓呮櫚锛岀洰褰曠粨鏋勮鑼冦€傚墠绔娇鐢ㄥ鏉傜殑宓屽銆佸姩鎬併€佸彲鎶樺彔鐨勮〃鍗曞拰浠ｇ爜缂栬緫鍣紱鍚庣閲囩敤浜嗗绉嶄富娴佽璁℃ā寮忥紝AOP鍒囬潰璁よ瘉绛夛紝杩樻槸闈炲父鍊煎緱灏忎紮浼翠滑瀛︿範鐨勩€傚ぇ浣滑澶氬鎸囨暀馃檹馃徎鍔熻兘鐧剧鐢ㄦ埛鍓嶇鍙鍖栧缓琛ㄥ揩閫熷鍏ュ缓琛ㄦ櫤鑳藉鍏ュ缓琛ㄩ厤缃鍏QL瀵煎叆Excel涓€閿敓鎴怱QL寤鸿〃銆佹彃鍏ユ暟鎹鍙ユā鎷熸暟鎹甁SON鏁版嵁Java浠ｇ爜鍓嶇浠ｇ爜澶氱妯℃嫙鏁版嵁鐢熸垚瑙勫垯瀹氬€奸殢鏈哄€兼鍒欒〃杈惧紡閫掑鑷畾涔夎瘝搴撹瘝搴撳叡浜垱寤鸿瘝搴撹瘝搴撶户鎵夸竴閿垱寤哄瓧鍏歌〃鏍规嵁璇嶅簱鐢熸垚妯℃嫙鏁版嵁锛堝彲鐢ㄤ簬鍐冲畾鍚冧粈涔堝崍椁愬搱鍝堬級琛ㄤ俊鎭叡浜垱寤鸿〃淇℃伅涓€閿鍒跺垱寤鸿〃璇彞涓€閿鍏ヨ〃瀛楁鍒嗕韩鍒涘缓瀛楁涓€閿鍒跺垱寤哄瓧娈佃鍙ヤ竴閿鍏ュ瓧娈垫姤琛ㄧ鐞嗗悗鍙扮敤鎴风鐞嗚瘝姹囩鐞嗚〃淇℃伅绠＄悊瀛楁淇℃伅绠＄悊鎶ヨ〃绠＄悊鎶€鏈爤鍓嶇涓昏鎶€鏈細React18Umi4.xAntDesign4.x缁勪欢搴揂ntDesignProComponentsAdvancedComponentsTypeScriptTypeControlEslintCodeSpecificationControlPrettier缇庡寲浠ｇ爜渚濊禆搴擄細monaco-editorCodeEditorcopy-to-clipboardClipboardCopyBackend涓昏鎶€鏈細SpringBoot2.7.xMyBatisPlus3.5.xMySQL8.xSpringAOP渚濊禆搴擄細FreeMarker锛氭ā鏉垮紩鎿嶥ruid锛歋QL瑙ｆ瀽datafaker锛氭ā鎷熸暟鎹瓵pacheCommonsLang3锛氬伐鍏峰簱Hutool锛氬伐鍏峰簱Gson锛欽son瑙ｆ瀽EasyExcel锛欵xcel瀵煎叆瀵煎嚭Knife4j锛氭帴鍙ｆ枃妗ｇ敓鎴愬揩閫熷叆闂ㄨ繍琛屽悗绔痵ql鐩綍涓嬬殑create_table.sql鍒涘缓琛ㄥ皢application.yml涓殑鏁版嵁搴撳湴鍧€淇敼涓鸿嚜宸辩殑瀹夎Maven渚濊禆鍚庡嵆鍙洿鎺ヨ繍琛屽畠銆侱ockerfile宸茬粡缂栧啓瀹屾垚锛屾敮鎸丏ocker闀滃儚閮ㄧ讲銆傚墠绔畨瑁呬緷璧栵細npmruninstall杩愯锛歯pmrundev鎵撳寘锛歯pmrunbuild绯荤粺璁捐涓昏鍒嗕韩绯荤粺鐨勬暣浣撴灦鏋勫拰鏍稿績璁捐锛屼紶缁焪eb寮€鍙戦儴鍒嗕笉鍐嶈繃澶氫粙缁嶃€傛暣浣撴灦鏋勮璁＄殑鏍稿績璁捐鐞嗗康锛氬皢鍚勪釜杈撳叆娉曠粺涓€鎴愪竴涓竻鏅扮殑Schema锛屾牴鎹甋chema鐢熸垚鍚勭鍐呭銆傛灦鏋勮璁″浘濡備笅锛屽嵆浠绘剰杈撳叆=>缁熶竴Schema=>浠绘剰杈撳嚭锛氱郴缁熷垎涓轰互涓嬪嚑涓牳蹇冩ā鍧楋紝姣忎釜妯″潡鑱岃矗鏄庣‘锛歋chema鏋勯€犲櫒锛氬皢鍚勭杈撳叆婧愯浆鎹㈡垚涓€涓粺涓€鐨凾ableSchema瀹氫箟缁熶竴Schema瀹氫箟锛氭湰璐ㄤ笂鏄竴涓狫ava绫伙紙JSON閰嶇疆锛夛紝鐢ㄤ簬淇濆瓨琛ㄥ拰瀛楁鐨勪俊鎭€侴enerator锛氳礋璐ｅ熀浜嶴chema鐢熸垚鏁版嵁鍜屼唬鐮佸叡浜湇鍔★細鍖呮嫭璇嶅簱銆佽〃淇℃伅銆佸瓧娈典俊鎭€傛牳蹇冩ā鍧椾唬鐮侀兘鍦ㄥ悗绔痗ore鐩綍涓婼chema鏋勫缓鍣ㄧ殑鏍稿績绫伙細TableSchemaBuilder锛屽叾浣滅敤鏄皢涓嶅悓鐨勫弬鏁扮粺涓€姹囪仛鎴愪竴涓猅ableSchema瀵硅薄銆傚叾涓璪uildFromSql锛堟牴鎹甋QL鐢熸垚Schema锛変娇鐢ㄤ簡Druid鏁版嵁搴撹繛鎺ユ睜鑷甫鐨勮娉曡В鏋愬櫒锛岄潪甯稿己澶с€傦紙涓€鑸笉闇€瑕佽嚜宸卞啓parser涔嬬被鐨勪笢瑗匡紝杩欎釜鏃跺€欏彲浠ュ仛鍑犱釜椤圭洰锛屾病鏈夊叾浠栫殑濂界敤銆傦級schemadefinition鐢ㄤ簬淇濆瓨琛ㄥ拰瀛楁鐨勪俊鎭€傜粨鏋勫涓嬶細{"dbName":"搴撳悕","tableName":"test_table","tableComment":"琛ㄦ牸娉ㄩ噴","mockNum":20,"fieldList":[{"fieldName":"username","comment":"Username","fieldType":"varchar(256)","mockType":"Random","mockParams":"Name","notNull":true,"primaryKey":false,"autoIncrement":false}]}鐢熸垚澶氱敓鎴愮被鍨嬬殑鍏变韩鏈嶅姟锛屽寘鎷瘝搴撱€佽〃淇℃伅銆佸瓧娈典俊鎭叡浜€傚叾瀹炲氨鏄杩欎簺瀹炰綋杩涜澧炲垹鏀规煡鐨剋eb鏈嶅姟锛屽氨涓嶅璇翠簡銆傚墠鍚庣鍏ㄦ爤椤圭洰ByProgrammerYupi鍒朵綔涓嶆槗锛岃鍕垮晢涓氬寲杞敭锛侊紒锛佸湪绾夸綋楠岋細https://sqlfather.com/瑙嗛婕旂ず锛堟暀绋嬶級锛歨ttps://www.bilibili.com/video...濡傛灉瑙夊緱杩欎釜椤圭洰瀵逛綘鏈夊府鍔╋紝缁橴P涓讳竴涓叧娉紝涓変釜閾炬帴鏈€澶ф劅璋㈡偍鐨勬敮鎸侊紒鍓嶇浠ｇ爜浠撳簱锛歨ttps://github.com/liyupi/sql...鍚庣浠ｇ爜浠撳簱锛歨ttps://github.com/liyupi/sql...
