使用STS框架在jdbcTemplate中执行求和操作

Question

我必须使用jdbcTemplate找到sum(actual_effort)和sum(planned_effort)，因为我正在进行下面的编码，但我正在为actual_effort以及planned_effort获得空值，其余的值都是正确的。请帮帮我……

List<TaskDTO> getAllProjectsTaskReport(){
log.info(" Service getAllProjectsTaskReport");
String sql="select id,sum(actual_effort),actual_end_date,actual_start_date,code,created_date,description,name,sum(planned_effort),planned_end_date,planned_start_date,status,work_completed_percent,assigned_to_id,created_by_id,parent_task_code_id,project_id from task group by project_id";
List<TaskDTO> list  = getJdbcTemplate().query(sql,new BeanPropertyRowMapper(TaskDTO.class));
return list;
}

Answer 1

Try sql with select as

List<TaskDTO> getAllProjectsTaskReport(){
log.info(" Service getAllProjectsTaskReport");
String sql="select id,sum(actual_effort) as actual_effort,actual_end_date,actual_start_date,code,created_date,description,name,sum(planned_effort) as planned_effort,planned_end_date,planned_start_date,status,work_completed_percent,assigned_to_id,created_by_id,parent_task_code_id,project_id from task group by project_id";
List<TaskDTO> list  = getJdbcTemplate().query(sql,new BeanPropertyRowMapper(TaskDTO.class));
return list;
}