省地县的二级联动

省市县的二级联动

?

?

?

?

?

?

?

?

?

?

public?class?AreaLinkageDao?{ ????????/** ???????*?根据省ID查询城市信息 ???????*? ???????*?@param?parameter ???????*?@param?servletContext ???????*?@return ???????*/ ??????public?List?areaLinkage(String?provinceId,?ServletContext?servletContext) ??????????????throws?Exception?{ ??????????RootDaoInterface?rootDao?=?(RootDaoInterface)?DataSourceHelper ??????????????????.getDaoInterfae(servletContext); ??????????String?sql?=?"select?id,city_code,city_name?from?tb_area_city?where?pid?=??"; ??????????return?rootDao.preparedQuery(sql,?new?String[]?{?provinceId?}); ??????} ????}??

?

来自：http://waynett.iteye.com/blog/815257