select new map(person.personid as personid,
person.name as name,
person.placename as placename,
person.picurl as picurl,
person.telephone as telephone,person.mobilephone as mobilephone,
person.email as email,
person.sex as sex,user.linkmanid as linkmanid,
cardtype.cardtypename as cardtypename,
country.countryname as countryname,
province.provincename as provincename,
company.companyname as companyname) from org.caexpo.hibernate.model.TPerson as person
inner join person.user as user
inner join person.sex as sex
inner join user.company as company
inner join person.country as country
left join person.province as province
left join province.parentid as parentid
left join person.expo as personexpo
left join person.expoPersonSet as expoPerson
left join expoPerson.cardtype as cardtype
left join person.position as position
left join person.teamIdentity as teamIdentity
left join expoPerson.expo as expo
where person.shamdeletetime is null and person.deletetime is null and user.userid = ? and (personexpo.expoid is null or personexpo.expoid <>? )];
hql
person.name as name,
person.placename as placename,
person.picurl as picurl,
person.telephone as telephone,person.mobilephone as mobilephone,
person.email as email,
person.sex as sex,user.linkmanid as linkmanid,
cardtype.cardtypename as cardtypename,
country.countryname as countryname,
province.provincename as provincename,
company.companyname as companyname) from org.caexpo.hibernate.model.TPerson as person
inner join person.user as user
inner join person.sex as sex
inner join user.company as company
inner join person.country as country
left join person.province as province
left join province.parentid as parentid
left join person.expo as personexpo
left join person.expoPersonSet as expoPerson
left join expoPerson.cardtype as cardtype
left join person.position as position
left join person.teamIdentity as teamIdentity
left join expoPerson.expo as expo
where person.shamdeletetime is null and person.deletetime is null and user.userid = ? and (personexpo.expoid is null or personexpo.expoid <>? )];
hql
"(person.personid as personid,person.name as name," +
"person.placename as placename,person.picurl as picurl," +
"person.telephone as telephone,person.mobilephone as mobilephone," +
"person.email as email,person.sex as sex,user.linkmanid as linkmanid," +
"cardtype.cardtypename as cardtypename,country.countryname as countryname," +
"province.provincename as provincename,company.companyname as companyname) " +
"from org.caexpo.hibernate.model.TPerson as person " +
"inner join person.user as user " +
"inner join person.sex as sex " +
"inner join user.company as company " +
"inner join person.country as country " +
"left join person.province as province " +
"left join province.parentid as parentid " +
"left join person.expo as personexpo " +
"left join person.expoPersonSet as expoPerson " +
"left join expoPerson.cardtype as cardtype " +
"left join person.position as position " +
"left join person.teamIdentity as teamIdentity " +
"left join expoPerson.expo as expo " +
"where person.shamdeletetime is null and person.deletetime is null and user.userid = ? " +
"and (personexpo.expoid is null or personexpo.expoid <>? )";我整理了下你的HQL代码
"inner join person.sex as sex " +
"inner join user.company as company " +
"inner join person.country as country " +person.user as user user到底是外键表 还是person表中的属性??
其它的也是