I do not know in which part of SAX Class

[Leonidas Savvides]

I am trying use SAX (java class) and an XML Doc to write xml data to database, well I do not know in which part of SAX Class, use the database conn, stm and execute query, statements??? can you help?

Also is it required use, ArrayList or Array or a collection?

[Paul Clapham]

There aren't any rules which say you always have to put the JDBC code in a particular part of your code. That's not how programming works. It's up to you to write the program and put the code in the correct places. (Where "correct" means "whatever works for your requirements".)

And likewise, no, you aren't required to use an ArrayList or any other collection in any code you write.

If you have a specific question, you should ask that specific question here. It seems like you don't know where to go with this SAX program you want to write. So how about if you produce some code, then explain your requirements and ask what to do with that code?

[Leonidas Savvides]

For the particular sax refered I wrote code that prints correctly in output the query statement, but when I tried actual query , in another try this does not written in local db...

  import java.io.*;
import java.sql.*;
import java.util.*;
import org.xml.sax.*;
import org.xml.sax.helpers.DefaultHandler;
import javax.xml.parsers.*;

// Class header for Java class CountEmModified>FindPlant>xmlPlantToDB  WORKS  C:\Course Technology\db tech\Chapter11\tests
public class xmlPlantToDB  extends DefaultHandler  {

  // Variable j is a counter for number of plants
  public int j = 0;
  static public OutputStreamWriter writer;
  static public int state = 0;
  static public String plant = null;
  static public int min = Integer.MAX_VALUE;
  static public String minPlant = null;
  static public String str = " ";
  static public int getRest = 0;
  static public String[] searchname=new String[3] ;//= " "
  static public String[] searchscientificName=new String[3];
  static public String[] searchonHand=new String[3] ;
  static public String[] searchcolor=new String[3];
  public int i = -1;  
  
   private Statement sttmnt;
   private Connection conn;  
   String sqlCommand3;  
  // header for method main
  public static void main ( String args [ ] )   {

    String xmlFile = "plants2.xml";   

    // Uses instance of class CountEm as SAX event handler
    DefaultHandler eventHandler  = new xmlPlantToDB(  );

    // Create instance of SAXParseFactory called sFactory
    SAXParserFactory  sFactory  = 
       SAXParserFactory.newInstance( );

    // The name of the XML file is xmlFile
    try  {
       // Create output stream in UTF8 character mode
       writer = new  OutputStreamWriter(System.out, "UTF8");

       // Create a SAXParser object called parser
       SAXParser  parser  =  sFactory.newSAXParser(  );
       //searchname="Lily-Of-The-Valley";
       // execute method parse using the SAXParser object
       parser.parse(new  File(xmlFile), eventHandler);

    }  catch (Throwable t)  {
           t.printStackTrace( );
    }
    System.exit(0);

  } // end of main


  // output is a method used to write to System.out
  private  void  output(String  s) throws SAXException {
    try   {
        writer.write(s);
        writer.flush( );
    } catch (IOException  e)  {
        throw new SAXException("I/O error", e);
    }
  } // end of method output


  // This method writes a newline character to System.out
  private void newLine( ) throws SAXException  {
    String endOfLine = 
        System.getProperty("line.separator");
    try  {
         writer.write(endOfLine);
    }  catch (IOException  e)  {
         throw  new  SAXException("I/O error", e);
    }
  }  // end of method newLine


  // This method executes when the beginning of the XML 
  //  file is encountered
  public  void  startDocument( )  throws  SAXException  {
        newLine(  );
		
     String url = "jdbc:odbc:plants"; //dsn plants
     String user="";
     String password="";
     try {
       Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
       conn=DriverManager.getConnection
         ("jdbc:odbc:plants", user, password);

  
          //get statement object
      }catch (Exception exception)  {
	  //return (exception.getMessage());
      } // end of catch		
		
		
  } // end of method startDocument

  // This method executes when the end of the XML file is 
  //   encountered
  public  void  endDocument(  )  throws SAXException  {
    try  {
         // Write newline character and then flush the output
         newLine( );
         writer.flush( );
         // Display total number of plant tags encountered
         output("Total number of different plants was: " 
            + j);
         //output("\nMinimum on hand balance is:" + min + "\nfor plant" + minPlant);
		
        //output("\nMinimum on hand balance is: " + min + " for plant " + minPlant);
         output("\nName:" + searchname +  
		"\nOnHand:" + searchonHand +    
		"\nSci Name:" +searchscientificName+
		"\ncolor:" + searchcolor);			
		
    }  catch (IOException  e)  {
         throw  new  SAXException("I/O error", e);
    }
  } // end of method endDocument

  //Executes when new element start tag is encountered
  public void startElement (String namespaceURI, 
     String sName, String qName, Attributes  attrs)   
     throws  SAXException   {
    String eName = sName;  // The name of an element
    if ("".equals(eName))  eName = qName; 

    if (eName == "plant") // Check for plant element
       j++;  // increment j by 1 for each plant element
    
    if (eName == "name")
       state = 2;
    else if (eName == "onHand")
       state = 1;
    else if (eName == "scientificName")
       state = 3;
    else if (eName == "color")
       state = 4;	   
    else 
       state = 0;
  } // end of method startElement

  //Executes when end element tag is encountered
  public  void  endElement(String namespaceURI, 
    String sName, String qName) throws SAXException    {

    if (state == 2 ) // && searchname.equals(str)
	{
	getRest=1;
	i++;
    }
    //if (state == 2 && !searchname.equals(str))
		//getRest=0;
		   
    if (getRest==1 && state == 1) // here error does not go to endDocument(  )
		searchonHand[i]=str;	  
		   
    if (getRest==1 && state == 2)
		searchname[i]=str;	

    if (getRest==1 && state == 3)
		searchscientificName[i]=str;	
		
    if (getRest==1 && state == 4)
		searchcolor[i]=str;
if (state == 4) {		
System.out.println("INSERT INTO Plants VALUES("+i+",'"+searchname[i]+"','"+searchscientificName[i]+"','"+searchcolor[i]+"',"+10.00+","+searchonHand[i]+")");  
     try {
	 
       sttmnt=conn.createStatement();
       sqlCommand3 = "INSERT INTO Plants VALUES("+i+",'"+searchname[i]+"','"+searchscientificName[i]+"','"+searchcolor[i]+"',"+10.00+","+searchonHand[i]+")";
       //sqlCommand3 = "INSERT INTO p VALUES(1,'bhjgbh','jlkjlk','nkjhnk',7.9,8777)";

	 sttmnt.executeUpdate(sqlCommand3);
	} // end of try
	catch (Exception exception)  {
          // catch general exceptions
  	 // return ("Exception 2: "+ exception.getMessage( ));
	} // end of catch

getRest=0; 
state = 0;
}
		
		
  } // end of method endElement

  // Outputs the characters the parser sees
  public void characters(char  buf[ ], int offset, 
     int len) throws SAXException    {
    str  =  new  String(buf, offset, len);
    output(str);
   
  } // end of method characters

} // end of the CountEmModified class definition  

[Paul Clapham]

Leonidas Savvides wrote:For the particular sax refered I wrote code that prints correctly in output the query statement, but when I tried actual query , in another try this does not written in local db...

I see. Then what you should do is to write a small piece of code which does nothing but update a record in a database. Once you have that code working, put a copy of it in your SAX program and adapt it to use the data from SAX. Trying to use two hundred lines of code to debug a database interaction, when most of them have nothing to do with the database, is doing things the hard way.

And here's a hint: your code has a catch-clause which looks like this:

catch (Exception e)   {
}

If the code above that throws an exception, then you won't know that. Because the catch clause does nothing. This is not a good way to debug your code. At least print the exceptions so you know when they happen and what went wrong. Like this:

catch (Exception e)   {
  e.printStackTrace();
}