本文整理汇总了Java中org.skife.jdbi.v2.unstable.BindIn类的典型用法代码示例。如果您正苦于以下问题：Java BindIn类的具体用法？Java BindIn怎么用？Java BindIn使用的例子？那么恭喜您, 这里精选的类代码示例或许可以为您提供帮助。
BindIn类属于org.skife.jdbi.v2.unstable包，在下文中一共展示了BindIn类的9个代码示例，这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞，您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: IN
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);
示例2: IN
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) ;
示例3: IN
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);
示例4: findRecords
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);
示例5: array_remove
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);
示例6: in
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);
示例7: makeTimelineChunksInvalid
import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlUpdate
void makeTimelineChunksInvalid(@BindIn("chunkIds") final List<Long> chunkIds,
@BindBean final MeterInternalCallContext context);
示例8: deleteTimelineChunks
import org.skife.jdbi.v2.unstable.BindIn; //导入依赖的package包/类
@SqlUpdate
void deleteTimelineChunks(@BindIn("chunkIds") final List<Long> chunkIds,
@BindBean final MeterInternalCallContext context);
示例9: in
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);