Java Query類代碼示例

本文整理匯總了Java中ch.digitalfondue.npjt.Query類的典型用法代碼示例。如果您正苦於以下問題：Java Query類的具體用法？Java Query怎麽用？Java Query使用的例子？那麽, 這裏精選的類代碼示例或許可以為您提供幫助。

Query類屬於ch.digitalfondue.npjt包，在下文中一共展示了Query類的15個代碼示例，這些例子默認根據受歡迎程度排序。您可以為喜歡或者感覺有用的代碼點讚，您的評價將有助於係統推薦出更棒的Java代碼示例。

示例1: scan_audit

import ch.digitalfondue.npjt.Query; //導入依賴的package包/類
@Query("insert into scan_audit(ticket_uuid, event_id_fk, scan_ts, username, check_in_status, operation) values(:ticketUuid, :eventId, :scanTs, :username, :status, :operation)")
Integer insert(@Bind("ticketUuid") String ticketUuid,
               @Bind("eventId") int eventId,
               @Bind("scanTs") ZonedDateTime timestamp,
               @Bind("username") String username,
               @Bind("status") CheckInStatus checkInStatus,
               @Bind("operation") ScanAudit.Operation operation);

開發者ID:alfio-event，項目名稱:alf.io，代碼行數:8，代碼來源:ScanAuditRepository.java

示例2: FROM

import ch.digitalfondue.npjt.Query; //導入依賴的package包/類
@Query("SELECT * FROM (SELECT DISTINCT CARD_ID_FK FROM LA_CARD_LABEL "
    + " INNER JOIN LA_CARD_LABEL_VALUE ON CARD_LABEL_ID = CARD_LABEL_ID_FK "
    + " WHERE CARD_LABEL_VALUE_USER_FK = :userId AND CARD_LABEL_DOMAIN = 'SYSTEM' AND "
    + " CARD_LABEL_NAME IN ('ASSIGNED', 'WATCHED_BY') ) CARD_IDS "
    + " INNER JOIN LA_EVENT ON CARD_ID_FK = EVENT_CARD_ID_FK "
    + " WHERE EVENT_USER_ID_FK <> :userId AND EVENT_TIME BETWEEN :from AND :upTo ORDER BY EVENT_TIME ASC")
List<Event> eventsForUserWithoutHisOwns(@Bind("userId") int userId, @Bind("from") Date from, @Bind("upTo") Date upTo);

開發者ID:digitalfondue，項目名稱:lavagna，代碼行數:8，代碼來源:NotificationQuery.java

示例3: auditing

import ch.digitalfondue.npjt.Query; //導入依賴的package包/類
@Query("insert into auditing(reservation_id, user_id, event_id, event_type, event_time, entity_type, entity_id, modifications) " +
    " values (:reservationId, :userId, :eventId, :eventType, :eventTime, :entityType, :entityId, :modifications)")
int insert(@Bind("reservationId") String reservationId, @Bind("userId") Integer userId,
           @Bind("eventId") Integer eventId,
           @Bind("eventType") Audit.EventType eventType, @Bind("eventTime") Date eventTime,
           @Bind("entityType") Audit.EntityType entityType, @Bind("entityId") String entityId,
           @Bind("modifications") String modifications);

開發者ID:alfio-event，項目名稱:alf.io，代碼行數:8，代碼來源:AuditingRepository.java

示例4: LA_AUTO

import ch.digitalfondue.npjt.Query; //導入依賴的package包/類
@Query("CREATE TABLE LA_AUTO (ID INTEGER GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY NOT NULL, VALUE CLOB NOT NULL)")
void createTable();

開發者ID:digitalfondue，項目名稱:npjt-extra，代碼行數:3，代碼來源:AutogeneratedKeyQueriesTest.java

示例5: findKeyByValue

import ch.digitalfondue.npjt.Query; //導入依賴的package包/類
@Query("SELECT ID FROM LA_AUTO WHERE VALUE = :value")
Integer findKeyByValue(@Bind("value") String value);

開發者ID:digitalfondue，項目名稱:npjt-extra，代碼行數:3，代碼來源:AutogeneratedKeyQueriesTest.java