import com.fasterxml.jackson.annotation.JsonFormat;
 ---
 @JsonFormat(pattern = "yyyy-MM-dd HH:mm:ss")
 private Date createtime;

@Select("select e.name,d.* from(SELECT a.`no`,a.classID,a.studentno,b.ID scoreid,b.score," 
 "DATE_FORMAT(b.time,'%Y-%m-%d %h:%m:%s') as time,b.note " 
 "from studentclass a " 
 "LEFT JOIN score b " 
 "on a.studentno=b.studentno " 
 "and b.jobID=#{jobid} " 
 "where a.classID =(SELECT teachclassid FROM job WHERE ID=#{jobid}) " 
 "ORDER BY a.`no` asc)d,student e " 
 "WHERE d.studentno=e.studentno")
 List getscorebyjobid(int jobid);