Thanks.. I added the jar.
Now I'm stuck on this exception -
exception in thread "main" org.springframework.jdbc.BadSqlGrammarException: StatementCallback; bad SQL grammar [insert into employee values(1,Shubham,100000.0)]; nested exception is com.mysql.jdbc.exceptions.MySQLSyntaxErrorException: Unknown column 'Shubham' in 'field list'
What happens if you run this in a SQL client? Does it work? If not, what changes would you need to make to fix this?
There's a quick fix for the code you've shown, but more generally, it's probably a good idea to use a PreparedStatement for this. Since you're using Spring's jdbcTemplate, this functionality is found in the 3-arg version of update(), not the single-arg version that you used. See example here - the part about