List list = null;
String QueryStr = "from Employee emp,Department dep where emp.department = dep.id";
EmployeeBiz empbiz = EmployeeBiz.getInstance();
list = empbiz.find(QueryStr);
for (int i = 0; i < list.size(); i++)
{
Object[] obj = (Object[]) list.get(i);
for (int j = 0; j < obj.length; j++)
{
if (obj[j] instanceof Employee)
{
Employee emp = (Employee) obj[j];
System.out.print(emp.getName());
}
elseif (obj[j] instanceof Department)
{
Department dep = (Department) obj[j];
System.out.print(dep.getDep_mc());
}
}
System.out.println();
}
String QueryStr = "from Employee emp,Department dep where emp.department = dep.id";
EmployeeBiz empbiz = EmployeeBiz.getInstance();
list = empbiz.find(QueryStr);
for (int i = 0; i < list.size(); i++)
{
Object[] obj = (Object[]) list.get(i);
for (int j = 0; j < obj.length; j++)
{
if (obj[j] instanceof Employee)
{
Employee emp = (Employee) obj[j];
System.out.print(emp.getName());
}
elseif (obj[j] instanceof Department)
{
Department dep = (Department) obj[j];
System.out.print(dep.getDep_mc());
}
}
System.out.println();
}