import ru.ispras.sedna.driver.*; 
public class SednaClient { 
 public static void main(String args[]) { 
  SednaConnection con = null; 
  try { 
   /* Get a connection */ 
   con = DatabaseManager.getConnection("localhost", 
                     "testdb", 
                     "SYSTEM", 
                     "MANAGER"); 
   /* Begin a new transaction */ 
   con.begin(); 
   /* Create statement */ 
   SednaStatement st = con.createStatement(); 
   /* Load XML into the database */ 
   System.out.println("Loading data ..."); 
   boolean res; 
   res = st.execute("LOAD 'C:/region.xml' 'region'"); 
   System.out.println("Document 'region.xml' "+ 
     "has been loaded successfully"); 
   /* Execute query */ 
   System.out.println("Executing query"); 
   res = st.execute("doc('region')/*/*"); 
   /* Print query results */ 
   printQueryResults(st); 
   /* Remove document */ 
   System.out.println("Removing document ..."); 
   res = st.execute("DROP DOCUMENT 'region'"); 
   System.out.println("Document 'region' " + 
         "has been dropped successfully"); 
   /* Commit current transaction */ 
   con.commit(); 
  } 
  catch(DriverException e) { 
    e.printStackTrace(); 
  } 
  finally { 
   /* Properly close connection */ 
   try { if(con != null) con.close(); } 
   catch(DriverException e) { 
    e.printStackTrace(); 
   } 
  } 
 } 
 /* Pretty printing for query results */ 
 private static void printQueryResults(SednaStatement st) 
  throws DriverException { 
  int count = 1; 
  String item; 
  SednaSerializedResult pr = st.getSerializedResult(); 
  while ((item = pr.next()) != null) { 
   System.out.println(count + " item: " + item); 
   count++; 
  } 
 } 
}