import java.io.*;
import javax.xml.parsers.*;
import javax.xml.transform.*;
import javax.xml.transform.dom.*;
import javax.xml.transform.stream.*;

import org.w3c.dom.*;
import java.sql.*;

public class Abimp{
  public static void main(String argumendid[]) throws Exception{
	Document d=DocumentBuilderFactory.newInstance().newDocumentBuilder().parse("aadressikogu.xml");
    try {
     Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
     Connection cn=DriverManager.getConnection("jdbc:odbc:baas1", "", "");
     Statement st=cn.createStatement();
     //teeb uued tabelid baasi1
     try {
     String alause="CREATE TABLE aadress2 (id_a int, aadress text)";
      st.executeUpdate(alause);
     String mlause="CREATE TABLE marksonad2 (id_m int, marksona text)";
      st.executeUpdate(mlause); 
     String ylause="CREATE TABLE yhend2 (id_y int, id_m int, id_a int)";
      st.executeUpdate(ylause); 
     } catch(Exception s) {
      System.out.println("Baasid olemas: "+s.getMessage());
      s.printStackTrace();
     }
     //paneb andmed andmebaasi
     NodeList aadressid=d.getFirstChild().getFirstChild().getChildNodes();
     for(int i=0; i<aadressid.getLength(); i++){
	     kirjutaAadress(aadressid.item(i), st);
	 }
	 NodeList marksonad=d.getFirstChild().getFirstChild().getNextSibling().getChildNodes();
     for(int i=0; i<marksonad.getLength(); i++){
	     kirjutaMarksona(marksonad.item(i), st);
	 }
	 NodeList yhendused=d.getFirstChild().getFirstChild().getNextSibling().getNextSibling().getChildNodes();
     for(int i=0; i<yhendused.getLength(); i++){
	     kirjutaYhendus(yhendused.item(i), st);
	 }
	 cn.close();
    } catch(Exception e) {
     System.out.println("Miskit viga: "+e.getMessage());
     e.printStackTrace();
    }
	  
  }
  static void kirjutaAadress(Node aadress, Statement st) throws Exception{
   String lause="INSERT into aadress2 (id_a, aadress) values ("+aadress.getFirstChild().getFirstChild().getNodeValue()+", '"+aadress.getFirstChild().getNextSibling().getFirstChild().getNodeValue()+"')";
   System.out.println(lause);
   st.executeUpdate(lause);
   }
  static void kirjutaMarksona(Node marksona, Statement st) throws Exception{
   String lause="INSERT into marksonad2 (id_m, marksona) values ("+marksona.getFirstChild().getFirstChild().getNodeValue()+", '"+marksona.getFirstChild().getNextSibling().getFirstChild().getNodeValue()+"')";
   System.out.println(lause);
   st.executeUpdate(lause);
   }
   static void kirjutaYhendus(Node yhendus, Statement st) throws Exception{
   String lause="INSERT into yhend2 (id_y, id_m, id_a) values ("+yhendus.getFirstChild().getFirstChild().getNodeValue()+", "+yhendus.getFirstChild().getNextSibling().getFirstChild().getNodeValue()+", "+yhendus.getFirstChild().getNextSibling().getFirstChild().getNodeValue()+")";
   System.out.println(lause);
   st.executeUpdate(lause);
   }
}