This week's book giveaway is in the General Computing forum. We're giving away four copies of Arduino in Action and have Martin Evans, Joshua Noble, and Jordan Hochenbaum on-line! See this thread for details.
I am working on a web site, where i am listing a set of stored procedures on a page. user can click any of them, then it prompts another page where it asks for parameters for the stored procedure. After entering the parameters for the Stored Procedure user can submit the form on that page, it should call another servlet. where i need to execute stored procedure in a httpServlet. The parameters for the Stored PRocedure will come from the previous servlet along with the Stored Procedure name. Different stored procedures have different parameters, user can click Spexecute?procedure_name=SP_EXPORT_PGE&Invoice_number=ewrew&+user_id=wrw MY QUESTION IS HOW DO I COLLECT THESE VALUES(sometimes it can have three or four or five parameters) and then call Stored PRocedure in the database, i know how to connect to the database, but don't know how to call stored procedure. does anyone has any code that solved similar problem, sorry i think i am not very clear, ask me if this doesn't make sense
I think when using JDBC you will have to use callable statements to call storedprocedures..
Originally posted by Bhasker Reddy: I am working on a web site, where i am listing a set of stored procedures on a page. user can click any of them, then it prompts another page where it asks for parameters for the stored procedure. After entering the parameters for the Stored Procedure user can submit the form on that page, it should call another servlet. where i need to execute stored procedure in a httpServlet. The parameters for the Stored PRocedure will come from the previous servlet along with the Stored Procedure name. Different stored procedures have different parameters, user can click Spexecute?procedure_name=SP_EXPORT_PGE&Invoice_number=ewrew&+user_id=wrw MY QUESTION IS HOW DO I COLLECT THESE VALUES(sometimes it can have three or four or five parameters) and then call Stored PRocedure in the database, i know how to connect to the database, but don't know how to call stored procedure. does anyone has any code that solved similar problem, sorry i think i am not very clear, ask me if this doesn't make sense
0
