67,514
社区成员
发帖
与我相关
我的任务
分享
Session session = this.getSession();
try {
String sql = " select * FROM (SELECT * from LampInfo WHERE LampID IN(SELECT MIN(LampID) FROM LampInfo "
+ " WHERE IsDoubleLamp='Y' and boxID = " + boxID + " and boxgruop = " +boxgruop + " "
+ " GROUP BY SUBSTR(LAMPNO,1,LENGTH(LampNo)-1)) ORDER BY LampID) t1 "
+ " UNION ALL select * FROM (SELECT * from LampInfo WHERE IsDoubleLamp<>'Y' "
+ " and boxID = " + boxID + " and boxgruop = " + boxgruop + " ORDER BY LampID ) t2 ";
SQLQuery query = session.createSQLQuery(sql).addEntity("LampInfo",LampInfo.class);
List<LampInfo> list = query.list();
return list;
} catch (Exception e) {
e.printStackTrace();
return null;
}finally {
session.close();
}
}