In my project i need to write a servlet which parses an XML, retrieves values of XML and invokes stored procedures using those values.
My servlet uses a Parserclass method Map parsexml(string str) to parse the data. This method parses the data and return the parsed values as a HashMap.
My problem is ... i am not sure where to include my JDBC code to execute the stored procedures.
1) Should i write the jdbc logic in a method of the parserclass itself [or] 2) should i write one more class which takes care of jdbc stuff [or] 3)should i include the jdbc code in servlet.
I am using weblogicServer8.1 for the application and jdbc connection pool inorder to get the connection object. I think if i have to use some other class to handle jdbc stuff, i should be passing this connection object to other class
I would like to know whether my approach is correct or not. What would be the best approach in my cenario. I am not able to properly judge as i am new to this.
Any help is appreciated, Thanks in advance, Pooja.