XMLDBDOM.java Source code

Java tutorial

Introduction

Here is the source code for XMLDBDOM.java

Source

import java.sql.*;
import java.io.*;
import org.apache.xerces.parsers.*;
import org.w3c.dom.*;
import org.xml.sax.*;

public class XMLDBDOM {

    public static void main(String[] args) throws Exception {

        Class.forName("COM.cloudscape.core.JDBCDriver").newInstance();

        Connection conn = DriverManager.getConnection("jdbc:cloudscape:GAMETRADER");

        conn.setAutoCommit(false);

        Statement s = conn.createStatement();
        s.executeUpdate("CREATE TABLE XMLData(GAMEID INT, MANUAL SERIALIZE(org.w3c.dom.Document))");
        conn.commit();

        File file = new File("XMLData.xml");
        InputStream is = new FileInputStream(file);

        PreparedStatement ps = conn.prepareStatement("INSERT INTO XMLData VALUES(?,?)");

        ps.setInt(1, 1285757);

        DOMParser parser = new DOMParser();
        parser.parse("XMLData.xml");
        Document manual = parser.getDocument();
        ps.setObject(2, manual);

        ps.execute();

        conn.commit();
    }
}