沙发土豆土豆沙发
2017-09-25 11:00JDBC获取多行数据转成List<Map>报错
业务需求将sql返回的多行数据,分别生成多个map,存放进一个List,语句如下:
public List getJgnrLjList(Long jgnrId, Long ajywId) {
String sql = "SELECT ID," +
" MC," +
" DM," +
" JGXID," +
" JGXDM," +
" SJID," +
" DQCJ," +
" GJZBS," +
" (SELECT DM" +
" FROM T_AJJG_XT_DMX" +
" WHERE ID = (SELECT XTDM" +
" FROM T_AJJG_JGNR_SSWP" +
" WHERE SFYX_ST = '1'" +
" AND JGNRID = C.ID)) SSWPDM,'' SSWPLIST" +
" FROM T_AJJG_JGNR C" +
" START WITH C.ID = ?" +
"CONNECT BY PRIOR C.SJID = C.ID" +
" AND C.SFYX_ST = '1'" +
" ORDER BY C.DQCJ";
return super.getJdbcTemplate().queryForList(sql, jgnrId);
}
报错:Incorrect column count: expected 1, actual 18
- 点赞
- 回答
- 收藏
- 复制链接分享
1条回答
为你推荐
- 关于JDBC获取connection对象的问题
- spring
- java
- intellij-idea
- tomcat
- java-ee
- 2个回答
- JDBC已成功连接到数据库,但是无法获取数据表的名称?
- sql
- java
- mysql
- 1个回答
- 关于jdbc获得大批量数据的提问
- ibatis
- 0个回答
- <JDBC> <BEA-001153> <Forcibly releasing inactive connection "weblogic.jdbc.wrap
- it技术
- 互联网问答
- IT行业问题
- 计算机技术
- 编程语言问答
- 0个回答
- jdbc连接问题,不能从数据库读数据
- jdbc
- 6个回答