SqlResultSetMapping (Java EE 5 SDK)

Java

Java EE 5 SDK

深圳电信培训中心.徐海蛟老师.


javax.persistence Annotation Type SqlResultSetMapping


@Target(value=TYPE)
@Retention(value=RUNTIME)
public @interface SqlResultSetMapping

This annotation is used to specify the mapping of the result of a native SQL query.

    Example:

    Query q = em.createNativeQuery(
        "SELECT o.id AS order_id, " +
            "o.quantity AS order_quantity, " +
            "o.item AS order_item, " +
            "i.name AS item_name, " +
        "FROM Order o, Item i " +
        "WHERE (order_quantity > 25) AND (order_item = i.id)",
    "OrderResults");
    
    @SqlResultSetMapping(name="OrderResults", 
        entities={ 
            @EntityResult(entityClass=com.acme.Order.class, fields={
                @FieldResult(name="id", column="order_id"),
                @FieldResult(name="quantity", column="order_quantity"), 
                @FieldResult(name="item", column="order_item")})},
        columns={
            @ColumnResult(name="item_name")}
    )
 

从以下版本开始:
Java Persistence 1.0

Required Element Summary
 String name
          The name given to the result set mapping, and used to refer to it in the methods of the Query API.
 
Optional Element Summary
 ColumnResult[] columns
          Specifies the result set mapping to scalar values.
 EntityResult[] entities
          Specifies the result set mapping to entities.
 

元素详细信息

name

public abstract String name
The name given to the result set mapping, and used to refer to it in the methods of the Query API.

entities

public abstract EntityResult[] entities
Specifies the result set mapping to entities.

默认值:
{}

columns

public abstract ColumnResult[] columns
Specifies the result set mapping to scalar values.

默认值:
{}

Java EE 5 SDK

深圳电信培训中心.徐海蛟老师.


提交错误或意见

版权所有 2007 Sun Microsystems, Inc. 保留所有权利。 请遵守许可证条款。深圳电信培训中心.徐海蛟老师教学参考.