本文整理汇总了Java中org.jdbi.v3.core.Jdbi.open方法的典型用法代码示例。如果您正苦于以下问题:Java Jdbi.open方法的具体用法?Java Jdbi.open怎么用?Java Jdbi.open使用的例子?那么恭喜您, 这里精选的方法代码示例或许可以为您提供帮助。您也可以进一步了解该方法所在类org.jdbi.v3.core.Jdbi
的用法示例。
在下文中一共展示了Jdbi.open方法的6个代码示例,这些例子默认根据受欢迎程度排序。您可以为喜欢或者感觉有用的代码点赞,您的评价将有助于系统推荐出更棒的Java代码示例。
示例1: test
import org.jdbi.v3.core.Jdbi; //导入方法依赖的package包/类
@Test
public void test() throws Exception {
Jdbi jdbi = Jdbi.create(ds.getDataSource());
try (Handle h = jdbi.open()) {
h.execute("create table contacts (id int primary key, name varchar(100))");
h.execute("insert into contacts (id, name) values (?, ?)", 1, "Alice");
h.execute("insert into contacts (id, name) values (?, ?)", 2, "Bob");
List<String> names = h.createQuery("select name from contacts order by id")
.mapTo(String.class)
.list();
assertThat(names)
.containsExactly("Alice", "Bob");
String name = h.createQuery("select name from contacts where id = :id")
.bind("id", 1)
.mapTo(String.class)
.findOnly();
assertThat(name)
.isEqualTo("Alice");
}
}
示例2: classBlock
import org.jdbi.v3.core.Jdbi; //导入方法依赖的package包/类
@Override
protected Statement classBlock(RunNotifier notifier) {
final Statement statement = super.classBlock(notifier);
return new Statement() {
@Override
public void evaluate() throws Throwable {
// Open a new handle for every test
// It affords to avoid creating a static state which makes tests more independent
JditProperties jditProperties = klass.getAnnotation(JditProperties.class);
Jdbi dbi = jditProperties != null ? DBIContextFactory.getDBI(jditProperties.value()) : DBIContextFactory.getDBI();
try (Handle handle = dbi.open()) {
injector = new TestObjectsInjector(dbi, handle);
databaseMaintenance = DatabaseMaintenanceFactory.create(handle);
dataSetInjector = new DataSetInjector(new DataMigration(handle));
statement.evaluate();
}
}
};
}
示例3: test
import org.jdbi.v3.core.Jdbi; //导入方法依赖的package包/类
@Test
public void test() throws Exception {
Jdbi jdbi = Jdbi.create(ds.getDataSource());
jdbi.registerRowMapper(BeanMapper.factory(Account.class));
jdbi.registerColumnMapper(new MoneyMapper());
jdbi.registerArgument(new MoneyArgumentFactory());
try (Handle h = jdbi.open()) {
Money tenDollars = Money.of(USD, 10);
Money fiveDollars = Money.of(USD, 5);
h.execute("create table accounts (id int primary key, name varchar(100), balance decimal)");
h.execute("insert into accounts (id, name, balance) values (?, ?, ?)", 1, "Alice", tenDollars);
h.execute("insert into accounts (id, name, balance) values (?, ?, ?)", 2, "Bob", fiveDollars);
List<Account> list = h.createQuery("select * from accounts order by id")
.mapTo(Account.class)
.list();
assertThat(list)
.extracting(Account::getId, Account::getName, Account::getBalance)
.containsExactly(tuple(1, "Alice", tenDollars),
tuple(2, "Bob", fiveDollars));
Account bob = h.createQuery("select * from accounts where id = :id")
.bind("id", 2)
.mapTo(Account.class)
.findOnly();
assertThat(bob)
.extracting(Account::getId, Account::getName, Account::getBalance)
.containsExactly(2, "Bob", fiveDollars);
}
}
示例4: test
import org.jdbi.v3.core.Jdbi; //导入方法依赖的package包/类
@Test
public void test() throws Exception {
Jdbi jdbi = Jdbi.create(ds.getDataSource());
try (Handle h = jdbi.open()) {
h.execute("create table contacts (id int primary key, name varchar(100))");
h.execute("insert into contacts (id, name) values (?, ?)", 1, "Alice");
h.execute("insert into contacts (id, name) values (?, ?)", 2, "Bob");
List<Contact> list = h.createQuery("select * from contacts order by id")
.map(new ContactMapper())
.list();
assertThat(list)
.extracting(Contact::getId, Contact::getName)
.containsExactly(tuple(1, "Alice"),
tuple(2, "Bob"));
Contact bob = h.createQuery("select * from contacts where id = :id")
.bind("id", 2)
.map(new ContactMapper())
.findOnly();
assertThat(bob)
.extracting(Contact::getId, Contact::getName)
.containsExactly(2, "Bob");
}
}
示例5: test
import org.jdbi.v3.core.Jdbi; //导入方法依赖的package包/类
@Test
public void test() throws Exception {
Jdbi jdbi = Jdbi.create(ds.getDataSource());
jdbi.registerRowMapper(new ContactMapper());
try (Handle h = jdbi.open()) {
h.execute("create table contacts (id int primary key, name varchar(100))");
h.execute("insert into contacts (id, name) values (?, ?)", 1, "Alice");
h.execute("insert into contacts (id, name) values (?, ?)", 2, "Bob");
List<Contact> list = h.createQuery("select * from contacts order by id")
.mapTo(Contact.class)
.list();
assertThat(list)
.extracting(Contact::getId, Contact::getName)
.containsExactly(tuple(1, "Alice"),
tuple(2, "Bob"));
Contact bob = h.createQuery("select * from contacts where id = :id")
.bind("id", 2)
.mapTo(Contact.class)
.findOnly();
assertThat(bob)
.extracting(Contact::getId, Contact::getName)
.containsExactly(2, "Bob");
}
}
示例6: testMapToDbObject
import org.jdbi.v3.core.Jdbi; //导入方法依赖的package包/类
@Test
public void testMapToDbObject() throws Exception {
Jdbi dbi = Jdbi.create(DbHelper.getHsqlDataSource());
dbi.installPlugins();
Handle handle = dbi.open();
try {
DbObject dbObject = handle.createQuery(DbHelper.TEST_DB_OBJECT_QUERY).mapTo(DbObject.class).findFirst().get();
DbHelper.assertDbObjectMapping(dbObject);
} finally {
handle.close();
}
}