SQL查询返回数据多列，保存在list中时，怎么取值

最新推荐文章于 2024-07-07 22:47:13 发布

是夜色太荒芜

最新推荐文章于 2024-07-07 22:47:13 发布

阅读量6k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/qichangleixin/article/details/45561869

版权

java 专栏收录该内容

17 篇文章 1 订阅

订阅专栏

SQL：

select DISTINCT a.as_id as id,a.as_subjectnum as subjectnum from Pm_Announcementsubjectinfo a where a.as_Auctiontime like '%2015.05%'

返回的数据为List：[[82061cd1c8924cb8b0076922a47f95d7, null], [62fffa9b59d5438ca107bce049eddbb6, 1], [931a30f043934da2a81e38df6dfc1c49, 20], [7f8419fed9144b80b094375ab0d77823, 30], [2010ab16193a4f7788d8d18d19049c50, 1], [2ed739bf12d2477a9932e2732c07506a, 30], [69b0fb6dd9d142ee97ff22c3764c494d, 1], [f0db527affe44c2dbed7ca2b3661742a, null], [29f922d8bfd444ed87658aa374a1d35e, null], null]

取值：

List list = announcementsubjectService.findeverymonthmoneyin("",strs,combotypes,area,department); //实入公司帐
if (list != null && list.size() > 0) {
	for (int m=0;m<list.size();m++) {
		Object[] subjectnum = (Object[]) list.get(m);
		if (subjectnum[1] == null || "".equals(subjectnum[1])) {
			num = num +0;
		} else {
			num = num + Double.parseDouble(subjectnum[1].toString());
		}
	}
}