Spring 3.x的NamedParameterJdbcTemplate.qu?报错

import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate
import test.entity.UserInfo

String sql = "select city from tbl_user where userName like :username";
UserInfo userRequest = new UserInfo();
userRequest.setUsername("%陈%");
userRequest.setCity("城市"); // 改类有城市
NamedParameterJdbcTemplate.queryForList(sql, new BeanPropertySqlParameterSource(userRequest), UserInfo.class);

一直报错

org.springframework.dao.TypeMismatchDataAccessException: Type mismatch affecting row number 0 and column type 'VARCHAR2': Value [广州] is of type [java.lang.String] and cannot be converted to required type [test.entity.UserInfo]

//------------分割线-----------

如果：

String sql = "select userName, city from tbl_user where userName like :username";

错误如下：

org.springframework.jdbc.IncorrectResultSetColumnCountException: Incorrect column count: expected 1, actual 2

真是蛋痛，还是使用返回List<Map<String, Object>>的queryForList好了，不过要转类型麻烦。一直很忙，感觉累啊。