81,092
社区成员
发帖
与我相关
我的任务
分享
String queryString = "SELECT s.sname AS stuName,s.sage AS stuAge ,s.snum AS stuNum ,s.sdept AS stuDept ,s.ssex as stuSex,t.tname AS teaName,t.titles AS teaTitles FROM stu AS s ,stuAndTea AS st, teacher AS t WHERE s.id=st.sid AND t.id=st.tid";
List<StuDTO> list = getSession().createSQLQuery(queryString).setResultTransformer(Transformers.aliasToBean(StuDTO.class)).list();