XML Servlet Sample Application

 
	.....
	.....         
    // select query   
    String query =
          "select w.warehouse_id , w.warehouse_spec.getStringVal() "+
          "from warehouses w where w.warehouse_id = ?";
    //create the prepareStatement object and type cast it to
    //OraclePreparedStatement
    opstmt = (OraclePreparedStatement)this.conn.prepareStatement(query);
    //set the value of warehouse id
    opstmt.setInt(1,warehouse_id);
    //execute the query and retrieve the resultset                                    
    rset = opstmt.executeQuery();

    // type cast to oracle result set.  
    OracleResultSet orset = (OracleResultSet) rset;

    // create new object to dom parser
    DOMParser parser = new DOMParser();
    parser.setPreserveWhitespace(true);

    String xmlstr = null;

    // if there is any row in the table for given warehouse id 
    if (orset.next()) {
        xmlstr = orset.getString(2);

        if (xmlstr != null) {
            // parse the xml string
            parser.parse(new StringReader(xmlstr));

            // Obtain the document.
            doc = parser.getDocument();

            // get the elements  
            data = this.getElements(doc);

            // add to the collection
            coll.add(data);
            coll.add(xmlstr);
        } else {
              coll = null;
          }
    } else {
         coll = null;
      }
	.....
	.....
    return coll;
	    

 
  private Object[][] getElements(Document doc) {
      // get all the elements 
      NodeList nList = doc.getElementsByTagName("*");
      Node node;

      // get the no of elements
      int noOfElement = nList.getLength();
      Object[][] data = new Object[noOfElement][2];

      for (int i = 0; i < noOfElement; i++) {
          // get the ith node 
          node = nList.item(i);

          // get the node name and save into data[i][0]   
          data[i][0] = node.getNodeName();

          //get the value of the child node
          if (node.getChildNodes().item(0) == null) {
              // if it is null, than set data[ i ][ 1 ] =  a blank string
              data[i][1] = "";
          } else {
              // set the value of value of that node to data[ i ][ 1 ].
              data[i][1] = node.getChildNodes().item(0).getNodeValue();
            }
       }

        // return the element and its value as a Object[][]
        return data;
  }

  for (int i = 1; i < data.length; i++) {
      // create update query
      updateQuery = "UPDATE warehouses SET warehouse_spec =  " +
            "UPDATEXML(warehouse_spec, '/Warehouse/" + data[i][0] +
             "',XMLType('<" + data[i][0] + ">" + data[i][1] + "')) where warehouse_id = ?";

      // where the structure of the data is like 
      //  <Warehouse>                
      //   <Building>Owned</Building>
      //   <Area>25000</Area>
      //   <Docks>3</Docks>
      //   <DockType>Rear load</DockType>
      //   <WaterAccess>N</WaterAccess>
      //   <RailAccess>Y</RailAccess>
      //   <Parking>Lot</Parking>
      //   <VClearance>30 ft</VClearance>
      //  </Warehouse>
      // create reference to OraclePreparedStatement by using updateQuery               
      opstmt = (OraclePreparedStatement) conn.prepareStatement(updateQuery);

      // set the value of warehouse_id
      opstmt.setInt(1, warehouseId);

      // execute the query 
      opstmt.executeUpdate();
  }

 
  String xmlstr = "INSERT INTO warehouses (warehouse_id , WAREHOUSE_SPEC) VALUES 
								(144 , XMLType('<Warehouse>
								         <Building>data1</Building>
									 <Area>data2</Area>
									 <Docks>data3</Docks>
									 <DockType>data4</DockType>
									 <WaterAccess>data5</WaterAccess>
									 <RailAccess>data6</RailAccess>
									 <Parking>data7</Parking>
									 <VClearance>data8</VClearance>
									</Warehouse>'))"; 
  // get the OraclePreparedStatement object for the query 
  opstmt = (OraclePreparedStatement) conn.prepareStatement( query );
  // execute the query to insert dummy data
  opstmt.execute( );

XMLServlet