Java XML Node Save toResultSet(Node node, ResultSet rs)

Description

to Result Set

License

Open Source License

Declaration

private static ResultSet toResultSet(Node node, ResultSet rs) throws SQLException 

Method Source Code

//package com.java2s;
/**/*from  w ww .j a v  a2  s . com*/
 * Copyright (c) 2001-2002. Department of Family Medicine, McMaster University. All Rights Reserved.
 * This software is published under the GPL GNU General Public License.
 * This program is free software; you can redistribute it and/or
 * modify it under the terms of the GNU General Public License
 * as published by the Free Software Foundation; either version 2
 * of the License, or (at your option) any later version. 
 *
 * This program 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 General Public License for more details.
 *
 * You should have received a copy of the GNU General Public License
 * along with this program; if not, write to the Free Software
 * Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA.
 *
 * This software was written for the
 * Department of Family Medicine
 * McMaster University
 * Hamilton
 * Ontario, Canada
 */

import java.sql.ResultSet;

import java.sql.SQLException;

import org.w3c.dom.NamedNodeMap;
import org.w3c.dom.Node;

public class Main {
    private static ResultSet toResultSet(Node node, ResultSet rs) throws SQLException {
        int type = node.getNodeType();

        if (type == Node.ELEMENT_NODE) {
            NamedNodeMap nnm = node.getAttributes();
            String name = node.getNodeName();
            String value = "";

            Node next = node.getFirstChild();
            if (next != null) {
                type = next.getNodeType();
                if (type == Node.TEXT_NODE) {

                    value = next.getNodeValue();
                }
            }

            if (!name.equalsIgnoreCase("Results") && !name.equalsIgnoreCase("Row") && !name.equalsIgnoreCase("ID"))
                rs.updateString(name, value);
        }

        //recurse
        for (Node child = node.getFirstChild(); child != null; child = child.getNextSibling()) {
            toResultSet(child, rs);
        }

        return rs;

    }
}

Related

1. save(String filename, Node node)
2. write(Node node, Writer out)
3. writeByDom(Node node, Writer writer, int indent)
4. writeDescription(PrintWriter out, Node node, String offSet)
5. writeDOM(Node node, PrintWriter writer)