当前位置:编程学习 > C#/ASP.NET >>

菜鸟求助大侠 vb 中如何实现拼音模糊检索?

那位大侠能帮帮我,我是菜鸟。现在在做一个需求,vb前台实现拼音模糊检索。就像火车票订票系统,只要输入拼音头位字母,就会下拉出好多地名?求助~~~~~~ vb 拼音模糊检索 --------------------编程问答-------------------- 弄个字典  对应起来   

我就是这么做的  毕竟地名是固定量的  少改动的 --------------------编程问答-------------------- 老师您好,能否再具体点呢,谢谢 --------------------编程问答-------------------- 我的做法就是1个多维数组  每行3列  
FJFZ fujianfuzhou  福建福州
FJFZTJ fujianfuzhoutaijiang  福建福州台江

一般到区为止就够了
每次查询  看你自己算法了  循环比对   3个值

www.i-ssy.com 》搜索易》系统设置里 输入城市 支持 首字母和汉字混合识别   就是用的上面思路
不过我就两列 没有拼音全部

--------------------编程问答-------------------- 您的意思是不是,如果数据库中没有拼音字段,需要加上去才可以匹配是吗?那么有没有不改动原有数据库就可以实现模糊检索的功能呢? --------------------编程问答--------------------
引用 4 楼 xiaoniao_1225 的回复:
您的意思是不是,如果数据库中没有拼音字段,需要加上去才可以匹配是吗?那么有没有不改动原有数据库就可以实现模糊检索的功能呢?

不加拼音字段?那你什么意思?难道每次加载都要重新读取数据库然后生成拼音吗? --------------------编程问答-------------------- 老师,我同事说jsp在实现模糊检索的时候,没有修改原有的后台代码,数据库。只修改了前台部分。我不知道vb是否也有这样的功能,还请得请教您 --------------------编程问答-------------------- 谢谢您的解答哦!祝您生活愉快! --------------------编程问答-------------------- web方式是可以把拼音放到js里,
vb不用数据库也可以的,把所有词组的拼音生成到一个数组里
然后根据数组里的拼音模糊查询

var citySelect = new Array('北京|beijing|bj','上海|shanghai|sh','广州|guangzhou|gz','天津|tianjin|tj','杭州|hangzhou|hz','南京|nanjing1|nj','成都|chengdou|cd','重庆|chongqingshi|zq','福州|fuzhou1|fz','苏州|suzhou2|sz','深圳|shenzhen|sz','武汉|wuhan|wh','西安|xian|xa','厦门|xiamen|xm','沈阳|shenyang|sy','安庆|anqing|aq','蚌埠|bangbu|bb','亳州|bozhou|bz','巢湖|chaohu|ch','池州|chizhou|cz','滁州|chuzhou|cz','阜阳|fuyang1|fy','合肥|hefei|hf','淮北|huaibei|hb','淮南|huainan|hn','黄山|huangshan|hs','六安|liuan|la','马鞍山|maanshan|mas','宿州|suzhou1|sz','铜陵|tongling1|tl','芜湖|wuhu1|wh','宣城|xuancheng|xc','龙岩|longyan|ly','南平|nanping|np','宁德|ningde|nd','莆田|putian|pt','泉州|quanzhou1|qz','三明|sanming|sm','漳州|zhangzhou|zz','白银|baiyin|by','定西|dingxi|dx','甘南藏族|gannancangzu|gncz','嘉峪关|jiayuguan|jyg','酒泉|jiuquan|jq','兰州|lanzhou|lz','临夏回族|linxiahuizu|lxhz','陇南|longnan1|ln','平凉|pingliang|pl','庆阳|qingyang1|qy','天水|tianshui|ts','武威|wuwei1|ww','张掖|zhangye|zy','潮州|chaozhou|cz','东莞|dongwan|dw','佛山|foshan|fs','河源|heyuan|hy','惠州|huizhou|hz','江门|jiangmen|jm','揭阳|jieyang|jy','茂名|maoming|mm','梅州|meizhou|mz','清远|qingyuan1|qy','汕头|shantou|st','汕尾|shanwei|sw','韶关|shaoguan|sg','阳江|yangjiang|yj','云浮|yunfu|yf','湛江|zhanjiang|zj','肇庆|zhaoqing|zq','中山|zhongshan1|zs','珠海|zhuhai|zh','百色|baise|bs','北海|beihai|bh','崇左|chongzuo|cz','防城港|fangchenggang|fcg','贵港|guigang|gg','桂林|guilin|gl','河池|hechi|hc','贺州|hezhou|hz','来宾|laibin|lb','柳州|liuzhou|lz','南宁|nanning|nn','钦州|qinzhou|qz','梧州|wuzhou|wz','玉林|yulin1|yl','安顺|anshun|as','毕节地区|bijiediqu|bjdq','贵阳|guiyang1|gy','六盘水|liupanshui|lps','黔东南苗族侗族|qiandongnanmiaozudongzu|qdnmzdz','黔南布依族苗族|qiannanbuyizumiaozu|qnbyzmz','黔西南布依族苗族|qianxinanbuyizumiaozu|qxnbyzmz','铜仁地区|tongrendiqu|trdq','遵义|zunyi1|zy','海口|haikou|hk','三亚|sanya|sy','保定|baoding|bd','沧州|cangzhou|cz','承德|chengde1|cd','邯郸|handan1|hd','衡水|hengshui|hs','廊坊|langfang|lf','秦皇岛|qinhuangdao|qhd','石家庄|shijiazhuang|sjz',
'唐山|tangshan|ts','邢台|xingtai1|xt','张家口|zhangjiakou|zjk','安阳|anyang1|ay','鹤壁|hebi|hb','焦作|jiaozuo|jz','开封|kaifeng1|kf','洛阳|luoyang|ly','漯河|luohe|lh','南阳|nanyang|ny','平顶山|pingdingshan|pds','濮阳|puyang1|py','三门峡|sanmenxia|smx','商丘|shangqiu|sq','新乡|xinxiang1|xx','信阳|xinyang|xy','许昌|xuchang1|xc','郑州|zhengzhou|zz','周口|zhoukou|zk','驻马店|zhumadian|zmd','大庆|daqing|dq','大兴安岭地区|daxinganlingdiqu|dxaldq','哈尔滨|haerbin|heb','鹤岗|hegang|hg','黑河|heihe|hh','鸡西|jixi1|jx','佳木斯|jiamusi|jms','牡丹江|mudanjiang|mdj','七台河|qitaihe|qth','齐齐哈尔|qiqihaer|qqhe','双鸭山|shuangyashan|sys','绥化|suihua|sh','伊春|yichun1|yc','鄂州|ezhou|ez','恩施土家族苗族|enshitujiazumiaozu|estjzmz','黄冈|huanggang|hg','黄石|huangshi|hs','荆门|jingmen|jm','荆州|jingzhou|jz','十堰|shiyan|sy','随州|suizhou|sz','咸宁|xianning|xn','襄樊|xiangfan|xf','孝感|xiaogan|xg','宜昌|yichang|yc','长沙|changsha1|cs','常德|changde|cd','郴州|chenzhou|cz','衡阳|hengyang1|hy','怀化|huaihua|hh','娄底|loudi|ld','邵阳|shaoyang1|sy','湘潭|xiangtan1|xt','湘西州|xiangxizhou|xxz','益阳|yiyang1|yy','永州|yongzhou|yz','岳阳|yueyang1|yy','张家界|zhangjiajie|zjj','株洲|zhuzhou1|zz','白城|baicheng1|bc','白山|baishan|bs','长春|changchun|cc','吉林|jilin2|jl','辽源|liaoyuan|ly','四平|siping|sp','松原|songyuan|sy','通化|tonghua1|th','延边朝鲜族|yanbianchaoxianzu|ybcxz','常州|changzhou|cz','淮安|huaian1|ha','连云港|lianyungang|lyg','南通|nantong|nt','宿迁|suqian|sq','泰州|taizhou1|tz','无锡|wuxi1|wx','徐州|xuzhou|xz','盐城|yancheng|yc','扬州|yangzhou|yz','镇江|zhenjiang|zj','抚州|fuzhou2|fz','赣州|ganzhou|gz','吉安|jian1|ja','景德镇|jingdezhen|jdz','九江|jiujiang1|jj','南昌|nanchang1|nc','萍乡|pingxiang1|px','上饶|shangrao1|sr','新余|xinyu|xy','宜春|yichun2|yc','鹰潭|yingtan|yt','鞍山|anshan|as','本溪|benxi|bx','朝阳|chaoyang1|cy','大连|dalian|dl','丹东|dandong|dd','抚顺|fushun1|fs','阜新|fuxin|fx','葫芦岛|huludao|hld','锦州|jinzhou1|jz','辽阳|liaoyang1|ly','盘锦|panjin|pj','铁岭|tieling1|tl','营口|yingkou|yk','阿拉善盟|alashanmeng|alsm',
'巴彦淖尔|bayannaoer|byne','包头|baotou|bt','赤峰|chifeng|cf','鄂尔多斯|eerduosi|eeds','呼和浩特|huhehaote|hhht','呼伦贝尔|hulunbeier|hlbe','通辽|tongliao|tl','乌海|wuhai|wh','锡林郭勒盟|xilinguolemeng|xlglm','兴安盟|xinganmeng|xam','乌兰察布|wulanchabu1|wlcb','固原|guyuan1|gy','石嘴山|shizuishan|szs','吴忠|wuzhong|wz','银川|yinchuan|yc','中卫|zhongwei|zw','果洛藏族|guoluocangzu|glcz','海北藏族|haibeicangzu|hbcz','海东地区|haidongdiqu|hddq','海南藏族|hainancangzu|hncz','海西蒙古族藏族|haiximengguzucangzu|hxmgzcz','黄南藏族|huangnancangzu|hncz','西宁|xining|xn','玉树藏族|yushucangzu|yscz','滨州|binzhou|bz','德州|dezhou|dz','东营|dongying|dy','菏泽|heze|hz','济南|jinan|jn','济宁|jining|jn','莱芜|laiwu|lw','聊城|liaocheng|lc','临沂|linyi1|ly','青岛|qingdao|qd','日照|rizhao|rz','泰安|taian1|ta','威海|weihai|wh','潍坊|weifang|wf','烟台|yantai|yt','枣庄|zaozhuang|zz','淄博|zibo|zb','长治|changzhi1|cz','大同|datong1|dt','晋城|jincheng|jc','晋中|jinzhong|jz','临汾|linfen|lf','吕梁|lvliang|ll','朔州|shuozhou|sz','太原|taiyuan|ty','忻州|xinzhou|xz','阳泉|yangquan|yq','运城|yuncheng1|yc','安康|ankang|ak','宝鸡|baoji|bj','汉中|hanzhong|hz','商洛|shangluo|sl','铜川|tongchuan|tc','渭南|weinan|wn','咸阳|xianyang|xy','延安|yanan|ya','榆林|yulin2|yl','阿坝州|abazhou|abz','巴中|bazhong|bz','达州|dazhou|dz','德阳|deyang|dy','甘孜藏族|ganzicangzu|gzcz','广安|guangan|ga','广元|guangyuan|gy','乐山|leshan|ls','凉山彝族|liangshanyizu|lsyz','泸州|luzhou|lz','眉山|meishan|ms','绵阳|mianyang|my','内江|najiang|nj','南充|nanchong|nc','攀枝花|panzhihua|pzh','遂宁|suining1|sn','雅安|yaan|ya','宜宾|yibin1|yb','资阳|ziyang1|zy','自贡|zigong|zg','阿里地区|alidiqu|aldq','昌都地区|changdoudiqu|cddq','拉萨|lasa|ls','林芝地区|linzhidiqu|lzdq','那曲地区|naqudiqu|nqdq','日喀则地区|rikazediqu|rkzdq','山南地区|shannandiqu|sndq','阿克苏地区|akesudiqu|aksdq','阿勒泰地区|aletaidiqu|altdq','巴音郭楞蒙古|bayinguolengmenggu|byglmg','博尔塔拉蒙古|boertalamenggu|betlmg','昌吉回族|changjihuizu|cjhz','哈密地区|hamidiqu|hmdq','和田地区|hetiandiqu|htdq','喀什地区|kashidiqu|ksdq','克拉玛依|kelamayi|klmy',
'克孜勒苏柯尔克孜|kezilesukeerkezi|kzlskekz','塔城地区|tachengdiqu|tcdq','吐鲁番地区|tulufandiqu|tlfdq','乌鲁木齐|wulumuqi|wlmq','伊犁哈萨克|yilihasake|ylhsk','保山|baoshan|bs','楚雄彝族|chuxiongyizu|cxyz','大理白族|dalibaizu|dlbz','德宏傣族景颇族|dehongdaizujingpozu|dhdzjpz','迪庆藏族|diqingcangzu|dqcz','红河哈尼族彝族|honghehanizuyizu|hhhnzyz','昆明|kunming|km','丽江|lijiang|lj','临沧|lincang|lc','怒江傈僳族|nujianglisuzu|njlsz','普洱|puer|pe','曲靖|qujing|qj','文山文山壮族苗族|wenshanwenshanzhuangzumiaozu|wswszzmz','西双版纳傣族|xishuangbannadaizu|xsbndz','玉溪|yuxi|yx','昭通|zhaotong|zt','湖州|huzhou|hz','嘉兴|jiaxing|jx','金华|jinhua|jh','丽水|lishui1|ls','宁波|ningbo|nb','衢州|quzhou1|qz','绍兴|shaoxing1|sx','台州|taizhou2|tz','温州|wenzhou|wz','舟山|zhoushan|zs','密云|miyun|my','延庆|yanqing|yq','蓟县|jixian1|jx','静海|jinghai|jh','宁河|ninghe|nh','崇明|chongming|cm','璧山|bishan|bs','城口|chengkou|ck','大足|dazu|dz','垫江|dianjiang|dj','丰都|fengdou|fd','奉节|fengjie|fj','开县|kaixian|kx','梁平|liangping|lp','彭水苗族土家族|pengshuimiaozutujiazu|psmztjz','綦江|qijiang|qj','荣昌|rongchang|rc','石柱土家族|shizhutujiazu|sztjz','铜梁|tongliang|tl','潼南|tongnan|tn','巫山|wushan1|ws','巫溪|wuxi2|wx','武隆|wulong|wl','秀山土家族苗族|xiushantujiazumiaozu|xstjzmz','酉阳土家族苗族|youyangtujiazumiaozu|yytjzmz','云阳|yunyang|yy','忠县|zhongxian|zx','枞阳|zongyang|zy','怀宁|huaining|hn','潜山|qianshan1|qs','宿松|susong|ss','太湖|taihu|th','桐城|tongcheng1|tc','望江|wangjiang|wj','岳西|yuexi1|yx','固镇|guzhen1|gz','怀远|huaiyuan|hy','五河|wuhe|wh','利辛|lixin|lx','蒙城|mengcheng|mc','涡阳|woyang|wy','含山|hanshan|hs','和县|hexian|hx','庐江|lujiang|lj','无为|wuwei2|ww','东至|dongzhi|dz','青阳|qingyang2|qy','石台|shitai|st','天长|tianchang|tc','全椒|quanjiao|qj','明光|mingguang|mg','来安|laian|la','凤阳|fengyang|fy','定远|dingyuan|dy','阜南|funan|fn','界首|jieshou|js','临泉|linquan|lq','太和|taihe1|th','颍上|yingshang|ys','长丰|changfeng|cf','肥东|feidong|fd','肥西|feixi|fx','濉溪|suixi1|sx','凤台|fengtai|ft','祁门|qimen|qm','歙县|xixian1|xx',
'休宁|xiuning|xn','黟县|yixian1|yx','霍邱|huoqiu|hq','霍山|huoshan|hs','金寨|jinzhai|jz','寿县|shouxian|sx','舒城|shucheng|sc','当涂|dangtu|dt','砀山|dangshan|ds','灵璧|lingbi|lb','泗县|sixian|sx','萧县|xiaoxian|xx','铜陵|tongling2|tl','繁昌|fanchang|fc','南陵|nanling|nl','芜湖|wuhu2|wh','广德|guangde|gd','绩溪|jixi2|jx','泾县|jingxian1|jx','旌德|jingde|jd','郎溪|langxi|lx','宁国|ningguo|ng','长乐|changle1|cl','福清|fuqing|fq','连江|lianjiang1|lj','罗源|luoyuan|ly','闽侯|minhou|mh','闽清|minqing|mq','平潭|pingtan|pt','永泰|yongtai|yt','长汀|changting|ct','连城|liancheng|lc','上杭|shanghang|sh','武平|wuping|wp','永定|yongding|yd','漳平|zhangping|zp','光泽|guangze|gz','建瓯|jianou|jo','建阳|jianyang1|jy','文成|wencheng|wc','永嘉|yongjia|yj','岱山|daishan|ds',
'嵊泗|shengsi|ss');
--------------------编程问答-------------------- 其实到区为止  数据量也不是很大 看你是cs还是bs   bs的弄个单独的js文件 就是数据源

cs的 直接放在资源里  开启程序时候 分割下字符串

一样的 未必要存在数据库里 --------------------编程问答-------------------- 你如果要用数据库维护地区字段   就增加拼音字段,数据修改的时候  自动生成静态的js文件就可以了 --------------------编程问答-------------------- 嗯,好的,谢谢您哦
补充:.NET技术 ,  VB.NET
CopyRight © 2012 站长网 编程知识问答 www.zzzyk.com All Rights Reserved
部份技术文章来自网络,