本文整理了Java中org.skife.jdbi.v2.Update.define()
方法的一些代码示例,展示了Update.define()
的具体用法。这些代码示例主要来源于Github
/Stackoverflow
/Maven
等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Update.define()
方法的具体详情如下:
包路径:org.skife.jdbi.v2.Update
类名称:Update
方法名:define
暂无
代码示例来源:origin: io.kazuki/kazuki-db
public static Update getBoundStatement(Handle handle, String dbPrefix, String tableParameterName,
String tableName, String queryName) {
return handle.createStatement(dbPrefix + queryName).define(tableParameterName, tableName);
}
代码示例来源:origin: io.kazuki/kazuki-db
@Override
public Boolean inTransaction(Handle handle, TransactionStatus arg1) throws Exception {
try {
handle.createStatement(prefix + "table_exists").define("table_name", tableName).execute();
return true;
} catch (UnableToExecuteStatementException e) {
// expected in missing case
} catch (UnableToCreateStatementException e) {
// expected in missing case
}
return false;
}
});
代码示例来源:origin: org.kill-bill.commons/killbill-jdbi
@Override
public Object withHandle(final Handle h) throws Exception {
h.createStatement("create table <name> (id int primary key, name text)")
.define("name", "something")
.execute();
h.execute("insert into something (id, name) values (3, 'Carlos')");
return null;
}
});
代码示例来源:origin: com.nesscomputing.migratory/migratory-core
@Override
public Integer withHandle(final Handle handle) throws SQLException {
final SqlScript cleanScript = migratoryContext.getDbSupport().createCleanScript(handle);
setSchema(migratoryContext.getDbSupport().getCurrentSchema(handle));
for (SqlStatement sqlStatement : cleanScript.getSqlStatements()) {
try {
if (!MigratoryOption.containsOption(MigratoryOption.DRY_RUN, options)) {
handle.createStatement(sqlStatement.getSql())
.define(sqlStatement.getDefines())
.execute();
}
}
catch (DBIException e) {
LOG.warn("While executing {}", sqlStatement, e);
}
}
return 0;
}
});
代码示例来源:origin: org.kill-bill.commons/killbill-jdbi
@Override
public Object withHandle(final Handle h) throws Exception {
h.execute("createSomething");
h.createStatement("insert")
.define("table", "something")
.bind("id", 1)
.bind("name", "Ven")
.execute();
final Something s = h.createQuery("findById")
.bind("id", 1)
.map(new ResultSetMapper<Something>() {
@Override
public Something map(final int index, final ResultSet r, final StatementContext ctx) throws SQLException {
return new Something(r.getInt("id"), r.getString("name"));
}
})
.first();
assertThat(s).isEqualTo(new Something(1, "Ven"));
return null;
}
});
代码示例来源:origin: org.jdbi/jdbi
@Test
public void testFoo() throws Exception
{
Handle h = openHandle();
h.setStatementLocator(new StatementLocator() {
@Override
public String locate(String name, StatementContext ctx) throws Exception
{
return name.replaceAll("<table>", String.valueOf(ctx.getAttribute("table")));
}
});
final int inserted = h.createStatement("insert into <table> (id, name) values (:id, :name)")
.bind("id", 7)
.bind("name", "Martin")
.define("table", "something")
.execute();
assertEquals(1, inserted);
}
}
代码示例来源:origin: org.kill-bill.commons/killbill-jdbi
@Test
public void testFoo() throws Exception
{
Handle h = openHandle();
h.setStatementLocator(new StatementLocator() {
@Override
public String locate(String name, StatementContext ctx) throws Exception
{
return name.replaceAll("<table>", String.valueOf(ctx.getAttribute("table")));
}
});
final int inserted = h.createStatement("insert into <table> (id, name) values (:id, :name)")
.bind("id", 7)
.bind("name", "Martin")
.define("table", "something")
.execute();
assertEquals(1, inserted);
}
}
代码示例来源:origin: org.kill-bill.commons/killbill-jdbi
.define("name", "something")
.execute();
内容来源于网络,如有侵权,请联系作者删除!