51,412
社区成员
发帖
与我相关
我的任务
分享sql语句怎么写成hql
String sql="select a.id id,a.UNITNAME grantingagecy,m.UNITNAME perationalunits,u.unitname estateunit,o.type operationtype,d.type defecttype" +
" from T_HCAD2_ASSET_UNIT a,T_HCAD2_MAINTENANCE_UNIT m,T_HCAD2_ASSET_UNIT2 u,CRM_OPRATION_TYPE o,CRMSYS_DEFECTTYPE d " +
" where a.id = m.id " +
" and m.id = u.id" +
" and u.id = o.id " +
" and o.id = d.id";
将sql写成hql格式应该怎么写啊
" from T_HCAD2_ASSET_UNIT a,T_HCAD2_MAINTENANCE_UNIT m,T_HCAD2_ASSET_UNIT2 u,CRM_OPRATION_TYPE o,CRMSYS_DEFECTTYPE d " +
" where a.id = m.id " +
" and m.id = u.id" +
" and u.id = o.id " +
" and o.id = d.id";
将sql写成hql格式应该怎么写啊
...全文
请发表友善的回复…
发表回复
qq_38936033 2017-05-26
- 打赏
- 举报
我试下，谢谢啦
云墨浅殇 2017-05-26
- 打赏
- 举报
String sql="select id,grantingagecy" +
" from CrmBasetype " +
<id name="id" type="java.lang.String">
<column name="id" length="32"/>
</id>
<property name="grantingagecy" type="java.lang.String" lazy="true">
<column name="type" precision="50" scale="0"/>
<class name="com.tt.po.CrmBasetype" table="CRM_OPRATION_TYPE">
大概就是这样.表名换成类名,字段名换成属性名
qq_38936033 2017-05-26
- 打赏
- 举报
<hibernate-mapping>
<class name="com.tt.po.CrmBasetype" table="CRM_OPRATION_TYPE">
<id name="id" type="java.lang.String">
<column name="id" length="32"/>
</id>
<property name="grantingagecy" type="java.lang.String" lazy="true">
<column name="type" precision="50" scale="0"/>
</property>
<property name="perationalunits" type="java.lang.String"
formula=" (select m.UNITNAME from T_HCAD2_MAINTENANCE_UNIT m where m.id = id )" insert="false" update="false">
</property>
<property name="estateunit" type="java.lang.String"
formula=" (select u.unitname from T_HCAD2_ASSET_UNIT2 u where u.id = id )" insert="false" update="false">
</property>
<property name="operationtype" type="java.lang.String"
formula=" (select o.type from CRM_OPRATION_TYPE o where o.id = id )" insert="false" update="false">
</property>
<property name="defecttype" type="java.lang.String"
formula=" (select d.type from CRMSYS_DEFECTTYPE d where d.id = id )" insert="false" update="false">
</property>
</class>
</hibernate-mapping>
qq_38936033 2017-05-26
- 打赏
- 举报
private String id;//id
private String grantingagecy;//出资单位
private String estateunit;//资产单位
private String perationalunits;//运维单位
private String operationtype;//任务类型
private String defecttype;//缺陷类型
云墨浅殇 2017-05-26
- 打赏
- 举报
把实体贴出来
qq_38936033 2017-05-26
- 打赏
- 举报
新人没写过hql，像上边这种sql语句应该怎么改？
云墨浅殇 2017-05-26
- 打赏
- 举报
hql语句和sql语句其实差不多的，只是把表名、字段名用做相对应的类名、属性名等。
