hibernate查询

hibernate关联查询不需要sql拼接只需要配置即可

Java代码

 

public class ElecFeeServiceImpl extends BaseServiceImpl<String, ElecFee>implements ElecFeeService{

@Override
public List<ElecFee> queryElecFees() throws Exception {
       StringBuffer sb = new StringBuffer(" from ElecFee where 1= 1 ");
        
        return baseDao.query(sb.toString());
}
}

 

 

 

 

 

页面

 

{
field : 'companyName',
title : '单位名称',
align:'center',
width :'180px',
formatter:function(value,row,index){
             if(row.supplyCompany == null){
                 return "";
             }
             return row.supplyCompany.company;
        }
},
{
field : 'Companylinkmen',
title : '单位联系人',
align:'center',
width :'100px',
formatter:function(value,row,index){
             if(row.supplyCompany == null){
                 return "";
             }
             return row.supplyCompany.linkmen;
        }
},
{
field : 'Companyaccount',
title : '开户账号',
align:'center',
width :'200px',
formatter:function(value,row,index){
             if(row.supplyCompany == null){
                 return "";
             }
             return row.supplyCompany.account;
        }
},
{
field : 'Companybank',
title : '开户行',
align:'center',
width :'200px',
formatter:function(value,row,index){
             if(row.supplyCompany == null){
                 return "";
             }
             return row.supplyCompany.bank;
        }
},
{
field : 'meterInfoRent',
title : '场地租金',
align:'right',
width :'100px',
formatter:function(value,row,index){
             if(row.meterInfo == null){
                 return "";
             }
             return row.meterInfo.rent;
        }
}

 

 

 

 

 

配置文件

 

  <many-to-one name="meterInfo" class="com.ymdsm.model.baseinfo.Meterinfo" fetch="select" lazy="false">
            <column name="MeterID"/>
   </many-to-one>
 <many-to-one name="supplyCompany" class="com.ymdsm.model.baseinfo.SupplyCompany" fetch="select" lazy="false">
            <column name="companyid"/>
 </many-to-one>