@SqlBatch("insert into something (id, name) values (0, '')") int[] insertBeans(); // whoops, no parameters at all! }
@SqlBatch("INSERT INTO users (name) VALUES(?)") @GetGeneratedKeys List<User> createUsers(String... names); }
@SqlBatch void insertBunches(@BindBean Something... somethings); }
@SqlBatch("insert into test (id) values (:id)") void invalidInsertString(@Bind("id") String id); }
@SqlBatch("update something set name = :name where id = :id") boolean[] update(@BindBean Something... values); }
@SqlBatch("insert into something (id, name) values (:id, :name)") void insert(@BindBean Something... somethings); }
@SqlBatch("insert into batching (id, values) values (:id, :values)") int[] insertValues(int[] id, @SingleValue int[] values);
@SqlBatch("insert into user (id, name) values (:id, :name)") void insertUsers(@BindBean User... users);
@SqlBatch("insert into table (a) values (:a)") int getNames(@Bind("a") String a); }
@SqlBatch void insertBunches(@BindBean Something... somethings); }
@SqlBatch("insert into something(name) values (:name)") @GetGeneratedKeys({"id", "created_on"}) @UseRowMapper(IdCreateTimeMapper.class) List<IdCreateTime> insertBatch(String... name); }
@SqlBatch("insert into something (name) values (:name)") @GetGeneratedKeys("id") int[] insert(@Bind("name") List<String> names);
@SqlBatch("insert into something(name) values (:name)") @GetGeneratedKeys({"id", "created_on"}) @RegisterRowMapper(IdCreateTimeMapper.class) List<IdCreateTime> insertBatch(String... name); }
@SqlBatch("insert into something (name) values (:name)") @GetGeneratedKeys List<Something> insertVarargs(@Bind("name") String... names); }
@SqlBatch("insert into something (name) values (:name)") @GetGeneratedKeys long[] insertNames(@Bind("name") String... names);
@SqlBatch("insert into something (name) values (:name)") @GetGeneratedKeys Something[] insertNamesToBean(@Bind("name") Iterable<String> names);
@SqlBatch("insert into something (id, name) values (:it.id, :it.name)") @BatchChunkSize(2) int[] insertChunked(@BindBean("it") Iterable<Something> its);
@SqlBatch("insert into something (id, name) values (:id, :first || ' ' || :last)") void insertFamily(@Bind("id") List<Integer> ids, @Bind("first") Iterator<String> firstNames, @Bind("last") String lastName);
@SqlBatch("insert into something (id, name) values (:id, :name)") @BatchChunkSize(2) void insertBatch(@Bind("id") List<Integer> ids, @Bind("name") List<String> names);
@SqlBatch("insert into something (id, name) values (:id, :first || ' ' || :last)") @BatchChunkSize(2) void insertFamily(@Bind("id") List<Integer> ids, @Bind("first") Iterator<String> firstNames, @Bind("last") String lastName);