【你不知道的Java】-【用ue 格式化sql 供StringBuffer 使用 】

一：原sql语句

select *
  from (select Info_Id,
               Title,
               image_file,
               url_link,
               create_Timestamp,
               editor,
               category_id,
               is_review,
               row_number() over(partition by category_id order by create_timestamp desc) rn
          from tb_info_images
         where is_Review = 1
           and info_id in
               (select info_id
                  from tb_info_Published
                 where system_id = 2101
                   and category_id in (select category_id
                                         from tb_info_category
                                        where type = 1))
        
        )
 where rn = 1

二：打开ue

CRTL+R

替换后：

CRT+R

结果：

三：修改下，最终结果

sb.append("select *");
sb.append("  from (select Info_Id,");
sb.append("               Title,");
sb.append("               image_file,");
sb.append("               url_link,");
sb.append("               create_Timestamp,");
sb.append("               editor,");
sb.append("               category_id,");
sb.append("               is_review,");
sb.append("               row_number() over(partition by category_id order by create_timestamp desc) rn");
sb.append("          from tb_info_images");
sb.append("         where is_Review = 1");
sb.append("           and info_id in");
sb.append("               (select info_id");
sb.append("                  from tb_info_Published");
sb.append("                 where system_id = 2101");
sb.append("                   and category_id in (select category_id");
sb.append("                                         from tb_info_category");
sb.append("                                        where type = 1))");
sb.append("        ");
sb.append("        )");
sb.append(" where rn = 1");