Play framework 执行原生SQL并转换成实体对象
//sql语句String sql = "SELECT * FROM question where id<(select max(id) from question) order by id desc;";//创建sql查询Query query = Model.em().createNativeQuery(sql,Question.class);// 查询结果返回至实体对象questionList<Question> questions = query.getResultList();//分页ValuePaginator paginator = new ValuePaginator(questions);paginator.setPageSize(20);paginator.setPageNumber(1);
?
