人体穴位分布学习.docx

1、人体穴位分布学习人体穴位分布学习第一部分：数据库的建立drop table body;create table body(id smallint unsigned primary key auto_increment, #编号name char(3) not null default , #穴位名称pos char(6) not null default , #经络名称num tinyint not null default 0, #某穴位在自己经络中的序号part char(3) not null default , #所在身体部位描述，如头部，小腿，大腿等branch tinyint no

2、t null default 1, #某些经络点有多分支link varchar(20) not null default #记录每个穴位相邻的穴位) charset=utf8;#insert body (pos,part,num,name) values(足厥阴肝经,胸部,1,期门);insert body (pos,part,num,name) values(足厥阴肝经,腹部,2, 章门);insert body (pos,part,num,name) values(足厥阴肝经,大腿,3,急脉);insert body (pos,part,num,name) values(足厥阴肝经,大腿

3、,4, 阴廉);insert body (pos,part,num,name) values(足厥阴肝经,大腿,5,足五里);insert body (pos,part,num,name) values(足厥阴肝经,大腿,6,阴包);insert body (pos,part,num,name) values(足厥阴肝经,膝,7,曲泉);insert body (pos,part,num,name) values(足厥阴肝经,膝,8,膝关);insert body (pos,part,num,name) values(足厥阴肝经,小腿,9,中都);insert body (pos,part,n

4、um,name) values(足厥阴肝经,小腿,10,离沟);insert body (pos,part,num,name) values(足厥阴肝经,踝,11,中封);insert body (pos,part,num,name) values(足厥阴肝经,脚,12,太冲);insert body (pos,part,num,name) values(足厥阴肝经,脚,13,行间);insert body (pos,part,num,name) values(足厥阴肝经,脚,14,大敦);#insert body (pos,part,num,name) values(足少阳胆经,头,1,瞳子

5、辽);insert body (pos,part,num,name) values(足少阳胆经,头,2,听会);insert body (pos,part,num,name) values(足少阳胆经,头,3,上关);insert body (pos,part,num,name) values(足少阳胆经,头,4,颌厌);insert body (pos,part,num,name) values(足少阳胆经,头,5,悬颅);insert body (pos,part,num,name) values(足少阳胆经,头,6,悬厘);insert body (pos,part,num,name)

6、values(足少阳胆经,头,7,曲鬓);insert body (pos,part,num,name) values(足少阳胆经,头,8,率谷);insert body (pos,part,num,name) values(足少阳胆经,头,9,天冲);insert body (pos,part,num,name) values(足少阳胆经,头,10,浮白);insert body (pos,part,num,name) values(足少阳胆经,头,11,头窍阴);insert body (pos,part,num,name) values(足少阳胆经,头,12,完谷);insert bod

7、y (pos,part,num,name) values(足少阳胆经,头,13,本神);insert body (pos,part,num,name) values(足少阳胆经,头,14,阳白);insert body (pos,part,num,name) values(足少阳胆经,头,15,头临泣);insert body (pos,part,num,name) values(足少阳胆经,头,16,目窗);insert body (pos,part,num,name) values(足少阳胆经,头,17,正营);insert body (pos,part,num,name) values(

8、足少阳胆经,头,18,承灵);insert body (pos,part,num,name) values(足少阳胆经,头,19,脑空);insert body (pos,part,num,name) values(足少阳胆经,头,20,风池);insert body (pos,part,num,name) values(足少阳胆经,肩,21,肩井);insert body (pos,part,num,name) values(足少阳胆经,肋,22,渊腋);insert body (pos,part,num,name) values(足少阳胆经,肋,23,辄筋);insert body (po

9、s,part,num,name) values(足少阳胆经,肋,24,日月);insert body (pos,part,num,name) values(足少阳胆经,肋,25,京门);insert body (pos,part,num,name) values(足少阳胆经,肋,26,带脉);insert body (pos,part,num,name) values(足少阳胆经,腰,27,五枢);insert body (pos,part,num,name) values(足少阳胆经,腰,28,维道);insert body (pos,part,num,name) values(足少阳胆经,

10、大腿,29,居辽);insert body (pos,part,num,name) values(足少阳胆经,大腿,30,环跳);insert body (pos,part,num,name) values(足少阳胆经,大腿,31,风市);insert body (pos,part,num,name) values(足少阳胆经,大腿,32,中渎);insert body (pos,part,num,name) values(足少阳胆经,膝,33,膝阳关);insert body (pos,part,num,name) values(足少阳胆经,小腿,34,阳陵泉);insert body (p

11、os,part,num,name) values(足少阳胆经,小腿,35,阳交);insert body (pos,part,num,name) values(足少阳胆经,小腿,36,外丘);insert body (pos,part,num,name) values(足少阳胆经,小腿,37,光明);insert body (pos,part,num,name) values(足少阳胆经,小腿,38,阳辅);insert body (pos,part,num,name) values(足少阳胆经,小腿,39,悬钟);insert body (pos,part,num,name) values(

12、足少阳胆经,脚,40,丘墟);insert body (pos,part,num,name) values(足少阳胆经,脚,41,足临泣);insert body (pos,part,num,name) values(足少阳胆经,脚,42,地五会);insert body (pos,part,num,name) values(足少阳胆经,脚,43,侠溪);insert body (pos,part,num,name) values(足少阳胆经,脚,44,足窍阴);#insert body (pos,part,num,name) values(手少阴心经,手,1,少冲);insert body

13、(pos,part,num,name) values(手少阴心经,手,2,少府);insert body (pos,part,num,name) values(手少阴心经,腕,3,神门);insert body (pos,part,num,name) values(手少阴心经,腕,4,阴戏);insert body (pos,part,num,name) values(手少阴心经,腕,5,通里);insert body (pos,part,num,name) values(手少阴心经,腕,6,灵道);insert body (pos,part,num,name) values(手少阴心经,肘,

14、7,少海);insert body (pos,part,num,name) values(手少阴心经,大臂,8,青灵);insert body (pos,part,num,name) values(手少阴心经,大臂,9,极泉);#insert body (pos,part,num,name) values(足太阴脾经,舌,0,聚泉);insert body (pos,part,num,name) values(足太阴脾经,肋,1,大包);insert body (pos,part,num,name) values(足太阴脾经,胸,2,周荣);insert body (pos,part,num,

15、name) values(足太阴脾经,胸,3,胸乡);insert body (pos,part,num,name) values(足太阴脾经,胸,4,天溪);insert body (pos,part,num,name) values(足太阴脾经,胸,5,食窦);insert body (pos,part,num,name) values(足太阴脾经,腹,6,腹哀);insert body (pos,part,num,name) values(足太阴脾经,腹,7,大横);insert body (pos,part,num,name) values(足太阴脾经,腹,8,腹结);insert b

16、ody (pos,part,num,name) values(足太阴脾经,腹,9,府舍);insert body (pos,part,num,name) values(足太阴脾经,大腿,10,冲门);insert body (pos,part,num,name) values(足太阴脾经,大腿,11,箕门);insert body (pos,part,num,name) values(足太阴脾经,大腿,12,血海);insert body (pos,part,num,name) values(足太阴脾经,小腿,13,阴陵泉);insert body (pos,part,num,name) va

17、lues(足太阴脾经,小腿,14,地机);insert body (pos,part,num,name) values(足太阴脾经,小腿,15,漏谷);insert body (pos,part,num,name) values(足太阴脾经,小腿,16,三阴交);insert body (pos,part,num,name) values(足太阴脾经,踝,17,商丘);insert body (pos,part,num,name) values(足太阴脾经,脚,18,公孙);insert body (pos,part,num,name) values(足太阴脾经,脚,19,太白);insert

18、 body (pos,part,num,name) values(足太阴脾经,脚,20,大都);insert body (pos,part,num,name) values(足太阴脾经,脚,21,隐白);#insert body (pos,part,num,name) values(手太阴肺经,肩, 1,中府);insert body (pos,part,num,name) values(手太阴肺经,肩, 2,云门);insert body (pos,part,num,name) values(手太阴肺经,大臂, 3,天府);insert body (pos,part,num,name) va

19、lues(手太阴肺经,大臂, 4,侠白);insert body (pos,part,num,name) values(手太阴肺经,肘, 5,尺泽);insert body (pos,part,num,name) values(手太阴肺经,小臂, 6,孔最);insert body (pos,part,num,name) values(手太阴肺经,腕, 7,列缺);insert body (pos,part,num,name) values(手太阴肺经,腕, 8,经渠);insert body (pos,part,num,name) values(手太阴肺经,腕, 9,太渊);insert b

20、ody (pos,part,num,name) values(手太阴肺经,手, 10,鱼际);insert body (pos,part,num,name) values(手太阴肺经,手, 11,少商);#insert body (pos,part,num,name) values(足阳明胃经,颈,0,大椎);insert body (pos,part,num,name) values(足阳明胃经,头,1,头维);insert body (pos,part,num,name) values(足阳明胃经,头,2,下关);insert body (pos,part,num,name) values

21、(足阳明胃经,头,3,颊车);insert body (pos,part,num,name) values(足阳明胃经,头,4,大迎);insert body (pos,part,num,name) values(足阳明胃经,头,5,承泣);insert body (pos,part,num,name) values(足阳明胃经,头,6,四白);insert body (pos,part,num,name) values(足阳明胃经,头,7,巨辽);insert body (pos,part,num,name,branch, link) values(足阳明胃经,头,8,地仓,2,巨辽，大迎，

22、人迎);insert body (pos,part,num,name) values(足阳明胃经,颈,9,人迎);insert body (pos,part,num,name) values(足阳明胃经,颈,10,水突);insert body (pos,part,num,name) values(足阳明胃经,胸,10,气舍);insert body (pos,part,num,name) values(足阳明胃经,胸,12,缺盆);insert body (pos,part,num,name) values(足阳明胃经,胸,13,气户);insert body (pos,part,num,n

23、ame) values(足阳明胃经,胸,14,库房);insert body (pos,part,num,name) values(足阳明胃经,胸,15,屋亦);insert body (pos,part,num,name) values(足阳明胃经,胸,16,英窗);insert body (pos,part,num,name) values(足阳明胃经,胸,17,乳中);insert body (pos,part,num,name) values(足阳明胃经,胸,18,乳根);insert body (pos,part,num,name) values(足阳明胃经,腹,19,不容);ins

24、ert body (pos,part,num,name) values(足阳明胃经,腹,20,承满);insert body (pos,part,num,name) values(足阳明胃经,腹,21,梁门);insert body (pos,part,num,name) values(足阳明胃经,腹,22,关门);insert body (pos,part,num,name) values(足阳明胃经,腹,23,太乙);insert body (pos,part,num,name) values(足阳明胃经,腹,24,滑肉门);insert body (pos,part,num,name)

25、values(足阳明胃经,腹,25,天枢);insert body (pos,part,num,name) values(足阳明胃经,腹,26,外陵);insert body (pos,part,num,name) values(足阳明胃经,腹,27,大巨);insert body (pos,part,num,name) values(足阳明胃经,腹,28,水道);insert body (pos,part,num,name) values(足阳明胃经,腹,29,归来);insert body (pos,part,num,name) values(足阳明胃经,腹,30,气冲);insert b

26、ody (pos,part,num,name) values(足阳明胃经,大腿,31,毕关);insert body (pos,part,num,name) values(足阳明胃经,大腿,32,伏兔);insert body (pos,part,num,name) values(足阳明胃经,大腿,33,阴市);insert body (pos,part,num,name) values(足阳明胃经,大腿,34,梁丘);insert body (pos,part,num,name) values(足阳明胃经,膝,35,读鼻);insert body (pos,part,num,name) va

27、lues(足阳明胃经,小腿,36,足三里);insert body (pos,part,num,name) values(足阳明胃经,小腿,37,上巨虚);insert body (pos,part,num,name) values(足阳明胃经,小腿,38,条口);insert body (pos,part,num,name) values(足阳明胃经,小腿,39,下巨虚);insert body (pos,part,num,name) values(足阳明胃经,小腿,40,丰隆);insert body (pos,part,num,name) values(足阳明胃经,踝,41,解溪);in

28、sert body (pos,part,num,name) values(足阳明胃经,脚,42,冲阳);insert body (pos,part,num,name) values(足阳明胃经,脚,43,陷谷);insert body (pos,part,num,name) values(足阳明胃经,脚,44,内庭);insert body (pos,part,num,name) values(足阳明胃经,脚,45,厉兑);#insert body (pos,part,num,name) values(足少阴肾经,胸,1,俞府);insert body (pos,part,num,name)

29、values(足少阴肾经,胸,2,玉中);insert body (pos,part,num,name) values(足少阴肾经,胸,3,神藏);insert body (pos,part,num,name) values(足少阴肾经,胸,4,灵墟);insert body (pos,part,num,name) values(足少阴肾经,胸,5,神封);insert body (pos,part,num,name) values(足少阴肾经,胸,6,步廊);insert body (pos,part,num,name) values(足少阴肾经,胸,7,幽门);insert body (pos,part,num,name) values(