Cnd 如何直接加Orderby？

Cnd where=Cnd.New();
where.and(new Static(" order by id" );

wendal

1楼•2734天前

Cnd.orderBy()

zhangjianshe

2楼•2734天前

我想要添加一个ordeby的字符串

wendal

3楼•2734天前

想生成怎样的sql？

zhangjianshe

4楼•2734天前

select * from ABC order by ID asc,NAME desc ,其中 order by ID asc,NAME desc 是一个字符串

wendal

5楼•2734天前

。。。为毛(*￣m￣)要这样。。。

用1=1吧

wendal

6楼•2734天前

不会是前端页面拼好传过来的吧？

zhangjianshe

7楼•2734天前

 if (!Strings.isBlank(req.orderSql)) {
      if (req.filters.size() == 0) {
        where.and("1", "=", "1");
        where.and(new Static(" order by " + req.orderSql));
      } else {
        where.and(new Static(" order by " + req.orderSql));
      }
    } else {

    }

错误 'SELECT * FROM ADMIN_USER WHERE 1=? AND order by EXTRA_ID asc LIMIT 5, 5 '

wendal

8楼•2734天前

Cnd where=Cnd.where.(new Static("1=1 order by id") );

但你从请求直接取值拼入sql，不怕注入？

zhangjianshe

9楼•2734天前

试一试

请先登陆