一 get the list of buyers加上left join不会出现问题
Criteria crit = getSession().createCriteria(Buyer.class, "b");
if(!lastName.equalsIgnoreCase("") || !email.equalsIgnoreCase("")){
crit.createCriteria("users", "u", Criteria.LEFT_JOIN)
.add(Restrictions.eqProperty("b.id", "u.buyer.id"));
}
一 get the total records of buyers加上left join 会出现问题,好像
buyer, user hibernate会自动连接
Criteria crit = getSession().createCriteria(Buyer.class, "b");
crit.setProjection(Projections.rowCount());
if(!lastName.equalsIgnoreCase("") || !email.equalsIgnoreCase("")){
crit.createCriteria("users", "u");
}
/////////////////////
ForwarderDAO.java line:244
table: forwarder, forwarder_inquiry_departure_country,
forwarder_inquiry_arrival_country,
country
4个表,
用拉2个left join好像不行(in hibernate)
只能用full join( why ?)
//////////////////////
crit.createAlias("inquiryDepartureCountry", "idcList", Criteria.FULL_JOIN);
crit.createAlias("inquiryArrivalCountry", "iacList", Criteria.FULL_JOIN);
Criteria crit = getSession().createCriteria(Buyer.class, "b");
if(!lastName.equalsIgnoreCase("") || !email.equalsIgnoreCase("")){
crit.createCriteria("users", "u", Criteria.LEFT_JOIN)
.add(Restrictions.eqProperty("b.id", "u.buyer.id"));
}
一 get the total records of buyers加上left join 会出现问题,好像
buyer, user hibernate会自动连接
Criteria crit = getSession().createCriteria(Buyer.class, "b");
crit.setProjection(Projections.rowCount());
if(!lastName.equalsIgnoreCase("") || !email.equalsIgnoreCase("")){
crit.createCriteria("users", "u");
}
/////////////////////
ForwarderDAO.java line:244
table: forwarder, forwarder_inquiry_departure_country,
forwarder_inquiry_arrival_country,
country
4个表,
用拉2个left join好像不行(in hibernate)
只能用full join( why ?)
//////////////////////
crit.createAlias("inquiryDepartureCountry", "idcList", Criteria.FULL_JOIN);
crit.createAlias("inquiryArrivalCountry", "iacList", Criteria.FULL_JOIN);