Sql文整理小函数

最新推荐文章于 2025-10-01 18:05:18 发布

最新推荐文章于 2025-10-01 18:05:18 发布 · 110 阅读

文章标签：

#SQL

数据库专栏收录该内容

9 篇文章

订阅专栏

private void showSql(String strIn)
    {
    String strOut = "";
    strOut = strIn.toUpperCase();
    strOut = strOut.replaceAll(" and ","\n\t and ");
    strOut = strOut.replaceAll(" on ","\n\t on ");
    strOut = strOut.replaceAll(" inner join ","\n inner join ");
    strOut = strOut.replaceAll(" left outer join ","\n left outer join ");
    strOut = strOut.replaceAll(" left join ","\n left join ");

    strOut = strOut.replaceAll(" AND ","\n\t AND ");
    strOut = strOut.replaceAll(" ON ","\n\t on ");
    strOut = strOut.replaceAll(" INNER JOIN ","\n inner join ");
    strOut = strOut.replaceAll(" LEFT OUTER JOIN ","\n left outer join ");
    strOut = strOut.replaceAll(" LEFT JOIN ","\n left join ");
    System.out.println(strOut);
    return ;
    }