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">
<!--?Generated?2007-3-20?16:44:34?by?Hibernate?Tools?3.2.0.beta8?-->
<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>
????
<!--?典型設(shè)備缺陷報表（緊急+重大+一般，詳細情況）?-->
<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>
對應(yīng)的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;
????}posted on 2007-03-29 13:20
Lib 閱讀(2037)
評論(0) 編輯 收藏 所屬分類:
開源框架