Metacat

import java.sql.*;

    private Connection			conn;

    // Constructer to init the class

    public DBWriter(String argv[]) 

	throws SAXException, SQLException, IOException, ClassNotFoundException {

	//

	// Load the document, using the appropriate custom

	// DOM elements.

	//

	XmlDocument	doc = createDocument (

		Resolver.createInputSource (new File (argv [1])),

		new FileInputStream (argv [0]),

		new ErrorPrinter ()

	);

	DBElement		root;

    	root = (DBElement)doc.getDocumentElement ();

	root.normalize ();

        System.out.println(root.getJunk());

        conn = openDBConnection(

		"oracle.jdbc.driver.OracleDriver",

		"jdbc:oracle:thin:@penelope.nceas.ucsb.edu:1526:DEV",

		"jones", "kinkaj0u");

        // Prepare a statement to cleanup the emp table

        Statement stmt = conn.createStatement ();

        try {

            	stmt.execute ("delete from xml_elements where nodeid = 1500");

        } catch (SQLException e) {

        	// Ignore an error here

        }

        // Prepare to insert new names in the Elements table

        PreparedStatement pstmt = conn.prepareStatement(

	        "insert into xml_elements (nodeid, nodename) values (?, ?)");

        // Add an element as employee number 1500

        pstmt.setInt (1, 1500);	// The first ? is for NODEID

        pstmt.setString (2, "eml-variable");// The second ? is for NODENAME

        // Do the insertion

        pstmt.execute ();

    }

            new DBWriter(argv);

    private Connection openDBConnection(String dbDriver, String connection, 

		String user, String password) 

		throws SQLException, ClassNotFoundException {

      // Load the Oracle JDBC driver

      Class.forName ("oracle.jdbc.driver.OracleDriver");

      // Connect to the database

      // You can put a database name after the @ sign in the connection URL.

      Connection conn = DriverManager.getConnection(

	"jdbc:oracle:thin:@penelope.nceas.ucsb.edu:1526:DEV", 

	"jones", "kinkaj0u");

      return conn;

    }