本文整理了Java中com.j256.ormlite.stmt.QueryBuilder.reset方法的一些代码示例，展示了QueryBuilder.reset的具体用法。这些代码示例主要来源于Github/Stackoverflow/Maven等平台，是从一些精选项目中提取出来的代码，具有较强的参考意义，能在一定程度帮忙到你。QueryBuilder.reset方法的具体详情如下：
包路径：com.j256.ormlite.stmt.QueryBuilder
类名称：QueryBuilder
方法名：reset

QueryBuilder.reset介绍

暂无

代码示例

代码示例来源：origin: j256/ormlite-core

@Test
public void testUtf8() throws Exception {
  Dao<Foo, Integer> dao = createDao(Foo.class, true);
  Foo foo = new Foo();
  foo.stringField = "اعصاب";
  assertEquals(1, dao.create(foo));
  QueryBuilder<Foo, Integer> qb = dao.queryBuilder();
  List<Foo> results = qb.where().like(Foo.STRING_COLUMN_NAME, '%' + foo.stringField + '%').query();
  assertNotNull(results);
  assertEquals(1, results.size());
  assertEquals(foo.id, results.get(0).id);
  assertEquals(foo.stringField, results.get(0).stringField);
  qb.reset();
  results = qb.where().like(Foo.STRING_COLUMN_NAME, new SelectArg('%' + foo.stringField + '%')).query();
  assertNotNull(results);
  assertEquals(1, results.size());
  assertEquals(foo.id, results.get(0).id);
  assertEquals(foo.stringField, results.get(0).stringField);
}

代码示例来源：origin: j256/ormlite-core

@Test
public void testClear() throws Exception {
  Dao<Foo, String> dao = createDao(Foo.class, false);
  QueryBuilder<Foo, String> qb = dao.queryBuilder();
  qb.selectColumns(Foo.VAL_COLUMN_NAME);
  qb.groupBy(Foo.VAL_COLUMN_NAME);
  qb.having("COUNT(VAL) > 1");
  qb.where().eq(Foo.ID_COLUMN_NAME, 1);
  qb.reset();
  assertEquals("SELECT * FROM `foo` ", qb.prepareStatementString());
}

代码示例来源：origin: j256/ormlite-core

@Test
public void testLeftJoinTwoColumns() throws Exception {
  Dao<Foo, Integer> fooDao = createDao(Foo.class, true);
  Dao<StringColumnArg, Integer> scaDao = createDao(StringColumnArg.class, true);
  Foo foo1 = new Foo();
  foo1.val = 123213213;
  foo1.stringField = "stuff";
  fooDao.create(foo1);
  StringColumnArg sca1 = new StringColumnArg();
  sca1.str1 = foo1.stringField;
  scaDao.create(sca1);
  StringColumnArg sca2 = new StringColumnArg();
  sca2.str1 = "something eles";
  scaDao.create(sca2);
  QueryBuilder<Foo, Integer> fooQb = fooDao.queryBuilder();
  QueryBuilder<StringColumnArg, Integer> scaQb = scaDao.queryBuilder();
  scaQb.join(StringColumnArg.STR1_FIELD, Foo.STRING_COLUMN_NAME, fooQb);
  List<StringColumnArg> results = scaQb.query();
  assertNotNull(results);
  assertEquals(1, results.size());
  assertEquals(sca1.id, results.get(0).id);
  scaQb.reset();
  scaQb.join(StringColumnArg.STR1_FIELD, Foo.STRING_COLUMN_NAME, fooQb, JoinType.LEFT, JoinWhereOperation.AND);
  results = scaQb.query();
  assertNotNull(results);
  assertEquals(2, results.size());
  assertEquals(sca1.id, results.get(0).id);
  assertEquals(sca2.id, results.get(1).id);
}

代码示例来源：origin: j256/ormlite-core

@Test
public void testJoinOrder() throws Exception {
  Dao<Bar, Integer> barDao = createDao(Bar.class, true);
  Dao<Baz, Integer> bazDao = createDao(Baz.class, true);
  Bar bar1 = new Bar();
  bar1.val = 2234;
  assertEquals(1, barDao.create(bar1));
  Bar bar2 = new Bar();
  bar2.val = 324322234;
  assertEquals(1, barDao.create(bar2));
  Baz baz1 = new Baz();
  baz1.bar = bar1;
  assertEquals(1, bazDao.create(baz1));
  Baz baz2 = new Baz();
  baz2.bar = bar2;
  assertEquals(1, bazDao.create(baz2));
  QueryBuilder<Bar, Integer> barQb = barDao.queryBuilder();
  barQb.orderBy(Bar.VAL_FIELD, true);
  List<Baz> results = bazDao.queryBuilder().join(barQb).query();
  assertEquals(2, results.size());
  assertEquals(bar1.id, results.get(0).bar.id);
  assertEquals(bar2.id, results.get(1).bar.id);
  // reset the query to change the order direction
  barQb.reset();
  barQb.orderBy(Bar.VAL_FIELD, false);
  results = bazDao.queryBuilder().join(barQb).query();
  assertEquals(2, results.size());
  assertEquals(bar2.id, results.get(0).bar.id);
  assertEquals(bar1.id, results.get(1).bar.id);
}

代码示例来源：origin: j256/ormlite-core

assertEquals(sca1.id, results.get(0).id);
fooQb.reset();
fooQb.where().eq(Foo.VAL_COLUMN_NAME, foo2.val);
scaQb.reset();
scaQb.join(StringColumnArg.STR1_FIELD, Foo.STRING_COLUMN_NAME, fooQb);
results = scaQb.query();

代码示例来源：origin: j256/ormlite-core

assertEquals(bar2.id, results.get(1).bar.id);
bazQb.reset();
bazQb.where().eq(Baz.VAL_FIELD, baz2.val);
results = bazQb.join(barQb, JoinType.INNER, JoinWhereOperation.OR).query();
bazQb.reset();
bazQb.where().eq(Baz.VAL_FIELD, baz2.val);
results = bazQb.join(barQb).query();

代码示例来源：origin: com.j256.ormlite/ormlite-jdbc

@Test
public void testJoinOrder() throws Exception {
  Dao<Bar, Integer> barDao = createDao(Bar.class, true);
  Dao<Baz, Integer> bazDao = createDao(Baz.class, true);
  Bar bar1 = new Bar();
  bar1.val = 2234;
  assertEquals(1, barDao.create(bar1));
  Bar bar2 = new Bar();
  bar2.val = 324322234;
  assertEquals(1, barDao.create(bar2));
  Baz baz1 = new Baz();
  baz1.bar = bar1;
  assertEquals(1, bazDao.create(baz1));
  Baz baz2 = new Baz();
  baz2.bar = bar2;
  assertEquals(1, bazDao.create(baz2));
  QueryBuilder<Bar, Integer> barQb = barDao.queryBuilder();
  barQb.orderBy(Bar.VAL_FIELD, true);
  List<Baz> results = bazDao.queryBuilder().join(barQb).query();
  assertEquals(2, results.size());
  assertEquals(bar1.id, results.get(0).bar.id);
  assertEquals(bar2.id, results.get(1).bar.id);
  // reset the query to change the order direction
  barQb.reset();
  barQb.orderBy(Bar.VAL_FIELD, false);
  results = bazDao.queryBuilder().join(barQb).query();
  assertEquals(2, results.size());
  assertEquals(bar2.id, results.get(0).bar.id);
  assertEquals(bar1.id, results.get(1).bar.id);
}