Hibernate 多表查询强制映射实体类
强制映射
hibernate中SQLQuery的addEntity()
public List<FarmDocLucene> selectFarmDocLuceneByDocId(String id) {
Session session = sessionFatory.getCurrentSession();
Query sqlQuery = session.createSQLQuery("SELECT * FROM farm_doc_lucene a LEFT JOIN farm_rf_doctextfile b ON a.file_id = b.FILEID where b.DOCID='" + id + "'");
//查询的结果集中的字段强制映射实体类对应字段
((SQLQuery) sqlQuery).addEntity(FarmDocLucene.class);
List<FarmDocLucene> list = sqlQuery.list();
return list;
}