anyele
V2EX  ›  问与答

求助, mybatis plus 的 LambdaQueryWrapperX 后面加一个 ORDER BY 该怎么写?

  •  
  •   anyele · Jul 11, 2024 · 575 views
    This topic created in 700 days ago, the information mentioned may be changed or developed.
    想用 LambdaQueryWrapperX 加一个 ORDER BY 实现如下 SQL 来排序, 但不知道怎么写

    ORDER BY CASE WHEN img = 'http://www.xx.logo.jpg' THEN 2 ELSE 1 END, img ;

    问了 AI, 给我生成了一段幻觉答案
    LambdaQueryWrapperX<XX> queryWrapper = new LambdaQueryWrapperX<XX>()
    .orderBy(
    // 使用 when 方法构建 CASE WHEN 表达式
    when(Bn::getImg, "http://www.xx.logo.jpg").then(2).otherwise(1),
    Bn::getImg
    );
    List<bn> list = yourService.list(queryWrapper);
    No Comments Yet
    About   ·   Help   ·   Advertise   ·   Blog   ·   API   ·   FAQ   ·   Solana   ·   4264 Online   Highest 6679   ·     Select Language
    创意工作者们的社区
    World is powered by solitude
    VERSION: 3.9.8.5 · 41ms · UTC 05:21 · PVG 13:21 · LAX 22:21 · JFK 01:21
    ♥ Do have faith in what you're doing.