Insert Record 

Spring JDBC Framework simplifies the use of JDBC and helps to avoid common errors. The following example shows inserting a new record using JdbcTemplate class.

File Name  :   /SpringJDBC001/conf/basic/applicationContext.xml

view sourceprint? 01 <?xml version="1.0" encoding="UTF-8"?> 02 <beans xmlns="http://www.springframework.org/schema/beans" 03        xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" 04        xsi:schemaLocation="http://www.springframework.org/schema/beans 05            http://www.springframework.org/schema/beans/spring-beans-3.0.xsd"> 06   07     <bean id="dataSource" class="org.springframework.jdbc.datasource.DriverManagerDataSource"> 08         <property name="driverClassName" value="org.h2.Driver" /> 09         <property name="url" value="jdbc:h2:tcp://localhost/~/test" /> 10         <property name="username" value="sa" /> 11         <property name="password" value="" /> 12     </bean> 13   14 </beans>

File Name  :   com/bethecoder/tutorials/spring3/tests/InsertTest.java  Author  :   Sudhakar KV Email  :   kvenkatasudhakar@gmail.com

package com.bethecoder.tutorials.spring3.tests; import java.util.Map; import javax.sql.DataSource; import org.springframework.context.ApplicationContext; import org.springframework.context.support.ClassPathXmlApplicationContext; import org.springframework.jdbc.core.JdbcTemplate; public class InsertTest {   /**    * @param args    */   public static void main(String[] args) {          /**      * Initialize context and get the JdbcTemplate      */     ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");     DataSource dataSource = (DataSource) appContext.getBean("dataSource");     JdbcTemplate template = new JdbcTemplate(dataSource);     int userId = 6;     template.update("insert into USER values (?, ?, ?, ?)",         userId, "Steve", 66, 666666);          Map<String, Object> row = template.queryForMap(         "select * from USER where ID = ? ", userId);     System.out.println(row);   } }

{ID=6, NAME=Steve, AGE=66, SALARY=666666}