Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1; nested exception is org.hibernate.QueryParameterException: Position beyond number of declared ordinal parameters. Remember that ordinal parameters are 1-based! Position: 1

出现这个错误，是因为你的hql设置了错误的参数

如：

String hql = "from city cs where cs.areaid=:areaid";
list = new ArrayList<Map<String, Object>>();
iter = hibernateTemplate.find(hql, Areaid).iterator();

很明显，在查询的时候参数错误了，如果使用find  那您的参数应该是对应hql里面的问号

该成这样就行 了

iter = hibernateTemplate.findByNamedParam(hql, "areaid", Areaid).iterator();

或者将hql修改成这样也可以

String hql = "from city cs where cs.areaid=?";