Example of using JdbcTemplate to do an insert

[cfboxall]

I cannot seem to find any examples of doing an insert, there are lots of selects and updates. Has any one got sample code of doing an insert using an SQL statement and passing parameters.

Thanks,
Chris

[Rod Johnson]

jdbcTemplate.update("insert into foo (col1, col2) values (?, ?) ",
    new Object[] { value1, value2 })

[AyushSuman]

Thansk for good example. If we are able to do the insert and update with this

jdbcTemplate.update("insert into foo (col1, col2) values (?, ?) ",
    new Object[] { value1, value2 })

code, then why we use

int update(String sql,
           Object[] args,
           int[] argTypes)

What is the use of third parameter as argTypes. Kindly tell us when we should use argTypes parameter and in which condition we should not use this. Please one samll example also.

Thanks in advance,

Thanks,

Ayush Suman

http://ayushsuman.blogspot.com