tl  tr
  Home | Tutorials | Articles | Videos | Products | Tools | Search
Open Source | Tag Cloud | Follow Us | Bookmark | Contact   
 
 Spring > JDBC > Update Record

Update Record 

Spring JDBC Framework simplifies the use of JDBC and helps to avoid common errors. The following example shows updating an existing record using JdbcTemplate class.


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

File Name  :  
com/bethecoder/tutorials/spring3/tests/UpdateTest.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 UpdateTest {

  /**
   @param args
   */
  public static void main(String[] args) {
    
    /**
     * Initialize context and get the JdbcTemplate
     */
    ApplicationContext appContext = new ClassPathXmlApplicationContext("applicationContext.xml");
    DataSource dataSource = (DataSourceappContext.getBean("dataSource");
    JdbcTemplate template = new JdbcTemplate(dataSource);

    String statusToCheck = "RESOLVED";
    Map<String, Object> row = template.queryForMap(
        "select * from BUG_STAT where STATUS = ? ", statusToCheck);
    System.out.println(row);
    
    //Update the row
    int countToUpdate = 18;
    template.update("update BUG_STAT set COUNT = ? where STATUS = ?"
        countToUpdate, statusToCheck);
    
    row = template.queryForMap(
        "select * from BUG_STAT where STATUS = ? ", statusToCheck);
    System.out.println(row);
  }

}
   

It gives the following output,
{ID=3, STATUS=RESOLVED, COUNT=16}
{ID=3, STATUS=RESOLVED, COUNT=18}


                    Print

   



Books Recommendation

 
 
bl  br