日歷

隨筆檔案

SpeedProductLoad.java

public ? class ?SpeedProductLoad? {

???? private ?SpeedProduct?product;

???? private ?SpeedVehicleType?vehicleType;

???? private ?Double?loaded;

???? private ?Long?lineNo;

????

???? public ?SpeedProductLoad(SpeedProduct?product,SpeedVehicleType?vehicleType,Double?loaded,Long?lineNo) {

???????? this .product? = ?product;

???????? this .vehicleType? = ?vehicleType;

???????? this .loaded? = ?loaded;

???????? this .lineNo? = ?lineNo;

????}

}

hbm中的映射：

<map?name="vehicleTypes"?table="PRODUCT_VEHICLETYPE"?lazy="true"?inverse="false"?cascade="all">

????????????<key?column="PRODUCT_ID"/>

????????????<index-many-to-many?class="com.vtradex.speedtms.model.base.vehicle.SpeedVehicleType"?column="VEHICLE_TYPE_ID"/>

????????????<element?type="double"?column="FULLYLOADED"/>

</map>

?HQL語句：

SELECT?new?com.vtradex.speedtms.model.base.product.SpeedProductLoad(product,index(vehicleTypes),vehicleTypes,product.id)

????????????????FROM?SpeedProduct?AS?product

????????????????LEFT?JOIN?FETCH?product.vehicleTypes?AS?vehicleTypes

????????????????WHERE?1=1??AND?product.disabled=false

????????????????/~code:?AND?product.code?LIKE?{code}?~/

????????????????/~name:?AND?product.name?LIKE?{name}?~/

????????????????/~company.id:?AND?product.company.id={company.id}?~/

????????????????/~product.uom:?AND?product.uom={product.uom}?~/

????????????????/~productType.id:?AND?product.productType.id={productType.id}?~/

posted on 2006-05-09 17:14 費思量閱讀(734) 評論(0) 編輯收藏


Copyright © 費思量	Powered by: 博客園模板提供：滬江博客

導航