org.skife.jdbi.v2.Update.define()方法的使用及代码示例

x33g5p2x  于2022-02-01 转载在 其他  
字(3.7k)|赞(0)|评价(0)|浏览(80)

本文整理了Java中org.skife.jdbi.v2.Update.define()方法的一些代码示例,展示了Update.define()的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台,是从一些精选项目中提取出来的代码,具有较强的参考意义,能在一定程度帮忙到你。Update.define()方法的具体详情如下:
包路径:org.skife.jdbi.v2.Update
类名称:Update
方法名:define

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();

相关文章