Formats sql for reading. - Java JDBC

Java examples for JDBC:SQL Statement

  1. HOME
  2. Java
  3. JDBC
  4. SQL Statement

Description

Formats sql for reading.

Demo Code

/*/*from  w  w w  .  j  av  a2s  .  com*/
 Copyright (C) 2003 EBI, GRL

 This library is free software; you can redistribute it and/or
 modify it under the terms of the GNU Lesser General Public
 License as published by the Free Software Foundation; either
 version 2.1 of the License, or (at your option) any later version.

 This library is distributed in the hope that it will be useful,
 but WITHOUT ANY WARRANTY; without even the implied warranty of
 MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the GNU
 Lesser General Public License for more details.

 You should have received a copy of the GNU Lesser General Public
 License along with this library; if not, write to the Free Software
 Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA  02111-1307  USA
 */
//package com.java2s;

import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

import java.util.StringTokenizer;

public class Main {
    /**
     * Formats sql for reading.
     */
    public static String beautifySQL(String rawSQL) {

        StringBuffer buf = new StringBuffer();

        int indent = 0;
        StringTokenizer tokens = new StringTokenizer(rawSQL);
        while (tokens.hasMoreTokens()) {
            String token = tokens.nextToken();
            String lowerCaseToken = token.toLowerCase();
            if (lowerCaseToken.equals("select")
                    || lowerCaseToken.equals("where")
                    || lowerCaseToken.equals("from")
                    || lowerCaseToken.equals("group")
                    || lowerCaseToken.equals("order")
                    || lowerCaseToken.equals("having"))
                buf.append("\n\n").append(token).append("\n").append("  ");
            else
                buf.append(' ').append(token);
        }

        return buf.toString();
    }

    /**
     * @return String containing each column in current row of result set.
     */
    public static String toString(ResultSet rs) {

        StringBuffer buf = new StringBuffer();
        buf.append("[");
        try {
            ResultSetMetaData metaData = rs.getMetaData();
            int nColumns = metaData.getColumnCount();
            for (int i = 1; i <= nColumns; ++i) {
                buf.append(metaData.getColumnName(i));
                buf.append(" = ");
                buf.append(rs.getString(i));
                if (i < nColumns)
                    buf.append(" , ");
            }
        } catch (SQLException e) {
            buf.append(e.getMessage());
            e.printStackTrace();
        }
        buf.append("]");

        return buf.toString();
    }
}

Related Tutorials