Examples of org.nutz.dao.Condition.toSql()

org.nutz.dao.Condition.toSql()
根据一个实体，你可以生成一个条件，这个条件就是 SQL 'WHERE' 关键字后面的那部分。
当然你返回的字符串如果不是以 WHERE 或者 ORDER BY 开头，将会被 Nutz.Dao 加上 WHERE。
你的字符串前后的空白会被截除 @param entity 实体 @return 条件字符串

  public void test_segment() {
    Map<String, Object> map = new HashMap<String, Object>();
    map.put("name", "比尔盖茨");
    map.put("age", 50);
    Condition c1 = Cnd.wrap("name='${name}' AND age>${age}", map);
    assertEquals("name='比尔盖茨' AND age>50", c1.toSql(en));
    
    Worker worker = new Worker();
    worker.name = "老板";
    worker.age = 30;
    Condition c2 = Cnd.wrap("name like'${name}%' AND age>${age}", worker);

View Full Code Here

    
    Worker worker = new Worker();
    worker.name = "老板";
    worker.age = 30;
    Condition c2 = Cnd.wrap("name like'${name}%' AND age>${age}", worker);
    assertEquals("name like'老板%' AND age>30", c2.toSql(en));
  }


  @Test
  public void test_gt_like() {
    Condition c = Cnd.where("id", ">", 45).and("name", "LIKE", "%ry%");

View Full Code Here


  @Test
  public void test_gt_like() {
    Condition c = Cnd.where("id", ">", 45).and("name", "LIKE", "%ry%");
    String exp = "WHERE wid>45 AND wname LIKE '%ry%'";
    assertEquals(exp, c.toSql(en).trim());
  }


  @Test
  public void test_bracket() {
    Condition c = Cnd.where(Cnd.exps("id", ">", 45)).and("name", "LIKE", "%ry%");

View Full Code Here


  @Test
  public void test_bracket() {
    Condition c = Cnd.where(Cnd.exps("id", ">", 45)).and("name", "LIKE", "%ry%");
    String exp = "WHERE (wid>45) AND wname LIKE '%ry%'";
    assertEquals(exp, c.toSql(en).trim());
  }


  @Test
  public void test_order() {
    Condition c = Cnd.orderBy().asc("id").desc("name").asc("age").desc("workingDay");

View Full Code Here


  @Test
  public void test_order() {
    Condition c = Cnd.orderBy().asc("id").desc("name").asc("age").desc("workingDay");
    String exp = "ORDER BY wid ASC, wname DESC, age ASC, days DESC";
    assertEquals(exp, c.toSql(en).trim());
  }


  @Test
  public void test_like_in() {
    int[] ages = {4, 7, 9};

View Full Code Here

    int[] ages = {4, 7, 9};
    SqlExpression e = Cnd.exps("age", ">", 35).and("id", "<", 47);
    SqlExpression e2 = Cnd.exps("name", "\tLIKE ", "%t%").and("age", "IN  \n\r", ages).or(e);
    Condition c = Cnd.where("id", "=", 37).and(e).or(e2).asc("age").desc("id");
    String exp = "WHERE wid=37 AND (age>35 AND wid<47) OR (wname LIKE '%t%' AND age IN (4,7,9) OR (age>35 AND wid<47)) ORDER BY age ASC, wid DESC";
    assertEquals(exp, c.toSql(en).trim());
  }


  @Test
  public void test_equel() {
    Condition c = Cnd.where("ff", "=", true);

View Full Code Here


  @Test
  public void test_equel() {
    Condition c = Cnd.where("ff", "=", true);
    String exp = "WHERE ff=true";
    assertEquals(exp, c.toSql(en).trim());
  }


  @Test
  public void test_in_by_int_array() {
    int[] ids = {3, 5, 7};

View Full Code Here

  @Test
  public void test_in_by_int_array() {
    int[] ids = {3, 5, 7};
    Condition c = Cnd.where("id", "iN", ids);
    String exp = "WHERE id IN (3,5,7)";
    assertEquals(exp, c.toSql(null).trim());
  }


  @Test
  public void test_in_by_int_list() {
    List<Integer> list = new ArrayList<Integer>();

View Full Code Here

    list.add(3);
    list.add(5);
    list.add(7);
    Condition c = Cnd.where("id", "iN", list);
    String exp = "WHERE id IN (3,5,7)";
    assertEquals(exp, c.toSql(null).trim());
  }


  @Test
  public void test_in_by_str_array() {
    Condition c = Cnd.where("nm", "iN", Lang.array("'A'", "B"));

View Full Code Here


  @Test
  public void test_in_by_str_array() {
    Condition c = Cnd.where("nm", "iN", Lang.array("'A'", "B"));
    String exp = "WHERE nm IN ('''A''','B')";
    assertEquals(exp, c.toSql(null).trim());
  }


  @Test
  public void test_in_by_str_list() {
    List<String> list = new ArrayList<String>();

View Full Code Here

0 1 2 3 4

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.