Spring SimpleJdbcTemplate update

This section is about update method using SimpleJdbcTemplate  to update records . The update method is beneficial where you need to issue single update .It is easy and effective in this condition. This method throw DataAccessException .

EXAMPLE

In this example , we are going to update the database table row using update method . We are using "Emp" class for setting the value.

UpdateSJT.java

package net.roseindia;

import javax.sql.DataSource;

import org.springframework.jdbc.core.simple.SimpleJdbcTemplate;

public class UpdateSJT {
	private SimpleJdbcTemplate simpleJdbcTemplate;
	private static final String update = 
	"update skills set first_name = ?, last_name = ? where id = ?";

	public void setDataSource(DataSource dataSource) {
		this.simpleJdbcTemplate = new SimpleJdbcTemplate(dataSource);
	}

	public void insert(Emp emp) {
		simpleJdbcTemplate.update(update, emp.getFirstName(),
				emp.getLastName(), emp.getId());
	}

	public Emp newEmp() {
    Emp emp = new Emp();
	emp.setId(1101);
	emp.setFirstName("Rakesh");
	emp.setLastName("Chaudhary");
	return emp;
	}
}

UpdateSJTMain.html

package net.roseindia;

import org.springframework.beans.factory.xml.XmlBeanFactory;
import org.springframework.core.io.ClassPathResource;

public class UpdateSJTMain {

	public static void main(String[] args) {

		XmlBeanFactory beanFactory = new XmlBeanFactory(new ClassPathResource(
				"UpdateSJT.xml"));

		UpdateSJT myBean = (UpdateSJT) beanFactory.getBean("BSJT");

		myBean.insert(myBean.newEmp());

	}
}

UpdateSJT.xml

Emp.java

package net.roseindia;

public class Emp {
	private int id;
	private String firstName;
	private String lastName;

	public String getFirstName() {
		return this.firstName;
	}

	public String getLastName() {
		return this.lastName;
	}

	public int getId() {
		return this.id;
	}

	public void setId(int id) {
		this.id = id;
	}

	// setters methods

	public void setFirstName(String firstName) {
		this.firstName = firstName;
	}

	public void setLastName(String lastName) {
		this.lastName = lastName;
	}

	public String toString() {
		return id + " " + firstName + " " + lastName;
	}

}

OUTPUT

Before executing query database table :

After executing database table :

Download Source Code

Related Tags for Spring SimpleJdbcTemplate update :