Sql文整理小函数

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

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

0 ·

CC 4.0 BY-SA版权

文章标签：

#sql #join #string

JAVA 专栏收录该内容

34 篇文章

订阅专栏

本文介绍了一个简单的Java方法，用于格式化SQL查询语句，通过将关键字转换为大写并进行适当的换行，使SQL语句更易读。该方法特别关注了如'AND'、'ON'、'INNER JOIN'等常见SQL关键字。

    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 ;
    }