Java SQL ResultSet writeResultSetToFile(String path, ResultSet results)

Description

write Result Set To File

License

Apache License

Declaration

public static void writeResultSetToFile(String path, ResultSet results) throws SQLException 

Method Source Code

//package com.java2s;
/*//from ww  w  .jav a2s . c om
 * Copyright 2017 ThoughtWorks, Inc.
 *
 * Licensed under the Apache License, Version 2.0 (the "License");
 * you may not use this file except in compliance with the License.
 * You may obtain a copy of the License at
 *
 *     http://www.apache.org/licenses/LICENSE-2.0
 *
 * Unless required by applicable law or agreed to in writing, software
 * distributed under the License is distributed on an "AS IS" BASIS,
 * WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
 * See the License for the specific language governing permissions and
 * limitations under the License.
 */

import java.io.BufferedWriter;
import java.io.IOException;
import java.nio.file.Files;
import java.nio.file.Paths;
import java.nio.file.StandardOpenOption;
import java.sql.*;

public class Main {
    public static void writeResultSetToFile(String path, ResultSet results) throws SQLException {
        ResultSetMetaData metaData = results.getMetaData();

        int columnCount = metaData.getColumnCount();

        try {
            BufferedWriter bw = Files.newBufferedWriter(Paths.get(path), StandardOpenOption.CREATE);

            bw.write("**************** SQL DEBUG ****************\n");
            bw.write("*******************************************\n");
            bw.write("*******************************************\n");
            while (results.next()) {
                StringBuilder row = new StringBuilder();
                for (int i = 1; i <= columnCount; i++) {
                    if (i > 1)
                        row.append(", ");
                    String columnValue = results.getString(i);
                    row.append(String.format("%s: %s", metaData.getColumnName(i), columnValue));
                }
                bw.write(row.toString() + "\n");
            }
            bw.write("*******************************************\n");
            bw.write("*******************************************\n");
            bw.write("*******************************************\n");
            bw.write("\n");
            bw.close();
        } catch (IOException e) {
            e.printStackTrace();
        }
    }
}

Related

1. parseSqlResultToListMap(ResultSet rs)
2. putResultSetToMap(final Hashtable map, final ResultSet resultSet, final String... keys)
3. safeGetString(ResultSet r, String name)
4. saveResultsetAsFile(ResultSet rs, String filePath, String fileName)
5. toXML(ResultSet rs)