import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlUpdate("UPDATE SNM_MONITOR SET STATUS = :status, MODIFIED_TIME = :modifiedTime WHERE MONITOR_ID IN (<monitorIds>)")
void updateMonitorsStatus(@BindIn("monitorIds") List<String> monitorIds, @Bind("status") int status, @Bind("modifiedTime") Date modifiedTime);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlQuery("SELECT SNM_TASK.TASK_ID, MONITOR_ID, ACCOUNT_ID, NAME, TASK_INTERVAL AS 'INTERVAL', CONFIG_JSON, STATUS, CREATION_TIME, MODIFIED_TIME FROM SNM_TASK INNER JOIN SNM_MONITOR_TASK ON SNM_MONITOR_TASK.TASK_ID = SNM_TASK.TASK_ID " +
        " WHERE SNM_MONITOR_TASK.MONITOR_ID = :monitorId AND SNM_MONITOR_TASK.TASK_ID NOT IN (<runningTaskIds>) AND STATUS = :taskEnableStatus AND REDISPATCHER <ne> :redispatcher")
@MaxRows(1)
@RegisterMapper(TaskMapper.class)
Task getNextStartTask(@Bind("monitorId") String monitorId, @BindIn("runningTaskIds") List<String> runningTaskIds, @Bind("taskEnableStatus") int taskEnableStatus, @Define("ne") String notEqual, @Bind("redispatcher") int redispatcher) ;
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlQuery("SELECT * FROM todo.todoItem WHERE id IN (<ids>)")
List<TodoItem> findByIds(@BindIn("ids") Collection<Long> ids);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlQuery(recordForKeyQuery)
@RegisterMapper(DerivationRecordMapper.class)
public abstract List<Record> findRecords(@BindIn("keys") List<String> derivationKeys, @Bind("name") String derivationName, @Define("schema") String schema, @Define("entry_table") String entryTable);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@RegisterMapper(EntryMapper.class)
@SingleValueResult(Entry.class)
@SqlQuery("select e.entry_number, array_remove(array_agg(ei.sha256hex), null) as sha256hex, e.timestamp, e.key, e.type from \"<schema>\".<entry_table> e left join \"<schema>\".<entry_item_table> ei on ei.entry_number = e.entry_number where e.key in (<keys>) group by e.entry_number order by e.entry_number asc")
Collection<Entry> getEntriesByKeys(@BindIn("keys") List<String> entryKeys, @Define("schema") String schema, @Define("entry_table") String entryTable, @Define("entry_item_table") String entryItemTable);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlQuery("select id, type, updated_at from users where id in (<ids>)")
@Mapper(UserUpdatedAtMapper.class)
List<User> findUsersWithUpdatedAt(@BindIn("ids") List<Integer> ids);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlUpdate
void makeTimelineChunksInvalid(@BindIn("chunkIds") final List<Long> chunkIds,
                               @BindBean final MeterInternalCallContext context);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlUpdate
void deleteTimelineChunks(@BindIn("chunkIds") final List<Long> chunkIds,
                          @BindBean final MeterInternalCallContext context);
 

import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
/**
 *
 * @param teststepId
 * @param ids can not be empty, otherwise jdbi will throw exception, though H2 works with empty.
 */
@SqlUpdate("delete from assertion where teststep_id = :teststepId and id not in (<ids>)")
public abstract void deleteByTeststepIdIfIdNotIn(@Bind("teststepId") long teststepId, @BindIn("ids") List<Long> ids);