String orderSql = "select fileId,evalsum from deptmgrevalmark t where evalid=" + curEvalId +" union all select fileId,evalsum from OfficeMgrEvalMark O where evalid=" + curEvalId +" union all select fileId,evalsum from OfficeEvalMark Oe where evalid=" + curEvalId +" union all select fileId,evalsum from EmployeeEvalMark em where evalid=" + curEvalId ;
直接在最后一个SQL语句后加 Order By 就可以了。