Hai All,
I need an advice in
JDBC coding !!
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
methods.
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.