hiberaten 多表查询结果处理
?
hiberaten 多表查询结果处理:
在以前的项目里，经常会遇到关于hiberaten多表联系查询的处理,
在网上看到不少的同行问到关于hiberate 多表查询的结果如何处理,以下是我个人的一些项目经验，分享给大家看一下，
如果有什么好的建议的话，请提出：
/**
?*
?* @author?jbeduhai
?*/
public class MessageServiceImp extends BusinessClass implements MessageService
//处理方法一:
public void getMessage(){
?//取得收件箱内容,传一个消息类型,一个HQL语句;
?????? List list =? this.getMessageByHql("",
?????????????? "? select m.title,m.body,m.event_time,m.sender? "+
?????????????? "? from MessageImp m,MessageReceiversImp r? "+
?????????????? "? where m.id = r.messageid? and? m.type =1? and r.receiverid='userid' and r.tag =0");
?//MessageI 一方,MessageReceiversI 多方，嵌套输出
??????? for (Iterator ite = list.iterator(); ite.hasNext();) {?
????
??????????? MessageI messageI = (MessageI) ite.next();? //实体类接口
??????????? System.out.println(">>>>>>>>>>>>>>getTitle>>>>>>>>>>>>>" + messageI.getTitle());
???? System.out.println(">>>>>>>>>>>>>>getBody>>>>>>>>>>>>>" + messageI.getBody());
??????????? System.out.println(">>>>>>>>>>>>>>getSender>>>>>>>>>>>>>" + messageI.getSender());
??????????? System.out.println(">>>>>>>>>>>>>>getEvent_time>>>>>>>>>>>>>" + messageI.getEvent_time());
??????????? System.out.println("=================== set=" + messageI.getMessageReceiversImpSet().size());
??????????? for (Iterator ite1 = messageI.getMessageReceiversImpSet().iterator(); ite1.hasNext();) {
??????????????? MessageReceiversI messageReceiversI = (MessageReceiversI) ite1.next();
??????????????? System.out.println("=================== getId=" + messageReceiversI.getId());
??????????????? System.out.println("=================== getReceiverid=" + messageReceiversI.getReceiverid());
??????????????? System.out.println("=================== getReplybody=" + messageReceiversI.getReplybody());
??????????? }
??????? }
}
//处理方法二:
public void getMessage(){
?List list = this.getMessageByHql(
??????????????? "? from MessageImp m,MessageReceiversImp r? " +
??????????????? "? where m.id = r.messageid? and? m.type =1? and r.receiverid='user9' and r.tag =0");
??????? Iterator ite = list.iterator();
?//MessageI 一方,MessageReceiversI 多方
??????? while (ite.hasNext()) {
??????????? Object[] o = (Object[]) ite.next();
???? //索引值是根据查询时对象的多少来定义的，从0开始，0到 n-1个索引
??????????? MessageI messageI = (MessageI) o[0];
??????????? MessageReceiversI messageReceiversI = (MessageReceiversI) o[1];
???????????
??????????? System.out.println("=================== getTitle=" + messageI.getTitle());
??????????? System.out.println("=================== getBody=" + messageI.getBody());
??????????? System.out.println("=================== getId=" + messageReceiversI.getId());
??????????? System.out.println("=================== getSenderid=" + messageReceiversI.getSenderid());
??????????? System.out.println("=================== getReceiverid=" + messageReceiversI.getReceiverid());
??????????? System.out.println("=================== getReplybody=" + messageReceiversI.getReplybody());
??????? }
}
?
??? /**
???? *
???? * @return hql 查询HQL语句
???? */
??? public List getMessageByHql(String hql) {
??????? List list = new ArrayList();
??????? try {
???? //根据spring 配置得到 工厂类实现对象
??????????? MessageFactoryI messageFactoryImp =
??????????? (MessageFactoryImp) factory.getBean("messageFactoryImp");
???? //根据工厂类? 得到Dao实现类对象
??????????? MessageDB messageDB = messageFactoryImp.getMessage();
??????????? list = this.getMessageByHql(hql);
??????? } catch (Exception ex) {
??????????? ex.printStackTrace();
??????? }
??????? return list;
??? }
????? /**
???? *
???? * @param hql
???? * @return 根据hql返回消息表中符合条件的消息
???? *
???? */
??? public List<MessageI> getMessageByHql(String hql) {
??????? Session session = HibernateSessionFactory.currentSession();
??????? Query query = session.createQuery(hql);
??????? return query.list();
???????
??? }
? }
? //由于时间关系，贴出不是很全，全面的整理后，再贴出，以上希望对需要的朋友有帮助;
