JDBCTemplate QueryForList returns wrong value

最新推荐文章于 2023-04-07 03:09:23 发布

原创最新推荐文章于 2023-04-07 03:09:23 发布 · 171 阅读

0 ·

CC 4.0 BY-SA版权

文章标签：

#springmvc jdbc

springmvc 专栏收录该内容

0 篇文章

订阅专栏

本文讨论了使用Spring JDBCTemplate进行查询时遇到的问题，即返回的列表元素类型与预期不符。解释了原因在于查询结果包含多列时，返回的是Map类型元素，而非字符串类型。提出了通过Map.get()方法获取特定字段值的解决方案。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

http://www.coderanch.com/t/559054/Spring/JDBCTemplate-QueryForList-returns-wrong

JDBCTemplate QueryForList returns wrong value

Hi all,

I have the following code...

view plainprint?
         Note: Text content in the code blocks is automatically word-wrapped
        
String GET_AGENTS_FOR_CYCLE = "select AGENTSURROGATECODE from SETTLEMENT.AGENT_DETAILS where CYCLE = ?";  
List agentsList = jdbcTemplate.queryForList(GET_AGENTS_FOR_CYCLE,  
                new Object [] {getCycle()});  
Iterator agentItr = agentsList.iterator();  
while (agentItr.hasNext())  
        {  
            String agentCode = (String) agentItr.next();  

Right now this is failing with the exception...

view plainprint?
         Note: Text content in the code blocks is automatically word-wrapped
        
java.lang.ClassCastException: org.springframework.util.LinkedCaseInsensitiveMap cannot be cast to java.lang.String  
    at com.wu.interstream.advising.loaders.AgentsRetriever.execute(AgentsRetriever.java:54)  

So it looks like AgentList is made up of LinkedCaseInsensitiveMap objects instead of String objects. Why is this?

Thanks in advance for any help.

解决：

If the query returns more than one column the List is made up of Map elements.

You might want to try
String agentCode = (String)((Map)agentItr.next()).get("AGENTSURROGATECODE");