【你不知道的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");