我这是在SSM框架下的网站,在Dao层的mapper里用了这样的查询语句
<select id="selectData"
parameterType="String"
resultType="Data">
select sum(op_numbers),
sum(pb_numbers),
sum(pe_numbers)
from b_data
where year = #{year}
and quarter = #{quarter}
</select>
resultType="Data"这里的Data是持久化类,在controller里调用查询语句,执行了
上面的查询sql语句成功了,那我要怎么得到查询出来的那3个用sum()求和过的结果啊?
@RequestMapping(value = "/admin/allData.action")
public String allData(Model model){
nursingQualityDataService
.selectData(year,quarter);
//这里查询后要怎么获得结果?
return "admin";