SqlResultSetMapping (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

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.

默认值:

{}

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