hibernate查询

来源：互联网发布：阿里云药师招聘编辑：程序博客网时间：2024/06/09 19:02

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

Java代码

public class ElecFeeServiceImpl extends BaseServiceImpl<String, ElecFee>implements ElecFeeService{@Overridepublic 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>

阅读全文

0 0