Sql文整理小函数

gohands

于 2008-01-18 13:35:00 发布

阅读量612

点赞数

分类专栏： JAVA 文章标签： sql join string

本文链接：https://blog.youkuaiyun.com/gohands/article/details/2051260

版权

JAVA 专栏收录该内容

34 篇文章

订阅专栏

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

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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