Java Bind类代码示例

import ch.digitalfondue.npjt.Bind; //导入依赖的package包/类
@Query("SELECT USER_PROVIDER, USER_NAME FROM LA_USER "
		+ " INNER JOIN LA_PROJECT_USER_ROLE ON USER_ID = USER_ID_FK "
		+ " INNER JOIN LA_PROJECT_ROLE ON PROJECT_ROLE_ID_FK = PROJECT_ROLE_ID "
		+ " WHERE PROJECT_ROLE_NAME = :roleName AND LA_PROJECT_ROLE.PROJECT_ID_FK = :projectId AND "
		+ " LA_PROJECT_USER_ROLE.PROJECT_ID_FK = :projectId ORDER BY USER_PROVIDER, USER_NAME")
List<UserIdentifier> findUserIdentifierByRoleAndProjectId(@Bind("roleName") String roleName,
		@Bind("projectId") int projectId);
 

import ch.digitalfondue.npjt.Bind; //导入依赖的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.Bind; //导入依赖的package包/类
@Query("select t.id t_id, t.uuid t_uuid, t.creation t_creation, t.category_id t_category_id, t.status t_status, t.event_id t_event_id," +
    " t.src_price_cts t_src_price_cts, t.final_price_cts t_final_price_cts, t.vat_cts t_vat_cts, t.discount_cts t_discount_cts, t.tickets_reservation_id t_tickets_reservation_id," +
    " t.full_name t_full_name, t.first_name t_first_name, t.last_name t_last_name, t.email_address t_email_address, t.locked_assignment t_locked_assignment," +
    " t.user_language t_user_language, t.ext_reference t_ext_reference, " +
    " s.user_id s_user_id, s.creation s_creation, s.event_id s_event_id, s.ticket_id s_ticket_id" +
    " from sponsor_scan s, ticket t where s.event_id = :eventId and s.user_id = :userId and s.creation > :start and s.ticket_id = t.id order by s.creation")
List<DetailedScanData> loadSponsorData(@Bind("eventId") int eventId, @Bind("userId") int userId, @Bind("start") ZonedDateTime start);
 

import ch.digitalfondue.npjt.Bind; //导入依赖的package包/类
@Query("INSERT INTO LA_AUTO(VALUE) VALUES (:value)")
AffectedRowCountAndKey<Integer> insert(@Bind("value") String value);
 

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

import ch.digitalfondue.npjt.Bind; //导入依赖的package包/类
@Query("INSERT INTO LA_CONF_DATE(CONF_KEY, CONF_VALUE) VALUES(:key, :value)")
int insertValue(@Bind("key") String key, @Bind("value") ZonedDateTime date);
 

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

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

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

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

import ch.digitalfondue.npjt.Bind; //导入依赖的package包/类
@Query("INSERT INTO LA_CONF_BOOL(CONF_KEY, CONF_BOOL, CONF_STR, CONF_INT) VALUES(:key, :confBool, :confStr, :confInt)")
int insertValue(@Bind("key") String key,
		@Bind("confBool") Boolean confBool,
		@Bind("confStr") Boolean confStr,
		@Bind("confInt") Boolean confInt);
 

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

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

import ch.digitalfondue.npjt.Bind; //导入依赖的package包/类
@Query("INSERT INTO LA_CONF_ENUM (CONF_KEY) VALUES (:key)")
int insert(@Bind("key") TestEnum test);
 

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