コード例 #1
0
  public void testMapAndObjectHolder() {
    // 清晰的sql语句,/~ ~/为一个语法块
    String sql =
        "select * from user where 1=1 "
            + "/~ and title = {title} ~/"
            + "/~ and sex = {sex} ~/"
            + "/~ and salary = {salary} ~/"
            + "/~ and age = [age] ~/"
            + "/~ and mapKey = [mapKey] ~/";

    // filters为参数
    BlogInfo info = new BlogInfo();
    info.setTitle("java");
    Map hashMap = new HashMap();
    hashMap.put("mapKey", "2009_mapKey");

    XsqlFilterResult result = new XsqlBuilder().generateHql(sql, hashMap, info);

    assertEquals(
        "select * from user where 1=1  and title = :title  and sex = :sex  and age = 0  and mapKey = 2009_mapKey ",
        result.getXsql());
    assertTrue(result.getAcceptedFilters().containsKey("sex"));
    assertTrue(result.getAcceptedFilters().containsKey("title"));
    assertFalse(result.getAcceptedFilters().containsKey("age"));
  }
コード例 #2
0
  public void testBean() {
    // 清晰的sql语句,/~ ~/为一个语法块
    String sql =
        "select * from user where 1=1 "
            + "/~ and title = {title} ~/"
            + "/~ and sex = {sex} ~/"
            + "/~ and salary = {salary} ~/"
            + "/~ and age = [age] ~/";

    // filters为参数
    BlogInfo info = new BlogInfo();
    info.setTitle("java");
    XsqlFilterResult result = new XsqlBuilder().generateHql(sql, info);

    assertEquals(
        "select * from user where 1=1  and title = :title  and sex = :sex  and age = 0 ",
        result.getXsql());
    assertTrue(result.getAcceptedFilters().containsKey("sex"));
    assertTrue(result.getAcceptedFilters().containsKey("title"));
    assertFalse(result.getAcceptedFilters().containsKey("age"));
  }