java hql 多表查询语句,hql 语句多表联合查询解决办法

Java codeimport java.util.ArrayList;

import java.util.Collections;

import java.util.Date;

import java.util.List;

import java.util.Vector;

import org.hibernate.Query;

import org.hibernate.Session;

import org.hibernate.Transaction;

import y.model.Test;

import y.model.Test1;

import y.model.Test2;

import com.targ.track.financeManager.buildProjectAccount.domain.BuildProjectAccount;

import com.targ.track.financeManager.buildProjectAccount.domain.BuildProjectAccountDetail;

import com.targ.track.startAppManager.domain.StartApplication;

public class MyJunitTest {

@org.junit.Test

public void testDDL(){

//插入数据

HibernateTest.doInHibernateSession(new InHibernateSession(){

@Override

public Object doInHibernateSession(Session session) {

Test1 test1 = new Test1();

test1.setCAgo("CAgo");

test1.setCName("CName");

test1.setCPwd("CPwd");

test1.setCSex("CSex");

Test2 test2 = new Test2();

test2.setDAddr("DAddr");

test2.setDAge(123);

test2.setDName("DName");

test2.setDPwd("DPwd");

test2.setDSex("DSex");

session.save(test1);

session.save(test2);

return null;

}

});

//查询

List all = (List) HibernateTest.doInHibernateSession(new InHibernateSession(){

public Object doInHibernateSession(Session session) {

String sql="select new y.model.Test(c.CId,c.CName,d.DId,d.DName) from Test1 c,Test2 d where c.CId=d.DId";

Query query = session.createQuery(sql);

return query.list();

}

});

for(Test test : all){

System.out.println(test);

}

}

public static class HibernateTest {

public static Object doInHibernateSession(InHibernateSession doInHibernateSession){

Session session = HibernateSessionFactory.getSession();

Transaction transaction = session.beginTransaction();

try{

Object object = doInHibernateSession.doInHibernateSession(session);

transaction.commit();

return object;

}catch(RuntimeException e){

try{

System.err.println("rollback");

transaction.rollback();

}catch(RuntimeException ex){

System.err.println("回滚失败！");

}

throw e;

}finally{

//HibernateSessionFactory.closeSession();

}

}

}

public interface InHibernateSession {

public Object doInHibernateSession(Session session);

}

}