`

查询多表返回一个list

    博客分类:
  • java
 
阅读更多

public List<?> getCourseWareList(String userName)throws DataAccessException{

String sql = "SELECT T5.id,T5.course_number,T5.type FROM " +

"domain T,domain_course_paper T2," +

"paper T3,papers_question T4,course_ware T5 " +

"WHERE T.id=T2.domain_id AND T3.id=T2.course_paper_id AND " +

"T3.id=T4.test_id AND T4.course_id=T5.id  " +

"AND T.username=? And T5.category=?";

return super.findByJDBC(sql,  new Object[]{userName,2}, CourseWare.class);

}

分享到:
评论

相关推荐

Global site tag (gtag.js) - Google Analytics