sql

 SELECT  a.project_id AS projectid

,a.eva_ass_id AS assid
, b.pr_name AS projectname , c.name as assname
,COUNT(if(score ='5',a.project_id,null)) AS tocal5
,COUNT(if(score ='4',a.project_id,null)) AS tocal4
,COUNT(if(score ='3',a.project_id,null)) AS tocal3
,COUNT(if(score ='2',a.project_id,null)) AS tocal2
,COUNT(if(score ='1',a.project_id,null)) AS tocal1 FROM
eva_easy_person_detail a
LEFT JOIN project b ON b.id = a.project_id
LEFT JOIN eva_assignment c ON a.eva_ass_id =c.id
WHERE
eva_ass_id = 7
GROUP BY
a.project_id

//xml 文件获得刚生成的id id自增刚插进就获得
useGeneratedKeys="true" keyProperty="id"