Which technique should be used for inserting,updating and deleting data in oracle database via Spring?

First of all, I would like to tell you that I am a project manager and managed some good sized projects (n-tier) in .NET technology. Now I have to manage a java project and the developer also does not have that much experience in java and sql so I am completely new to java so would like some help.

We are developing spring servlets which we will be inserting,updating and deleting data into oracle database tables. And we will be using JDBCTemplate in order to connect to oracle database via Spring. We are not using hibernate ,ejb and JPA as I have read over the internet that these are other methods to connect to oracle via spring. My first question is I would like to know whether interaction with jdbctemplate is ok? Or it has disadvantages?

My second question is :

I would like to know which technique is the best to manipulate data as per industry standards like “should we write sql commands from java code or should we call stored procedures?” Because in .NET , we used to write stored procedures for everything because a lot of processing was to be kept at the database level hence making the processing faster. What about spring and oracle?

I thank you for taking your team to read this and helping me out.

Thanks

Rohan.