konsei 2018-05-24 13:11 采纳率: 72.2%
浏览 3782
已采纳

select查询时用了sum函数后,怎么得到结果?

我这是在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";
  • 写回答

5条回答 默认 最新

  • 超级IT大神 2018-05-24 13:49
    关注
     <select id="selectData" 
                parameterType="String" 
                resultType="Data">
            select sum(op_numbers) as op_numbers,
                sum(pb_numbers) as pb_numbers ,
                sum(pe_numbers) as pe_numbers
            from b_data 
            where year = #{year}
            and quarter = #{quarter}
        </select>
    

    在controller里用Data.getOp_Numbers();这种相应的getter方法就可获取到

    本回答被题主选为最佳回答 , 对您是否有帮助呢?
    评论
查看更多回答(4条)

报告相同问题?