Java Query类代码示例

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);
 

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);
 

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);
 

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();
 

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

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("CREATE TABLE LA_CONF_DATE (CONF_KEY VARCHAR(64) PRIMARY KEY NOT NULL, CONF_VALUE TIMESTAMP NOT NULL)")
void createTable();
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT * FROM LA_CONF_DATE WHERE CONF_KEY = :key")
Conf findByKey(@Bind("key") String key);
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT CONF_VALUE FROM LA_CONF_DATE WHERE CONF_KEY = :key")
Instant findInstantByKey(@Bind("key") String key);
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT * FROM LA_CONF_DATE WHERE CONF_KEY = :key")
ConfInstant findConfInstantByKey(@Bind("key") String key);
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT CONF_VALUE FROM LA_CONF_DATE WHERE CONF_KEY = :key")
ZonedDateTime findDateByKey(@Bind("key") String key);
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("CREATE TABLE LA_CONF_BOOL (CONF_KEY VARCHAR(64) PRIMARY KEY NOT NULL, CONF_BOOL BOOLEAN NOT NULL, CONF_STR VARCHAR(255) NOT NULL, CONF_INT INTEGER NOT NULL)")
void createTable();
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT * FROM LA_CONF_BOOL WHERE CONF_KEY = :key")
BoolConf findByKey(@Bind("key") String key);
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT CONF_BOOL FROM LA_CONF_BOOL WHERE CONF_KEY = :key")
Boolean findConfBoolByKey(@Bind("key") String key);
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("CREATE TABLE LA_CONF_ENUM (CONF_KEY VARCHAR(64))")
void createTable();
 

import ch.digitalfondue.npjt.Query; //导入依赖的package包/类
@Query("SELECT CONF_KEY FROM LA_CONF_ENUM WHERE CONF_KEY = :key")
TestEnum findByKey(@Bind("key") TestEnum test);