Hibernate 原生SQL的使用,类似iBaits方式

最新推荐文章于 2020-09-11 11:00:37 发布

最新推荐文章于 2020-09-11 11:00:37 发布 · 106 阅读

·

0

·

文章标签：

#Hibernate #SQL #.net #XML

本文介绍了一个使用Hibernate框架通过原生SQL查询典型设备缺陷报表的方法。该示例展示了如何定义Hibernate映射文件及对应的Java代码来执行SQL查询并返回具体的数据模型。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

Hibernate 原生SQL

<? xml version="1.0" ?>

<! DOCTYPE hibernate-mapping PUBLIC "-//Hibernate/Hibernate Mapping DTD 3.0//EN"

"http://hibernate.sourceforge.net/hibernate-mapping-3.0.dtd" >

< hibernate-mapping >

< class name ="com.mip.biz.defect.domain.TypidefdetailVo" >

< id name ="oid" type ="java.lang.Long" >

< column name ="OID" precision ="22" scale ="0" />

< generator class ="assigned" />

</ id >

< property name ="devtype" type ="string" >

< column name ="DEVTYPE" length ="20" />

</ property >

< property name ="pwlevel" type ="string" >

< column name ="PWLEVEL" length ="20" />

</ property >

< property name ="stno" type ="java.lang.Long" >

< column name ="STNO" precision ="22" scale ="0" />

</ property >

< property name ="stname" type ="string" >

< column name ="STNAME" length ="50" />

</ property >

< property name ="factory" type ="string" >

< column name ="FACTORY" length ="40" />

</ property >

< property name ="devstyle" type ="string" >

< column name ="DEVSTYLE" length ="40" />

</ property >

< property name ="finddate" type ="java.util.Date" >

< column name ="FINDDATE" length ="7" />

</ property >

< property name ="definfo" type ="string" >

< column name ="DEFINFO" length ="200" />

</ property >

< property name ="defreason" type ="string" >

< column name ="DEFREASON" length ="200" />

</ property >

< property name ="measure" type ="string" >

< column name ="MEASURE" length ="200" />

</ property >

< property name ="cleardate" type ="java.util.Date" >

< column name ="CLEARDATE" length ="7" />

</ property >

</ class >

< sql-query name ="queryTypidefdetailReportQuerySql" >

< return alias ="detail" class ="com.mip.biz.defect.domain.TypidefdetailVo" >

< return-property name ="oid" column ="typOID" />

< return-property name ="devtype" column ="typDEVTYPE" />

< return-property name ="pwlevel" column ="typPWLEVEL" />

< return-property name ="factory" column ="typFACTORY" />

< return-property name ="devstyle" column ="typDEVSTYLE" />

< return-property name ="finddate" column ="typFINDDATE" />

< return-property name ="definfo" column ="typDEFINFO" />

< return-property name ="defreason" column ="typDEFREASON" />

< return-property name ="cleardate" column ="typCLEARDATE" />

< return-property name ="measure" column ="typMEASURE" />

< return-property name ="stno" column ="typSTNO" />

< return-property name ="stname" column ="typeSTNAME" />

</ return >

<![CDATA[

SELECT

1 as typSTNO,

'stname' as typeSTNAME,

definfo.taskbillid AS typOID,

definfo.devtype AS typDEVTYPE,

definfo.powerlevel AS typPWLEVEL,

definfo.devfactory AS typFACTORY,

definfo.xinghao AS typDEVSTYLE,

definfo.findtime AS typFINDDATE,

definfo.findcontent AS typDEFINFO,

definfo.slidea AS typDEFREASON,

definfo.checktime AS typCLEARDATE,

definfo.checkresult AS typMEASURE

FROM DEFECT_DEFECTINFO definfo

WHERE

definfo.orgid = :orgid

]]>

</ sql-query >

</ hibernate-mapping >

对应的java代码

public List queryTypidefdetailsByHibernate(Long loginerOrgid,Date startTime, Date endTime)

{

Query query = this.getSession().getNamedQuery("queryTypidefdetailReportQuerySql");

query.setLong("orgid", new Long(1));

List result = query.list();

return result;

}

Lib 2007-03-29 13:20 发表评论

评论

被折叠的条评论为什么被折叠?

到【灌水乐园】发言

查看更多评论

添加红包

成就一亿技术人!

hope_wisdom

发出的红包

实付元

使用余额支付

点击重新获取

扫码支付

钱包余额 0

抵扣说明：

1.余额是钱包充值的虚拟货币，按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载，可以购买VIP、付费专栏及课程。