各位求救!我需要从数据库中根据日期时间进行分组查询,查询语句在Oracle数据库中可行;
语句如下:
select to_char(MAKETIME,'yyyy-mm-dd'),"COUNT"(MAKETIME) from TB_PRODUCT_ORTHO WHERE STATUS_WATER = 0
group by to_char(MAKETIME,'yyyy-mm-dd')order by to_char(MAKETIME,'yyyy-mm-dd')
在Mybatis的mapping编写如下:
<select id="dayCount3" resultType="map" parameterType="double">
select to_char(MAKETIME,'yyyy-mm-dd hh:mm:ss'),"COUNT"(MAKETIME) from TB_PRODUCT_ORTHO WHERE STA
TUS_WATER = 0 group by to_char(MAKETIME,'yyyy-mm-dd hh:mm:ss')order by to_char(MAKETIME,'yyyy-mm-dd hh:mm:ss')
</select>
测试类编写如下:
Map<Double, Double> map = new HashMap<Double, Double>();
map = product_OrthoDayDao.dayCount0();
for (Map.Entry<Double, Double> entry : map.entrySet()) {
System.out.println("Key = " + entry.getKey() + ", Value = " + entry.getValue());
}
然而结果并没有出现数据列表:
[org.mybatis.spring.transaction.SpringManagedTransaction] - JDBC Connection [jdbc:oracle:thin:@127.0.0.1:1521:orac, UserName=WATER, Oracle JDBC driver] will not be managed by Spring
[com.iwhr.water.dao.Product_OrthoDayDao.dayCount0] - ==> Preparing: select to_char(MAKETIME,'yyyy-mm-dd hh:mm:ss'),"COUNT"(MAKETIME) from TB_PRODUCT_ORTHO WHERE STATUS_WATER = 0 group by to_char(MAKETIME,'yyyy-mm-dd hh:mm:ss')order by to_char(MAKETIME,'yyyy-mm-dd hh:mm:ss')
[com.iwhr.water.dao.Product_OrthoDayDao.dayCount0] - ==> Parameters:
[com.iwhr.water.dao.Product_OrthoDayDao.dayCount0] - <== Total: 211
[org.mybatis.spring.SqlSessionUtils] - Closing non transactional SqlSession [org.apache.ibatis.session.defaults.DefaultSqlSession@73ff4fae]
[org.springframework.jdbc.datasource.DataSourceUtils] - Returning JDBC Connection to DataSource
求救啊!!!