Examples of com.google.code.hs4j.IndexSession.find()

com.google.code.hs4j.IndexSession.find()
Getting data from mysql, use filter @param keys keys to compare with index columns @param operator specifies the comparison operation to use @param limit limit fetch count @param offset fetch offset @param filters specifies a filter @return @throws InterruptedException @throws TimeoutException @throws HandlerSocketException

    sum = 100;
    for (i = 0; i < sum; i++) {
      result=stmt.incr(keys, FindOperator.EQ);
      assertTrue(result == 1);
    }
    rs = session.find(keys);
    while(rs.next()){
      System.out.println("increment age is: "+rs.getInt("age"));
      assertEquals(107, rs.getInt("age"));
    }
    // decrement 100

View Full Code Here

    sum = 100;
    for (i = 0; i < sum; i++) {
      result=stmt.decr(keys, FindOperator.EQ);
      assertTrue(result == 1);
    }
    rs = session.find(keys);
    while(rs.next()){
      System.out.println("decrement age is: "+rs.getInt("age"));
      assertEquals(7, rs.getInt("age"));
    }
    assertEquals(1, session.delete( keys, FindOperator.EQ));

View Full Code Here

        stmt
            .executeUpdate("insert into test_user values(0,'dennis','test@163.com','27','2010-11-28 13:24:00')"));


    final String[] keys = { "dennis", "test@163.com" };
    Filter[] filters ={new Filter(FilterType.FILTER,FindOperator.EQ, 0, "27")};
    ResultSet rs = session.find(keys,FindOperator.EQ,1,0,filters);
    assertTrue(rs.next());


    System.out.println(rs.getInt(1));
    assertEquals("dennis", rs.getString(2));
    assertEquals("test@163.com", rs.getString(3));

View Full Code Here

    assertEquals("test@163.com", rs.getString(3));
    assertEquals(27, rs.getInt(4));
    assertFalse(rs.next());


    filters = new Filter[]{new Filter(FilterType.FILTER,FindOperator.GT, 0, "27")};
    rs = session.find(keys,FindOperator.EQ,1,0,filters);
    assertFalse(rs.next());    
  }


}

View Full Code Here

TOP

All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.