去掉SQL代码中回车换行和多余空格

sql.replace(’\r’, ’ ‘).replace(’\n’, ’ ').replaceAll( " {2,}", " ");
注：sql为需要还原的sql字符串

sql = "SELECT\n" +
                "    count(1) as countNum,\n" +
                "    a.ID,\n" +
                "    a.account,\n" +
                "    a.password,\n" +
                "    a.status,\n" +
                "    b.role_id\n" +
                "FROM\n" +
                "    t_bs_users a\n" +
                "    LEFT JOIN (\n" +
                "        SELECT\n" +
                "            role_id,\n" +
                "            user_id\n" +
                "        FROM\n" +
                "            t_bs_role_user\n" +
                "    ) b ON a.id = b.user_id\n" +
                "WHERE\n" +
                "    status = 0\n" +
                "    AND type >= 0\n" +
                "    AND password LIKE CONCAT('*6', '%')\n" +
                "GROUP BY\n" +
                "    id\n" +
                "ORDER BY\n" +
                "    CreateTime DESC";
//还原格式化的sql
 String formatsql = sql.replace('\r', ' ').replace('\n', ' ').replaceAll( " {2,}", " ");