Execute sql from jsp page

[msvoren]

Hi,
Is it possible to execute some mysql code from jsp page and how?
Can you give me an example?

I need to execute store procedure, which returns few numbers i want to display on the page.

Perhaps this can be done through freemarker template?

Thanks

[raweck]

Call sql in bean assigned to this jsp.