Sql文整理小函数

webdev2008

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

阅读量93

点赞数

分类专栏：数据库文章标签： 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 ;
    }